Title: Problem with datase
Last modified: August 20, 2016

---

# Problem with datase

 *  [marryb](https://wordpress.org/support/users/marryb/)
 * (@marryb)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/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/](http://wordpress.org/extend/plugins/better-wp-security/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [marryb](https://wordpress.org/support/users/marryb/)
 * (@marryb)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/problem-with-datase/#post-3399804)
 * 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.

 * ![](https://ps.w.org/better-wp-security/assets/icon.svg?rev=2980272)
 * [Solid Security – Password, Two Factor Authentication, and Brute Force Protection](https://wordpress.org/plugins/better-wp-security/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-wp-security/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-wp-security/)
 * [Active Topics](https://wordpress.org/support/plugin/better-wp-security/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-wp-security/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-wp-security/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [sql-error](https://wordpress.org/support/topic-tag/sql-error/)

 * 1 reply
 * 1 participant
 * Last reply from: [marryb](https://wordpress.org/support/users/marryb/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/problem-with-datase/#post-3399804)
 * Status: not resolved