General Discussions

MYSQL error "already exists" quandry – c h i e f y

c h i e f y

Member

Posts: 415
From: Surrey, United Kingdom
Registered: 03-07-2002
quote:
MYSQL ERROR:

Table 'sphbb_auth_access' already exists

CREATE TABLE 'sphbb_auth_access' ( 'group_id' mediumint(8)NOT NULL default '0'


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?

------------------
please post your photo into the CCN gallery !

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
but you might to drop the whole database, or all the tables.

------------------
Karl /GODCENTRIC
Visionary Media
the creative submitted to the divine.
Husband of my amazing wife Aleshia
Klumsy@xtra.co.nz

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

------------------
Do you live or work in Surrey? Why not JOIN the Surrey.CO.UK premier website then? It's all about Surrey places and people, join up!