[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bigsister-general] mysql logging doesn't create correct tables


On Mon, 2007-02-12 at 17:04 +0100, Kai Schaetzl wrote:
> Bigsister reports "failed to add table host", before I deleted the .frm 
> files. After deleting and restarting MySQL I got "table host doesn't 
> exist, can't create table host". 

Ok, can you please try running 

  mysql -u <bsuser> -p <bsdb>

with <bsuser> being the user you set in db.cfg, bsdb being the name
of the database configured in db.cfg, and then execute

  CREATE TABLE host (id INT NOT NULL,name VARCHAR(200),PRIMARY KEY (id));

at the prompt you get? That's how BigSister attempts to create the host
relation, for instance. Maybe you'll get some enlightening error message
:-)

Best regards,
Tom

-- 
----------------------------------------------------------------------------
Thomas Aeby, Kirchweg 52, 1735 Giffers, Switzerland, Tel: (+41)264180040
Internet: suppressed                       PGP public key available
----------------------------------------------------------------------------



-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bigsister-general mailing list
suppressed
https://lists.sourceforge.net/lists/listinfo/bigsister-general


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.