Did I really ask that tough a question? Anyone?
On 4/15/04 7:38 PM, "Mark Susol | Ultimate Creative Media" <[EMAIL PROTECTED]> wrote: > I've found a nice shell script to use to backup my server's MySQL databases. > https://sourceforge.net/projects/automysqlbackup/ > > However, when I tried this earlier today it resulted in a corrupt table. Now > the table in question is one I've had issues with for other reasons, but it > has over 2 mil records in it when only partially built. > > What I need to do is put a lock on the database/tables before the script is > run. The script allows for a pre & post shell script to run. > > So what do I need to do before running any backup scripts to ensure the > tables will not be corrupted during any kind of shell operation? Do I have > to stop services like mysqld or httpd before hand? > > Does anyone use MySQL 4.0.18 and the hot copy instead? I'm using 4.0.17-max > > > Mark Súsol > ------------------------------- > u l t i m a t e CreativeMedia > Web | Print | CD Media | eCommerce > www.ultimatecreativemedia.com > Ph: 301-668-0588 > Mark Súsol ------------------------------- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]