Encrier wrote:Can you please explain how I can import a dump into MySql with PHPMyAdmin?
Best regards,
Paul
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.
Select
IMPORT
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:
DEFAULT CHARSET=latin1
You can open the dump.sql file in any text editor of your choice to peruse its content.
Partial import ticked with a zero (default)
Format of import file is SQL
Click on the
GO bottom right hand side.
Your done.
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
.
Good luck