InnoDB backup - the best way.
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 to the safe place because of unwanted rollbacks danger. What if I use mysqldump to backup databases data, and then I copy innodb log files to the safe place? I suppose I should flush tables first. I'm interested in your opinions. I'm sure that there is anybody more experienced in this matter. Regards, -- Jarek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error code 28: No space left on device
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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: user
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 'newuser'@'yourhost' identified by 'somepass'; Above will create user named newuser with all privileges on all databases (including mysql) but without grant privilege (can't create new users). Something like that will create user with all provileges on all dbs and with power of creating new users: grant all on *.* to 'newuser'@'yourhost' identified by 'somepass' with grant option; For more information take a look on GRAND command. And then you can use other tables in database mysql to define rights of this user to table user. Have a look to manual pages: 4.2 General Security Issues and the MySQL Access Privilege System http://www.mysql.com/doc/P/r/Privilege_system.html Regards, Jan (...) Best Regards, -- Jarek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Latin-2
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 file into section [mysqld] line like this: [mysqld] default-character-set=latin2 This enables latin-2 character set as default. Best Regards, -- Jarek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Privileges question.
Hi All, I have some database named DB1 and one table in it named TBL1. In TBL1 there is 3 columns: name, address, id. There is mysql user named dbuser. Now, I want to give to 'dbuser' privileges to read ONLY 'name' and 'address' columns from table 'TBL1'. So, I added record to mysql.user table (with no global privileges) - thans to thar 'dbuser' is able to connect to MySQL server, and it works OK. Further I added records to mysql.column_privileges: mysql insert into columns_priv values('localhost','DB1','dbuser','TBL1','address', '', 'Select'); and I assume that now 'dbuser' will be able only to read 'address' column from 'TBL1' table in 'DB1' database... but it is not true. When 'dbuser' tries to do command mysql use DB1; he got 'Access denied to DB1 for user dbuser@localhost' - the reason is that there is no record in mysql.db table for database 'DB1' (I assume). But if I give SELECT privileges to 'DB1' in mysql.db table 'dbuser' is able to read all columns 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php