Re: rpm mysql5.0 for fedora4
Thanks! If I have the glibc 2.3, I have to use Linux x86 generic RPM (dynamically linked). Otherwise, version lower than 2.3, we should use Linux x86 generic RPM (statically linked against glibc 2.2.5). Am I right? unplug On 3/3/06, Joerg Bruehe [EMAIL PROTECTED] wrote: Hi N.N., all, Denis (hoping that it also helps with your question), unplug wrote: Hi, I found that there are 2 versions of mysql 5.0 rpm for download. Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads Linux x86 generic RPM (dynamically linked) downloads What is the difference between them? How to determine what version should I use for fedora4? Glibc 2.2 has issues when the number of threads gets large, that is why ehere is a patched version (that issue fixed) is linked statically to MySQL binaries intended to run on systems (still) using glibc 2.2. Glibc 2.3 does not have these issues, so for this version dynamic linking can be used. This is the current version of glibc, used for all MySQL binaries (except those special 2.2 ones). Check your system for the glibc version used, then get and install the appropriate package. HTH, Jperg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't select to outfile
You have to enable the file_permission for the user in order to create file. On 3/3/06, Bruce Bales [EMAIL PROTECTED] wrote: I'm using mysql 3.23.58 on linux. I recently upgraded from RedHat 9 to Fedora 3 and now I am unable to write to an outfile. If I have started mysql with the simple mysql I get 'access denied' even if I am trying to put it into my home directory. mysql select lname,fname,mname,addr,city,stzip from 1950class3 into outfile '/usr/class3-2'; ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) mysql If I have started with mysql -u root -p and then a password, I get 'Can't create file.' mysql select lname, fname, addr,city,stzip from 1950class2 into outfile '/usr/database3-2'; ERROR 1: Can't create/write to file '/usr/database3-2' (Errcode: 13) mysql bruce has all privileges on the table. How can I get my data out? bruce -- 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]
rpm mysql5.0 for fedora4
Hi, I found that there are 2 versions of mysql 5.0 rpm for download. Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads Linux x86 generic RPM (dynamically linked) downloads What is the difference between them? How to determine what version should I use for fedora4? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
file permission
Hi, When I use a query SELECT * into outfile '/tmp/report.csv' fields terminated by ',' lines terminated by '\n' FROM table;, it will create a file with the following permission and owner. -rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv How can I change the default permission or the ownership of the file? Rgds, unplug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: file permission
Thanks! But I want to change the default setting of the file permission and ownership. (i.e. the file will be created with permission and ownerhsip according to my setting). On 3/1/06, CodeHeads [EMAIL PROTECTED] wrote: On Tuesday 28 February 2006 22:55, unplug wrote: Hi, When I use a query SELECT * into outfile '/tmp/report.csv' fields terminated by ',' lines terminated by '\n' FROM table;, it will create a file with the following permission and owner. -rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv How can I change the default permission or the ownership of the file? Rgds, unplug chown your_username:your_username report.cvs Of course change the your_username to the user you are logged in as. -- Best regards, ~WILL~ Key: http://code-heads.com/keys/ch1.asc Key: http://code-heads.com/keys/ch2.asc Linux Commands: http://code-heads.com/commands Linux Registered User: 406084 (http://counter.li.org/) -- 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]
Re: file permission
Actually, here is my case. There is a script owned by user A running daily. script--- rm -rf /tmp/report.csv mysql -umysql -pabc table -e SELECT * into outfile '/tmp/report.csv' fields terminated by ',' lines terminated by '\n' FROM table; In the first run, a file with the following permission and ownership will be created. -rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv In the seconde run, the script will failed as user A have no permission to remove the file. In order to run the script daily, ownership of the file should be changed to user A. On 3/1/06, CodeHeads [EMAIL PROTECTED] wrote: On Tuesday 28 February 2006 23:41, Joshua Kugler wrote: You can't do that. The mysql server runs as user mysql, so it cannot create files owned by another user. If you run the mysql server as root (don't!), you might be able to do that, but I do not believe mysql has a facility for changing the owner of a file. You are better off running a script as the user you want to own the file and outputing the results via the script. j- k- I was just going to post something similar to that. Try something like this: #!/bin/bash Your query you want to run... chown user:user /path/to/report.cvs Then put this in your cron.daily or where ever you wish to run it or crontab 00 03 * * * /path/to/script I think I explained that right. :) -- Best regards, ~WILL~ Key: http://code-heads.com/keys/ch1.asc Key: http://code-heads.com/keys/ch2.asc Linux Commands: http://code-heads.com/commands Linux Registered User: 406084 (http://counter.li.org/) -- 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]
sendmail+mysql
Hi all, Is it possible for sendmail to work with mysql under linux environment? I am finding a way to handle sendmail alias by using mysql. Does anyone can tell me how to do it? Any reference site? unplug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: sendmail+mysql
Thanks. Have you tried it before? Does it work or not. I found that the installation process is very complicated. There are 3 sendmail rpm files. Do I need to install them before applying the patches? Greg Donald wrote: On Wed, 19 Nov 2003, unplug wrote: Is it possible for sendmail to work with mysql under linux environment? I am finding a way to handle sendmail alias by using mysql. Does anyone can tell me how to do it? Any reference site? http://sourceforge.net/projects/sendmail-sql -- Greg Donald http://destiney.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
fulltext key search
Hi all, As I know innodb doesn't support fulltext key search. Any replacement in innodb that have the same purpose? Rgds, unplug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using innodb
I can use innodb in Redhat9 but failed in redhat 7.2. I find the version of mysql in both redhat is identical. I wonder why it is the case. Version of mysql mysqladmin Ver 8.23 Distrib 3.23.56, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.56 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Any document to describe the replication process of the following case? innodb (master) --replication -- myisam (slave) unplug Jeremy Zawodny wrote: On Wed, Jul 30, 2003 at 12:34:54PM +0800, unplug wrote: I use rpm to update the previous version. I can use innodb in redhat 9 with version 2.23.56. But it failed in redhat 7.2. I wonder it is the kernel problem. Why would you suspect the kernel? How did it fail? BTW, I want to ask whether I can do replication in the following case. innodb (master) --replication -- myisam (slave) Yes. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 207,625,568 queries (399/sec. avg) -- 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]
replication question
HI all, Is it possible to perform replication as follow? HOW? master (innodb) ---replication--- slave (myisam) Rgds, Ringo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
using innodb
Hi all, I am trying to use mysql with innodb. After I set it up as follow. The db start failed. I wonder why it failed to use innodb. Does anyone can tell me? OS: redhat 7.2 with kernel 2.4.20-18.7 mysql version: 3.23.56 In mysql.log /usr/libexec/mysqld: unrecognized option `--innodb_data_home_dir=' /usr/libexec/mysqld Ver 3.23.56 for pc-linux on i686 In my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:50M:autoextend set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = /var/lib/mysql/iblogs innodb_log_arch_dir = /var/lib/mysql/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=15M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using innodb
I use rpm to update the previous version. I can use innodb in redhat 9 with version 2.23.56. But it failed in redhat 7.2. I wonder it is the kernel problem. BTW, I want to ask whether I can do replication in the following case. innodb (master) --replication -- myisam (slave) unplug Jeremy Zawodny wrote: On Tue, Jul 29, 2003 at 03:08:42PM +0800, unplug wrote: Hi all, I am trying to use mysql with innodb. After I set it up as follow. The db start failed. I wonder why it failed to use innodb. Does anyone can tell me? OS: redhat 7.2 with kernel 2.4.20-18.7 mysql version: 3.23.56 In mysql.log /usr/libexec/mysqld: unrecognized option `--innodb_data_home_dir=' /usr/libexec/mysqld Ver 3.23.56 for pc-linux on i686 InnoDB wasn't bundled by default in 3.23 unless you used a MySQL-Max binary. Are you using one? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 577,665,735 queries (346/sec. avg) -- 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]
data path
Hi all, By default, data dir is located at /var/lib/mysql. I have run mysql for serveral month with data in that path. Now, I want to move all database data to another path, say /var2/lib/mysql. What is the suitable purpose to do it? Is it only shutdown mysql and move all data file from /var/lib/mysql to /var2/lib/mysql and startup again? Any experience to share? Rgds, unplug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
connect failed from external
Hi, I failed to connect mysql from external network (it works by connected . In the error log, I found the following message. Number of processes running now: 1 mysqld process hanging, pid 13523 - killed 021009 12:35:28 mysqld restarted /usr/libexec/mysqld: ready for connections As you can see, mysql restart itself when I try to connect from external network. I found the it happened after I upgrade glibc to 2.2.5-40 from redhat network. I wonder anyone get the same experience. Instead of downgrade to 2.2.5-39, anyone can tell me how to solve it? unplug -- - 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: Question on non-English support
YES Soong, Michael Sau Wah (Michael) wrote: Hi, Does mysql support Chinese language? Thank you, Regards, Michael - 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 - 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
admin password
Hi all, How can I retrieve mysql admin password if I forget it?? Rgds, unplug - 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: ODBC Installation
reboot your pc in safe mode and install myodbc again. Quentin Bennett wrote: Hi, When trying to install the latest ODBC I get An error occurred while copying C:\WINDOWS\SYSTEM\ctl3d32.dll. Restart Windows and try installing again. The file mentioned exists, and is not read only. Restarting windows does not help.There are not other ODBC programs running. Any suggestions? Thanks Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 - 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: ?
you missed the , before the word primary key. Toth Dalibor wrote: Part 1.1Type: Plain Text (text/plain) - 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