Forums

MySQL Problems (6 posts)

  1. lcherolis
    Member
    Posted 3 years ago #

    Does anyone have any serious MySQL help links they can share?

    We've got three wordpress blogs that we're trying to move to a new server and keep hitting roadblocks trying to get the old posts to show up on the new server.

    We've searched and replaced the old urls in the SQL files. We've checked and double checked the wp-config files are correct. Old posts still won't show up.

  2. Samuel B
    moderator
    Posted 3 years ago #

    on the new server - did you reset the permalinks?
    admin - settings - permalinks

    Also, wordpress has the native import/export function. Did you try this?

  3. lcherolis
    Member
    Posted 3 years ago #

    Samboll, my permalinks are set to default. Is this a problem?

    I did not know about the native import/export function. It says it imports WordPress WXR files. What is the procedure to create one, and will it involve resetting my domains back to my old server and logging in to my old sites?

    Good think they haven't been removed from my old server yet!

  4. Samuel B
    moderator
    Posted 3 years ago #

    log in to old wordpress - export
    admin - tools - export

    log in to new wordpress - import
    admin - tools - import - the file you exported

    default permalinks are fine

  5. lcherolis
    Member
    Posted 3 years ago #

    I exported the WXR file and when attempting to import it on my new server I get this error message:
    Unable to create directory /home/.fickel/biscuitp/bytm.biscuitpress.com/brainstormingcomics/wp-content/uploads/2009/03. Is its parent directory writable by the server?

    It appears to be trying to write to my old server. It should be trying to write to brainstormingcomics.com/wp-content/uploads...

    Why is it looking for home/.fickle/my old URL... etc?

  6. lcherolis
    Member
    Posted 3 years ago #

    Ah. Fixed it. Needed to try importing the data from a fresh install.

    Thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic