Support » Plugin: NS Cloner - Site Copier » MySQL server has gone away

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Never Settle

    (@neversettle)

    That is actually caused by your MySQL timeout, not the PHP timeout.

    You may want to look at this answer on how to increase that.

    If that doesn’t work you can refer to https://dev.mysql.com/doc/refman/5.0/en/gone-away.html for additional info on what might be causing the problem.

    Thread Starter rasmas

    (@rasmas)

    Many thanks, but where I have to add these lines?

    ini_set(‘mysql.connect_timeout’, 300);
    ini_set(‘default_socket_timeout’, 300);

    Plugin Author Never Settle

    (@neversettle)

    You can put them in any PHP file that gets loaded as part of WordPress. I would recommend either wp-config.php or your theme functions.php.

    Thread Starter rasmas

    (@rasmas)

    Doesn’t fix. 🙁

    Seems crashing after 30 seconds.
    Seems the last operation is:
    usewpress; INSERT INTO wp_7_options (option_name, option_value, autoload) VALUES ('siteurl', 'http://ref.local', 'yes'), ('home', 'http://ref.local', 'yes'), ('blogname', '[...]', 'yes'), ('blogdescription', '...]', 'yes'), ('users_can_register', '0', 'yes'), ('admin_email', 'you@example.com', 'yes'), ('start_of_week', '1', 'yes'), ('use_balanceTags', '0', 'yes'), ('use_smilies', '1', 'yes'), ('require_name_email', '1', 'yes'), ('comments_notify', '1', 'yes'), ('posts_per_rss', '10', 'yes'), ('rss_use_excerpt', '0', 'yes'), ('mailserver_url', 'mail.example.com', 'yes'), ('mailserver_login', 'login@example.com', 'yes'), ('mailserver_pass', 'password', 'yes'), ('mailserver_port', '110', 'yes'), ('default_category', '1', 'yes'), ('default_comment_status', 'open', 'yes'), ('default_ping_status', 'open', 'yes'), ('default_pingback_flag', '1', 'yes'), ('posts_per_page', '10', 'yes'), ('date_format', 'j F Y', 'yes'), ('time_format', 'G:i', 'yes'), ('links_updat[...]

    Plugin Author Never Settle

    (@neversettle)

    Thanks for the update, rasmas.

    Unfortunately we can’t provide free support for environement/hosting issues – I would recommend contacting your host to see if they can lengthen the mysql timeout for you.

    Thread Starter rasmas

    (@rasmas)

    Hi.
    I’m running on local using EasyPHP so I could modify any MySQL setting.
    I have changed all timeout settings of mysql, but the process doesn’t work.

    Thanks.

    Thread Starter rasmas

    (@rasmas)

    Maybe there could be some troubles when clone the “master” site?

    Plugin Author Never Settle

    (@neversettle)

    It’s probably not “master” site specific – any site takes about the same amount of time to clone so the timeout would have the same effect. If the ini_set method doesn’t work, you could try looking for php.ini and and changing the mysql timeout there:

    mysql.connect_timeout=300
    default_socket_timeout=300

    We really can’t offer free support for issues not related to our plugin but hopefully that gets you pointed in the right direction. If you still run into trouble I would suggest doing a web search on EasyPHP configuration as there may be some other resources available that could help you.

    Best regards!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘MySQL server has gone away’ is closed to new replies.