Is it possible to import MySQL data?

Category: MySQL

Yes, the easiest way to import your MySQL data is through phpMyAdmin; assuming you have an SQL, XML, OpenDocument Spreadsheet, CSV, MediaWiki Table, ESRI Shape File filetype in the correct format – typically you will use a .SQL. To import your data you will complete the following steps:

  1. Login to cPanel.
  2. Click the phpMyAdmin icon.
  3. Using the left hand menu of phpMyAdmin, select the database you wish to import your data to.
  4. Now that you’re viewing the particular database, click the Import tab.
  5. There you will click Browse to select the file to upload, select the appropriate character set (if in doubt, leave as utf-8) and tweak the additional settings if required; then click Go.
  6. The file will then be imported, perhaps taking some time depending on file size; the outcome of the import will then be confirmed to you.

If your database is quite large (in excess of 100MB) it may time out during import. In the event of this occurring you may need to lodge a Support Request through your Synergy Wholesale System account to have the support staff conduct an import of the database through command line for you. We kindly request you attempt an import through phpMyAdmin as your first port of call.

More Info Request
  • Select All
  • Sample Pricing Guide
    Due to the nature of our services as a wholesale provider, we do restrict full pricing from being released. You can request a sample pricing guide to give you some insight as to what you can look forward to by becoming a partner with Synergy Wholesale.
  • API Information
  • Whitelabel Billing Information
  • Migration Process
Required
* denotes required field
Thank you for submitting a More Info Request!
An email will be sent to you shortly with the requested information.
Begin your 7-day free-trial today!
Get Started
Close