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.