public marks

PUBLIC MARKS from springnet with tags database & innodb

10 September 2006 22:30

MySQL 5.0 Reference Manual :: 8.12 mysqldump — A Database Backup Program

For a faster "mysqldump" innodb tables 1. mysqldump --opt --user=username --password database > filetosaveto.sql 2. open the dump file put this statement at the beginning of the sql dump text file: SET FOREIGN_KEY_CHECKS=0; 3. mysql --user=usern