Importing large database file in MAMP phpMyAdmin

2019-08-22 10:12发布

i'm trying to load a database file in MAMP Version 5.1

The file is a wordPress database file 250M (230M are stored in wp options table). When doing this i get this error: - phpMyAdmin - Error - Incorrect format parameter

I have tried this with no luck: https://www.youtube.com/watch?v=WX_f_JVZCms

and also tried changing php.ini file in MAMP with no luck:

post_max_size = 300M
upload_max_filesize = 300M
max_execution_time = 600     
max_input_time = 600
memory_limit = 512M 

error:

Error Static analysis:

1 errors were found during analysis.

Missing expression. (near "ON" at position 25) SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

2006 - MySQL server has gone away

After that i get a large Backtrace...

I really hope someone can help.

0条回答
登录 后发表回答