Cannot Restore Database Backup

PostAlmostAnything

• October 04, 2022 23:20

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 '<', "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.

• 

  PostAlmostAnything

  • October 05, 2022 05:24

  Now it looks like my backup was uploaded but as a new database with no privileged user.

  0
• 

  kodeslogic

  • October 05, 2022 08:31

  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.

  0
• 

  cPRex Jurassic Moderator

  • October 05, 2022 13:10

  I like that idea from @kodeslogic - that would let you see if the issue is with the backup or the database you're trying to import things to.

  0

Please sign in to leave a comment.