• Resolved giorgosnl

    (@giorgosnl)


    Everything was working fine but after the latest upgrade backups are failing. below errors are showing.

    ERROR: Can not connect to MySQL Database 2002: Can't connect to local MySQL server through socket '/No-MySQL-hostname-was-specified' (2)
    
    ERROR: Allowed memory size of 94371840 bytes exhausted (tried to allocate 131072 bytes)

    Strange is that on another site at the same dedicated machine the latest release it runs just fine,

    Any idea how to solve this?

    https://www.ads-software.com/extend/plugins/backwpup/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Anonymous User 7658014

    (@anonymized_7658014)

    Hi giorgosnl, have you tried to split up your backup into separate jobs? Like 1. /wp-content/ without /uploads/, 2. /uploads/ on its own, 3. the database.

    Thread Starter giorgosnl

    (@giorgosnl)

    Thanks Caspar, At the moment I stick to the working 2.1.17 version till I sort out the mysql error below. The memory issue was due to trying to backup a directory with gigs of its own backwpup backup files.

    [01-Mar-2013 21:35:53] 1. Try for database dump …
    [01-Mar-2013 21:35:53] WARNING: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can't connect to local MySQL server through socket '/No-MySQL-hostname-was-specified' (2)
    [01-Mar-2013 21:35:53] ERROR: Can not connect to MySQL Database 2002: Can't connect to local MySQL server through socket '/No-MySQL-hostname-was-specified' (2)
    [01-Mar-2013 21:35:54] 2. Try for database dump …
    [01-Mar-2013 21:35:54] WARNING: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can't connect to local MySQL server through socket '/No-MySQL-hostname-was-specified' (2)
    [01-Mar-2013 21:35:54] ERROR: Can not connect to MySQL Database 2002: Can't connect to local MySQL server through socket '/No-MySQL-hostname-was-specified' (2)
    [01-Mar-2013 21:35:55] 3. Try for database dump …
    [01-Mar-2013 21:35:55] WARNING: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can't connect to local MySQL server through socket '/No-MySQL-hostname-was-specified' (2)
    [01-Mar-2013 21:35:55] ERROR: Can not connect to MySQL Database 2002: Can't connect to local MySQL server through socket '/No-MySQL-hostname-was-specified' (2)
    [01-Mar-2013 21:35:56] 1. Trying to make a list of folders to back up …
    [01-Mar-2013 21:35:56 UTC] WordPress database error Incorrect database name '' for query SHOW TABLES FROM <code></code> made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, apply_filters('request'), call_user_func_array, BackWPup_FrontEnd->request, BackWPup_Job::start_http, BackWPup_Job->run, call_user_func, BackWPup_JobType_File->job_run, BackWPup_JobType_File->get_exclude_dirs, BackWPup_Option::get, BackWPup_Option::defaults_job, BackWPup_JobType_DBDump->option_defaults, m_wpdb->query
    [01-Mar-2013 21:35:56 UTC] WordPress database error Incorrect database name '' for query SHOW TABLES FROM <code></code> made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, apply_filters('request'), call_user_func_array, BackWPup_FrontEnd->request, BackWPup_Job::start_http, BackWPup_Job->run, call_user_func, BackWPup_JobType_File->job_run, BackWPup_JobType_File->get_exclude_dirs, BackWPup_Option::get, BackWPup_Option::defaults_job, BackWPup_JobType_DBDump->option_defaults, m_wpdb->query

    Indeed I have changed my database name lately but that doesn’t seem to bother the 2.1.17 release as it works fine. 3.0.3 must check something differently and obviously doesn’t like it.

    what did you enterd in wp-config by define(‘DB_HOST’, ‘???’); ?

    Thread Starter giorgosnl

    (@giorgosnl)

    define(‘DB_HOST’, ‘mysql.mydomainname.net’);

    hmmm, that looks good.

    The massage means that he connaction to datbase can’t done. Is ther a limit of mysql Connection from a PHP script?

    I have also changed some little connection seetins with the next release.

    Thread Starter giorgosnl

    (@giorgosnl)

    No that I know. I will retry again on a test site and let you know. Thanks for checking.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Errors about DB and memory after the upgrade’ is closed to new replies.