moving database from one server to another

  • Resolved Glowe

    (@glowe)


    11 years, 8 months ago

    When I move my database from one server to another I get lots of errors.
    I use same version of database, same version of php and just move the folder from old server, /var/lib/mysql to same folder on the new server.

    I have try everything I can think of and google for hours but no soulutioon.

    The errors I get when I try to repair is:

    wp_users: Table is marked as crashed and last repair failed
    wp_usermeta: Table is marked as crashed and last repair failed
    wp_posts: Table is marked as crashed and last repair failed
    wp_links: Table is marked as crashed and last repair failed
    wp_options: Table is marked as crashed and last repair failed
    wp_postmeta: Table is marked as crashed and last repair failed
    wp_terms: Table is marked as crashed and last repair failed
    wp_term_taxonomy: Table is marked as crashed and last repair failed
    wp_term_relationships: Table is marked as crashed and last repair failed

    Anyone here who know why this happens?
    Everything works fine on the old server and no problems there.

    [ Please do not bump, that’s not permitted here. ]

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

  • Hi,

    Have you considered this?
    Step 1
    Dashboard > Extra > Export > Entire content
    You may be asked to install and run an export plugin
    Run the plugin
    Save database file to your desktop.

    Step 2 In the NEW empty website
    Import the backup in the new [empty] site:

    Dashboard > Extra > Import > WordPress
    Select the created database file
    You may be asked to install and run an import plugin
    Run the plugin

    Check the result
    You should be able to see the entire content of the old site.

    ONLY when the transfer clearly has been successful, you can delete the original database / site etc.

    Thread Starter Glowe

    (@glowe)

    We found a soulution.
    Upgrade mysql on the old server.
    Dump files from mysql and import to the new one.

    Now runing smooth.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘moving database from one server to another’ is closed to new replies.