InnodDB question / my.cnf

2005-03-28 Thread sc2
Hello I need little bit help i have 1 ibdata file (now) innodb_data_file_path=ibdata1:10M:autoextend:max:262M works fine but when i make innodb_data_file_path=ibdata1:10M;ibdata2:10M:autoextend or autoextend:max:201 then my 4.1 mysql server will not start, cuase of a "syntax error". In the Documen

ISAM to MyISAM Convert pls

2005-01-02 Thread sc2
hello i hope im correct here i have a problem, after upgrade 4.1 from 4.0 one table is away (index) i have table.ISM,.frm and .ISD. when i try to convert it with ALTER TABLE table TYPE = MYISAM; he only says did not found table.MYI (where table is my name of the table) how i can convert it to MYI?

question...

2001-05-28 Thread sc2
hi hope this is the correct list for questions...if not , sorry i have a mysql server under linux, works fine but, if a user has an mysql account eg: "XYZ" and connects then he can take a look into the other DB, of other users ..he cant change any things. how i can set the permission for read t