View Single Post
  #2  
Old 26th Jan 03, 09:01 AM
Sephiroth Sephiroth is offline
BetaONE Supporter
 
Join Date: Jul 2001
Posts: 1,979
Sephiroth is an unknown quantity at this point
Send a message via MSN to Sephiroth
robin, try this

1) delete everything in the imported database, yes, everything

2) upload your dump of the db to somewhere on the server (just make sure it is not http accessible!!!)

3) login to the shell

4) type

Quote:

mysql -u yourusername -p
hit enter, it will prompt you for your pass

5) enter your pass

6) type:

Quote:

use yourdbname;
and enter the command

7) type:

Quote:

source /path/to/your/db/dump/file/ext;
ie, if your db dump was backup.sql and your path to it was /home/robin/ , it would be source /home/robin/backup.sql (note, if you need to figure out the absolute path, type pwd at the shell right after you login, and it will show you the abs path to your home dir, and you can manage from there with ls and cd to list the dirs and change through them

that will go through and import your entire db.... if you need anymore help reply here or pm me
Reply With Quote