How to Backup MySQL Database
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 »How to Backup MySQL Database
mysqldump
How to Migrate Local Databases to Remote Host or Vice Versa Without Dump Files
For migrating a remote database, you can dump and pipe the whole database from remote server to local server via ssh tunnel without intermediate dump… Read More »How to Migrate Local Databases to Remote Host or Vice Versa Without Dump Files
How to Backup MySQL Data and Stored Procedures
By default, mysqldump only backup the data from which database indicated in the command line. For stored procedures, You have to enable the backup by… Read More »How to Backup MySQL Data and Stored Procedures
How to Resolve Error 1712: Index table_name is corrupted
Got this error when using mysqldump for backing up a database. At this moment, we can't do any operations but DDL.mysqldump: Error 1712: Index table_name… Read More »How to Resolve Error 1712: Index table_name is corrupted
How to Minimize the Impact of Mysqldump
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 to Minimize the Impact of Mysqldump
How to Backup Selected Tables by mysqldump
There're two ways to backup selected tables in MySQL:Positive ListingYou can backup tables by positively and explicitly listing all necessary ones. The syntax is as… Read More »How to Backup Selected Tables by mysqldump
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 (1030)I… Read More »How to Resolve mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE XXX'': Got error 28 from storage engine (1030)
How to Dump a Remote Database over SSH in Windows
First of all, you have to ensure that SSH command utility has been installed, because Windows does not provide it by default.C:Usersed>ssh'ssh' is not recognized… Read More »How to Dump a Remote Database over SSH in Windows
How to Import From a Remote MySQL Database in Windows
You can pipe the remote dump result into the local database in Windows like this:C:Usersed>mysqldump -u root -p -h db.example.com database_name | mysql -u root… Read More »How to Import From a Remote MySQL Database in Windows