HostGator Web Hosting Help
MySQL Database Restore
Summary
There are three options available to backup your MySQL databases
Using Site Backup & Restore
- Log in to your HostGator cPanel account.
- Under the Files section, select Site Backup & Restore.
- Click the Restore tab.
- Select MySQL Database option.
- Select the desired archive date.
- Select the desired database.
- Click Restore option on the right, or from the interactive mouse-over menu.
Using phpMyAdmin
- Login to your cPanel and click phpMyAdmin icon in Databases section.
- Select the database you wish to import the backup from the drop-down list.
- Click on the Import tab.
- Click the Choose File button.
- Click the Go button.
Note: This can take a significant period of time, depending on the size of the file being imported, the number of operations the .sql file must perform, and a number of other variables.
Using the Command Line
mysql -p -u username database_name < file.sql
Note: You will be prompted for your MYSQL password. Enter your password and this will export a copy of the database into your specified filename.
If you need assistance with any of these procedures, please contact our Support department.
Knowledgebase Article
382,503 views
bookmark
share
tags: admin database mysql php phpmyadmin restore
Share or save this via:
Recommended Help Content
How do I import a backup of my database (.sql file) using phpMyAdmin?
A repository of information on how you can manage your database by using the phpMyAdmin interface.
How to restore MySQL databases using the Site Backup & Restore tool
Related Help Content
A guide to duplicating a MySQL database using phpMyAdmin
A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin
Guidance on adding tables to your mySQL database in phpMyAdmin
Knowledgebase Article
113,361 views
tags: mysql phpmyadmin
How to backup all of your MySQL databases using the Site Backup & Restore tool
How to repair and optimize your database using phpMyAdmin:
This article will show you how to rename a database table in phpMyAdmin.
Step by step directions on how you can search your database using phpMyAdmin
I am prompted to set a new MySQL password. What does this mean and how do I change it?