Moved to new server, database broken

  • DisplacedHoser

    (@displacedhoser)


    15 years, 11 months ago

    I just moved WordPress from my old server (JustHost) to a new one (Verve Hosting). My blog is called “loveofallwisdom.com”; on the old site it was in the root, but now I’m trying to install it in a subdirectory as an addon domain. (My account with Verve Hosting is under “gasfoodblogging.net”; I’ve set the addon domain loveofallwisdom.com to point to “gasfoodblogging.net/loveofallwisdom”.)

    I did a one-click install with Fantastico, dropped the old database and restored from backup, as instructions recommended. My front page will load and my site admin pages work, but everything else (all my old posts, clicking on tags, categories, etc.) does not work. (Plus, Unicode diacritical characters appear as “?”.) My database now appears to be named gasfoodb_wrdp1 instead of loveofa1_wrdp1, so I changed my wp_config file accordingly; but that didn’t seem to fix anything. Any ideas what I can do to fix this?

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    15 years, 11 months ago

    You need to review Moving WordPress

    The old database loveofa1_wrdp1 is at your old host, so the DB_NAME should be gasfoodb_wrdp1.

    You should use the http://wordpress.org/extend/plugins/search-and-replace/ plugin and replace your old URL with your new URL. Don’t forget to update your Permalinks when done.

    Also you might try deleting the DB_COLLATE and DB_CHARSET values in your new wp-config.php for the ‘Unicode diacritical characters’. See http://codex.wordpress.org/Editing_wp-config.php#Database_character_set

    Thread Starter DisplacedHoser

    (@displacedhoser)

    15 years, 11 months ago

    Thanks. The basic database problems are fixed. The diacritics still aren’t working, though. Deleting (or commenting out) DB_COLLATE and DB_CHARSET doesn’t fix anything, though; it actually makes it worse. When I do that, even standard French and German diacritics (like é) don’t work (they get replaced by a “?” inside an opaque diamond shape), in addition to my usual problem that more obscure Sanskrit diacritics (like ā) get replaced by a ? character. A friend suggested “make sure your MySQL tables use Unicode to encode their data.” How do I do that?

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Moved to new server, database broken’ is closed to new replies.