web data entry problem
I hope someone might be willing to help out. I'm trying [still] to learn MySQL and php - to create some simply web based database. I have installed quite a few php/MySQL web database apps from books, however, none of them will get data entered into my database. When I create the database exactly as instructed, everything works great, but when I create the form to send/add a new record to my db then look at the db the new data is not there. This happens repeatedly with every example I build. I can add records using a terminal or phpMyAdmin. I'm running MySQL 4.0.14, Mac OS X 10.3, PHP 4.3.2. I installed 'tasks' - http://www.versiontracker.com/dyn/moreinfo/macosx/17996 and it works just fine! but it is too big for me to use to compare to my very simple scripts. Here is one I have recently installed whose data will not enter: http://hotwired.lycos.com/webmonkey/99/21/index3a_page4.html? tw=programming I believe my db connection is being made (I may be wrong), after all my phpMyAdmin app also works fine. I would be very grateful is there might be a kind soul who would work with me to help me to find out what is wrong? I have had dbs before that worked fine, I don't understand this problem at all. Thanks, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Any word on G5/64bit compiles of mysql?
Any word on G5/64bit compiles of mysql? I know I am not the only one wanting to know Does it work, and How to compile best for it. or am I alone in the universe? -- Adam Goldstein White Wolf Networks http://whitewlf.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Variation of SELECT DISTINCT
Alan Dickinson [EMAIL PROTECTED] wrote: I've got a query that looks like this.. SELECT Foot_Id, Dir_Uni, Part_Suffix, Part_Number, Appln_No, Description, Product_Ref, Vehicle_Ref, Part_Prompt, Part_Description, Foot_Id, Qualifier, Years FROM application_parts WHERE (('$id' = Appln_No) and (Years = '$dropdown') and (Dir_Uni 'U') and (Part_Description 'Pipe Kit') and (Part_Description 'Universal Converter') and (Part_Description 'Pre Cat')) ORDER BY Part_Prompt; (sorry if the spacing is weird) I need to drop the rows returned that have the same part_description field, like the DISTINCT clause does for rows, i need the same thing for a field value, how can I do this? If I've got you right you need: SELECT .. GROUP BY part_description -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access rules for users from specific hosts
Hi there, I'm seeing some problems with the way I've granted access to different users. I've setup the server to allow access only from certain clients. For example, the backup user is only allowed access from some machines: GRANT SELECT ON testdb.* TO [EMAIL PROTECTED] The problem is that when connecting I must supply a -h option to match the grant e.g. [EMAIL PROTECTED] mm1]$ mysql -u backup ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED] mm1]$ mysql -u backup -h 127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 32 to server version: 4.0.15-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Is there an option to get the MySQL server to resolve localhost to 127.0.0.1 automatically? Or do I just have to use the -h option everywhere? It's not a big problem for me, but somewhat of an annoyance :( Many Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web data entry problem
[EMAIL PROTECTED] wrote: I hope someone might be willing to help out. I'm trying [still] to learn MySQL and php - to create some simply web based database. I have installed quite a few php/MySQL web database apps from books, however, none of them will get data entered into my database. When I create the database exactly as instructed, everything works great, but when I create the form to send/add a new record to my db then look at the db the new data is not there. This happens repeatedly with every example I build. I can add records using a terminal or phpMyAdmin. This sounds like an access rights problem. Is your MySQL server on the same machine as the WWW server? I assume that you have included your MySQL username/password in your PHP script, but do the access rights on the MySQL server allow access for your MySQL account from the WWW server? You might also want to check PHP error handling and reporting . In particular make sure your code goes something like $result = mysql_query(SELECT my_col FROM my_tbl) or exit (Invalid query); I'm running MySQL 4.0.14, Mac OS X 10.3, PHP 4.3.2. I installed 'tasks' - http://www.versiontracker.com/dyn/moreinfo/macosx/17996 and it works just fine! but it is too big for me to use to compare to my very simple scripts. Here is one I have recently installed whose data will not enter: http://hotwired.lycos.com/webmonkey/99/21/index3a_page4.html? tw=programming I believe my db connection is being made (I may be wrong), after all my phpMyAdmin app also works fine. I would be very grateful is there might be a kind soul who would work with me to help me to find out what is wrong? I have had dbs before that worked fine, I don't understand this problem at all. Thanks, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Column Definition Column?
Does MySQL have a description column avialable for columns within table definitions? What I mean is when you do and explain TABLE_NAME can you get a column that as a description for each field? This would of course be especially useful for documentation purposes. Thanks for your help. Chris Streeter Bethlehem, PA, USA
Column Description Column
Does MySQL have a description column avialable for columns within table definitions? What I mean is when you do and explain TABLE_NAME can you get a column that as a description for each field? This would of course be especially useful for documentation purposes. Thanks for your help. Chris Streeter Bethlehem, PA, USA
Big difference in MyISAM and InnoDB SELECT speed
Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming selects. After converting all tables to InnoDB I noticed a big difference in processing speed of one of the SELECT queries performed by the application. My configuration file /etc/my.cnf is based on my-huge.cnf example. Table structure: create table urlword(url_id integer auto_increment primary key, site_id integer not null, tree_id integer not null, deleted tinyint DEFAULT 0 NOT NULL, url varchar(128) not null, next_index_time INT NOT NULL, status int(11) DEFAULT '0' NOT NULL, crc char(32) DEFAULT '' NOT NULL, last_modified varchar(32) DEFAULT '' NOT NULL, etag varchar(48) DEFAULT '' NOT NULL, last_index_time INT NOT NULL, referrer int(11) DEFAULT '0' NOT NULL, tag int(11) DEFAULT '0' NOT NULL, hops int(11) DEFAULT '0' NOT NULL, redir integer, origin integer, unique index(url), index(next_index_time), index(hops,next_index_time), index crc (origin, crc(8))); Query: select url_id from urlword where deleted=0 and status=200 and origin=1 MyISAM: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-+--+---++-+-+++-+ | urlword | MyISAM | Dynamic| 46648925 |143 | 6714978360 | 1099511627775 | 4052629504 | 0 | 46648929 | 2003-11-21 14:13:28 | 2003-11-22 04:01:16 | NULL | max_rows=1 | | Sample disk usage (iostat -x -d /dev/scsi/... 10): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 5510.20 0.20 361.10 0.40 46970.404.80 23485.20 2.40 129.95 16.41 45.39 27.11 98.00 Processing time: Query OK, 14274315 rows affected (4 min 54.88 sec) InnoDB: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-+--+---++-+-+++-+ | urlword | InnoDB | Dynamic| 44477984 |228 | 10150215680 | NULL | 13322158080 | 0 | 46648929 | NULL| NULL| NULL | max_rows=1 | InnoDB free: 6715392 kB | Sample disk usage (iostat -x -d /dev/scsi/... 10): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 2179.10 0.00 94.90 0.00 4548.000.00 2274.00 0.0047.92 9.96 104.85 104.00 98.70 Processing time: Query OK, 14274315 rows affected (1 day 8 hours 46 min 46.70 sec) Could someone please explain me what can be the reason of this difference and if there is a way to optimize InnoDB to perform better? Thanks, Janusz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Column Definition Column?
Chris Streeter [EMAIL PROTECTED] wrote: Does MySQL have a description column avialable for columns within table definitions? What I mean is when you do and explain TABLE_NAME can you get a column that as a description for each field? This would of course be especially useful for documentation purposes. From version 4.1 MySQL supports comments on the column level. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Big difference in MyISAM and InnoDB SELECT speed
Innodb may not use an index (full scan) where MyIsam does (index crc which is the only relevant one). Have you done an EXPLAIN on your query ? May be an index on (origin,status,deleted) could help. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] Envoy : lundi 24 novembre 2003 13:58 A : [EMAIL PROTECTED] Objet : Big difference in MyISAM and InnoDB SELECT speed Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming selects. After converting all tables to InnoDB I noticed a big difference in processing speed of one of the SELECT queries performed by the application. My configuration file /etc/my.cnf is based on my-huge.cnf example. Table structure: create table urlword(url_id integer auto_increment primary key, site_id integer not null, tree_id integer not null, deleted tinyint DEFAULT 0 NOT NULL, url varchar(128) not null, next_index_time INT NOT NULL, status int(11) DEFAULT '0' NOT NULL, crc char(32) DEFAULT '' NOT NULL, last_modified varchar(32) DEFAULT '' NOT NULL, etag varchar(48) DEFAULT '' NOT NULL, last_index_time INT NOT NULL, referrer int(11) DEFAULT '0' NOT NULL, tag int(11) DEFAULT '0' NOT NULL, hops int(11) DEFAULT '0' NOT NULL, redir integer, origin integer, unique index(url), index(next_index_time), index(hops,next_index_time), index crc (origin, crc(8))); Query: select url_id from urlword where deleted=0 and status=200 and origin=1 MyISAM: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-+--+---++-+-+++-+ | urlword | MyISAM | Dynamic| 46648925 |143 | 6714978360 | 1099511627775 | 4052629504 | 0 | 46648929 | 2003-11-21 14:13:28 | 2003-11-22 04:01:16 | NULL | max_rows=1 | | Sample disk usage (iostat -x -d /dev/scsi/... 10): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 5510.20 0.20 361.10 0.40 46970.404.80 23485.20 2.40 129.95 16.41 45.39 27.11 98.00 Processing time: Query OK, 14274315 rows affected (4 min 54.88 sec) InnoDB: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-+--+---++-+-+++-+ | urlword | InnoDB | Dynamic| 44477984 |228 | 10150215680 | NULL | 13322158080 | 0 | 46648929 | NULL| NULL| NULL | max_rows=1 | InnoDB free: 6715392 kB | Sample disk usage (iostat -x -d /dev/scsi/... 10): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 2179.10 0.00 94.90 0.00 4548.000.00 2274.00 0.0047.92 9.96 104.85 104.00 98.70 Processing time: Query OK, 14274315 rows affected (1 day 8 hours 46 min 46.70 sec) Could someone please explain me what can be the reason of this difference and if there is a way to optimize InnoDB to perform better? Thanks, Janusz -- 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: Error 1045: Acess denied for user: 'ODBC@localhost' (Using password: YES)
ike strong [EMAIL PROTECTED] wrote: Can anyone help me to figure out why suddenly I cant gain access into MySQL database with my password, which I assigned myself and which was working fine until yesterday when access was suddenly denied to me with the following meassage: Error 1045: Acess denied for user: '[EMAIL PROTECTED]' (Using password: YES) You didn't specify user name. This is perhaps an old story here but very well new to me. Has anyone tackled or know what is causing this problem? I'd appreciate some help with this one. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error 1045: Acess denied for user: 'ODBC@localhost' (Using password: YES)
ike, Well, there are quite a few wierdnessess that I have experienced. One, for instance, is if you are working in the GUI editor interface, and are mucking around with the User priveleges I have actually had the GUI wipe the passwords to null for all rows. I'm sure its just because I'm not aware of the assumptions being made by the Control Center. Something like, I will change everything with the prefix XYZ when you press this button. Anyway, I probably created a new user for a specific database or something for my standard user login (but for a different machine host maybe) ( I use explicit definitions for all hosts.) And forgot to put in the password and that updated ALL the passwords for that login in the User table...on ALL hosts?... which rapidly halted all working applications. So I suggest logging into you mySQL server as root, and look at the user table and the user privileges, use a specific SQL request, otherwise you'll get an unreadable table in the Command Prompt viewer. (Don't forget to set the database to the master mysql database.) Select Host, User, Password from User ( The conclusion is that I believe you have all the passwords for your given login will be ) Use the Update User set Password = PASSWORD(mypasshere) where User = someone; Don't forget to FLUSH PRIVILEGES; when you're done mucking around, or none of you changes will take effect and you will quietly go crazy and or bald. Does Paul.D. actually HAVE hair? Has anyone met him in person to verify the existance of strands. lol- ;) _TheMechE -Original Message- From: ike strong [mailto:[EMAIL PROTECTED] Sent: Saturday, November 22, 2003 12:16 PM To: [EMAIL PROTECTED] Subject: Error 1045: Acess denied for user: '[EMAIL PROTECTED]' (Using password: YES) Can anyone help me to figure out why suddenly I cant gain access into MySQL database with my password, which I assigned myself and which was working fine until yesterday when access was suddenly denied to me with the following meassage: Error 1045: Acess denied for user: '[EMAIL PROTECTED]' (Using password: YES) This is perhaps an old story here but very well new to me. Has anyone tackled or know what is causing this problem? I'd appreciate some help with this one. Thanks in advance Ike __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- 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: DB design question - shell scripting...
That worked like a charm, thanks so much! I don't know why I didn't try that before! Julian At 02:46 PM 11/21/2003 -0600, Paul DuBois wrote: At 10:56 -0500 11/21/03, Julian Zottl wrote: Andy, Thanks for responding. I think that I am going to go with the idea of creating a tale for each day. My thoughts were to write a shell script to do this for me, but I am running into a problem: I wrote the following: #!/bin/sh date=`date +%m%d%Y` export date mysql -u root -p createdb.sql Then in createdb.sql CONNECT Blah; CREATE TABLE $date ( . ) TYPE=MyISAM; But it's not passing the $date variable to SQL :/ I've been looking on the web for a way to do this, but have yet to find it. any ideas? You could use a here-document instead of createdb.sql #!/bin/sh date=`date +%m%d%Y` mysql -u root -p EOF CONNECT Blah; CREATE TABLE t$date ( .. ) TYPE=MyISAM; EOF I put a t before $date -- you don't want to try creating a table with a name that's all digits. That makes it indistinguishable from a number, so you'd have to quote it with backticks every time you refer to it. Julian -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Julian Zottl Unix Systems Administrator NASA HQ - 202-358-1682 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Configuring built in OpenSLL
Daniel Kiss [EMAIL PROTECTED] wrote: I would like to know how to configure MySQL with the --with-vio and= --with-openssl options. I have a MySQL-4.1 installed on a Red Hat 9 system from .rpm packages. When I use the show variables command, it returns have_opensll =3D NO. Does it mean that the ssl support is not compiled into this binary, or I= just need to switch it on somehow? Official binaries are compiled without SSL support. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connection Refused by Linux Server
I have RH9 running on a p4 machine. I have mysql 3.23.58 running on this linux machine. Through Websphere studio application developer on windows xp machine I am trying to connect to my MySql database on the Linux machine. The error I receive is: connection refused I then tried to telnet to the Linux machine, this also error'd with: Connection Refused On the Linux machine I can see and access the other computers on my network, however none of my Windows machines see the Linux Server through Network Places. I can however successfully ping the Linux server. Addtional info: Linux security is set to none. Logging into Linux server MySql DB with root/password. Do I need to activate or configure something on the Linux server in order to allow connections? Thank you for your assistance -EKG
RE: MySQL 4.0.16 on SCO OpenServer 5.0.6
I'm totally lost now.. As you can (could) see in my previous post, I managed to get MySQL working on SCO with --with-debug as a configure option. Whenever I remove --with-debug, I can compile and install it, but I can't connect to it. Can someone please explain what this --with-debug adds that makes it run on my system ? Stefaan -Original Message- From: Stefaan Van Dooren [mailto:[EMAIL PROTECTED] Sent: vrijdag 21 november 2003 15:28 To: [EMAIL PROTECTED] Subject: RE: MySQL 4.0.16 on SCO OpenServer 5.0.6 I hate to respond to myself, but. I have it working now... MySQL 4.0.16-debug on SCO OPenServer 5.0.6a Stefaan Stefaan Van Dooren wrote: Since I got no answers, I will put another question Is anybody using MySQL 4.x on SCO OpenServer 5.x ? Stefaan Stefaan Van Dooren wrote: Hi, I'm trying to install (compile, since there are no binaries for this system) MySQL on an SCO OPenServer 5.0.6 system. Prior to compiling MySQL, I installed the following packages for SCO : FSU Pthreads (ver 3.9) GNU Development Tools (ver 5.0.7Kj) Netscape Communicator (ver 4.7.0e) OSS631B - Supplemental Graphics, Web and X11 Libraries (ver 1.2.1) SCO OpenServer Enterprise System (ver 5.0.6j) SCO OpenServer Linker and Application Development Libraries (ver 5.1.2A) SCO SendMail (ver 8.11.0) OSS635A: Graphical Environment Supplement for OpenServer 5.0.6 (ver 1.0.0) OSS646B - Execution Environment Supplement (ver 1.1.0j) RS506A: Release Supplement for SCO OpenServer Release 5.0.6 (ver rs506a) RS506A: Software Manager Supplement (ver rs506a) USB Supplement (ver 1.0a) I followed the manual for compiling and installing MySQL. MySQL compiles just fine. I can use the compiled client to connect to databases running on W2K and linux servers. When I start the server (mysqld-safe --user=mysql --log ), it seems to start fine : Starting mysqld daemon with databases from /usr/local/mysql/var Err log : 031120 10:35:55 mysqld started Log : /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql/libexec/mysqld, Version: 4.0.16-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id CommandArgument The socket is there, but when I start mysql it just hangs there forever When I try msqladmin status it also hangs, but when I stop it, I get # mysqladmin status mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (4) ' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! It's there : # l /tmp/mysq* prwxrwxrwx 1 mysqlmysql 0 Nov 20 10:35 /tmp/mysql.sock # Any help would be appreciated, Stefaan Van Dooren .--. Technical Support |o_o | Kompas Automatisering |:_/ | // \ \ Tel : +32 3 2350084(| | ) Fax : +32 3 2359792 /'\_ _/`\ Email : [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]
Problems creating databases
Hi All, When I type a command after the mysql prompt nothing happens and no error. For example: mysql CREATE DATABASE members SHOW DATABASES What do you think is the problem. This is an apache web server. The OS is Redhat Edgar
Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
Marc, Thank you for your prompt answer. I run EXPLAIN in both cases and got: MyISAM (fast): mysql explain select url_id from urlword where deleted=0 and status=200 and origin=1; +-+--+---+--+-+--+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+--++ | urlword | ALL | crc | NULL |NULL | NULL | 46648925 | where used | +-+--+---+--+-+--+--++ 1 row in set (0.18 sec) InnoDB (very slow): mysql explain select url_id from urlword where deleted=0 and status=200 and origin=1; +-+--+---+--+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+--++ | urlword | ref | crc | crc | 5 | const | 16951116 | where used | +-+--+---+--+-+---+--++ 1 row in set (0.22 sec) So I retried InnoDB with ignore index (crc) and got: Sample disk usage (iostat): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 32586.70 0.00 530.10 0.00 66233.600.00 33116.80 0.00 124.9515.35 28.99 15.11 80.10 Processing time: Query OK, 14274315 rows affected (5 min 43.23 sec) That's it, 5 minutes, not 32 hours. Next I found that this issue is not related to InnoDB. On my second server with almost the same data in MyISAM tables the query also uses the index and lasts forever. Now the question is: how should I set up (and maintain?) my MySQL server to prevent it from using indexes inefficiently? Janusz Mechain Marc wrote: Innodb may not use an index (full scan) where MyIsam does (index crc which is the only relevant one). Have you done an EXPLAIN on your query ? May be an index on (origin,status,deleted) could help. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] Envoy : lundi 24 novembre 2003 13:58 A : [EMAIL PROTECTED] Objet : Big difference in MyISAM and InnoDB SELECT speed Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming selects. After converting all tables to InnoDB I noticed a big difference in processing speed of one of the SELECT queries performed by the application. My configuration file /etc/my.cnf is based on my-huge.cnf example. Table structure: create table urlword(url_id integer auto_increment primary key, site_id integer not null, tree_id integer not null, deleted tinyint DEFAULT 0 NOT NULL, url varchar(128) not null, next_index_time INT NOT NULL, status int(11) DEFAULT '0' NOT NULL, crc char(32) DEFAULT '' NOT NULL, last_modified varchar(32) DEFAULT '' NOT NULL, etag varchar(48) DEFAULT '' NOT NULL, last_index_time INT NOT NULL, referrer int(11) DEFAULT '0' NOT NULL, tag int(11) DEFAULT '0' NOT NULL, hops int(11) DEFAULT '0' NOT NULL, redir integer, origin integer, unique index(url), index(next_index_time), index(hops,next_index_time), index crc (origin, crc(8))); Query: select url_id from urlword where deleted=0 and status=200 and origin=1 MyISAM: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-+--+---++-+-+++-+ | urlword | MyISAM | Dynamic| 46648925 |143 | 6714978360 | 1099511627775 | 4052629504 | 0 | 46648929 | 2003-11-21 14:13:28 | 2003-11-22 04:01:16 | NULL | max_rows=1 | | Sample disk usage (iostat -x -d /dev/scsi/... 10): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 5510.20 0.20 361.10 0.40 46970.404.80 23485.20 2.40 129.95 16.41 45.39 27.11 98.00 Processing time: Query OK, 14274315 rows affected (4 min 54.88 sec) InnoDB: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment |
Re: Problems creating databases
When I type a command after the mysql prompt nothing happens and no error. For example: mysql CREATE DATABASE members SHOW DATABASES What do you think is the problem. This is an apache web server. The OS is Redhat This is just a shot in the dark, but there are no semi-colons at the end of each of the above lines to indicate full, executable query. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems creating databases
End your commands with a semicolon. Edgar Powell wrote: Hi All, When I type a command after the mysql prompt nothing happens and no error. For example: mysql CREATE DATABASE members SHOW DATABASES What do you think is the problem. This is an apache web server. The OS is Redhat Edgar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
You are not using any indicies, because there aren't any that could be used in this query. Try adding an index on (status,deleted) Janusz Krzysztofik wrote: Marc, Thank you for your prompt answer. I run EXPLAIN in both cases and got: MyISAM (fast): mysql explain select url_id from urlword where deleted=0 and status=200 and origin=1; +-+--+---+--+-+--+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+--++ | urlword | ALL | crc | NULL |NULL | NULL | 46648925 | where used | +-+--+---+--+-+--+--++ 1 row in set (0.18 sec) InnoDB (very slow): mysql explain select url_id from urlword where deleted=0 and status=200 and origin=1; +-+--+---+--+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+--++ | urlword | ref | crc | crc | 5 | const | 16951116 | where used | +-+--+---+--+-+---+--++ 1 row in set (0.22 sec) So I retried InnoDB with ignore index (crc) and got: Sample disk usage (iostat): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 32586.70 0.00 530.10 0.00 66233.600.00 33116.80 0.00 124.9515.35 28.99 15.11 80.10 Processing time: Query OK, 14274315 rows affected (5 min 43.23 sec) That's it, 5 minutes, not 32 hours. Next I found that this issue is not related to InnoDB. On my second server with almost the same data in MyISAM tables the query also uses the index and lasts forever. Now the question is: how should I set up (and maintain?) my MySQL server to prevent it from using indexes inefficiently? Janusz Mechain Marc wrote: Innodb may not use an index (full scan) where MyIsam does (index crc which is the only relevant one). Have you done an EXPLAIN on your query ? May be an index on (origin,status,deleted) could help. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] Envoy : lundi 24 novembre 2003 13:58 A : [EMAIL PROTECTED] Objet : Big difference in MyISAM and InnoDB SELECT speed Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming selects. After converting all tables to InnoDB I noticed a big difference in processing speed of one of the SELECT queries performed by the application. My configuration file /etc/my.cnf is based on my-huge.cnf example. Table structure: create table urlword(url_id integer auto_increment primary key, site_id integer not null, tree_id integer not null, deleted tinyint DEFAULT 0 NOT NULL, url varchar(128) not null, next_index_time INT NOT NULL, status int(11) DEFAULT '0' NOT NULL, crc char(32) DEFAULT '' NOT NULL, last_modified varchar(32) DEFAULT '' NOT NULL, etag varchar(48) DEFAULT '' NOT NULL, last_index_time INT NOT NULL, referrer int(11) DEFAULT '0' NOT NULL, tag int(11) DEFAULT '0' NOT NULL, hops int(11) DEFAULT '0' NOT NULL, redir integer, origin integer, unique index(url), index(next_index_time), index(hops,next_index_time), index crc (origin, crc(8))); Query: select url_id from urlword where deleted=0 and status=200 and origin=1 MyISAM: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-+--+---++-+-+++-+ | urlword | MyISAM | Dynamic| 46648925 |143 | 6714978360 | 1099511627775 | 4052629504 | 0 | 46648929 | 2003-11-21 14:13:28 | 2003-11-22 04:01:16 | NULL | max_rows=1 | | Sample disk usage (iostat -x -d /dev/scsi/... 10): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 5510.20 0.20 361.10 0.40 46970.404.80 23485.20 2.40 129.95 16.41 45.39 27.11 98.00 Processing time: Query OK, 14274315 rows affected (4 min 54.88 sec) InnoDB: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length |
RE: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
Janusz, Now the question is: how should I set up (and maintain?) my MySQL server to prevent it from using indexes inefficiently? Quite a good question, no idea. But if the query select url_id from urlword where deleted=?? and status=??? and origin=?; is a query that you will use very often, I still think that creating an index on (origin,status,deleted) is the good answer. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] Envoy : lundi 24 novembre 2003 16:48 A : Mechain Marc Cc : [EMAIL PROTECTED] Objet : Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed) Marc, Thank you for your prompt answer. I run EXPLAIN in both cases and got: MyISAM (fast): mysql explain select url_id from urlword where deleted=0 and status=200 and origin=1; +-+--+---+--+-+--+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+--++ | urlword | ALL | crc | NULL |NULL | NULL | 46648925 | where used | +-+--+---+--+-+--+--++ 1 row in set (0.18 sec) InnoDB (very slow): mysql explain select url_id from urlword where deleted=0 and status=200 and origin=1; +-+--+---+--+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+--++ | urlword | ref | crc | crc | 5 | const | 16951116 | where used | +-+--+---+--+-+---+--++ 1 row in set (0.22 sec) So I retried InnoDB with ignore index (crc) and got: Sample disk usage (iostat): Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-sz avgqu-sz await svctm %util /dev/scsi/host1/bus4/target0/lun0/disc 32586.70 0.00 530.10 0.00 66233.600.00 33116.80 0.00 124.9515.35 28.99 15.11 80.10 Processing time: Query OK, 14274315 rows affected (5 min 43.23 sec) That's it, 5 minutes, not 32 hours. Next I found that this issue is not related to InnoDB. On my second server with almost the same data in MyISAM tables the query also uses the index and lasts forever. Now the question is: how should I set up (and maintain?) my MySQL server to prevent it from using indexes inefficiently? Janusz Mechain Marc wrote: Innodb may not use an index (full scan) where MyIsam does (index crc which is the only relevant one). Have you done an EXPLAIN on your query ? May be an index on (origin,status,deleted) could help. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] Envoy : lundi 24 novembre 2003 13:58 A : [EMAIL PROTECTED] Objet : Big difference in MyISAM and InnoDB SELECT speed Hello, I am trying to optimize MySQL (3.23.49 from Debian stable) setup for ASPseek application. I decided to try InnoDB in order to be able to update tables while performing time consuming selects. After converting all tables to InnoDB I noticed a big difference in processing speed of one of the SELECT queries performed by the application. My configuration file /etc/my.cnf is based on my-huge.cnf example. Table structure: create table urlword(url_id integer auto_increment primary key, site_id integer not null, tree_id integer not null, deleted tinyint DEFAULT 0 NOT NULL, url varchar(128) not null, next_index_time INT NOT NULL, status int(11) DEFAULT '0' NOT NULL, crc char(32) DEFAULT '' NOT NULL, last_modified varchar(32) DEFAULT '' NOT NULL, etag varchar(48) DEFAULT '' NOT NULL, last_index_time INT NOT NULL, referrer int(11) DEFAULT '0' NOT NULL, tag int(11) DEFAULT '0' NOT NULL, hops int(11) DEFAULT '0' NOT NULL, redir integer, origin integer, unique index(url), index(next_index_time), index(hops,next_index_time), index crc (origin, crc(8))); Query: select url_id from urlword where deleted=0 and status=200 and origin=1 MyISAM: Table status: | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-+--+---++-+-+++-+ | urlword | MyISAM | Dynamic| 46648925 |143 | 6714978360 | 1099511627775 | 4052629504 | 0 | 46648929 | 2003-11-21
Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
Hi, You are not using any indicies, because there aren't any that could be used in this query. Try adding an index on (status,deleted) I wonder: how many possible different values would such an index return? If this is a (very) low value, won't the index make things slower (if it's being used) compared to a full table scan? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inquery from Varian Medical Systems
Hi Robert, I did not see any suggestions to you. So here is one. If you want a guarantee simple brute force dump the entire DB with mysqldump and recreate of the slave. For Exmaple mysqldump --opt mydb | mysql -umyuser -pmypwd -hremotehost myremotedb You can run this through an ssh tunnel for security or compress and forward or do it in multiple steps. But if it completes without errors all data will be present on the remote system. Hope this helps, Ken - Original Message - From: robertxu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 21, 2003 6:37 PM Subject: Inquery from Varian Medical Systems To Whom It May Concern: I am Robert and work for Varian Medical Systems. MySQl is the backend of our Intranet, VMSNet. Our current environment is: The web server and MySQL reside in one hardware server- US server. If this hardware server fails, we switch the users to our European web server. But the European web server is not bundled with MySQL. So all the MySQL applications still are not available until US server is back. That is the problem. Someone suggests to set up MySQL master and slave instances to solves this. But such configuration does not guarantee 100% data synchronization between the master and the slave. Is there any other alternatives? Please advise. Appreciate your attention and time. Regards, Robert -- 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: web data entry problem
There could be a number of things going on. It would help troubleshoot your problem if your script check for errors and print them if there are any. You cant just assume a connection is being made just because phpmyadmin connects. Your web app has to make its own connection. So how about showing us one of your scripts. I bet it is something simple youre overlooking in your setup. [EMAIL PROTECTED] wrote: I hope someone might be willing to help out. I'm trying [still] to learn MySQL and php - to create some simply web based database. I have installed quite a few php/MySQL web database apps from books, however, none of them will get data entered into my database. When I create the database exactly as instructed, everything works great, but when I create the form to send/add a new record to my db then look at the db the new data is not there. This happens repeatedly with every example I build. I can add records using a terminal or phpMyAdmin. I'm running MySQL 4.0.14, Mac OS X 10.3, PHP 4.3.2. I installed 'tasks' - http://www.versiontracker.com/dyn/moreinfo/macosx/17996 and it works just fine! but it is too big for me to use to compare to my very simple scripts. Here is one I have recently installed whose data will not enter: http://hotwired.lycos.com/webmonkey/99/21/index3a_page4.html? tw=programming I believe my db connection is being made (I may be wrong), after all my phpMyAdmin app also works fine. I would be very grateful is there might be a kind soul who would work with me to help me to find out what is wrong? I have had dbs before that worked fine, I don't understand this problem at all. Thanks, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
Martijn Tonies wrote: Hi, You are not using any indicies, because there aren't any that could be used in this query. Try adding an index on (status,deleted) I wonder: how many possible different values would such an index return? mysql select distinct status, deleted from urlword; ++-+ | status | deleted | ++-+ |200 | 0 | |503 | 0 | |302 | 0 | | 0 | 1 | |200 | 1 | |504 | 0 | |301 | 0 | | 0 | 0 | |204 | 0 | |420 | 0 | | 1 | 0 | |303 | 0 | |470 | 0 | ++-+ 13 rows in set (6 min 55.94 sec) mysql select distinct status, deleted, origin from urlword; ... 23 rows in set (7 min 9.90 sec) If this is a (very) low value, won't the index make things slower (if it's being used) compared to a full table scan? I guess these values are very low for a table with 46 milion records, so I understand it is better not to use such indicies, right? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com Thanks, Martijn, Janusz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SHOW TABLE STATUS without LIKE
Hi! Please reply to the list, not to me personally, so that others can follow this discussion. Thanks. At 13:21 +0200 11/21/03, Jozsa Boti wrote: Hi! How an i get the last Check-time of a specific table without using LIKE statements? There isn't another way. There's the SHOW TABLE STATUS command, but if there are many tables in a database this command is very slow, even if a specific table name is after the LIKE statment. Slow? How many tables are we talking about? I'm talking about nearly 20 000 tables in a database. In this case a SHOW TABLE STATUS commande takes about 20-30 seconds. Hm, that is pretty slow. How long does an ls command in the database directory take? Thanks, Boti -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA LOCAL INFILE question...
Egor, Thanks for the info. However, like I said, I already have local-infile=1 and set-variable = local-infile=1 in my my.ini on the server. I also have already done 'show variable like '%infile%' ' and receive local_infile ON in the result set. I run the command line client with --local-infile=1 I still receive the same error regardless of the configuration. -- R - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 22, 2003 5:25 AM Subject: Re: LOAD DATA LOCAL INFILE question... Robert [EMAIL PROTECTED] wrote: Having problems using 'LOAD DATA LOCAL INFILE' from a UNIX client talking to a Win32 server. I've read the documentation several times now and have had zero success with this command. You should run client and server with --local-infile option: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SHOW TABLE STATUS without LIKE
Hi, I have noticed also that SHOW TABLE STATUS became slower in 5 times at least (from 1 sec to 5-6 secs). Since I've switched to version 3.23.53 to version 4.0.14. But I have changed type of all my tables (~30 tables) from MyISAM to InnoDB as well. How long does an ls command in the database directory take? less than 1 sec. Thanks, Mikhail. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Jozsa Boti [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 24, 2003 5:36 PM Subject: Re: SHOW TABLE STATUS without LIKE Hi! Please reply to the list, not to me personally, so that others can follow this discussion. Thanks. At 13:21 +0200 11/21/03, Jozsa Boti wrote: Hi! How an i get the last Check-time of a specific table without using LIKE statements? There isn't another way. There's the SHOW TABLE STATUS command, but if there are many tables in a database this command is very slow, even if a specific table name is after the LIKE statment. Slow? How many tables are we talking about? I'm talking about nearly 20 000 tables in a database. In this case a SHOW TABLE STATUS commande takes about 20-30 seconds. Hm, that is pretty slow. How long does an ls command in the database directory take? Thanks, Boti -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)
Hi, You are not using any indicies, because there aren't any that could be used in this query. Try adding an index on (status,deleted) I wonder: how many possible different values would such an index return? mysql select distinct status, deleted from urlword; ++-+ | status | deleted | ++-+ |200 | 0 | |503 | 0 | |302 | 0 | | 0 | 1 | |200 | 1 | |504 | 0 | |301 | 0 | | 0 | 0 | |204 | 0 | |420 | 0 | | 1 | 0 | |303 | 0 | |470 | 0 | ++-+ 13 rows in set (6 min 55.94 sec) mysql select distinct status, deleted, origin from urlword; ... 23 rows in set (7 min 9.90 sec) If this is a (very) low value, won't the index make things slower (if it's being used) compared to a full table scan? I guess these values are very low for a table with 46 milion records, so I understand it is better not to use such indicies, right? Well, that's what I have understood from many db engines :-) Of course, the engine itself should be smart enough to avoid using the index because of low selectivity. The idea is, that fetching rows in index order takes make time then fetching rows in storage order. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help recovering db
Using a backup I recreated the /var/lib/mysql directory and when I restart mysqld I am getting the following error: InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of a different size 0 5238827 byes InnoDB: than specified in the .cnf file 0 5242880 Of course, the database never starts because of this. Oddly, if I move the backup to another machine that is running the same version of MySQL (same OS and version), the database starts correctly. I have tried running mysqld with and without a my.cnf file present and have changed some of the values regarding the logfile size but have not been able to successfully start the database. Is anyone aware of any workaround for this? Thanks, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help recovering db
From MySQL Manual: If you want to change the number or the size of your InnoDB log files, you have to shut down MySQL and make sure that it shuts down without errors. Then copy the old log files into a safe place just in case something went wrong in the shutdown and you will need them to recover the database. Delete then the old log files from the log file directory, edit `my.cnf', and start MySQL again. InnoDB will tell you at the startup that it is creating new log files. I hope it can help you. Janusz -- Kevin Carlson wrote: Using a backup I recreated the /var/lib/mysql directory and when I restart mysqld I am getting the following error: InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of a different size 0 5238827 byes InnoDB: than specified in the .cnf file 0 5242880 Of course, the database never starts because of this. Oddly, if I move the backup to another machine that is running the same version of MySQL (same OS and version), the database starts correctly. I have tried running mysqld with and without a my.cnf file present and have changed some of the values regarding the logfile size but have not been able to successfully start the database. Is anyone aware of any workaround for this? Thanks, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error at Database Record Update Submit
The problem is: I am developing a database application in Adobe GoLive using MySQL and PHP. I can retrieve a record with no problem. When I modify the record and attempt to update it (Submit Button) the system thinks it should download mysql.actions6.php (from my computer) and when I click OK, it gives the message; Access to specified device, path, or file is denied. Attempting to do the AddRecord action gives the same result. Please help. Tim Whitley
Re: Problems creating databases
Thank you all for your prompt answers. It works find. As you can see, I am an infant as of now. I just picked up a Mysql PHP for Dummies book. If you have better learning references that I may consider, I would be very appreciative. Edgar - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Edgar Powell [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:48 AM Subject: Re: Problems creating databases End your commands with a semicolon. Edgar Powell wrote: Hi All, When I type a command after the mysql prompt nothing happens and no error. For example: mysql CREATE DATABASE members SHOW DATABASES What do you think is the problem. This is an apache web server. The OS is Redhat Edgar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Warnings in CREATE TABLE
Hi all, Could you please tell me what can be causing this warnings? How can I see them? My Python script is dying because of this warnings :( Since I'm using 4.0.16, I can't use SHOW WARNINGS. Thanks in advance, Hector mysql create table new_web select a.* from otr_new as a join internet as b on a.telefb = b.tel; Query OK, 25335 rows affected (46.98 sec) Records: 25335 Duplicates: 0 Warnings: 311 mysql explain select a.* from otr_new as a join internet as b on a.telefb = b.tel; +---+---+---+--+-+--+-+--+ | table | type | possible_keys | key | key_len | ref | rows| Extra| +---+---+---+--+-+--+-+--+ | a | index | NULL | tel | 47 | NULL | 3343166 | Using index | | b | ref | tel | tel | 8 | a.telefb | 11 | Using where; Using index | +---+---+---+--+-+--+-+--+ 2 rows in set (0.00 sec) mysql select version(); +---+ | version() | +---+ | 4.0.16-nt | +---+ 1 row in set (0.02 sec) mysql explain otr_new; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | tel| char(8) | YES | MUL | NULL| | | telefb | char(14) | YES | | NULL| | | rutaentran | char(8) | YES | | NULL| | | rutasalien | char(8) | YES | | NULL| | | minutos| int(7) | YES | | NULL| | ++--+--+-+-+---+ 5 rows in set (0.00 sec) mysql explain internet; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | tel | char(7) | YES | MUL | NULL| | | modem | char(30) | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql explain new_web; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | tel| char(8) | YES | | NULL| | | telefb | char(14) | YES | | NULL| | | rutaentran | char(8) | YES | | NULL| | | rutasalien | char(8) | YES | | NULL| | | minutos| int(7) | YES | | NULL| | ++--+--+-+-+---+ 5 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA LOCAL INFILE question...
Reverend Deuce [EMAIL PROTECTED] wrote: Egor, Thanks for the info. However, like I said, I already have local-infile=1 and set-variable = local-infile=1 in my my.ini on the server. I also have already done 'show variable like '%infile%' ' and receive local_infile ON in the result set. I run the command line client with --local-infile=1 I still receive the same error regardless of the configuration. Should work. What are the server and client versions? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My.cnf
I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new Location for the my.cnf file
Re: Warnings in CREATE TABLE
Héctor Villafuerte D. wrote: Hi all, Could you please tell me what can be causing this warnings? How can I see them? My Python script is dying because of this warnings :( Since I'm using 4.0.16, I can't use SHOW WARNINGS. Thanks in advance, Hector mysql create table new_web select a.* from otr_new as a join internet as b on a.telefb = b.tel; Query OK, 25335 rows affected (46.98 sec) Records: 25335 Duplicates: 0 Warnings: 311 mysql explain select a.* from otr_new as a join internet as b on a.telefb = b.tel; +---+---+---+--+-+--+-+--+ | table | type | possible_keys | key | key_len | ref | rows | Extra| +---+---+---+--+-+--+-+--+ | a | index | NULL | tel | 47 | NULL | 3343166 | Using index | | b | ref | tel | tel | 8 | a.telefb | 11 | Using where; Using index | +---+---+---+--+-+--+-+--+ 2 rows in set (0.00 sec) mysql select version(); +---+ | version() | +---+ | 4.0.16-nt | +---+ 1 row in set (0.02 sec) mysql explain otr_new; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | tel| char(8) | YES | MUL | NULL| | | telefb | char(14) | YES | | NULL| | | rutaentran | char(8) | YES | | NULL| | | rutasalien | char(8) | YES | | NULL| | | minutos| int(7) | YES | | NULL| | ++--+--+-+-+---+ 5 rows in set (0.00 sec) mysql explain internet; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | tel | char(7) | YES | MUL | NULL| | | modem | char(30) | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql explain new_web; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | tel| char(8) | YES | | NULL| | | telefb | char(14) | YES | | NULL| | | rutaentran | char(8) | YES | | NULL| | | rutasalien | char(8) | YES | | NULL| | | minutos| int(7) | YES | | NULL| | ++--+--+-+-+---+ 5 rows in set (0.00 sec) hmmm, a pretty strange behaviour we have here Look what I did: (1) Increase the length of 'internet.tel' field (so it matches 'otr_new.telefb') mysql explain internet; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | tel | char(14) | YES | MUL | NULL| | | modem | char(30) | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) (2) Run the query... and voila! mysql create table tmp_web3 select a.* from otr_new as a join internet as b ON a.telefb = b.tel; Query OK, 25335 rows affected (49.02 sec) Records: 25335 Duplicates: 0 Warnings: 0 The number of records found are the same in both queries, but this one has no warnings! Am I missing something obvious here? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new No official way. You can make a symbolic link at /etc/my.cnf that points to your new location. Location for the my.cnf file -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What's best
I would like to know what is the best program for administering MySAQL databases: is it PHPMyAmin or something else? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What's best
IMHO, there's nothing quite as intuitive and easy to deal with as phpmyadmin ... i can't begin to tell you how much time it saves me every day. kennM Sale Zenzo wrote: I would like to know what is the best program for administering MySAQL databases: is it PHPMyAmin or something else? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What's best
That depends :) I use phpMyAdmin and mysqlcc, just depending on what I want to do. j- At 11:36 AM 11/24/2003 -0800, Sale Zenzo wrote: I would like to know what is the best program for administering MySAQL databases: is it PHPMyAmin or something else? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Julian Zottl Unix Systems Administrator NASA HQ - 202-358-1682 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What's best
Yes i think it too. I use it but i thought that there are more tolls. --- Kenn Murrah [EMAIL PROTECTED] wrote: IMHO, there's nothing quite as intuitive and easy to deal with as phpmyadmin ... i can't begin to tell you how much time it saves me every day. kennM Sale Zenzo wrote: I would like to know what is the best program for administering MySAQL databases: is it PHPMyAmin or something else? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What's best
This is exactly what i use as well.both tools have their benefits and limitations Julian Zottl [EMAIL PROTECTED]To: Sale Zenzo [EMAIL PROTECTED], MySQL List [EMAIL PROTECTED] ov cc: Subject: Re: What's best 11/24/2003 02:40 PM That depends :) I use phpMyAdmin and mysqlcc, just depending on what I want to do. j- At 11:36 AM 11/24/2003 -0800, Sale Zenzo wrote: I would like to know what is the best program for administering MySAQL databases: is it PHPMyAmin or something else? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Julian Zottl Unix Systems Administrator NASA HQ - 202-358-1682 -- 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]
What administrative tasks
What administrative tasks should I do often on my database? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA LOCAL INFILE question...
Versions: Server is Win32 MySQL max 4.0.16 Client is FreeBSD MySQL 4.0.13 -- R Should work. What are the server and client versions? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new No official way. You can make a symbolic link at /etc/my.cnf that points to your new location. I don't even have a my.cnf on any of my *nix boxes, and MySQL runs fine. Does this only come into play with precompiled binaries? -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new No official way. You can make a symbolic link at /etc/my.cnf that points to your new location. I don't even have a my.cnf on any of my *nix boxes, and MySQL runs fine. Does this only come into play with precompiled binaries? No. Option files are, er, optional. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What's best
This is exactly what i use as well.both tools have their benefits and limitations I guess this goes for all tools :-) If you're running Windows, you might want to take a look at Database Workbench as well. It's not free and new to MySQL, but it includes other tools and features as well. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
Paul DuBois wrote: Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new No official way. You can make a symbolic link at /etc/my.cnf that points to your new location. I don't even have a my.cnf on any of my *nix boxes, and MySQL runs fine. Does this only come into play with precompiled binaries? No. Option files are, er, optional. Why would the OP not be able to start MySQL when moving the config file then? note Not trying to be a smartassjust want to know in case I run into the same problem sometime in the future. /note -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
At 14:37 -0600 11/24/03, John Nichel wrote: Paul DuBois wrote: Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new No official way. You can make a symbolic link at /etc/my.cnf that points to your new location. I don't even have a my.cnf on any of my *nix boxes, and MySQL runs fine. Does this only come into play with precompiled binaries? No. Option files are, er, optional. Why would the OP not be able to start MySQL when moving the config file then? I suppose he changed some other aspect of his installation that requires options to be specified, e.g., if you change the location of the data directory. This makes the *option* required, though it could be specified on the command line *or* in an option file. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
Paul DuBois wrote: At 14:37 -0600 11/24/03, John Nichel wrote: Paul DuBois wrote: Paul DuBois wrote: At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new No official way. You can make a symbolic link at /etc/my.cnf that points to your new location. I don't even have a my.cnf on any of my *nix boxes, and MySQL runs fine. Does this only come into play with precompiled binaries? No. Option files are, er, optional. Why would the OP not be able to start MySQL when moving the config file then? I suppose he changed some other aspect of his installation that requires options to be specified, e.g., if you change the location of the data directory. This makes the *option* required, though it could be specified on the command line *or* in an option file. Ah, okay. Thanks for the info. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TINYINT(1) vs ENUM?
Normally for a column with 2 possible values, I would use TINYINT(1) and programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is the correct: way? Now how about using ENUM instead? Is there any difference in overhead? Thanks!
TINYINT(1) vs ENUM ?
Normally for a column with 2 possible values, I would use TINYINT(1) and programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is the correct: way? Now how about using ENUM instead? Is there any difference in overhead? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
When you do a mysqld -? it will say: Default options are read from the following files in the given order: /etc/my.cnf /var/lib/mysql/my.cnf~/.my.cnf So that's the reason you can not start it anymore. (I'm using 4.1.0-alpha.) Hope this helps. Peter Sap. - Original Message - From: Arnoldus Th.J. Koeleman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 24, 2003 8:17 PM Subject: My.cnf I like to install the my.cnf in another directory and not the default /etc/my.cnf When I move this file to another directory it can't start anymore. Is there a way to install my.cnf in a different location and which file need to be updated to look into the new Location for the my.cnf file -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: TINYINT(1) vs ENUM?
I always gone with ENUMs b/c TINYINT(1) still allows you to insert a '2' into the field and the last idiot at my current job actually used '0' for 'true' in a some fields in some tables. I believe both would use 1 byte. Mike Paul Fine wrote: Normally for a column with 2 possible values, I would use TINYINT(1) and programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is the correct: way? Now how about using ENUM instead? Is there any difference in overhead? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My.cnf
I wanna deploy two different Mysql versions 3.23 and 4.0 As far as I understand this is not possible am I correct?? Since both version have different needs in case of my.cnf
protect data integrity??
Hello, mysql Gurus, I am wondering if there is any data integrity protection can be done if I allow uses to update database from mysql Control Center or Excel and any other applications that is connected to mysql thru mysql ODBC. I need to reject the action if it makes violation of the data integrity (like sth not in enum values, or some relations between tables that foreign key constraint can't protect). At this moment I have a script that takes a sql command file that intends to update the database, checks each command to see if the result of executing it would violate data integrity. The script is executed at command line. But if the update comes from windows applications, I am not sure how I can get my script working in between mysql server/client and the application. Has anyone been in the same situation as I am? Any suggestion would be very welcome. The version of mysql is 4.0.16 running on Linux redhat. Thanks ginger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
data integrity?
Hello, mysql Gurus, I am wondering if there is any data integrity protection can be done if I allow uses to update database from mysql Control Center or Excel and any other applications that is connected to mysql thru mysql ODBC. I need to reject the action if it makes violation of the data integrity (like sth not in enum values, or some relations between tables that foreign key constraint can't protect). At this moment I have a script that takes a sql command file that intends to update the database, checks each command to see if the result of executing it would violate data integrity. The script is executed at command line. But if the update comes from windows applications, I am not sure how I can get my script working in between mysql server/client and the application. Has anyone been in the same situation as I am? Any suggestion would be very welcome. The version of mysql is 4.0.16 running on Linux redhat. Thanks ginger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: TINYINT(1) vs ENUM?
maybe one more particle of information is that enums are actually strings, not numbers, so you may have to do a conversion somewhere. this is a pain for us, so we use tiny ints. jeff Mike [tmw] wrote: I always gone with ENUMs b/c TINYINT(1) still allows you to insert a '2' into the field and the last idiot at my current job actually used '0' for 'true' in a some fields in some tables. I believe both would use 1 byte. Mike Paul Fine wrote: Normally for a column with 2 possible values, I would use TINYINT(1) and programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is the correct: way? Now how about using ENUM instead? Is there any difference in overhead? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
You could install version 3.23 under a different username (like mysql323) than the 4.0 version (like username mysql40). Then put each .my.cnf in the ~ directory. Regards, Peter Sap - Original Message - From: Arnoldus Th.J. Koeleman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 24, 2003 10:33 PM Subject: My.cnf I wanna deploy two different Mysql versions 3.23 and 4.0 As far as I understand this is not possible am I correct?? Since both version have different needs in case of my.cnf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My.cnf
Not correct. The manual explains how. Use separate data directories, and put the my.cnf files in the data directories. Arnoldus Th.J. Koeleman wrote: I wanna deploy two different Mysql versions 3.23 and 4.0 As far as I understand this is not possible am I correct?? Since both version have different needs in case of my.cnf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: My.cnf
don't forget to change the port number that the server is listening on if you plan on running them simultaneously -Original Message- From: Peter Sap [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:59 PM To: [EMAIL PROTECTED] Subject: Re: My.cnf You could install version 3.23 under a different username (like mysql323) than the 4.0 version (like username mysql40). Then put each .my.cnf in the ~ directory. Regards, Peter Sap - Original Message - From: Arnoldus Th.J. Koeleman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 24, 2003 10:33 PM Subject: My.cnf I wanna deploy two different Mysql versions 3.23 and 4.0 As far as I understand this is not possible am I correct?? Since both version have different needs in case of my.cnf -- 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]
Uninstall binary install of mysql
Hello ! I hope all is good with you. It's a Red Hat Linux 8 with latest version of mysql. I'm used to using RPMs and uninstalling with rpm -e, however, this time a binary version of mysql was used have got no idea how to uninstall it completely off the system. Been looking over the Internet nada. I'd certainly appreciated if someone can shade some light or point me in the right direction to uninstall mysql binary install in the systems. Thanks so much! I am a newbie at mysql. __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Uninstall binary install of mysql
Carlos wrote: have got no idea how to uninstall it completely off the system. You could try something vaguely like this: # mkdir -p cd /tmp/mysqluninst # cd /tmp/mysqluninst # tar xvzf path-to-mysql-bin.tar.gz # find . -exec rm /{} \; DO NOT RUN THIS if you do not understand how it functions. It may contain bugs, and I won't be responsible if you blindly run it and it eats your filesystem. Even if you think you know how it functions, you should probably replace the 'rm' part of the last command with something harmless so you can ensure that it does the right thing before re-issuing the command with 'rm' instead. If you don't understand what I have done above and you are unwilling to learn, just disable the mysql server and don't bother erasing its files. It's probably only a few megs of disk space anyway. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do test unique values in a MySql column?
Hi Y'All I need to test if any values in a column are the same (or are unique) eg (my made up syntax Unique) SELECT * from tbl_addresses WHERE txtName is UNIQUE; How should this be done??? zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
programming language
Hello .. I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for MySql, that supports constructs such as LOOP, If-then-Else etc. Appreciate someone who could respond.. S Kusumo [EMAIL PROTECTED]
Re: My.cnf
At 16:33 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote: I wanna deploy two different Mysql versions 3.23 and 4.0 As far as I understand this is not possible am I correct?? No, it's perfectly possible. I have dozens of versions installed on my main machine. See the manual here: http://www.mysql.com/doc/en/Multiple_servers.html Since both version have different needs in case of my.cnf The easiest way to provide server-specific options is to compile each version yourself, each with a different compiled-in data directory location. Then put a my.cnf file in the data directory and only the corresponding server will read it. You can also arrange to start each server with --defaults-file, and specify a different file for each server. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: programming language
Hi I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for MySql, that supports constructs such as LOOP, If-then-Else etc. Use xharbour download ftom www.xharbour.org news group news://news.xharbour.org/xharbour Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 21/11/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: programming language
Hi php http://www.php.net would be a good start. Peter -Original Message- From: S Kusumo [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 12:09 To: [EMAIL PROTECTED] Subject: programming language Hello .. I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for MySql, that supports constructs such as LOOP, If-then-Else etc. Appreciate someone who could respond.. S Kusumo [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do test unique values in a MySql column?
On Monday 24 November 2003 03:25 pm, zzapper wrote: Hi Y'All I need to test if any values in a column are the same (or are unique) eg (my made up syntax Unique) SELECT * from tbl_addresses WHERE txtName is UNIQUE; SELECT DISTINCT txtName from tbl_addresses; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do test unique values in a MySql column?
On Nov 24, 2003, at 6:25 PM, zzapper wrote: I need to test if any values in a column are the same (or are unique) eg (my made up syntax Unique) SELECT * from tbl_addresses WHERE txtName is UNIQUE; How should this be done??? To get a list of all 'txtName' values that appear only once in the table: SELECT txtName FROM MyTable GROUP BY txtName HAVING count(*) = 1 ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
create own auto increment number
I have a request to create an auto increment field that increments like so: 1-112403 2-112403 3-112403 4-112503 etc... Is that possible??? Any variant of that is fine the big issue is they want the Date with the ID number of the record. Thanks, Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web data entry problem
Here is my connection script (conn_inc.php): ?php # conn_inc.php $connection=mysql_pconnect(localhost,mysuperusername,mypassword); if (!$connection) { echo Could not connect to MySQL server!; exit; } $db=mysql_select_db(test_gotcha,$connection); if (!$db) { echo Could not change into the database test_gotcha; exit; } ? Here is a web form (g_add_gotcha.php -- I have inserted a space around each s, hoping it will not render as html in your email program): HTML BODY ?php # g_add_system.php include (conn_inc.php); include (g_common_func.php); header1(); title(Add a new technical system area); $sql=SELECT system_type FROM system; $mysql_result=mysql_query($sql,$connection); [EMAIL PROTECTED]($mysql_result); echo FORM METHOD=GET ACTION=\g_write_system.php\ ; echo BWhat is the new system /B BR INPUT TYPE=\TEXT\ NAME=\system\ BR ; if ( $num_rows == 0 ) { echo There are currently no entries in the system tableBR; } else { # we have some records echo B Here are the existing entries in the system table /B BR ; echo SELECT NAME=\current_system\ ; while ($row=mysql_fetch_array($mysql_result)) { $system_type=$row[system_type]; # display results echo OPTION $system_type; } echo /SELECT ; } # end else echo BR BR ; echo INPUT TYPE=\SUBMIT\ VALUE=\Add the new System\ ; echo BR BR INPUT TYPE=\RESET\ VALUE=\Clear me!\ ; mysql_close($connection); ? /FORM ?php main_menu_scr(); footer(); ? /BODY /HTML Thanks for any help, Ted From: Colleen Dick [EMAIL PROTECTED] Date: November 24, 2003 10:24:05 AM EST To: [EMAIL PROTECTED] Cc: MySQL List [EMAIL PROTECTED] Subject: Re: web data entry problem Reply-To: [EMAIL PROTECTED] There could be a number of things going on. It would help troubleshoot your problem if your script check for errors and print them if there are any. You cant just assume a connection is being made just because phpmyadmin connects. Your web app has to make its own connection. So how about showing us one of your scripts. I bet it is something simple youre overlooking in your setup. [EMAIL PROTECTED] wrote: I hope someone might be willing to help out. I'm trying [still] to learn MySQL and php - to create some simply web based database. I have installed quite a few php/MySQL web database apps from books, however, none of them will get data entered into my database. When I create the database exactly as instructed, everything works great, but when I create the form to send/add a new record to my db then look at the db the new data is not there. This happens repeatedly with every example I build. I can add records using a terminal or phpMyAdmin. I'm running MySQL 4.0.14, Mac OS X 10.3, PHP 4.3.2. I installed 'tasks' - http://www.versiontracker.com/dyn/moreinfo/macosx/17996 and it works just fine! but it is too big for me to use to compare to my very simple scripts. Here is one I have recently installed whose data will not enter: http://hotwired.lycos.com/webmonkey/99/21/index3a_page4.html? tw=programming I believe my db connection is being made (I may be wrong), after all my phpMyAdmin app also works fine. I would be very grateful is there might be a kind soul who would work with me to help me to find out what is wrong? I have had dbs before that worked fine, I don't understand this problem at all. Thanks, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: create own auto increment number
Are you talking about a multiple key PRIMARY KEY? CREATE TABLE Blah ( MyDate datetime, MyID INT NOT NULL AUTO_INCREMENT, ... PRIMARY KEY (MyDate,MyID) ) for each unique MyDate the Auto Increment sequence will start over. If that's not what you're asking for, could you clairfy some more? Chris -Original Message- From: rmck [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: create own auto increment number I have a request to create an auto increment field that increments like so: 1-112403 2-112403 3-112403 4-112503 etc... Is that possible??? Any variant of that is fine the big issue is they want the Date with the ID number of the record. Thanks, Rob -- 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: web data entry problem
Adding this file (g_common_func.php). This is 'included' by the web form file's code along with the connection script), I thought I should include all referenced files and forgot this one: ?php # g_common_func.php # common functions to gotcha application # display header information function header1(){ echo CENTERB $today Delivery etc Gotcha Database/B/CENTER; echo HR SIZE=1; } # display what screen we are in function title($text) { echo CENTERB$text/B/CENTER; echo HR SIZE=1 WIDTH=40%; } # display footer information function footer(){ $today=(date(j F Y)); echo HR SIZE=1 WIDTH=50%; echo CENTERICopyright Delivery etc /I [ $today ]/CENTER; echo HR SIZE=1 WIDTH=50%; } # display HREF link to main menu function main_menu_scr(){ echo BRA HREF=\gotcha_menu.php\ Main Menu/A; } # display HREF link to view records function view_all_scr(){ echo BRA HREF=\g_view_all.php\ Search Records/A; } # display HREF link to add a gotcha function add_gotcha_scr(){ echo BRA HREF=\g_add_gotcha.php\ Back to Add a Gotcha/A; } # display HREF link to add a subject function add_subject_scr(){ echo BRA HREF=\g_add_subject.php\ Add a Technical Subject/A; } # display HREF link to add a system function add_system_scr(){ echo BRA HREF=\g_add_system.php\ Add a System Type/A; } ? Ted On Nov 24, 2003, at 7:25 PM, [EMAIL PROTECTED] wrote: Here is my connection script (conn_inc.php): ?php # conn_inc.php $connection=mysql_pconnect(localhost,mysuperusername,mypassword); if (!$connection) { echo Could not connect to MySQL server!; exit; } $db=mysql_select_db(test_gotcha,$connection); if (!$db) { echo Could not change into the database test_gotcha; exit; } ? Here is a web form (g_add_gotcha.php -- I have inserted a space around each s, hoping it will not render as html in your email program): HTML BODY ?php # g_add_system.php include (conn_inc.php); include (g_common_func.php); header1(); title(Add a new technical system area); $sql=SELECT system_type FROM system; $mysql_result=mysql_query($sql,$connection); [EMAIL PROTECTED]($mysql_result); echo FORM METHOD=GET ACTION=\g_write_system.php\ ; echo BWhat is the new system /B BR INPUT TYPE=\TEXT\ NAME=\system\ BR ; if ( $num_rows == 0 ) { echo There are currently no entries in the system tableBR; } else { # we have some records echo B Here are the existing entries in the system table /B BR ; echo SELECT NAME=\current_system\ ; while ($row=mysql_fetch_array($mysql_result)) { $system_type=$row[system_type]; # display results echo OPTION $system_type; } echo /SELECT ; } # end else echo BR BR ; echo INPUT TYPE=\SUBMIT\ VALUE=\Add the new System\ ; echo BR BR INPUT TYPE=\RESET\ VALUE=\Clear me!\ ; mysql_close($connection); ? /FORM ?php main_menu_scr(); footer(); ? /BODY /HTML Thanks for any help, Ted From: Colleen Dick [EMAIL PROTECTED] Date: November 24, 2003 10:24:05 AM EST To: [EMAIL PROTECTED] Cc: MySQL List [EMAIL PROTECTED] Subject: Re: web data entry problem Reply-To: [EMAIL PROTECTED] There could be a number of things going on. It would help troubleshoot your problem if your script check for errors and print them if there are any. You cant just assume a connection is being made just because phpmyadmin connects. Your web app has to make its own connection. So how about showing us one of your scripts. I bet it is something simple youre overlooking in your setup. [EMAIL PROTECTED] wrote: I hope someone might be willing to help out. I'm trying [still] to learn MySQL and php - to create some simply web based database. I have installed quite a few php/MySQL web database apps from books, however, none of them will get data entered into my database. When I create the database exactly as instructed, everything works great, but when I create the form to send/add a new record to my db then look at the db the new data is not there. This happens repeatedly with every example I build. I can add records using a terminal or phpMyAdmin. I'm running MySQL 4.0.14, Mac OS X 10.3, PHP 4.3.2. I installed 'tasks' - http://www.versiontracker.com/dyn/moreinfo/macosx/17996 and it works just fine! but it is too big for me to use to compare to my very simple scripts. Here is one I have recently installed whose data will not enter: http://hotwired.lycos.com/webmonkey/99/21/index3a_page4.html? tw=programming I believe my db connection is being made (I may be wrong), after all my phpMyAdmin app also works fine. I would be very grateful is there might be a kind soul who would work with me to help me to find out what is wrong? I have had dbs before that worked fine, I don't understand this problem at all. Thanks, Ted -- 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]
Compare dates
I have a table with start_date (date), end_date (date), rate(float) as 3 fields, I want to compare today's date with start and end date if it is inside this range then pick up the corresponding rate. But how mysql stores dates ? (-MM-DD ?) how can i compare with today's date ? I tried some different combinations but in not successful. regards, manisha
How To Learn php and mysql.
What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: How To Learn php and mysql.
The best way to learn is by taking a script (I used a message board written in php/mysql) and hacking it, then running it on your webserver, breaking it, and fixing it again. Just make tiny changes at first, play with logic, then work on bigger things. As for a book, I recommend the one on PHP and mySQL web development by Luke Willing and Laura Thompson. Good luck! Richard -Original Message- From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:48 PM To: [EMAIL PROTECTED] Subject: How To Learn php and mysql. What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- 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]
Which Linux....
I'm building up a new MySQL server. The box specs are: 2U, Dual 3Ghz Xeon processors, 6 Gigs ram, 500 gigs of Raid 5 storage. I'll have the hardware in my hands tomorrow. I've used RedHat on all my previous linux servers. I'm planning on going with Red Hat Enterprise Linux ES. But, I've heard that the new threading code in the latest linux kernal (2.6) really improves MySQL performance. The RedHat site says that Enterprise is based on the 2.4 Kernal, with numerous additions from the Linux 2.5/2.6 kernal. And I just spotted another place where it mentions Native Posix Thread Library: A new high-performance multi-threading capability provides improved performance for multi-threaded applications. So, am I assuming correctly that RedHat Enterprise does offer the new threading code? Anyone know any problems using the new RedHat Enterprise for MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.16 on SCO OpenServer 5.0.6
Hello Stefaan, Stefaan Van Dooren [EMAIL PROTECTED] wrote: I'm totally lost now.. As you can (could) see in my previous post, I managed to get MySQL working on SCO with --with-debug as a configure option. Whenever I remove --with-debug, I can compile and install it, but I can't connect to it. Can someone please explain what this --with-debug adds that makes it run on my system ? I have not tried the --with-debug option, so cannot advise on that. However ... I usually find that MySQL configuration problems can be explained by looking at the main mysql error file. This is called *.err and is normally in the data directory. Certainly, if the server will not start, you should find the reason there. You might also find clues to your connection problem. Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.16 on SCO OpenServer 5.0.6
Hello Stefaan, Stefaan Van Dooren wrote: Hi, I'm trying to install (compile, since there are no binaries for this system) MySQL on an SCO OPenServer 5.0.6 system. Prior to compiling MySQL, I installed the following packages for SCO : FSU Pthreads (ver 3.9) GNU Development Tools (ver 5.0.7Kj) Netscape Communicator (ver 4.7.0e) OSS631B - Supplemental Graphics, Web and X11 Libraries (ver 1.2.1) SCO OpenServer Enterprise System (ver 5.0.6j) SCO OpenServer Linker and Application Development Libraries (ver 5.1.2A) SCO SendMail (ver 8.11.0) OSS635A: Graphical Environment Supplement for OpenServer 5.0.6 (ver 1.0.0) OSS646B - Execution Environment Supplement (ver 1.1.0j) RS506A: Release Supplement for SCO OpenServer Release 5.0.6 (ver rs506a) RS506A: Software Manager Supplement (ver rs506a) USB Supplement (ver 1.0a) I asked our Unix technicians to comment about those. They said: Looks like he has all the patches loaded. Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Thanks, Richard. What is the name of the book by Luke Willing and Laura Thompson? Braulio Richard Bewley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The best way to learn is by taking a script (I used a message board written in php/mysql) and hacking it, then running it on your webserver, breaking it, and fixing it again. Just make tiny changes at first, play with logic, then work on bigger things. As for a book, I recommend the one on PHP and mySQL web development by Luke Willing and Laura Thompson. Good luck! Richard -Original Message- From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:48 PM To: [EMAIL PROTECTED] Subject: How To Learn php and mysql. What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- 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: How To Learn php and mysql.
G'day Braulio What is the best way to learn php and mysql? What book is recommended for self study of both ? As an absolute newbie I used Build Your Own Database Driven Website Using PHP MySQL from http://www.sitepoint.com/books/phpmysql1/ It got us up and running pretty painlessly. You can download the first 4 chapters for free and see if it's the sort of thing you're after. cheers Kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Thanks,Kim. G'day to you too. Braulio Kim Kohen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] G'day Braulio What is the best way to learn php and mysql? What book is recommended for self study of both ? As an absolute newbie I used Build Your Own Database Driven Website Using PHP MySQL from http://www.sitepoint.com/books/phpmysql1/ It got us up and running pretty painlessly. You can download the first 4 chapters for free and see if it's the sort of thing you're after. cheers Kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: running sql-bench scripts redhat 8.0
Hi all, I'am getting this error when I try to run any of the sql-bench tests. For instance, here is an attempt to run the test-connect script. This happens to me when I try any of the scripts. I attempted to change the location my perl install at the beginning of the script(RH 8.0) can anyone help me with this? Anyone else with Redhat run into this problem? Thanks ./test-connect Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at ./test-connect line 28. BEGIN failed--compilation aborted at ./test-connect line 28. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FW: running sql-bench scripts redhat 8.0
looks like you'll need to install the perl-DBD-mysql rpm to satisfy the requirement. HTH. Michael Weiner -- On Mon, 2003-11-24 at 23:11, jason steig wrote: Hi all, I'am getting this error when I try to run any of the sql-bench tests. For instance, here is an attempt to run the test-connect script. This happens to me when I try any of the scripts. I attempted to change the location my perl install at the beginning of the script(RH 8.0) can anyone help me with this? Anyone else with Redhat run into this problem? Thanks ./test-connect Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at ./test-connect line 28. BEGIN failed--compilation aborted at ./test-connect line 28. signature.asc Description: This is a digitally signed message part
Re: FW: running sql-bench scripts redhat 8.0
At 23:11 -0500 11/24/03, jason steig wrote: Hi all, I'am getting this error when I try to run any of the sql-bench tests. For instance, here is an attempt to run the test-connect script. This happens to me when I try any of the scripts. I attempted to change the location my perl install at the beginning of the script(RH 8.0) can anyone help me with this? Anyone else with Redhat run into this problem? Thanks ./test-connect Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at ./test-connect line 28. BEGIN failed--compilation aborted at ./test-connect line 28. Do you have the DBI module installed? If not, you might try this: su to root, then run these commands: shell perl -MCPAN -e shell cpan install DBI cpan force install DBD::mysql -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: FW: running sql-bench scripts redhat 8.0
Thank you much! -Original Message- From: Michael Weiner [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 11:18 PM Cc: [EMAIL PROTECTED] Subject: Re: FW: running sql-bench scripts redhat 8.0 looks like you'll need to install the perl-DBD-mysql rpm to satisfy the requirement. HTH. Michael Weiner -- On Mon, 2003-11-24 at 23:11, jason steig wrote: Hi all, I'am getting this error when I try to run any of the sql-bench tests. For instance, here is an attempt to run the test-connect script. This happens to me when I try any of the scripts. I attempted to change the location my perl install at the beginning of the script(RH 8.0) can anyone help me with this? Anyone else with Redhat run into this problem? Thanks ./test-connect Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at ./test-connect line 28. BEGIN failed--compilation aborted at ./test-connect line 28. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with merging tables
I am getting the following error when I try to access a merged table: This: Select * from subjects_2; or insert into subjects_2 (subj_id) values('10'); Returns: ERROR 1017: Can't find file: 'subjects_2.MRG' (errno: 2) Any Ideas what this means and how I can correct it. I can access the two tables merged by this table, just not the merged table itself. Merging tables are new to me so take it easy on my novice self... Thanks! /Tim
InnoDB caused crash and left me a log entry...
InnoDB seems to have crashed on us, and put the errors below into the log files... It took several crashes and some time but I was able to isolate the extremely simple query involved. Server is OSX 10.3 running on a Dual 200MHZ G5 with 4Gigs ram. MySQL is 4.0.16. The original queries to crash were a little longer in that they also updated the field description with a large block of text as well as the field name. The following Queries repeatedly caused a crash when executed from the mysql command line directly to mysqld with no other client connections open: update jiveForum set name='Technical Questions: SDK' where forumID=4; update jiveForum set name=Technical Questions: SDK where forumID=4; update jiveForum set name='Technical Questions - SDK' where forumID=4; update jiveForum set name='Technical Questions' where forumID=4; These queries did not cause the crash: update jiveForum set name='Technical' where forumID=4; update jiveForum set name='SDK Questions' where forumID=4; I eventually moved the table out of InnoDB, made the changes, and moved it back to InnoDB again without experiencing further problems. In order to restore client services I did not try again to reproduce the problem, instant Database server crash is not an attractive experience, especially in our production environment. The table in question has 12 rows and looks like this: CREATE TABLE `jiveForum` ( `forumID` bigint(20) NOT NULL default '0', `name` varchar(255) binary NOT NULL default '', `description` text, `modDefaultThreadVal` bigint(20) NOT NULL default '0', `modMinThreadVal` bigint(20) NOT NULL default '0', `modDefaultMsgVal` bigint(20) NOT NULL default '0', `modMinMsgVal` bigint(20) NOT NULL default '0', `creationDate` varchar(15) NOT NULL default '', `modifiedDate` varchar(15) NOT NULL default '', `categoryID` bigint(20) NOT NULL default '1', `categoryIndex` int(11) NOT NULL default '0', PRIMARY KEY (`forumID`), UNIQUE KEY `name` (`name`), KEY `jiveForum_name_idx` (`name`(10)), KEY `jiveForum_cat_idx` (`categoryID`), KEY `jiveForum_catIndex_idx` (`categoryIndex`) ) TYPE=InnoDB Below are the logs of the first two crashes and some additional comments from yours truly. Best Regards, Bruce 031124 16:27:18 InnoDB: Assertion failure in thread 2167428608 in file row0upd.c line 713 InnoDB: Failing assertion: len == dfield_get_len(dfield) InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] InnoDB: Thread 2168107008 stopped in file ha_innodb.cc line 396 InnoDB: Thread 8529408 stopped in file sync0arr.c line 126 InnoDB: Thread 8954880 stopped in file ha_innodb.cc line 396 InnoDB: Thread 12103168 stopped in file ha_innodb.cc line 396 InnoDB: Thread 8530432 stopped in file ../../innobase/include/sync0sync.ic line 109 InnoDB: Thread 11085312 stopped in file ha_innodb.cc line 396 InnoDB: Thread 12269056 stopped in file ha_innodb.cc line 396 InnoDB: Thread 9271296 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166052864 stopped in file ha_innodb.cc line 396 InnoDB: Thread 15272448 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166610432 stopped in file ha_innodb.cc line 396 InnoDB: Thread 14812160 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166472704 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166551552 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2167671808 stopped in file ha_innodb.cc line 396 InnoDB: Thread 15742976 stopped in file ha_innodb.cc line 396 InnoDB: Thread 15535616 stopped in file ha_innodb.cc line 396 InnoDB: Thread 16771584 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166734336 stopped in file ha_innodb.cc line 396 InnoDB: Thread 15129088 stopped in file ha_innodb.cc line 396 InnoDB: Thread 13153792 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166089216 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166471680 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2167336448 stopped in file ha_innodb.cc line 396 InnoDB: Thread 10588160 stopped in file ha_innodb.cc line 396 InnoDB: Thread 9951744 stopped in file ha_innodb.cc line 396 InnoDB: Thread 9901056 stopped in file ha_innodb.cc line 396 InnoDB: Thread 14827520 stopped in file ha_innodb.cc line 396 InnoDB: Thread 12161536 stopped in file ha_innodb.cc line 396 InnoDB: Thread 9560576 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2164816384 stopped in file ha_innodb.cc line 396 InnoDB: Thread 13114368 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2164369408 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166552576 stopped in file ha_innodb.cc line 396 InnoDB: Thread 2166132224 stopped in file ha_innodb.cc line 396 InnoDB: Thread 9431552 stopped in file ha_innodb.cc line 396 InnoDB: Thread 9461760 stopped in file ha_innodb.cc line 396 InnoDB: Thread 14631424 stopped in file ha_innodb.cc line 396 InnoDB: Thread 9867264 stopped in file ha_innodb.cc line 396 InnoDB: Thread 13056512 stopped in file
strings of variables, php, mysql
Would appreciate in anyone can help me. Let's say I do a query in php, eg. $query = select shed from structure; With the mysql_fetch_array function and a loop I could see all the values stored in the column, shed, using the command: echo $shed; Let's say now that I am carrying over a variable from a form called $form where $form = shed. I can still say $query = select $form from structure; because $form = shed. The problem I have now is with the strings and how do I see my column values. Using echo $$value; or echo $($value) or echo \$$value or echo $$value does not give me the values stored in the column shed. Help anyone? thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: FW: running sql-bench scripts redhat 8.0
Well looks like it has quite a few dependencies. I'll have to install these other dependencies -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 12:10 AM To: jason steig Subject: RE: FW: running sql-bench scripts redhat 8.0 Thank you much! Got it working using the RPM? -Original Message- From: Michael Weiner [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 11:18 PM Cc: [EMAIL PROTECTED] Subject: Re: FW: running sql-bench scripts redhat 8.0 looks like you'll need to install the perl-DBD-mysql rpm to satisfy the requirement. HTH. Michael Weiner -- On Mon, 2003-11-24 at 23:11, jason steig wrote: Hi all, I'am getting this error when I try to run any of the sql-bench tests. For instance, here is an attempt to run the test-connect script. This happens to me when I try any of the scripts. I attempted to change the location my perl install at the beginning of the script(RH 8.0) can anyone help me with this? Anyone else with Redhat run into this problem? Thanks ./test-connect Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at ./test-connect line 28. BEGIN failed--compilation aborted at ./test-connect line 28. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlimport
Dear everyone, (B (BI'd like to ask you a question, thanks in advance. (B (BQ: How long will it take to import 100GB data into MySQL DB by command "mysqlimport" ? (B (BBest regards, (BMay Yang (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SHOW TABLE STATUS without LIKE
Hi! Please reply to the list, not to me personally, so that others can follow this discussion. Thanks. Sorry, At 13:21 +0200 11/21/03, Jozsa Boti wrote: Hi! How an i get the last Check-time of a specific table without using LIKE statements? There isn't another way. There's the SHOW TABLE STATUS command, but if there are many tables in a database this command is very slow, even if a specific table name is after the LIKE statment. Slow? How many tables are we talking about? I'm talking about nearly 20 000 tables in a database. In this case a SHOW TABLE STATUS commande takes about 20-30 seconds. Hm, that is pretty slow. How long does an ls command in the database directory take? About 1-2 seconds. Boti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: programming language
S Kusumo wrote: Hello .. I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for MySql, that supports constructs such as LOOP, If-then-Else etc. Appreciate someone who could respond.. S Kusumo [EMAIL PROTECTED] I'm not familiar with CLIPPER. Is it a scripting language, or compiled? Anyway, for we applications, I'd recommend PHP. For machine apps, my choice would be Perl, with a quick and upcoming nod to PHP. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How To Learn php and mysql.
Braulio Lumbreras wrote: What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio The PHP website is an excelent place. The online manual is real nice, and there are plenty of user comments which I have found useful. The PHP mailing list is a good place to go when your stuck, as well as this mailing list when you need to solve a MySQL problem (after you've googled and searched the archives that is ;). I'm not much for actual print books, but I found, Web Database Applications with PHP MySQL from O'Reilly to be a pretty interesting read. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How To Learn php and mysql.
PHP and MySQL Web Development, by Luke Welling and Laura Thomson It's an excellent book. -Original Message- From: Richard Bewley [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 6:53 PM To: [EMAIL PROTECTED] Subject: FW: How To Learn php and mysql. The best way to learn is by taking a script (I used a message board written in php/mysql) and hacking it, then running it on your webserver, breaking it, and fixing it again. Just make tiny changes at first, play with logic, then work on bigger things. As for a book, I recommend the one on PHP and mySQL web development by Luke Willing and Laura Thompson. Good luck! Richard -Original Message- From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:48 PM To: [EMAIL PROTECTED] Subject: How To Learn php and mysql. What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- 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]
RE: Compare dates
Hi Manisha I have used the same thing in a pretty different way. Basicallyi have stored the date in string format say 'MMDD' and then done simple comparison say 2003112520031029 by converting it into Long format in my local code (note::this will specially work in case of MMDD format as future date will always be greater than past date in Long Format) Though this may not solve your problem completely but i hope this gives you some pointers. regards Kams -Original Message- From: Manisha Sathe [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 6:50 PM To: [EMAIL PROTECTED] Subject: Compare dates I have a table with start_date (date), end_date (date), rate(float) as 3 fields, I want to compare today's date with start and end date if it is inside this range then pick up the corresponding rate. But how mysql stores dates ? (-MM-DD ?) how can i compare with today's date ? I tried some different combinations but in not successful. regards, manisha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]