In my last note I wrote about prestashop database backup export with awesome tool to manage databases: PHPMyAdmin. The final effect of tutorial was database backup file 1541a.sql. Today i want to show you how to import this file to new database. The same as before PHPMyAdmin is necessary, so log in please to your account.
We will import 1541.sql file to new database created in our web hosting account - 1541b (this is for example our new database on your new hosting - or on localhost). Click on your new database exactly as I show on image below:
After clicking on the database name on the right hand side you will see database settings menu and specification. In this case - this table is new and there is no tables, so you will se communicate about that, exactly as below:
Click on Import button, you will see import settings page. All you have to to is select the .sql file that you exported, in this case the filename is 1541a.sql
After that click on "Go" button, wait a second because your database is now loading :) After that you will se imported database. That's all!.