Importing database from another oscommerce site...

[aussiejay]

Hi,

I am working on an oscommerce site that has the Mysql API ver 3.23.58. What i am trying to do is use this database backup and take it to a new server that has Mysql API ver 4.1.18.....the prpblem is is that it appears that none of the customer data has been picked up and it is causing all sort of errors.

Are changes in the table structure between these versions or issues with the old .sql file on the new server??

Is this right?

I have tried importing the 3.23.58 db via the Oscommerce backup/restore after FTPint the file the the install/backups dir, i have also tried using the MyPHP method.

I have made sure that i have FTp'd the backup.sql to the new server and renamed it oscommerce.sql in catalog/install/oscommerce.sql for initial install (i guess this is to maintain the table structure in the new database)

The 3.23.58 database HAS been imported i can view all the products and previous orders, but it seems to have failed for the customer data only. I can see the customer orders, catalog, all the products and modules...


The errors i am seeing are as follows:


1054 - Unknown column 'customer_id' in 'field list'

insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'f650def69f6cf604411ac48d591a105f', '211.28.231.146', '1150024865', '1150024865', '/catalog/index.php')

[TEP STOP]



1146 - Table 'websited_scrapbook.customers' doesn't exist

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id

[TEP STOP]


Does anyone know if this is a MYsql version error?

Appreciate any help on this one..


Jason