Import old database to new site

[z0rr0]

I have a .sql file with my old database and trying to import/replace it to the new database.

So when I try:

 

1.Import->browse->old_database.sql I get #1050 - Table 'address_book' already exists

2. SQL-> and I paste for example INSERT INTO `categories_description` VALUES (64, 4, 'InkJet', 'InkJet', 'InkJet', 'InkJet', NULL, ''); I get #1136 - Column count doesn't match value count at row 1 .Note: before the second methode import I did insert successfuly INSERT INTO `categories` VALUES (45, '', 42, 0, '2007-08-09 23:18:36', '2007-11-02 01:14:19');

 

What is the problem ???

Thanks

[♥geoffreywalton]

Look at the file you are tring to import is for a different version to the one you have installed.

 

The number of fields in the table have changed between versions.

 

Also the import sql is trying to create a file using sections starting

 

CREATE TABLE address_book (

 

Look for contributions or documentation on upgrading they should contain instructions on "convertng" the files.

 

Got to go out so I'll let you take over now.

[z0rr0]

The old .sql file starts with:

-- phpMyAdmin SQL Dump

-- version 2.9.0.2

-- http://www.phpmyadmin.net

and after I export from my new database the .sql file starts with:

-- phpMyAdmin SQL Dump

-- version 2.10.0.2

-- http://www.phpmyadmin.net

 

So I guess the old database was in different version.I search for a convert/upgrade tool but no luck. :'(

[z0rr0]

Solved the problem.I just droped the new database and imported the old one :-"

[♥geoffreywalton]

The version difference is not phpmyadmin but between the versions of os commerce.

 

Trouble with that is the new code will expect the extra fields in the db you just dropped.

 

Look in the extras directory the the standard install has.