Encrier wrote:Can you please explain how I can import a dump into MySql with PHPMyAdmin?
Paul, open phpMyAdmin then in the drop box in the left frame select the database you want to import the dump to.
You will be presented with a new center frame with your database and at the top of the center frame you will see a menu row.
Now browse to the dump.sql
file on your PC (dump.sql is only an example file name, yours may have a different name).
Select the Character set
which will be evident near the top of the dump.sql file but you can leave it on the default setting for this exercise as you can change it later if required by re-importing the dump.sql file with a different character set if things go wrong.
The Character set may look something like this in your dump.exe file:
You can open the dump.sql file in any text editor of your choice to peruse its content.
ticked with a zero (default)
Format of import
file is SQL
Click on the GO
bottom right hand side.
Now you should see your database populated with the data from the dump.sql file.
Obviously you have to have created your database first or there will be no place to create the tables and data etc. from the dump.sql file