Hi

I'm trying to recreate a copy of my Intranet site at work (which runs on Xoops) locally at home. I've got a backup of the database using phpMyAdmin and all the XOOPS files.

I've installed XAMPP and got all that up and running a treat. No problems there.

However, when I try to restore my database using phpMyAdmin I get an error where it states that the syntax is wrong.


So I tried installing MySQL Administrator instead and used it's restore feature (which is great by the way). I have tried it using both Latin1, Latin5 and UTF-8 as the encoding method. Using every one it reads the entire backup (it takes a couple of minutes to do in fact) and then says that the restore was successfull. Bu when I go and examine the database, all the tables are there, but empty. They all say 0 bytes for the 'Data Lenght' and the 'Index Length' all say 1Kb. No data in em!

No, I'm guessing that the problem here is that the database at work uses MySQL 4.0.x (can't remeber exactly which version, but it's about 8 months old) and XAMPP uses the MySQL 5 I think. But I though MySQL Administrator could deal with both 4 and 5 database backups.

Does anyone know what the problem could be and how to fix?

Thanks

Ted

What was the original database version, and what version are you importing to?

The backup version is MySQL Server 4.1.11 using phpMyAdmin 2.6.0 and PHP ver 4.3.7.

The restoration is using MySQL Server 5.0.15 (that came shipped with XAMPP) and MySQL Administrator 1.0.21 having just downgraded it from 1.1 to try and resolve above issue, but made no difference.

Therefore, as stated, I suspect it's a version issue but I'm not sure how to fix it.

Does this help JD?

Ted

Not sure, Google for the MySQL --compatible command from your version to the new version, see if you find any hits on it.

Sorry not feeling well at the moment or would check for you.

Had to resort to uninstalling version 5that came with XAMPP and downloaded and installed version 4.1.1. from mysql.com. Spent another hour or so trying to work out how to remove the old version 5 MySQL service in order that the version 4 service could start . click here if you are having same problem).

Eventually got that working, and got MySQL Administrator and MySQL Server 4.1.1. to play with each other.

The restoration of the version 4 backup was still unsuccessfull. I don't get it. Giving up for now

Ted