WordPress.org

Ready to get started?Download WordPress

Forums

WP Clone by WP Academy
Error Message : MySQL server has gone away (26 posts)

  1. StandOutSites
    Member
    Posted 1 year ago #

    When I first used WP Clone with moving a WordPress 3.5.1 to a new server as a test, it worked fine. But then I tried to repeat this process again, with the same host, and the same domain, and I keep getting this error "Error Message : MySQL server has gone away". I tried all kinds of combinations: full backup, just database, using wpdb -- all to no avail. What does this error mean? And why it worked the first time and now it's not working?

    http://wordpress.org/plugins/wp-clone-by-wp-academy/

  2. WP Academy
    Member
    Plugin Author

    Posted 1 year ago #

    I'm guessing a time out,but I'm not sure why (specially since it's the same server).
    are you comfortable with editing plugin files?

  3. StandOutSites
    Member
    Posted 1 year ago #

    Yes, i'm comfortable with editing plugin files. any suggestions?

  4. WP Academy
    Member
    Plugin Author

    Posted 1 year ago #

    okay give this a try,it just might work;
    the file that needs to be edited is 'wp-clone-by-wp-academy/lib/functions.php',scroll down to line 460,or in case that there aren't any line numbers,until you see
    function wpa_bump_limits(){
    add the below two lines just before the closing curly brace (or anywhere inside that function)
    @ini_set('mysql.connect_timeout', 300);
    @ini_set('default_socket_timeout', 300);
    you can use any value you like instead of '300'

  5. jowaol1st
    Member
    Posted 1 year ago #

    I'd tried that... Still no work...
    I even use value to be '999' and later 3,000
    but still getting the same error Message : MySQL server has gone away

  6. WP Academy
    Member
    Plugin Author

    Posted 12 months ago #

    I feared as much,looks like there isn't much to do until the db backup process is re-written to be more efficient..

  7. jowaol1st
    Member
    Posted 12 months ago #

    so, what next ?

  8. TheWatcher2
    Member
    Posted 11 months ago #

    I just tried WP Clone for the first time to backup my site (http://endtimestruth.com using Go Daddy hosting) and got the same error message (Error Message : MySQL server has gone away). My site isn't that large (total size of WP files is about 275 MB) and the typical database backup file is about 20 MB). Any help would be greatly appreciated, as it appears that many other users have gotten the plugin to work well.

    Thanks!

  9. WP Academy
    Member
    Plugin Author

    Posted 11 months ago #

    @jowaol1st unfortunately none,looks like we'll have to re-write some parts to get it to work with these hosts..

  10. tfmurphhk
    Member
    Posted 11 months ago #

    I just used WP Clone, for the second time ever. The first time, several weeks ago it went smoothly, no problems.

    Today when I tried it, I got the dreaded "MySQL server has gone away" ... so I tried it a second time, without changing anything and this time it "appears" to have worked successfully.

    My reason for saying "appears" is that it did not give me an html message or any completion message for that matter... but it did create two files on my server. One called pclzip-522e02ddd6374.gz and a second one called wpclone_backup_09th_Sep_2013_05-17PM_Pal_iZOb3N8Wth.zip. I don't recall it having created two files two weeks ago.

    By the way, I did use the "Advanced Settings" and checked the "Alternate Zip Method".

    Can someone at WP Academy tell me why the second file.. and a guess as to whether the one or two files are actually valid?

    Thanks

    Tom

  11. WP Academy
    Member
    Plugin Author

    Posted 10 months ago #

    pclzip creates a temporary file,but it deletes it afterwards.. the process must have gotten terminated in the middle of things,I think.

  12. MM
    Member
    Posted 9 months ago #

    Same problem!

    Been using this plugin on Bluehost sites flawlessly. Today I get this error message after trying to clone a site onto an inmotion hosting account.

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/*hidden*/public_html/*hidden*.com/wp-content/plugins/wp-clone-by-wp-academy/lib/functions.php on line 245

    Error Message : MySQL server has gone away

    Tried editing the plugin as described above. No dice.

  13. MM
    Member
    Posted 9 months ago #

    ** Update **

    I simply followed the directions listed in the 'Advanced Settings' dialog:

    Depending on your web host, WP Clone may not work for large sites. You may, however, exclude all of your 'wp-content' directory from the backup (use "Backup database only" option below), or exclude specific directories. You would then copy these files over to the new site via FTP before restoring the backup with WP Clone.

    So to reiterate:
    - Copy wp-content from OLD to NEW host
    - Select 'Backup Database Only' checkbox
    - Finally, proceed with backup

    Worked fine after this.

  14. jpw94
    Member
    Posted 8 months ago #

    My impression is WP Academy has no intentions of supporting what was one of the best utilities out there.

  15. WP Academy
    Member
    Plugin Author

    Posted 7 months ago #

    not at all jpw94,we're not abandoning wpclone :) but yes,development has been on hold due to unavoidable circumstances,but we're planning on releasing an update to fix the performance issues soon.

  16. betholsoncreative
    Member
    Posted 7 months ago #

    This Worked For Me:
    I had this problem as well and tried everything I could find here on the forums with no luck. Then I came across this article and it fixed it for me! WHEW! (it was for a client site hosted on GoDaddy and I was freaking out that it wasn't working!): http://www.techmesto.com/solving-wordpress-mysql-gone-error

    NOTE:
    When I opened the wp-db.php file to make the suggested addition the directions in the article say it can be found around line 1057. I couldn't find it near there so I did a search on the page for "db_connect_fail" and it took me to the right spot (which in my editor's case was something like line 1175).

    Hope this helps, Cheers!

  17. mlmnewsblog
    Member
    Posted 6 months ago #

    #betholsoncreative

    thanks a lot... It worked like a charm...

  18. betholsoncreative
    Member
    Posted 6 months ago #

    Glad to hear it! I think the plugin has worked like it's supposed to only once or twice. I almost always to it this way. It's a little more work but it works great!

  19. Daniel Delos
    Member
    Posted 5 months ago #

    I had this error just now so I Googled this thread but I tried again and it worked. It must be something with the web host's side as well.

    I've cloned a number of my sites and never seen this error before today.

  20. ajoull
    Member
    Posted 5 months ago #

    Same to Daniel Delos, I tried again and it worked fine. But I deleted the old backup zip first before the second try.

  21. poemihai
    Member
    Posted 4 months ago #

    Had same problem on a shared Godaddy host, in advanced settings section of the WPClone plugin i set the script execution time to 600 and worked fine.

  22. Marco Floriano
    Member
    Posted 3 months ago #

    Same problem with Siteground, tried again and worked.

  23. leclark
    Member
    Posted 3 months ago #

    As Siteground, tried second time went fine.

  24. Soody
    Member
    Posted 1 month ago #

    # betholsoncreative , Thanks

    its worked, i am using godaddy hosting & got that problem on it.
    also i am using WP 3.9.1 in case anyone thinking about version.
    i insert the code line after 25th instance of $this->dbh

    <p>If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.</p>
    " ), htmlspecialchars( $this->dbhost, ENT_QUOTES ) ), 'db_connect_fail' );

    return false;
    } else if ( $this->dbh ) {
    $this->has_connected = true;
    $this->set_charset( $this->dbh );
    $this->set_sql_mode();
    $this->ready = true;
    $this->query("set session wait_timeout=600" );
    $this->select( $this->dbname, $this->dbh );

    return true;
    }

    return false;
    }

  25. eric1985
    Member
    Posted 1 month ago #

    Having the same problem with LiquidWeb right now while moving a client site.

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/murphysx/public_html/wp-content/plugins/wp-clone-by-wp-academy/lib/functions.php on line 245
    The plugin encountered an error while cloning the database,the following error message was returned:
    Error Message : MySQL server has gone away

    Temporary files created in /home/murphysx/public_html/wp-content/wpclone-temp will be deleted.

  26. whichtransfers
    Member
    Posted 1 month ago #

    I receive this error on the website http://www.whichtransfers.com:

    The plugin encountered an error during the database backup,the following error message was returned:
    Error Message : MySQL server has gone away
    emporary files created in .../wp-content/uploads/wp-clone/wpclone_backup will be deleted.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.