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