Posts: 10
Threads: 3
Joined: Feb 2012
I noticed there is a tool to create database backups (very useful, thanks for that!)
However, I couldn't find a way to restore the database from this backup.
What is the best way to do this?
Posts: 2,873
Threads: 59
Joined: Jun 2010
Hi,
The best way is to open phpMyAdmin, go to Import, upload the file, and click Go.
Have
you completed
the interview?
Posts: 2,873
Threads: 59
Joined: Jun 2010
(Make sure to select the database on the left-hand side first. On the Import page, it should then say something like "Importing into the database commentics".)
Have
you completed
the interview?
Posts: 10
Threads: 3
Joined: Feb 2012
(01-Apr-2013, 05:31 PM)Steven Wrote: (Make sure to select the database on the left-hand side first. On the Import page, it should then say something like "Importing into the database commentics".)
Hi,
Thanks Steven. Do I need to do anything to clear current data first? I remember I tried to restore a backup of a database this way once, and I got a bunch of error messages that the table already exists, etc.
Posts: 2,873
Threads: 59
Joined: Jun 2010
No, the backup file contains the commands to drop the tables if they already exist.
Have
you completed
the interview?
Posts: 10
Threads: 3
Joined: Feb 2012
(01-Apr-2013, 08:49 PM)Steven Wrote: No, the backup file contains the commands to drop the tables if they already exist.
Brilliant, you are a hero among men!
