Best script to bacup mysql database?

[Sammy]

What is the best script to use to back up and admin my mysql database?
Tnanks, Sammy

[Michael Vilain]

In article <14******************************@40tude.net>,
Sammy <sa******@hotmail.com> wrote:

What is the best script to use to back up and admin my mysql database?
Tnanks, Sammy

The one you write and understand all by yourself. Check out the man
page for mysqladmin. It has everything you need to create a copy of
your database tables as a SQL file you can source from msyql.

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[Raj Shekhar]

If you have a second computer which you can connect to you database,
consider setting up a slave database using replication.
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html has the details.

or mysqldump --opt -u user --p "password" --all-databases | bzip2 -c

database.`date '+%d-%M-%Y'`.bz2 worked in the cron worked for me for

a long time

--
Raj Shekhar
blog : http://rajshekhar.net/blog home : http://rajshekhar.net
Disclaimer : http://rajshekhar.net/disclaimer

[Tim Van Wassenhove]

On 2005-07-31, Raj Shekhar <ra*****@rajshekhar.net> wrote:

If you have a second computer which you can connect to you database,
consider setting up a slave database using replication.
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html has the details.

or mysqldump --opt -u user --p "password" --all-databases | bzip2 -c

database.`date '+%d-%M-%Y'`.bz2 worked in the cron worked for me for

a long time

mysqldump -u user -ppassword databasename | bzip2 -c | mail
ba****@gmail.com -s "mysql backup of `date +%Y-%m-%d`"

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>