Return to "MySQL"

Importing Database Contents from a MySQL Dump


 
The topic of this article is not supported by our customer support department, however for your convenience we are providing this material to assist you in troubleshooting potential issues related to this topic.

If you are attempting to install an application which requires you to import MySQL database contents, or if you have a backup .SQL file (also known as a MySQL Dump) of a previous database, you can use it to create a new database with identical contents inside of your Jumpline.com web hosting account. This allows you to copy a MySQL database from a previous hosting comany and automatically re-create it inside of your Jumpline.com account without having to manually re-enter the data. You can create a new MySQL database and import a database backup from the Jumpline.com Control Panel, which can be accessed by clicking “Control Panel” from the My Products tab of the customer manager at https://my.jumpline.com.

  1. On your Home page, click Databases.
  2. Click Add New Database.
  3. Enter a name for the database.

    We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).

  4. Select the database type that you are going to use: MySQL. Click OK.
  5. To set up database administrator’s credentials, click btn new user Add New Database User.
  6. Type a user name and a password that will be used for accessing the contents of the database. Click OK.
  7. Click the DB WebAdmin icon in the Tools group, and the phpMyAdmin database management tool will open in a separate browser window.
  8. Click on the Query window icon in the left frame.
  9. Click the Import files tab.
  10. Select the text file that contains the data and click Go.
  11. Click the Insert data from a text file link.

Your previous database contents are now imported and ready for use by your web application.


 

Related Video:




 

Related Third-Party Documentation:




 

Related Articles: