Re: How to back up database..... ?
| From: | Jason Stechschulte | Date: | Sun, 06 May 2001 15:46:14 +0000 |
| Subject: | Re: How to back up database..... ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8601@lists.php.net to get a copy of this message | ||
On Mon, Apr 16, 2001 at 12:40:05AM +0800, E K L wrote:
> Hi all,
> Is there anyone can tell me how to back up Mysql database from one server
> to other server? Please advise....thanks
backup to zip:
mysqldump --add-drop-table -u root -ppass database | gzip > /dir/database.gz
--
Jason Stechschulte
jpstech@unoh.edu
--
Remember though that
THERE IS NO GENERAL RULE FOR CONVERTING A LIST INTO A SCALAR.
-- Larry Wall in the perl man page