This is a discussion on Importing .SQL file within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; Please can somebody tell me how I import my database from home. I have exported my database at home to ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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? |
|
#2
| ||||
| ||||
| You may not have root access, check the login details. Also, you could try using phpmyadmin, and running a query from there. |
|
#3
| |||
| |||
| I'm sorry but could you tell me how i would run the query from MySQL. I have got PHPMyAdmin installed. |
|
#4
| ||||
| ||||
| 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. |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importing database from another oscommerce site... | aussiejay | osCommerce 2.2 Installation Help | 0 | 06-11-2006 05:10 PM |
| Installed and upgrading from osc 2 database needs importing | gamefreak7 | osCMax v2 Installation issues | 4 | 07-17-2005 10:31 AM |
| Importing a Click Cart Pro product.csv file to oscommerce | nut | osCommerce 2.2 Installation Help | 2 | 02-26-2005 08:11 AM |
| Importing from msAccess | damnedpig | osCMax v1.7 Discussion | 1 | 04-16-2004 11:19 AM |
| Importing data with Easypopulate | michael_work2003 | osCMax v1.7 Discussion | 8 | 03-27-2004 01:30 AM |