…/lib/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… the same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with… SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied… create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied… create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to restore a ibd tablespace: The…mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN_KEY_CHECKS=1; mysql…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… the overhead is too high. But if you later restore enforcement, MySQL does not immediately scan all your data to verify that…_SCHEMA.KEY_COLUMN_USAGE P ON (K.TABLE_SCHEMA, K.TABLE_NAME) = (P.TABLE_SCHEMA, P.TABLE_NAME) AND P.CONSTRAINT_NAME = ‘PRIMARY’ WHERE… queries for quality control: mysql> CREATE TABLE test.MY_KEY_COLUMN_USAGE LIKE INFORMATION_SCHEMA.KEY_COLUMN_USAGE; mysql> INSERT INTO test.MY…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, ….commanual Com_resetblogpercona.commanual Com_resignalblogpercona.commanual Com_restore_tableblogpercona.commanual Com_revokeblogpercona.commanual Com_revoke_allblogpercona….
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… internally because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html… duplication then you can run the pt-table-checksum and pt-table-sync. How to restore a slave in a good and slow… error messages can dissapear on the shell buffer because the restore of the dump will continue. Be cautious. Same problem again…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… long webinar on 26th of April on data recovery for MySQL. Almost every long serving DBA has been faced with the… table or from Hardware or Software failure. In this Webinar we will give you a walk through guide on how to restore…) * Preparing your data * Identifying the structure and state of tables * Retrieving data * Restoring from recovered data During this Webinar the Percona-InnoDB…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… node Automatic cluster synchronization, both incremental and full restores The ability to read and write on every … (0.02 sec) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table: CREATE TABLE `autoinc` ( `i` int(10) …
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
…are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-…). innobackupex didn’t add the file-per-table setting for table-independent backups. Fixed by making XtraBackup …files. Bug fixed #1085099 (Alexey Kopytov). XtraBackup for MySQL 5.6 has improved the error reporting …
