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]

Re: Best script to bacup mysql database?

In article <14nnyrg2su7pp. 14b6qa4zjcgse$. dlg@40tude.net> ,
Sammy <sammy203@hotma il.com> wrote:
[color=blue]
> What is the best script to use to back up and admin my mysql database?
>
>
> Tnanks, Sammy[/color]

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]

Re: Best script to bacup mysql database?


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[color=blue]
> database.`date '+%d-%M-%Y'`.bz2 worked in the cron worked for me for[/color]
a long time

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

[Tim Van Wassenhove]

Re: Best script to bacup mysql database?

On 2005-07-31, Raj Shekhar <rajlist@rajshe khar.net> wrote:[color=blue]
>
> 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[color=green]
>> database.`date '+%d-%M-%Y'`.bz2 worked in the cron worked for me for[/color]
> a long time[/color]

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

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