|
Posted by Raj Shekhar on 08/01/05 00:58
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
Navigation:
[Reply to this message]
|