Scott Purcell wrote:
Hello,
After many months of preparation, I am finally going to go live with a project
I have created. It is your basic e-commerce site, where I need to make sure I
have a current backup, specifically on the orders placed, etc.
I am going to run the mysql server on a PC possibly running XP. (Small startup,
and Tomcat is running there).
I am considering buying a tape drive, and somehow backing up the database
periodically throughout the day. I am sure there are some best practices for
this.
Could anyone enlighten me as to how to back this up, and how often. Up until
now, I have always done database exports and imports, so I could use any info.
Sincerely
Scott
I use MySQL dump to dump the contents of the databases at several
intervals during the day (before work, during first break, lunch, last
break, end of the day), zip the .sql files, and distribute them to two
other "holding" machines. The last dump of the day is put to tape. We
aren't 24x7, and during the off times there are no users active (on
break/out to lunch) during the dumping/zipping/copying. I haven't
noticed any problems with this setup, however, YMMV.
--
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
