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 best way to do it, and for maximum portability, would either be to
create a replication slave which all this data would replicate to,
allowing you to have pretty much a "hot spare" if configured properly,
and alternatively using mysqldump so that you would not have to bring
the server down, aside from maybe some row or table locking while the
dump was running - which is completely subject based on how you're
currently running.
Perhaps others here can school me on this a bit, as well, and provide
some other options. However, I thought I could at least give this one a
shot :)
Thanks
-dant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
