Hi,
I have a MySQL 3.23.49 database, that was modified to perform transactions, on one server and I am trying to transfer it over to another server that has MySQL 4.0.4. I was wondering if someone could tell me the proper way to transfer a db? I am working on a WinXP machine and I tried just copying it, but it didn't work. When I tried it it told me I was missing some of the innoDB tables. I am guessing that it has something to do with the ibdata files that I had to create for the MySQL 3.23.49 database in order to support transaction, but I am just guessing.
Any help?
Thanks in advance,
Piet