c h i e f y Member Posts: 415 From: Surrey, United Kingdom Registered: 03-07-2002 |
quote: I am using DB Tool Manager to restore a message board data base but the database that is to be overwritten is not "giving way" the DB Tools manager gives an error pointing out that the tables sphbb already exist! YES I KNOW THAT and I want them overwritten by the ones I'm trying to load IN (the restore!!)
anybody tell me how I can get thsi sorted please? ------------------ |
Klumsy Administrator Posts: 1061 From: Port Angeles, WA, USA Registered: 10-25-2001 |
drop table sphbb_auth_access should do it for that one table ------------------ |
c h i e f y Member Posts: 415 From: Surrey, United Kingdom Registered: 03-07-2002 |
thanks Karl playing with tables in that database is like dynamite for me I dropped a few lines and then FOUR message boards went down I reinstated the missing lines and they were BACK - oh boy, this is scary I think I will back off very slowly and leave things exactly as they are ------------------ |