mysql database backup issue
Hello, could anyone explain me how to backup and in case of system crash restore the mysql database (main database where data about other databases, grants,users, etc. is kept)? Thanks in advance ! Regards, Saulius Gurklys mailto:[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
query max(length(column)) HANGS or there is a BUG in Mysql 3.23.33
Hi, I'm a bit desperate and have some questions to ask. I'm working with my own compiled server 3.23.33 on SuSe 7.0 I have table: mysql desc test.http_refer; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | rid | int(10) unsigned | | PRI | NULL| auto_increment | | refer | varchar(255) | YES | UNI | NULL|| +---+--+--+-+-++ 2 rows in set (0.00 sec) The data of table is referrer field from our Apache server logs. Most of it is some URLs from search engines, for example: http://listings.altavista.com/scripts/gt.dll?type=mainmethod=searchkl=ltdd=nspstq=30rank=30q=sajungosnbq=10glastQuery=Keywords%3dsajungosgrank=0 Some rows have refer of 255 chars long. Why queries: select rid,length(refer) from http_refer select rid,max(length(refer)) from http_refer group by refer WORKS just fine, while queries: select length(refer) from http_refer; select max(length(refer)) from http_refer; select max(length(refer)) from http_refer group by refer; just HANGS, and I have kill them after a while??? Is it incorrect queries or problems with table data or maybe these queries is long runnig? If anyone could shed some light on this issue I would be very appreciate. Thanks anyway. Saulius Gurklys mailto:[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
Re: Where are warnings located?
According to mysql manual: ... The warnings are not stored anywhere; the number of warnings can only be used as an indication if everything went well. If you get warnings and want to know exactly why you got them, one way to do this is to use SELECT ... INTO OUTFILE into another file and compare this to your original input file. Hope this helps. At 01:32 AM 3/19/01 Monday -0800, Phil Dibowitz wrote: I sent this once before, but got no answer, so I thought I'd try one more time... When I fill a table with a "LOAD DATA LOCAL INFILE..." file, it says there are some warnings... where can I find these warnings? Are they in a log file? Or is there a command to display them. Thanks. Additional info, I'm using 3.23.32 on Redhat Linux 7.0. safe_mysql starts my server... Phil -- Insanity Palace of Metallica http://www.ipom.com [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 Saulius Gurklys mailto:[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
Re: query max(length(column)) HANGS or there is a BUG in Mysql 3.23.33
be very appreciate. Thanks anyway. Saulius Gurklys mailto:[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
Stange behaviour max(length(a)) on table with index on column a varchar(255)
Hi, I have a table: CREATE TABLE http_refer( rid int unsigned auto_increment, refer varchar(255), unique index(rid), unique index(refer) ); It is filled with referrers from our webserver log and has 4138 rows. Today I've tried to execute: mysql select max(length(refer)) from http_refer; or mysql select min(length(refer)) from http_refer; but both queries just hanged and I had to kill them. Some of table rows is full filled with urls from search engines with long list of parameters. My server system : Linux 2.2.18 mysql-3.23.33-log Any comments? Saulius Gurklys mailto:[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