In general, you may import database backup via phpMyAdmin.

However, in a rare circumstance, your database backup is large, and cannot import via phpMyAdmin.

If so, you may use the following way to import it.

  1. Upload your MySQL dump output file onto the server
  2. Create a (e.g.) importmysql.php with the followingphp_import_mysql
  3. goto http://www.YourDomain.com/importmysql.php
  4. Check the data in phpMyAdmin (e.g. table counts, records, Chinese (or other language) characters, etc.)
  5. remove importmysql.php in your hosting account.
  6. remove your SQL file in your hosting account.

Notes:
– the above web page shows blank result, you may check the result inside phpMyAdmin

Pin It on Pinterest

Share This