Dear Kriesi,
I am creating a website, which is not finished yet – but I wanted to test it on a live server already.
Unfortunately I have great problems with importing the database in phpmyAdmin.
The database size is quite big, I prepared it with Migrate DB but when I am trying to import There is an Error from phpAdmin
“!Incorrect format paragraph”
I found out that this could be because of too low memory limit etc. and as I was using a little shared hosting I thought this is the problem.
So I asked the provider and they where willing to increase everything to:
max_execution_time = 120sek.
max_input_vars = 2000
memory_limit = 128 MB
post_max_size = 64 MB
upload_max_filesize = 32 MB
which didn’t help.
So I tried with another provider and got this error
SELECT comment
FROM phpmyadmin
.pma__column_info
WHERE db_name = ‘web263_db2’
AND table_name = ”
AND column_name = ‘(db_comment)’
MySQL meldet: Dokumentation
#2006 – MySQL server has gone away
Any ideas how I could manage this?
Thank you very much,
TanSmi
Hey TanSmi,
You can try to split your big sql dump with a script like: https://www.ozerov.de/bigdump/ to avoid the runtime limits.
Best regards,
Peter
Hi Peter,
thank you soooo much! I was spending the whole day searching for a solution – this is it!
Kind regards,
Tanja
Hi,
Great, glad I could help you :)
Best regards,
Peter