By charly on

Hi

Is there some issue ragarding drupal and mysql 4?
I ran drupal on my localhost using mysql 5 without problems. Then i exported my database using "mysqldump --create-options --compatibility=mysql40" cause the server the site is running on uses mysql 4. The site dumped the online database, and now my watchdog & accesslog (and some more) tables produces warnings and are not working anymore.
Warnings are "user warning: Duplicate entry '0' for key 1".

I tried dumping database twice, after checking it was running fine on localhost.
I could still try to install mysql4 on my host, but i would like to find a solution before...

Thanks

Charly

⋅ Categories: Drupal 4.7.x

Comments

lisa’s picture

lisa commented

I've had the same problem migrating from MySQL 5 to 4. I built a site on my localhost which is using MySQL 5 and everything worked fine.

But my host is running MySQL 4 so I did the mysqldump with the necessary --compatible=mysql40 option.

After importing data to the database on host server, I am also seeing watchdog and locales_source tables produce warnings:
Warnings are "user warning: Duplicate entry '0' for key 1

Anyone else experiencing this or have a solution?

heine’s picture

heine commented

mysqldump is broken. When using the --compatible=mysql40 flag, it strips auto_increments from fields (that's why you see the error). See http://bugs.mysql.com/bug.php?id=14515

It has been fixed in MySQL 5.0.23. If you can upgrade, otherwise export without the compatability flag and strip the offending commands by hand/script.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.

lisa’s picture

lisa commented

Thanks for pointing me toward a solution. Just to confirm will MySQL 5.0.22 fix the problem? I don't see a 5.0.23 at

http://dev.mysql.com/downloads/mysql/5.0.html

heine’s picture

heine commented

Sorry, it seems that the fix hasn't been released yet; it has been around in their source tree for a while; when I saw the fixed announcement I thought the mysql team just released the new version. alas.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.