Web Hosting
··1 minute readIs it possible to import MySQL data?
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:
- Login to cPanel.
- Click the phpMyAdmin icon.
- Using the left hand menu of phpMyAdmin, select the database you wish to import your data to.
- Now that you're viewing the particular database, click the Import tab.
- 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.
- 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.