I’d like to have phpMyAdmin import a database from a specific location every 24 hours, or any interval that i like. (28, ‘BQ’, ‘Bonaire, Sint Eustatius and Saba’, ‘en’), ]#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CREATE TABLE `xc_coupons` (. I have a windows hosting for asp.net but I want to upload a website which developed by wordpress. Import a MySQL Database using phpMyAdmin How to Import a MySQL Database using phpMyAdmin. Once your worksheet is selected, go to the ‘File’ menu and select ‘Save As’. You should simply create a BLANK database (no tables) through MySQL in cPanel. The instructions for restoring this backup are the same as what is outilined here:  go to phpMyAdmin in Cpanel, select the appropriate database, select “Import”, navigate to the backup file and click on the “Go” button. Be sure to indicate the name and location of the file in your request. Log into phpMyAdmin. I hope this helps! To import the database, you need to delete the new database, and replace it with the old one. These plugins will not allow uploading the database due to missing dependencies or verifications.