Home » Database, MySQL10 October 2007

MySQL: Backup/Export and Restore/Import Database & Table

This article shows how to backup/export and restore/import single & multiple databases and tables in MySQL.

Backup/Export

1) Backup/Export single database

2) Backup/Export multiple databases

Here: db1, db2, db3 are three different database name.

3) Backup/Export all databases

4) Backup/Export only specific tables from database

Here: table_name1 and table_name2 are dumped from database database_name.

5) Backup/Export database as gzip compressed file (Linux)

6) Backup/Export database as bzip2 compressed file (Linux)

Restore/Import

1) Restore/Import database

2) Restore/Import database as gzip compressed file (Linux)

3) Restore/Import database as bzip2 compressed file (Linux)

Hope it helps. Thanks.

MySQL

Get New Post by Email

Find me on

FacebookTwitterGoogle+LinkedInRSS Feed

Comments are closed.