Trouble Importing Database After Moving to New Web Host

  • Resolved youthman

    (@youthman)


    9 years, 8 months ago

    This is my first attempt at moving a wordpress site from one host to another but have run into some issues. It seems straight forward, especially since the domain is remaining the same.

    Here is what I have done.

    1) Backed up the database
    2) Downloaded the WordPress Files via Filezilla
    3) Created new database with new webhost
    4) Uploaded WordPress files via Filzilla to new webhost
    5) Updated config.php with new database info and uploaded to new server
    6) Installed basic wordpress site on new server
    7) Logged into myphpadmin on new server and imported the database backup.

    The new site seemed like it was working just fine then I went to the home page and it now is showing “Hello World” and the generic wordpress site.

    Then when I logged into WordPress, it only showed the “Sample Page” but after a few seconds, it loaded the rest of the pages.

    Now when I go to the home page, I get a “Problem Loading Page”.

    The website is https://www.citylifechurch.cc

Viewing 6 replies - 16 through 21 (of 21 total)
  • Thread Starter youthman

    (@youthman)

    Tara, I figured the original developer did that for added security.

    I found this site https://digwp.com/2010/10/change-database-prefix/ that recommends changing the defauld wp_ prefix in the config.php file BEFORE installing WordPress. I just created a new database and changed the prefix from wp_ to wp_m010svz2ny_ and am uploading the previous database to the new server.

    I’ve got my fingers crossed!

    Thread Starter youthman

    (@youthman)

    I just received an error saying one of the tables already existed. Do I need to delete the database and NOT do a WordPress install and just import the old database into the new database? I believe I tried this before and when WordPress loaded, it asked me to install WordPress which would create the additional default wordpress tables with the default wp_ prefix. I wonder if it wouldn’t do that now that I added the custom prefix to the config.php file?

    Thread Starter youthman

    (@youthman)

    I keep getting duplicate entry errors when uploading the backed up database to the new database

    #1062 – Duplicate entry ‘_transient_woocommerce_cache_excluded_uris’ for key ‘option_name’

    Man this has been a frustrating day. LOL

    It seems the developer has taken a security measure like this. If this is true all WordPress tables should have the give prefix ‘wp_m010svz2ny_’.

    Why don’t you start over one more time?

    Install a clean WordPress website. Make sure you use the given username/password for the database (see “wp-config.php”)!

    Import the database.

    Edit one line in the following file in the root of the installation: “wp-config.php”. Make a backup for editing this file.

    Find the line saying: “$table_prefix = ‘wp_’;”

    Change this text to:
    “$table_prefix = ‘wp_m010svz2ny_’;”

    Save the file and surf to: https://www.citylifechurch.cc

    If this edit does not help keep this prefix till the website works. You will need it and something other seems to be wrong.

    Thread Starter youthman

    (@youthman)

    It was a REALLY long day & night troubleshooting this issue. I ended up contacting 1and1 and they said the reason the import kept erroring out was due to the file size. Even though zipped it was only 6MB, the unzipped file was 60MB and 1and1 only allows up to 50MB.

    They ended up importing the database using SSH so it is now up and running. I was doing everything correctly but it was a physical limitation within phpmyadmin.

    Now I just have to tweak some pages but at least the site is live again.

    Moderator t-p

    (@t-p)

    glad yo know it ??

Viewing 6 replies - 16 through 21 (of 21 total)
  • The topic ‘Trouble Importing Database After Moving to New Web Host’ is closed to new replies.