I have a WordPress production website.
I’ve exported the database by the following commands:
select database > export > custom > select all tables > select .zip compression > 'Go'
I’ve downloaded the file which is example.sql.zip but when I upload to my localhost I get this error:
phpMyAdmin - Error > Incorrect format parameter
I’ve tried to export with other formats and I get the same error.
I’ve tried with other SQL Databases and it exports/ imports just fine.
What could it be? A corrupt database or other?
This issue is not because of corrupt database.
I found the solution from this video – https://www.youtube.com/watch?v=MqOsp54EA3I
It is suggested to increase the values of two variables in php.ini file.
Change following in php.ini
Then restart the server.
This solved my issue. Hope solves yours too.
Answered By – Pooja Mistry
Answer Checked By – Mildred Charles (BugsFixing Admin)