Trying to use phpmyadmin to export an old blog in mysql 4 to import into its new home on a mysql 5. Getting an error in input. Any ideas what I need to set to get this thing to import?
Google+: View post on Google+
Post imported by Google+Blog. Created By Daniel Treadwell.
What error specifically? Are are both databases set to the same character type encoding (UTF-8)?
ReplyDeletegood luck
ReplyDeleteThey should be. Trying to check that out now.
ReplyDeleteI'm pretty sure there is a checkbox to include the create statements. What format are you exporting to?
ReplyDeleteIll have to get back to it. Heading out the door. It does not offer a format like it does in 5. So ill play more later.
ReplyDeleteI'd be willing to help later if you still need it. I'm not a dedicated DBA, but as a Software Engineer I do SQL work every day.
ReplyDeleteSorry, I do Microsoft SQL, but if you still need help tonight, I'll see what I can do
ReplyDeleteCan you post the stack trace on the error? I do tons of ETL.
ReplyDeleteJust got home and have been working on it. Looks like I got it transferred. I ran into an issue when trying to upload the sql file in zip form as it had spit out. I uploaded it as text and it propagated. Now time to see if I can get WP installed over this old dump.
ReplyDeleteAnd it looks like I did have to convert the character set. I simply chose the correct language in the phpmyadmin and it seems to have worked. We shall see once things are up.
Thanks for everyones help. It did help me think in the right direction. This is why G+ ROCKS!
Install the same version of WP you were using before, and point it at this DB. Once that works, you can upgrade WP and it will take care of any needed schema changes.
ReplyDeleteGot it working :) Thanks. Sadly I am missing all my images. But hey, its been over a years since this blog has been up. Just glad I had the database.
ReplyDeleteIf you still have access to the files of the old site, WP defaults to putting them in wp-content/uploads I do believe.
ReplyDelete