Re: [PHP-DB] How to back up database..... ?

2001-04-17 Thread Xsarus Internetdiensten

mysqldump...

- Original Message -
From: "E K L" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 15, 2001 9:40 AM
Subject: [PHP-DB] How to back up database. ?


> Hi all,
>Is there anyone can tell me how to back up Mysql database from one
server
> to other server? Please advisethanks
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> --
> 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]
>


-- 
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]




Re: [PHP-DB] How to back up database..... ?

2001-04-16 Thread Jason Stechschulte

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 advisethanks

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]