Is possible set variable 'read_only' within my.ini?
Hello All, I'm using MySQL 4.1.0, InnoDB tables and Win2K. I need set read_only=1 and want do via option file, it's possible? According to http://dev.mysql.com/doc/mysql/en/Server_system_variables.html: * read_only ... This variable was added in MySQL 4.0.14. * I already tried put of both modes: read_only=1 and set-variable = read_only=1 But neither functioned. Anybody will can help me? Thanks in advance, Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Again: Is possible set variable 'read_only' within my.ini?
Hello All, I'm using MySQL 4.1.0, InnoDB tables and Win2K. I need set read_only=1 and want do via option file, it's possible? According to http://dev.mysql.com/doc/mysql/en/Server_system_variables.html: * read_only ... This variable was added in MySQL 4.0.14. * I already tried put of both modes: read_only=1 and set-variable = read_only=1 But neither functioned. Anybody will can help me? Thanks in advance, Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: ORDER BY problem
Hello Andy, I don't known if this is possible without handle string, what I don't guess recommended, because of performance and legibility of code. One suggestion will be store in column 'surname' (or other) the data already in format of sort. In other words, will be two columns in table, and, depending on approach, the second column will can be disabled for the users. Example: Name: Marco van Basten Archive: Basten, Marco van I hope that helps. Regards, Renato Cramer. -Mensagem original- De: andy thomas [mailto:[EMAIL PROTECTED] Enviada em: terça-feira, 8 de junho de 2004 08:51 Para: [EMAIL PROTECTED] Assunto: ORDER BY problem In a table called 'advisers' I have a column called 'surname' which contains the surnames of a number of people. Using a query like: 'select * from advisers order by surname' lists the people in the correct order but some people have surnames like 'du Sautoy' and 'van den Berg' and these are listed in the order of the first character that appears in their name, so that 'du Sautoy' appears surnames beginning with 'D' rather than 'S', etc. Does anyone know of a way of getting ORDER BY to sort on uppercase elements only in a sort string, so that 'du' and 'van den' in the example above are effectively ignored? Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: GRANT PRIVILEGES doesn't perform the way I expect it to....? ?
Hi Scott, Really in user table not modify nothing, but in db table the privileges appear ok. Your user get message of access denied? Regards, Renato Cramer. -Mensagem original- De: Scott Fletcher [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 7 de junho de 2004 17:29 Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: GRANT PRIVILEGES doesn't perform the way I expect it to?? I'm having a little trouble with granting the correct privilege to the user with one database instead of all databases. When I do this with all databases, it work great.. --snip-- //Issued SQL Command... GRANT ALL ON *.* TO 'Username'@'localhost.domain.com' mailto:'Username'@'localhost.domain.com' IDENTIFIED BY 'Password' //Correct Data in user table in mysql database.. +---+-+--+-+-+-- ---+-+-+---+-+-- -+--+---++-+ ++--++-- -+--+--+-+-- +--++-+--+---+-- ---+-+ | Host | User| Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +---+-+--+-+-+-- ---+-+-+---+-+-- -+--+---++-+ ++--++-- -+--+--+-+-- +--++-+--+---+-- ---+-+ | localhost | Username | 14617e5f1090a4a9 | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | N | Y | Y | Y | Y| Y | Y | Y | Y| Y | Y| | | | | 0 | 0 | 0 | +---+-+--+-+-+-- ---+-+-+---+-+-- -+--+---++-+ ++--++-- -+--+--+-+-- +--++-+--+---+-- ---+-+ --snip-- I don't want to this user to have access to most databases, just only one database. When I do this, it doesn't grant the priviledges the same way... --snip-- //Issued SQL Request GRANT ALL ON DATABASE_NAME.* TO 'Username'@'localhost.domain.com' mailto:'Username'@'localhost.domain.com' IDENTIFIED BY 'Password' //Incorrect Data in user table in mysql database.. | localhost | Username | 14617e5f1090a4a9 | N | N | N | N | N | N | N | N | N| N | N | N | N | N | N| N | N | N | N| N | N| | | | | 0 | 0 | 0 | --snip-- What do I need to do to make those 'Select', 'Update', 'Delete', 'Alter', etc.. to be Y by issuing that SQL Request from above??? What did I do wrong?? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Off Topic: Search in this list not are functioning
Hi, I tried search numerous times and not get: either return all messages or neither. Is one known problem? Regards, Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My question is too idiot for nobody answer?
-Mensagem original- De: Renato Cramer Enviada em: quarta-feira, 2 de junho de 2004 11:07 Para: Lista MySQL (E-mail) Assunto: Restore from Backup done with Replication features Dear Friends, Considering what a backup is done with the method following: 1. One master server replicate to one slave server. 2. The master server handle all manipulations and transactions of data (all tables are InnoDB type). 3. The slave server is exclusively used for to make backups. 4. The replication of the slave server is interrupted (stop slave statement). 5. The slave server is correctly shutdown. 6. One copy of the MySQL's data directory is done via operating system commands. 7. The slave server is started. 8. The replication of the slave server is started (start slave statement). In case problems with the master server, where is needed restore data from backup, is done the following: A. One copy is restored to MySQL's data directory in master server and also in slave server. B. The master server is started. C. The slave server is started. D. The replication of the slave server is started. My questions are: - The copy restored (A) will function in both servers? - The restart of the slave's replication (D) must be done with reset slave or start slave statement? - Exist a better method (1-8) to make consistents backups of the transactional databases without interrupt or block the master server and without use the InnoDB Hot Backup tool? All sugestions will be welcome. Thanks in advance, Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: How to retrieve MySQL Warning Messages
Hello Mauricio, I tested in version 4.1.0 and not function. Only in version 4.1.1, according to text below extracted from MySQL manual: Note that the framework for warnings was added in MySQL 4.1.0, at which point many statements did not generate warnings. In 4.1.1, the situation is much improved, with warnings generated for statements such as LOAD DATA INFILE and DML statements such as INSERT, UPDATE, CREATE TABLE, and ALTER TABLE. Regards, Renato Cramer. -Mensagem original- De: Mauricio Pellegrini [mailto:[EMAIL PROTECTED] Enviada em: quinta-feira, 3 de junho de 2004 13:20 Para: MySql List Assunto: How to retrieve MySQL Warning Messages Hi, Mysql 4.018 , SuSE 8.2. I'm using LOAD DATA LOCAL INFILE //.txt INTO TABLE zz_zzz ; and I get the following message Query OK, 158063 rows affected (1 min 36.49 sec) Records: 158063 Deleted: 0 Skipped: 0 Warnings: 158115 Nothing seems to be wrong with the table after executing the command. I would like to know the cause of the WARNINGS or what is the text corresponding to those warnings Is that possible? Thank you Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Restore from Backup done with Replication features
Dear Friends, Considering what a backup is done with the method following: 1. One master server replicate to one slave server. 2. The master server handle all manipulations and transactions of data (all tables are InnoDB type). 3. The slave server is exclusively used for to make backups. 4. The replication of the slave server is interrupted (stop slave statement). 5. The slave server is correctly shutdown. 6. One copy of the MySQL's data directory is done via operating system commands. 7. The slave server is started. 8. The replication of the slave server is started (start slave statement). In case problems with the master server, where is needed restore data from backup, is done the following: A. One copy is restored to MySQL's data directory in master server and also in slave server. B. The master server is started. C. The slave server is started. D. The replication of the slave server is started. My questions are: - The copy restored (A) will function in both servers? - The restart of the slave's replication (D) must be done with reset slave or start slave statement? - Exist a better method (1-8) to make consistency backups of the transactional databases without interrupt or block the master server and without use the InnoDB Hot Backup tool? All sugestions will be welcome. Thanks in advance, Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: RI enforcement and m2m relationships.
Hello, Maybe a solution to not allow a vacancy to be added without a supervisor being assigned: 1. Create an atribute of the identification in the supervision table as Primary Key (e.g. id_supervision). 2. Create column id_supervision in vacancy table as not null. 3. Create index in vacancy table to column id_supervision. 4. Create foreign key referencing the column id_supervision in vacancy table and supervision table. I hope that helps. Regards, Renato Cramer. -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 2 de junho de 2004 10:02 Para: eifion herbert (IAH-C) Cc: [EMAIL PROTECTED] Assunto: RI enforcement and m2m relationships. Hi all, I'm developing a database to store job adverts to appear on a company website. Each vacancy has at least one supervisor, but may have more than one, and a supervisor may be responsible for multiple vacancies. I've resolved the vacancy--supervisor many-to-many relationship in the normal(?) way of having a table called supervision inbetween them with two columns, the Ref of the vacancy and the ID of the supervisor. Both these columns make up the pri key in the supervision table, and are also foreign keys referencing the pri keys in the vacancy and supervisor table. Unfortunately this allows a vacancy to be added to the database without a supervisor being assigned. Is there a way in mySQL4 or Perl to enforce this without creating an insertion anomaly? Cheers Eifion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is possible Autocommit within my.ini?
Hi All, I already looking for Autocommit within my.ini at documentation and archives of the list, and not found. Anybody can help me? Thanks in advance, Renato Cramer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: 'show warnings' is not recognized
Hi Katherine, Sometimes happens, unfortunately, things as this: http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html: Note that the framework for warnings was added in MySQL 4.1.0, at which point many statements did not generate warnings. In 4.1.1, the situation is much improved, with warnings generated for statements such as LOAD DATA INFILE and DML statements such as INSERT, UPDATE, CREATE TABLE, and ALTER TABLE. I don't understand why, but... Greetings, Renato. -Mensagem original- De: Katherine Haines [mailto:[EMAIL PROTECTED] Enviada em: terça-feira, 18 de maio de 2004 09:56 Para: [EMAIL PROTECTED] Assunto: 'show warnings' is not recognized I appologize if this is redundant for anyone who follows google groups... Here's my post: Via the tutorial at http://www.analysisandsolutions.com/code/mybasic.htm, I downloaded mySQL and have been running most things with sucess. In case it is pertinent, I used the mysqld-max-nt --install command to install. I have version 4.1 However, when I run a query that produces warnings, I am still not able to view them. I get your typical Error 1064 for bad syntax. However, I've confirmed from mysql.com that the syntax is correct. Any help would be appreciated. Kathy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Books High Performance MySQL and Server Load Balancing
Hi All, I'm reading High Performance MySQL. In my humble opinion is an very good book. Congratulations to the authors. In the chapter Load Balancing and High Availability is cited the Tony Bourke's book Server Load Balancing. Someone read it? is one good reference font? I need study this subject. Any other recommendation? Thanks in advance. Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator don't connect
Hello, I use MySQL 4.1 in Windows 2000 and don't get connect with MySQL Administrator. The message what get is: Could not connect to the specified host. MySQL Error Nr.1115 Unknown character set: 'utf8' Details of the my connection: Username: root Password: not informed Hostname: localhost Port: 3306 Someone can help me? Thanks in advance, Renato Cramer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]