Posted on: 04/02/03 11:01am
By: Anonymous (Anonymous)
I created a Back up of my DB, I want to import that backup now, I have looked but maybe its somthing very easy I over looked.
Thank You
Import the Back up?
Posted on: 04/02/03 03:38pm
By: vinny
The best way to do this is from the command line.
from the command line run:
'mysql -p -u <database user> <geeklog database>'
enter the database password.
at the mysql> prompt type:
. /path/to/database/backup/file
-Vinny
Import the Back up?
Posted on: 04/02/03 09:46pm
By: Anonymous (Anonymous)
Can this be done with phpmyadmin??
Import the Back up?
Posted on: 04/03/03 09:51am
By: vinny
I'm sure it can, but I've never used phpmyadmin before so I don't know how you would do it. An option to upload an sql file or run an sql file from the local files system would be things (options, commands?) to look for. I doubt you'll be able to just copy and paste the sql into a form though. I'm willing to bet that the sql backup file is just too big to be uploaded by normal HTTP GET or POST.
-Vinny
Import the Back up?
Posted on: 04/05/03 08:17am
By: jhk
If the file is small enough to be uploaded through POST, you can do it through phpMyAdmin.
Select the DB on the left drop-down menu. Click "SQL" tab on the right. Browse to the sql-file and click "go".
You may have to empty your DB first! You do that under the "Structure" tab. Select all tables and select "drop" in the "With all tables" drop-down menu at the bottom of the table list.