Re: mysqlbug
hallo With reference to root on 14.07 20:31: Hello: When attempting to perform rpm installation I get: [root@...]# rpm -i MySQL-3.23.39-1.i386.rpm error: MySQL-3.23.39-1.i386.rpm cannot be installed first try this rpm -qa | grep mysql the original rpms have only lowercases with rpm -hUv you can upgrade the mysql with rpm -e you can uninstall the packages try it with rpm -hiv i hope telling you more error, perhaps missing dependence I am running RedHat 7.0 kernel 2.2.16-22 on an i586 (AMD K6-2 to be exact). Thank you for your assistance. Dylan Doxey [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 -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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 with perl error
hallo! With reference to Dawn H on 04.07 00:36: The error log says, Can't call method do: on an undefined value. . . But the EXACT SAME code works on another script I'm running. I don't see any reason for it to suddenly have a problem. What does this error message MEAN? Code Snippet-- # Form was okay; get image type and contents and create new record. # Use REPLACE to clobber any old image with the same name. $mime_type = uploadInfo ($image)-{'Content-Type'}; ($full, $thumb) = read_image_file ($image); $dbh-do (REPLACE INTO image (name,listing_id,image,thumbnail,mime_type) VALUES(?,?,?,?,?), undef, $name, $listing_id, $full, $thumb, $mime_type) or bail_out(There's a problem with the upload); i have it with (). like ($name), ($listing_id), ... -End Snippet--- http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia Filter fixer: database,sql,query - 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 -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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
case insensitive
hallo! in my table i have a column with the caracter char and binary. how can i search case insenitive? -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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
rename table
hallo i want to change the name of a table. what must i do? -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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
backup-problem
hallo! i have a backup-problem: when i use mysqldump -u michael -p --opt --all-databases backup i get the following error: USE backup; mysqldump: Got error: 1017: Can't find file: 'title.MYD' (errno: 2) when using LOCK TABLES but when i use mysqldump -u michael -p --opt --database books backup it works. table title is a part of books why? what is going wrong? -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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: deleting a table
hallo mailinglist! With reference to Yee Chuan Loh on 25.06 00:11: connect to your database by mysql -p your_db_name then type drop table your table name; this i want to know too. thanx! Hi, I need to delete a table from a database. I looked through the manual, but it's not listed in the table of content. Thank you for your help. -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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: Fw: Fw:
hallo yann! are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 2? yes, one is called perl-DBI and is at the powertools-cd and the other, which you mean is at ftp://ftp.redhat.com/pub/contrib/libc/i386/perl-DBD-msql-mysql... but you must copy some files after installation cp -iR /usr/lib/perl5/site_perl/5.005/i386-linux/* \ /usr/lib/perl5/site_perl/5.6.0/i386-linux/ I´m trying to install: perl -MCPAN -e'install DBD::mysql' in RH 7.0 to conect to mysql with perl it fail first time... 'BEGIN faild--compilation aborted at Makefile.PL line 5' how can I reinstall it, configure the script again?? why do you not use the rpm? i hope i can help you -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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: how to setup passwords for mysql
hallo! With reference to Terrell Johnson on 18.06 06:10: how to setup passwords for mysql mysql use mysql; mysql replace into user values ('localhost', 'root', password('testadmin'), 'Y', 'Y', ); mysql quit Bye user01@tunix:~ mysqladmin -u root reload try it with this On Mon, 18 June 2001, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - 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 -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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: how to setup passwords for mysql
hallo terrell! what if i can't get into mysql anymore at all, not even as root, :( is there file somewhere i can edit so i can get in again? have you try it with this? mysql -u root mysql Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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