ALL websites “connection was reset” after cloning WP to subfolder

  • Hi guys,

    Really stressed out here.
    I needed a working clone of a website into a subfolder so that I can test things out on it, but needed it to have the same content and everything.

    I previously tried WP-MU and WP-Hive with no success.

    This is what I did:

    1. Use WP Backup to backup all the database tables into an SQL file
    2. Edit SQL file to replace domain with domain/subfolder
    3. Use BigDump with config.php file with new database settings
    4. Upload and import SQL file into new database
    5. Upload entire previous website root folder into the subfolder

    THE PROBLEM:
    During the upload, the connection disconnects and cannot reconnect and ALL of my websites on ALL the databases at 1and1 stop working both through FTP and through domain access with the error message “connection was reset”

    The problem is fixed by deleting the new database.

    Clearly something in the clone is wrecking everything so this is no issue with the uploading of the files, but I have no idea how I can fix this.

    Doing a manual installation and copy pasting values, installing same plugins, importing settings doesn’t work because the previous web designer must have edited some of the php files through a text editor.

    Didn’t think this would be such a hassle!
    Another thing to mention is that in wp_options, I have an entry for “_transient_random_seed” followed by a random set of letters and numbers and the word ‘yes’
    I have no idea whether this has to be unique or at all what it does.

    If anybody has any help or advice, then please let me know as this is really frustrating me now.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator James Huff

    (@macmanx)

    Try this instead:

    1. Follow this guide to use phpMyAdmin to backup all the database tables into an SQL file
    2. Edit SQL file to replace domain with domain/subfolder
    3. Create the new database and database user in your hosting provider’s control panel
    4. Follow this guide to use phpMyAdmin to “restore” the tables into the new database.
    5. Upload entire previous website root folder into the subfolder
    6. Edit the wp-config.php file as necessary

    Thread Starter gurdain

    (@gurdain)

    Hi there

    Thanks for the help

    I did the backup through phpmyadmin but it did not show all the tables, only the database name.

    Replaced the domain information

    Database is just over 20mb in SQL format, so couldnt import in phpmyadmin which has limit of 2mb. I tried zipping it and telling it to autodetect compression but that did not work. I might be able to gzip it but not sure how – I’m running Windows 7 64 bit.

    I tried using bigdump to import the file, but looking at my database it seems that some of the database is in utf8 and some of it in latin1 – I don’t know if bigdump can handle this….

    Thread Starter gurdain

    (@gurdain)

    ok I managed to export the tables exactly like your guide

    uploading with bigdump now and website hasnt crashed so far

    phpmyadmin is showing identical database information so all looks good at the moment

    Thread Starter gurdain

    (@gurdain)

    Failed again.

    The database seemed fine. Before uploading I replaced all the domains with the new one.

    But somewhere during FTP transfer into the subfolder, the whole thing loses the connection and all the sites hosted just go down with the same error message “the connection was reset while the page was loading”

    I check the files uploaded and they’re meaningless to cause an error – just photos etc. Even if I delete any config or php files, the error remains.

    Only when I delete the new database, does everything go back to normal.

    I really don’t understand it…

    Moderator James Huff

    (@macmanx)

    If you’re losing the connection during the FTP transfer too, that’s definitely a server problem. You should contact your hosting provider.

    Thread Starter gurdain

    (@gurdain)

    Yeah

    I just tried again by making a subdomain forwarded to another area of webspace (not in a subfolder)

    Same thing happened – importing the database fine
    Somewhere randomly during the FTP upload, all websites crash and lose FTP

    Had to delete the new database AGAIN for the 5th or 6th time…

    Thread Starter gurdain

    (@gurdain)

    On the second 1and1 package, there is no problem – so it appears everything on the 1and1 professional package goes down.

    I can access the 1and1 back end, but all the websites go dead including FTP access.

    Moderator James Huff

    (@macmanx)

    Have you contacted 1and1’s support department yet?

    Thread Starter gurdain

    (@gurdain)

    I have contacted them and working through the problem at the moment, will post back later

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘ALL websites “connection was reset” after cloning WP to subfolder’ is closed to new replies.