Mysqldump Compress on the Fly
Backup MySQL Database MySQL provides mysqldump utility to let us dump SQL statements that can recreate the whole database. We can output the SQL statements… Read More »Mysqldump Compress on the Fly
mysqldump
mysqldump Remote Database to Local One
Remote to Local For migrating a remote database, you can dump and pipe the whole database from remote server to local server via ssh tunnel… Read More »mysqldump Remote Database to Local One
MySQL Backup Stored Procedures
Procedures and Functions By default, mysqldump only backup the data from which database indicated in the command line. For stored procedures, You have to enable… Read More »MySQL Backup Stored Procedures
How to Resolve ERROR 1712 (HY000): Index table_name is corrupted
ERROR 1712 (HY000) Got this error when using mysqldump for backing up a database. At this moment, we can't do any operations but DDL. mysqldump:… Read More »How to Resolve ERROR 1712 (HY000): Index table_name is corrupted
How Mysqldump Improve Performance
If you have a very big database containing big tables to be backed up, you might have the same issue with mine: The web server… Read More »How Mysqldump Improve Performance
How to Backup Selected Tables
There're two ways to backup selected tables in MySQL: Include Table You can backup tables by positively and explicitly listing all necessary ones. The syntax… Read More »How to Backup Selected Tables
How to Resolve Very Big Dump File of MySQL
I usually backup the database by mysqldump, but the plain SQL dump file was getting larger and larger and took most of the free space.… Read More »How to Resolve Very Big Dump File of MySQL
How to Resolve mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE XXX'': Got error 28 from storage engine (1030)
I met the error when I use mysqldump to backup the database. mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'XXX'': Got error 28 from storage engine… Read More »How to Resolve mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE XXX'': Got error 28 from storage engine (1030)
MySQL Dump Remote to Local
First of all, you have to ensure that SSH command utility has been installed, because Windows does not provide it by default. C:\Users\alex>ssh 'ssh' is… Read More »MySQL Dump Remote to Local
MySQL Import Remote Dump in Windows
You can pipe the remote dump output into the local database in Windows like this: C:\Users\ed>mysqldump -u root -p -h db.example.com database_name | mysql -u… Read More »MySQL Import Remote Dump in Windows