|
Posted by Tim Van Wassenhove on 08/01/05 01:54
On 2005-07-31, Raj Shekhar <rajlist@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
backup@gmail.com -s "mysql backup of `date +%Y-%m-%d`"
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
Navigation:
[Reply to this message]
|