database - phpMyAdmin - Error > Incorrect format parameter?

Question

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

Answer 1

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.