InnoDB backup - the best way.

2003-05-28 Thread Jarek Jarzebowski
Hi, I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM and InnoDB tables. MySQL docs shows what is the best way to backup InnoDB tables but I don't want to shutdown db server every backup time. I suppose it is not a good idea to just copy database files and innodb log files

Re: user

2002-07-15 Thread Jarek Jarzebowski
Jan Kudrman wrote: > Dear Michal, > > I am not sure, but I think you can create an user will all the rights in > "mysql - user" (database - table) - this will solve your problem with full > access to all databases. I think that the better choice is to use GRAND command: grant all on *.* to 'new

Error code 28: No space left on device

2002-08-08 Thread Jarek Jarzebowski
Hi, What will happen on Error code 28: No space left on device? Will mysql crash down?... Will there be posibility of reading data from tables? Best Regards, -- Jarek - Before posting, please check: http://www.mysql.com

Privileges question.

2001-11-19 Thread Jarek Jarzebowski
lumns in all tables in database DB1 - it is obvious. My question is: Is there anybody who can tell me what I am doing wrong, or how can I give privileges to read only several columns from table? I use MySQL 3.23.33 on Debian Potato Linux. Best Regards, -- Jarek Jarzebowski -

Re: Latin-2

2001-12-09 Thread Jarek Jarzebowski
On Saturday, December 08, 2001 at 21:46:52, Bojan IVANCIC wrote: BI> Hi: BI> Just a short Q: BI> - if I install MySQL through rpm is it possible with any sort of BI> postintallation to change the code page e.g. from Latin-1 to Latin-2. BI> Thanx and bye. BI> Bojan Hi, Try to add to my.cnf f