View Single Post
  #3 (permalink)  
Old 10-10-2006, 09:02 AM
kgun's Avatar
kgun kgun is offline
WebProWorld 1,000+ Club
 

Join Date: May 2005
Location: Norway
Posts: 5,344
kgun RepRank 3kgun RepRank 3
Default

Very easy in phpMyAdmin that comes with XAMPP

I was close to do it yesterday, but did not browse and import the file. The documentation is excellent.

Here is the way to do it for persons that like to read first, like me:

1. At the phpMyAdmin home page click "FAQ" on the top menu.

2. While on the FAQ menu click "Usage tips."

The point 6.5 (in my version of the admin toolkit) says:

How can I restore (upload) my database or table using a dump? How can I run a ".sql" file?

Click on a database name in the left frame, the properties will be displayed. Select "Import" from the list of tabs in the right–hand frame (or "SQL" if your phpMyAdmin version is older than 2.7.0). In the "Location of the text file" section, type in the path to your dump filename, or use the Browse button. Then click Go.

With version 2.7.0, the import engine has been re–written, if possible it is suggested that you upgrade to take advantage of the new features.

For additional help on this subject, look for the word "upload" in this document.

-------------------------------------------------------------------------

Done in a second.

A .sql file is a plain txt file.

Nevertheless, thank you for your advice.
Reply With Quote