I am trying to restore a db backup from a Wordpress site I had at another host. My backup .tar.gz file is 1 Gb. In the db admin page I browsed for my file and it started uploading, then an error occurred:
phpMyAdmin - Error
Incorrect format parameter
It also strangely say max upload is 300 MiB, this is tiny. I hope I have not wasted time with creating an account under the impression that I have 5 Gb storage then have a tiny db upload limit, if this is actually the issue.
Please advise on whether I can restore my WP db backup and how? Thanks
Hold on, what kind of backup is this exactly? A WordPress database backup doesn’t usually have the .tar.gz extension. A database backup would normally have the .sql.gz extension.
A .tar.gz archive, like a zip archive, is an archive with files and folders. That’s the kind of archive format you would use to transfer the WordPress files, not database. A database backup is usually single .sql file, which is then optionally compressed into a .sql.gz file.
This would also explain why phpMyAdmin would complain about the format. If it’s not a database backup, then phpMyAdmin cannot import it.
How exactly did you generate this backup? Could you perhaps open the archive on your own computer and take a screenshot of the contents (just the list of files/directories inside)?
This website was backed up by support at a host where I cancelled my plan. Hence I am not sure how it was done but assume using cPanel. I should have uncompressed before posting here, apologies!
Yes once uncompressed I see the .sql file, which should be what the importer expects. The folder contains all the WordPress files, which I assume can be ‘restored’ once the db is there and WordPress is installed.