Importing .SQL file

Anonymous · 11-06-2002, 06:13 AM

Please can somebody tell me how I import my database from home. I have exported my database at home to a file called catalog.sql. How do I import this to my computer at work.

I have tried using the following at the command prompt:

c:\mysql\bin\mysql -u root -p <c:\backup\catalog.sql>

but I am getting a File Creation error.

Can anyone help?

**michael_s** · 11-06-2002, 12:51 PM

You may not have root access, check the login details. Also, you could try using phpmyadmin, and running a query from there.

Anonymous · 11-07-2002, 08:10 AM

I'm sorry but could you tell me how i would run the query from MySQL. I have got PHPMyAdmin installed.

**michael_s** · 11-08-2002, 06:54 AM

In phpmyadmin, select your shopping cart database. Depending on your version of phpmyadmin, find the tab that says "SQL" and click it, or on older versions, scroll down and look for a text box the has the words "Run SQL query/queries on database" near it.

Once you have found this, simply copy and paste your sql file to the text box, or click the browse button, and locate the sql file on your hard drive. Select it and click the "Go" or "Run Query" button (again depending on your version of phpmyadmin).

You will get a query report in a moment, it will either show all your data, or an error message. If you get an error, there is something wrong with the syntax of the sql file.

Good luck.