Operating System & Version
Linux
cPanel & WHM Version
Don't Know

PostAlmostAnything

Well-Known Member
Mar 3, 2020
70
1
8
Portland, Oregon
cPanel Access Level
Website Owner
Hi,

When deleting all Wordpress posts before a specific post I accidentally deleted a bunch of categories, so I need to restore the database from the backup I made right before I did that. Problem is when I upload the backup I get the error:

Error: SyntaxError: Unexpected token '<', "<!DOCTYPE "... is not valid JSON

I tried uploading it in phpMyAdmin and got an error also which says:

phpMyAdmin - Error
Incorrect format parameter


I tried uploading it as a 600mb .sql.gz just as I downloaded it, extracting the 4GB .sql file and uploading it directly uncompressed, and compressing it to a .sql.zip but none of it works.
 
Last edited:

kodeslogic

Well-Known Member
PartnerNOC
Apr 26, 2020
527
247
118
IN
cPanel Access Level
Root Administrator
Let the current DB be as it is, create a new database and try to restore the backup to the new database, if it restores successfully then you can just change the database connection details in your code.
 
  • Like
Reactions: cPRex