restoring a backup problem via ssh

[butty]

hi there im trying to restore a backup of my database i am using the command mysql -u(username) -p(password) (database name) < dump.sql (the backup is in the root dir)

and I am getting the error:

ERROR 1050 at line 11: table 'access' already exists

I know its prolly summet silly im missin along the lines, it always is

hope u can help

[Kier]

You will need to drop all the existing vBulletin tables from the database before attempting to restore a backup.

[butty]

can i do this thru ssh? if so what commands will i need to use as i was having problems installing phpmyadmin so i binned it

cheers for ur help

[Kier]

Okay, first put phpMyAdmin back on to the system, then go through all the tables in the database and click the 'drop' link for each table.

Next open up an SSH prompt and run this:

/usr/local/mysql/bin/mysql -u[b]username[/b] -p[b]password[/b] [b]database[/b] < yourdumpfile.sql