Re: shell script to backup
En réponse à Ilyas Keser [EMAIL PROTECTED]: Hi you can use mysqldump et a crontab to save all databases in a text file. Regards Julien Sobrier Hi all... I am a new Linux user. Does any one have a shell script to backup all Mysql databases? Thanks ilyas... - 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: MySQL: Problem Installing on RH 7.3
En réponse à Philip Molter [EMAIL PROTECTED]: Hi I am sure that tehre is a bug in RH 7.3 I've said it several times in this mailing list, but nobody wants to belive me! It's true that this information is difficult to find, but I've learned it on the documentation of www.mysql.org, the one with user comments. Regards Julien Sobrier On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote: : The mysqld.log file says: : : 020717 13:05:05 mysqld started : 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: : './mysql/host.frm' (errno: 13) : 020717 13:05:05 mysqld ended : : But I do see the host.frm file: : : -rw-rw1 root root 8958 Jul 17 13:04 : /var/lib/mysql/mysql/host.frm : : How did you fix this problem? Permissions are wrong. MySQL typically runs as mysql:mysql, not root:root. If I remember correctly, there may have been a problem with the setup scripts that handled this. Check the RH bug reports. The fix is simply to change owner/groups on the necessary files/directories. But Trond can give you specifics. It still may be user error. :) : I do have the /var/lib/mysql/mysql.sock file... * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - 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: Bug in rpm from RH 7.3
En réponse à Jan Kudrman [EMAIL PROTECTED]: I've found it on the online documentation of MySQL.org with comments of user. Since I've replaced the RP of RH 7.3 by RPM of MySQL.org, I don't have any problem Regards Julien Sobrier I have receive an answer that there is a bug in MySQL rpm packages in Red Hat 7.3 distribution. I have tried to find any information about it but I didn't find anything about it. There is no errata on Red Hat web site, and also other sources hasn't any information about the bug in Red Hat 7.3 MySQL rpm packages. Do you have some info about a MySQL rpm bug in Red Had 7.3? Thank you, Jan - Original Message - Hi All, I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included in RH distribution). I am using ext3 file system. In my my.cfg is skip-locking. The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is used only as a database server which is accessable only from our web (apache, php). I would like to do some operation automatickly and periodicly (with a crond): - check all databases / tables - optimize all databases / tables According to documentation (http://www.mysql.com/doc/C/o/Command-line_options.html) I can't use myisamchk, as long as mysqld is running. I have try somethong like this: mysqld stop myisamchk -swr /path/to/datadir/*/*.MYI myisamchk -swm /path/to/datadir/*/*.MYI mysql start But I don't want to stop sql server every time. Could you help me how to solve this issue? Has somebody experience with MySQL on RedHat 7.3 with ext3? Thanks, Jan - 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
How to use teh FULLTEXT search?
Hello I have created a table: CREATE TABLE data (no int auto_increment, topic text, author text, date date, description text, file text, note longtext, name varchar(15), password (15), folder text, key(no), FULLTEXT(topic,author,description,file,note)); Then, I would like to a FULLTEXT SEARCH in ONE (or 2 or 3) field: ex: SELECT * FROM data WHERE MATCH(note) AGAINTS(text to find); error 1191: can't find FULLTEXT index matching the column list same problem for MATCH(note,author), by example That works only when I do MATCH(topic,author,description,file,note), so with all the fields in fulltext. But that's not what I would like to do. When I see the error message, I tried to create an other index: ALTER TABLE data ADD key(note); error 1170: BLOB column 'note' used in key specification without a key length I have the same problem with IN BOOLEAN MODE. I'm using MySQL 3.23.51 What should I do to use the FULLTEXT search in the desired number of fields? Thank you for your help Julien Sobrier - 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