public marks

PUBLIC MARKS with tags innodb & backup

2011

2006

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

by springnet
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

PUBLIC TAGS related to tag innodb

innodb_file_per_table +   mysql +   optimize +  

Active users

RETFU
last mark : 03/03/2011 12:52

springnet
last mark : 10/09/2006 22:31