mySQL 4 to 5 - Migrating the database

[Guest]

I want to install my osCommerce webshop on a new server using the latest osCommerce 2.2 RC2a. The old webshop's database is made on mySQL4.1 and the new server's got mySQL 5. When I try to export my database tables from the old to the new server, none of this information show up in the new osCommerce webshop. How do I make the osCommerce 2.2 RC2a talk with my imported database tables?

[MrPhil]

Are the tables showing up in phpMyAdmin (or other database GUI)? When you exported the old database, did it include CREATE TABLE statements? Did it include INSERT INTO statements to load the tables? Did you create the tables with a new installation of osC and only use INSERT INTO statements to load the tables (after removing duplicate table rows)? Or did you get rid of any newly-created tables and use the CREATE TABLEs in the .sql file?

 

Are you changing osC versions at the same time that you're transferring the database and server? You might want to do one thing at a time, if you can. How old of version of osC are you transferring from? You may need to create some new tables and/or add some columns for it to work with 2.2 RC2a.

 

Tell us what is in the .sql (export file) and what (if any) database tables you have when you try to import it via phpMyAdmin. What does phpMyAdmin show for database content (tables, rows in tables) before and after importing? If the tables appear to be loading up OK, are you getting any error messages when you run osC? What exactly are the symptoms?

 

And of course, you are aware that you need to make PHP code changes in osC in order to run with MySQL 5? If you don't, you will get "1054" errors.

[aabrahao]

Hi,

 

I migrated from mysql 4 to mysql 5 and still using php 411

After the migration I cant in /admin, if a wrong user or pass is typed appears an error message, but it a correctly user or pass is inserted nothing happens, still in login page.

Any suggestion?

 

Regards,