Results 1 to 1 of 1
Thread: Moving Databases
Oct 23, 2002, 19:55 #1
- Join Date
- May 2002
- Vancouver, BC
- 0 Post(s)
- 0 Thread(s)
I'm just moving a little DB from my home server to a remote one, so I've dumped all db info into a .sql file.
Now how do I get it into the database on the new server?
I've tried tinkering with the mysqlimport shell command, but I require a password to get into the mysql shell. It wigs out when I try mysqlimport, saying I don't have permission. SO, instead, I've tried using the "LOAD DATA INFILE '...'" statement, but it claims I've got a syntax error.
Anyone know a quick solution? I simply want to recreate my database from the file... (And the DB DOES already exist)