WordPress.org

1. dazzlindonna
   Member
   Posted 6 years ago #

   In moving my blog to a new server, I followed all instructions. Using phpmysql, I had to export the database using the option to save as MySQL 3.23 (current server is using MySQL 4.1.15).

   Upon restoring the database to the new server, there are two problems:

   1. Lots of funny characters. Am assuming the charset is messed up, but don't know how to fix. Looking at phpmyql on original server, it showed:

   Language: English (en-utf-8)
   MySQL Charset: UTF-8 Unicode (utf8)
   MySQL Connection Collation: utf8_general_ci

   The new server doesn't come with phpmsql (using CP+), so I don't know if I can find the same information on the new server.

   Any ideas on how to fix this?

   2. Permalinks are broken. 404 errors. Domain name hasn't changed. Checked the wp_options table in the database, but didn't see anything amiss. I thought maybe it was due to a different path structure, but don't know where to change the path info (if anywhere).

   Any help would be appreciated. (Oh, and yes, I did search first for previous answers, but couldn't find anything that would help me).

2. Mark (podz)
   Support Maven
   Posted 6 years ago #

   2.
   That's a htaccess problem. Delete any old one from the server (but keep a copy) then generate a new one.

   1. When exporting, don't choose any of those 'export options'. Doing so usually causes errors. Check the screenshots I have and ignore any extra's that have been added in subsequent versions. Did you follow my guides ?
   http://www.tamba2.org.uk/wordpress/

3. dazzlindonna
   Member
   Posted 6 years ago #

   Regarding the htaccess - the new one I generate looks exactly like the old one.

   Regarding the export options. If I don't choose to export at 3.23, the restore process fails on the new server.

4. Mark (podz)
   Support Maven
   Posted 6 years ago #

   Let's leave the htaccess for later :)

   How does the export 'fail' exactly? What is the error you see?

5. dazzlindonna
   Member
   Posted 6 years ago #

   I dont remember the exact wording, but it was something about a mysql syntax error on line 10 having to do with "ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8"

   hmmm...maybe if i take out the charset=latin1 part...

6. Mark (podz)
   Support Maven
   Posted 6 years ago #

   DEFAULT CHARSET=latin1

   delete all those and you'll be fine :)

   Do a search/replace and replace with nothing

7. dazzlindonna
   Member
   Posted 6 years ago #

   great, i'll give it a try right now. i'll report back.

8. dazzlindonna
   Member
   Posted 6 years ago #

   Still didn't work. Here's the error I get now...

   ERROR 1064 at line 20: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT AUTO_INCREMENT=8' at line 10

   oh, crud, wait, i didnt delete the word default. will redo.

9. dazzlindonna
   Member
   Posted 6 years ago #

   Nope, now the error is:

   ERROR 1064 at line 20: You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=8' at line 10

10. dazzlindonna
    Member
    Posted 6 years ago #

    GOT IT! I compared the two versions, and changed ENGINE=MyISAM to TYPE=MyISAM, and it worked! No more funny characters! Woohoo!

    SPOKE TOO SOON. The funny characters are still there. Didn't see them in the first post on the home page, but they are in the rest of the posts.

    Now, to get the permalinks to work...

11. dazzlindonna
    Member
    Posted 6 years ago #

    Ok, the funny characters are in the actual .sql file itself, so phpmyadmin is creating the file with them in it. Wish I could figure out how to tell it not to do that.

12. dazzlindonna
    Member
    Posted 6 years ago #

    Ok, I went through and did a find and replace on all the funky characters, replacing them with a backslash and quote or whatever it needed to be. After much trial and error, it seems to be displaying correctly now. That was the biggest headache I could ever possibly imagine.

    Now...on to the htaccess problem. Help?

13. Chris_K
    Member
    Posted 6 years ago #

    If you set your permalinks to default, do you still get 404s?

    Is your .htaccess writable by the webserver process?

    Some stuff to try in this post: http://codex.wordpress.org/Using_Permalinks#Fixing_Permalink_Problems

14. dazzlindonna
    Member
    Posted 6 years ago #

    If I set it to default, I do not get 404s.

    htaccess is not writable, since I can't seem to find a way to do that via my new control panel (cp+). so i've just manually added the rules to htacess locally and ftp'd it up.

    i know the server can handle rewrites, because it is handling my non-www to www rewrite fine.

15. dazzlindonna
    Member
    Posted 6 years ago #

    HandySolo, that url ended up helping me after all. It was a problem with the httpd.config having AllowOverrides set to none. All is well now. Thanks!

16. Chris_K
    Member
    Posted 6 years ago #

    Glad to be of service. :-) Happy blogging!

Topic Closed

This topic has been closed to new replies.