mysql help please!

[pamphage]

how do i restore on top of a database with tables already in there?

in ssh when i use mysql -u <username> -p<password> < backupfile i get crap like this:


ERROR 1050 at line 11: Table 'TGP_cat' already exists

i just wanna clear that database and start over!

[Juicy D. Links]

drop the database

[benthompson]

in ssh type:

drop database TGP_cat;
mysql -u username -p < backupfile;