Dumping and restoring are fairly common task of managing database. Dumping is a process of making a file containing SQL queries that can be used to construct the whole database. Dumping is commonly used to download your database for backup or other purposes. Restoring is the reverse process of dumping.
To dump MySQL database please do the following.
1.Log on to SiteManager if you haven't already logged on.
2.Go to Database Server menu and then click on manage for the database you want to dump. From there click on Dump database.
3. Inside the menu, there are several options you can choose to determine how you want the database to be dumped. Choose accordingly and click Dump Database.
The available options are described below.
a)What to dump. You can choose to dump both structure and data, structure only or data only.
b)Add DROP TABLE. If this option is selected, a DROP TABLE command will be created before creating tables. Useful if you want to replace existing database on the target database.
c)Add LOCKs. If this option is selected, a LOCK TABLE command will be added before creating tables.
d)Complete INSERTs. Use complete INSERT command.
e)Include all MySQL specific create options. This will include MySQL specific create options such as specifying the type of table.
f)Compress result. You can choose whether to compress the result or not. You can choose gzip or bzip2 compression.