WordPress.org

Support

Support » Plugins and Hacks » Problem with datase

Problem with datase

  • Hi there,

    I have problem with database import into a new server, it simply doesn’t work. I’ve created database backup via BWP Security,after I tried to import this database to a new installation of wordpress. Without any success.

    SQL query import is showing this error message. Pls check this out.

    Error
    
    SQL query:
    
    INSERT INTO <code>aljih0_bwps_log</code> VALUES("2679","3","1354880732","","0","","","27331144","","a:3:{s:5:\"added\";a:145:{s:75:\"wp-content/plugins/better-wp-security/languages/better-wp-security-tl_TL.po\";a:2:{s:8:\"mod_date\";d:1354874382;s:4:\"hash\";s:32:\"1f70adba90a4d2919dceee24ce327fb0\";}s:75:\"wp-content/plugins/better-wp-security/languages/better-wp-security-tl_TL.mo\";a:2:{s:8:\"mod_date\";d:1354874382;s:4:\"hash\";s:32:\"f4e7fd4cc3c091a04494d157a140d099\";}s:75:\"wp-content/plugins/better-wp-security/languages/better-wp-security-sk_SK.mo\";a:2:{s:8:\"mod_date\";d:1354874382;s:4:\"hash\";s:32:\"93d6390cd1803cb24e62fd6336d07c5f\";}s:75:\"wp-content/plugins/better-wp-security/languages/better-wp-security-sk_SK.po\";a:2:{s:8:\"mod_date\";d:1354874382;s:4:\"hash\";s:32:\"9217446e23549010714af264b15a322b\";}s:38:\"wp-content/uploads/2012/12/NP_006c.jpg\";a:2:{s:8:\"mod_date\";d:1354880062;s:4:\"hash\";s:32:\"3b64776113aa8931dd9a8f6abd503dbb\";}s:38:\"wp-content/uploads/2012/12/NP_005c[...]
    
    MySQL said: Documentation
    #2006 - MySQL server has gone away

    Do you please have any idea how to make it working? I reckon that this problem is related to this plugin only in my db.

    Please need your help with this.

    Cheers Martin

    http://wordpress.org/extend/plugins/better-wp-security/

Viewing 1 replies (of 1 total)
  • Hi,

    I solved this problem. Im using MAMP so it was problem of my MAMP.Its happening if you wanna import large database to your localhost server (MAMP). What you need to do is change this file” …\MAMP\bin\startMysql.sh” with the code bellow:

    # /bin/sh
    /Applications/MAMP/Library/bin/mysqld_safe --port=3306 --max_allowed_packet=268435456 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --lower_case_table_names=0 --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log &

    Martin

Viewing 1 replies (of 1 total)
  • The topic ‘Problem with datase’ is closed to new replies.