… (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes… backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock…
Post: Unexpected problem with triggers and mysqldump
February 11, 2013 By 8 Comments
…, let’s use them: # Export schema $ mysqldump –no-data sakila > schema.sql # Export data $ mysqldump –no-create-info sakila > data.sql Just… export data is therefore: # Export schema $ mysqldump –no-data sakila > schema.sql # Export data $ mysqldump –no-create-info –skip-triggers sakila > data…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… row in set (0.00 sec) SESSION2: root@ubuntu:~/dump# mysqldump –single-transaction dumptest > dump.sql SESSION1: (before dump has completed… at the same time as mysqldump was running we got table empty table with new structure in mysqldump instead of table with…. What are potential solutions for this problem ? you can use mysqldump –lock-all-tables instead which does not have this problem…
Post: How Percona Server handles data corruption more gracefully
January 6, 2012 By 2 Comments
… a question a while ago about how Percona Server handles corrupted data more gracefully than the standard MySQL server from Oracle… to continue running, so the corruption in one database does not affect the others. Percona Server handles corruption more gracefully, if you enable it, by simply marking the single table as corrupt, and not crashing the entire server. The relevant documentation is…
Comment: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… buffer stored in main tablespace and as such could cause corruption if it was not empty. I believe unpurged index entries… not use such tables directly but rather dump them with mysqldump and load back to be on the safe side
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
If you’re just running innodb, you can run mysqldump with the –singletransaction flag which will get you a consistent … on the internet of this form of snap coming up corrupt, but I will say I’ve personally never had a…
Post: An argument for not using mysqldump
November 8, 2010 By 26 Comments
I have a 5G mysqldump which takes 30 minutes to restore from backup. That … take 30×10=5 hours to restore. Right? Wrong. Mysqldump recovery time is not linear. Bigger tables, or tables…) * 1024)/70/60 = ~17 minutes I can tell progress with mysqldump by monitoring the rate at which show global status like…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…. You say you cannot afford the restoration time from a mysqldump‘s single table parsing. In that case, I suspect you… the time for a REPAIR TABLE on your MyISAM’s corrupted table. You say you need to prepare for a “really…
Post: Using INFORMATION_SCHEMA instead of shell scripting
November 24, 2008 By 7 Comments
…,”.sql”) | +——————————————————————————+ | mysqldump art73 article73 >> art73.sql | | mysqldump art73 author73 >> art73.sql | | mysqldump art73 forum73 >> art73.sql | | mysqldump art73 forum_stats73 >> art73.sql | | mysqldump art73 img… other case I needed to restore Innodb tables from mysqldump because of corrupted Innodb tablespace – to do this I had to clean…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… of various error messages you could see if relay log corrupted. You could also see malformed queries (with some junk), complaining… work) to find the next event start and potentially recover “corrupted” event to be manually executed on the slaves. Skipping around… depending on applications (and on amount of events which were corrupted) you may want to let replication continue from the new…
