Moving the database little by little

  • popcornnroses

    (@popcornnroses)


    11 years ago

    I’ve just switched to GoDaddy from my previous hosts, and have had considerable difficulty moving my multi-site’s database over. GoDaddy tells me I need to move it in chunks that are less than 2 MB – my database is almost 500 MB. Being new to the SQL end of things, I have no idea how to even approach doing this, and could use some step-by-step instructions on how to accomplish this. Is there a plug in or third party software out there that can help me prep the database to move within the size limits. Or can it be done via MyPHPAdmin? If someone can give me a gentle push in the right direction, I’d greatly appreciate it. I’ve been involved with this move for almost a month now and i”m going completely nuts trying to get everything done…

Viewing 2 replies - 1 through 2 (of 2 total)
  • W.P. Ginfo

    (@wp-ginfo)

    11 years ago

    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.

    bottleneck

    (@bottleneck)

    11 years ago

    @popcornnroses

    Is 500 MB file compressed or uncompressed?

    In other words, what’s your file extension?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Moving the database little by little’ is closed to new replies.