On Tue, 4 Sep 2001, sagar wrote:
> I have a remote server running my website. I've to make the backup of the mysql db
> i'm using. i can use mysqldump for this. but i'm not sure where the file will be
>created
> on the server and also i want to make that file to .zip and then download it to my
>pc.
> how can i do this. Please help.
Create a shell script to run mysqldump then compress it (I like bzip), and
schedule it to run nightly.
For future reference, check in the MySQL documentation and mail lists:
http://www.mysql.com/documentation/index.html
http://www.mysql.com/documentation/lists.html
There's not much MySQL/system maintenance support offered in this list by
comparison.
~Chris /"\
\ / Pine Ribbon Campaign
Microsoft Security Specialist X Against Outlook
The moron in Oxymoron. / \ http://www.thebackrow.net
--
PHP General 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]
