I'm having some issues myself...
I'm all backed up via the export function on my old server. Fine.
I have a new dedicated server. So I created the database, and user for sql.
Problems.
I don't think I'm setting up the permissions for that new user correctly... I'm using plesk to add the new database and user. Fine.
I try to restore the database via ssh, and I get:
Can't create database 'DB_Name'; database exists
Ugh... So what is the issue there? If I delete the database, and do it that way, I get the errors saying no database exists. So I feel like i'm stuck.
I know there is probably a simple answer, but I just cant find it.
Thanks in advance folks.
Carter
Ah ha.. think I found the answer...
in ssh.. on a new server... use the "-f" command to ignore the error messages.
That fixed it.
sql -f -u USERNAME -p DB_NAME < /Path_to/sql_dump_file.sql
@dj
look here:
http://www.vbulletin.com/docs/html/blank_pages