Issue
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?
Thanks
Solution
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
upload_max_filesize=64M
post_max_size=64M
Then restart the server.
This solved my issue. Hope solves yours too.
Answered By – Pooja Mistry
Answer Checked By – Mildred Charles (BugsFixing Admin)