Restoring Backup with phpMyAdmin
I am unable to restore my back up with the process described here:
I have created a new SQL database into which I am attempting to import the backup (though the instructions omit this part of the process so I am not sure about that part).
Every time I try, I get to the point where I choose the back up file which is on my desktop, I click the “go” button as instructed in the final step (step 8) and nothing happens.
It says to go grab a coffee as it can take a while. I’ve left it go for several hours at a time on each occasion, then I come back and it is still where I left it. The message at the bottom of the screen in the status bar says:
“Loading http://websiteaddress.com:2082/3rdparty/phpMyAdmin/index.php?”, completed 4 of 5 items.”
But it never gets any further.
Should I have dropped all the tables in the newly created SQL DB before attempting to import the backup or will the import process simply overwrite the tables with those contained in the back up?
I am guessing that several hours is more than enough time to restore small site with just a few pages and no posts. And so I assume it is hanging for some
I’ve spent so many hours on this that it might have been quicker to just build the site again from scratch. I’d rather be able to restore the database though.
Is there another way to restore a backup?
Lower down the page in those instructions it seems to give an alternate method of restoring the database. It says:
“Assuming your backup is a .bz2 file, creating using instructions similar to those given for Backing up your database using Mysql commands, the following steps will guide you through restoring your database :”
I am not sure what this sentence means as it is grammatically incorrect. It then gives a string of commands that can be used to restore the database. These instructions are so vague and don’t say where to type this command.
Where do I type this command?
- The topic ‘Restoring Backup with phpMyAdmin’ is closed to new replies.