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 mysqldump gzip Compress Backup
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 »How mysqldump Remote to Local
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