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
[EMAIL PROTECTED]
--
Remember though that
THERE IS NO GENERAL RULE FOR CONVERTING A LIST INTO A SCALAR.
             -- Larry Wall in the perl man page

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to