Order Now
Home>Encyclopedia>Video Tutorials>MySQL>How to create MySQL database dump
Advanched MySQL Database Management Tools

How to create a MySQL database dump/backup file

Domains and Subdomains Video Tutorials



Our Most Popular Hosting Plans



Budget Hosting

Value Hosting

Plus Hosting

Exclusive Hosting
Budget Hosting - $4.95 per month Value Hosting - $7.95 per month Plus Hosting - $9.95 per month Exclusive Hosting - $14.95 per month
Unlimited Space Unlimited Space Unlimited Space Unlimited Space
Unlimited Traffic Unlimited Traffic Unlimited Traffic Unlimited Traffic
1 Domains Unlimited Domains Unlimited Domains Unlimited Domains
FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *
Order Joomla Web Hosting
Order eLearning Web Hosting
Order WordPress Web Hosting
Order 4images Web Hosting

How to create a MySQL database dumb/backup file - overview


There are just 3 simple steps that you need to complete to dump a MySQL database:

1. First, you need to log into your personal Control Panel, using the log-in link, located in the upper right corner of the NTC Hosting's website. Then fill in the username and password of your Web Hosting Account in the Members Login Form and click the 'Login' button to open your web hosting Control Panel.

2. The next step is to access the MySQL Databases section. To do that, click the 'MySQL Databases' icon in the Site Management section.

3. Once in the MySQL Databases section of the Control Panel, click the name of the database you wish to make a dump for or on its corresponding PHPMyAdmin icon.

3.1. This will open for you the PHPMyAdmin tool. Once in the phpMyAdmin interface - select the database from the drop-down list on the left (you can scroll down to view all database entries in the table).

3.2. Now click the 'Export' option from the tabbed menu above the MySQL table.
In the Export tab, select the dump type from the corresponding list of options (to export an SQL backup you need the SQL option).

3.3. Next select the 'Save as file' option to create a MySQL database dump file and specify the dump file name. Then press the 'GO' button to export and download your database dump file.
You have completed all 3 simple MySQL database dump steps using the phpMyAdmin interface integrated into your Control Panel.