Ive seen the mysql documentation and that why I ask this question. The docs just confuse me because the mysqldump page says mysqlhotcopy is the preferred way, and vice versa.
The docs seem to favor mysqlhotcopy but then the page also says only to use it when your sure data isnt being written. Since this will be a nightly backup that runs at the same time everynight to backup a database of a publicly accessible site then that wouldnt seem like a good route if its going to cause problems. The backup will be done on the same box, and will be ftp'd after the words. I am archiving it, not moving it to another db. Thanks S. On Tue, 26 Feb 2002, Victoria Reznichenko wrote: > Stewart, > Tuesday, February 26, 2002, 5:13:58 PM, you wrote: > > SG> I want to create a cron job that does nightly backups of a database, tars > SG> and gzips it, then ftps it to another server. > > SG> I was wondering what the perferred method of copying the data would be. > SG> mysqldump, mysqlhotcopy or just copying the files. > > mysqlhotcopy is used only on the same box where MySQL server is > running. Look at: > http://www.mysql.com/doc/m/y/mysqlhotcopy.html > > Info about mysqldump you can find at: > http://www.mysql.com/doc/m/y/mysqldump.html > > Direct copying files is not recommended way to backup databases. > > SG> =S. > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
