mark27uk3 Posted March 11, 2004 Share Posted March 11, 2004 Hi Guys, Whats the best way to export data from 1 database to another? I have tried exporting the products using phpmyadmin but when I try to run the products.sql file I get this error: Error SQL-query : INSERT INTO products VALUES ( 52, 1, '', '3310images/nokia3310dhmuffdiver.jpeg', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '5.9900', '2004-01-06 18:40:31', '2004-01-27 17:58:34', NULL , '0.00', 1, 0, 0, 0 ) MySQL said: Column count doesn't match value count at row 1 Back What does this mean and what do I need to do to my new database to accept my product data. Thanx Mark :( Lifes a bitch, then you marry one, then you die! Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2004 Share Posted March 11, 2004 why dont you just do a backup of the database via the admin tool backup, then go into the sql file with wordpad, dreamweaver, visual studio (some sort of text editor) and then get the items you need. if you are adding to a database already populated, then you will need to remove the 'DROP' of the database Link to comment Share on other sites More sharing options...
mark27uk3 Posted March 11, 2004 Author Share Posted March 11, 2004 That sounds a bit complicated for me, am I able to do it using easy populate? Lifes a bitch, then you marry one, then you die! Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2004 Share Posted March 11, 2004 if the tables match, you can. Link to comment Share on other sites More sharing options...
mark27uk3 Posted March 11, 2004 Author Share Posted March 11, 2004 Unfortunately they dont, to be quite honest I dont have a clue what I am doing with databases. Lifes a bitch, then you marry one, then you die! Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2004 Share Posted March 11, 2004 if the tables do not match, then the the code for the stores does not match? Link to comment Share on other sites More sharing options...
mark27uk3 Posted March 11, 2004 Author Share Posted March 11, 2004 I guess I will have reside myself to the fact the I will have to load all my products again. Thanx Mibble Mark Lifes a bitch, then you marry one, then you die! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.