GoFuckYourself.com - Adult Webmaster Forum - View Single Post

pamphage · 12-21-2003, 07:37 PM

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!

12-21-2003, 07:37 PM
pamphage Confirmed User Join Date: Jan 2003 Location: Hollywood, CA Posts: 3,569	mysql help please! 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! __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, you may use a 624x80 instead of a 120x60. Let me repeat... A 120 x 60 button and no more that 3 lines of DEFAULT SIZE AND COLOR text.