A
A
alfik1972017-12-26 12:52:30
MySQL
alfik197, 2017-12-26 12:52:30

Import dump sql wordpress - who faced?

hello, I have a db dump (750mb).
Deployed MariaDB. I am doing the import using source bd.sql.
throws the following error. The request is too long. Please tell me how to solve this problem
ERROR 2006 (HY000)
Thank you!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Moris Haos, 2017-12-27
@morihaos

Hello,
Have you tried increasing the "max_allowed_packet" parameter?

O
Orkhan Hasanli, 2017-12-27
@azerphoenix

Easy... Download PHP script bigdump.php
www.ozerov.de/bigdump
Edit the script (specify connection parameters + $max_query_lines = 300000000000;)
Upload the file and database to the site root. Go to site.com/bigdump.php
And then everything will be intuitive.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question