WordPress.org

Ready to get started?Download WordPress

Forums

iThemes Security (formerly Better WP Security)
Problem with datase (2 posts)

  1. marryb
    Member
    Posted 1 year ago #

    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/

  2. marryb
    Member
    Posted 1 year ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic