Dan Trainor wrote:
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2 things.
1) if i would like to take mysql incremental backup weekly
cp /var/lib/mysql/ /backup/mysqlbak/
how can i do it by above command as i would like to run cron weekly
for take mysql backup.
i would like to take backup using cp command only as we have more then
1000 databases on one server.
IS THERE ANY BETTER WAY TO DO THIS
Thanks and Regards
Kaushal
Hi -
The following, has been my experience:
A) That will not work.
B) Depending on the OS, this may never complete, as files may constantly
still be written to
C) Depending on the OS, cp may not be able to take all of those
directories for those 1000's of databases as arguments
D) If you were doing that, you'd use 'cp -r'
The other thing of course is that to copy the files through the
filesystem, you have to stop mysql from running so you don't corrupt
anything which means your whole database system can't be used.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
