converting mysql 4.1 export from phpmyadmin to 5.0 import sql. ouch!!

[ultrus]

Hello,

My uncle has a WordPress website with all the pages and posts stored in a mysql 4.1 database. He's moving the website to a new location where a mysql 5.0 database is available. I was able to export the data and structure from his old website using phpmyadmin.

 

When I connect to the new database directly through navcat and try to run the query, I have troubles on a couple tables - the wp_options table so far. I'm wondering if there are some syntax fixes I can search and replace for to make it 5.0 happy. Any thoughts?

 

I went ahead and and attached the wp_options 4.1 export. Let me know if I can provide further info or re-export in any way. Thanks for the assist in advance!!

 

[attachment deleted by admin]

[fenway]

What kinds of "trouble"?

[ultrus]

That's a good question. At first I tried to export all the tables and run the query in the new database with the query taking too short of a time to run, no errors, and no tables. I started exporting each table one at a time. Everything was good until I tried to import/run the options sql. Same result. No error. No table imported. I can start trying to import one line at a time to see what line is causing issues.

[fenway]

Maybe one block at a time?

[Mchl]

Try setting compatibility mode in PhpMyAdmin, both when exporting and importing.

[ultrus]

Here's a line that is not working. I'm wondering if it has something to do with the \r\n , or some other odd combo...

 

INSERT INTO `wp_posts` VALUES (3, 2, '2008-11-15 15:25:21', '2008-11-15 22:25:21', '<h2>Full Service Network Solutions Provider</h2>\r\n<table>\r\n<tr>\r\n<td style="padding-right: 24px;"><img src="http://www.toysandtweaks.com/wp-content/uploads/2008/11/homeportrait.jpg" alt="" title="home page image" width="235" height="500" class="alignnone size-full wp-image-144" /></td>\r\n<td>\r\nMedical practices trust ProMed Networks, Inc. for superior full service networking solutions, including:\r\n<ul>\r\n<li>Minimize Internet and network risk with state of the art solutions</li>\r\n <li>Privide IT solutions for small to medium sized medical practices</li>\r\n <li>Deliver on time and within budget</li>\r\n<li>Provide technical guidance and training as needed</li>\r\n <li>Develop strategic alliances that will provide the best one stop, one shop equation</li>\r\n<li>Provide the doctors and their staff with a quick alarm response solution to equipment failures and network issues</li>\r\n<li>Remain as non-obstructive as possible</li>\r\n</ul>\r\nWe are currently servicing areas such as Castle Rock, Highlands Ranch, Centennial, Lone Tree, Englewood, Lakewood, Wheatridge, Arvada, Aurora, Denver Metro, Golden, North through Fort Collins in Colorado.\r\n\r\n<img src="http://www.toysandtweaks.com/wp-content/uploads/2008/11/whereisyourdatatonight.jpg" alt="" title="Where is your data tonight?" width="198" height="198" class="alignnone size-full wp-image-146" style="float: right; margin-left: 6px;" />Don’t take chances with an at-risk network that could potentially fail, destroying your valuable data, causing your work place to be inefficient, and ineffective. Instead, <a href="/contact-us">contact us</a> for a no-cost consultation.\r\n<div class="caption">Right: Medical professional in Colorado lost all data in a “fire proof” safe during an office fire. After contacting ProMed Networks, this client is now prepared for future success in any situation.</div>\r\n</td>\r\n</tr>\r\n</table>', 'Home', 0, '', 'publish', 'open', 'open', '', 'home', '', '', '2008-11-29 11:32:15', '2008-11-29 18:32:15', '', 0, 'http://www.toysandtweaks.com/?page_id=3', 0, 'page', '', 0);

 

Any thoughts?

[fenway]

And what error do you get from runnign that insert statement?