raid tables
Is there a way to tell MySQL to automatically spread its tables over a number of disks without going through the trouble of symbolic linking the chunks to the different disks? Thanks, Jamie Krasnoo [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: FW: FW: HELP! functions don't work...
Dawn H wrote: -Original Message- From: Les Roberts [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 9:06 PM Cc: Dawn H Subject: Fwd: FW: FW: HELP! functions don't work... first I apologize for the bad function name... I had changed it to several and left it at dayname() which, as you noted, is not valid. But monthname(), which is valid, fails exactly the same way. note the page http://65.108.143.207 says: Fatal error: Call to undefined function: monthname() in /home/ccrb/ccrb-www/index.html on line 7 and the code printf(test for jon... monthname is %s,monthname(2001-06-17)); Again, I apologize. Nothing is worse than asking for help and not getting the supporting evidence right. -Original Message- From: Don Read [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 2:38 PM To: Dawn H Subject: RE: FW: HELP! functions don't work... On 17-Jun-01 Dawn H wrote: -Original Message- From: Les Roberts [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 9:29 AM To: [EMAIL PROTECTED] Subject: HELP! functions don't work... please pass along to anyone who might help... If you look at http://65.108.143.207/ you'll see I get the following error: Fatal error: Call to undefined function: dayname() in /home/ccrb/ccrb-www/index.html on line 8 This indicates that I'm missing most all of the functions. Is there a standard include that I need, or is my php installation not complete? Here is the line of code in question: ?php printf(test for jon... dayname is %s,dayname(2001-06-17)); localhost.dread$ pwd /usr/local/share/doc/apache/phpmanual localhost.dread$ grep dayname * localhost.dread$ There isn't a PHP function 'dayname', date(), strftime(). mktime() are what you are looking for. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. Filter fixer: database,sql,query Hi, It seems that you are confusing SQL and PHP functions. Within mysql, monthdate works: mysql select monthname(2001-06-17); +-+ | monthname(2001-06-17) | +-+ | June| +-+ 1 row in set (0.00 sec) I don't know you to do that in PHP, I don't have any PHP experience. BTW, If your question is How to print monthname in PHP, may be you should ask on a PHP mailing list. Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql++
Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own appliacations core dumps if they can not connect to mysql, in other words the try block does not work! I have tried gcc 2.95 (recommended in the manual) and 2.95.3! Does any has experience with this, or am I allone in the dark as always in my sysadmin job? :-) Stepan Stepan Havel Nextra Telekom GmbH Kirchberggasse 33 1070 Wien Tel: +43-1-52533-837 Fax: +43-1-52533-100 Mobile: +43-699-15253-837 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HELP! functions don't work...
Fatal error: Call to undefined function: dayname() in /home/ccrb/ccrb-www/index.html on line 8 This indicates that I'm missing most all of the functions. Is there a standard include that I need, or is my php installation not complete? Here is the line of code in question: ?php printf(test for jon... dayname is %s,dayname(2001-06-17)); They're mysql functions, not php functions... ? $dblink = mysql_pconnect(localhost, user, pass); $res = mysql_query(SELECT dayname('2001-06-17')); list($dayname) = mysql_fetch_row($res); echo($dayname); ? http://www.php.net:8000/manual/en/html/ref.mysql.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: .dump files
thank you. that's sort of what i thought. now for the silly question: i know how to do it with 'monitor' (CLI), but where/how do you import using phpMyAdmin, please? (this i'd love to know :) i looked through the manual but didn't see anything for import db. Click a database on the left frame and it's under the query textarea (there's a browse button and a go button). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Number of Word Matches
Hi there, I'm using select queries like SELECT * FROM table_name WHERE col_name LIKE '%some_word%' to find rows that have col_name match to some_word. But I would also like to find the number of word matches for each row so that I can order these rows according to their relevances and word matches. How can I do that?? http://www.mysql.com/doc/F/u/Fulltext_Search.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
log event entry exceeded max_allowed_packet error: findings (again)
Today on a slave I got (this actually has occured several times in the past months): Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'xxx-bin.040' at position 47694 010511 10:37:19 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (read_errno 0,server_errno=65535) 010511 10:37:19 Slave: Failed reading log event, reconnecting to retry, log 'xxx-bin.040' position 47694 010511 10:37:19 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'xxx-bin.040' at position 47694 010511 10:37:19 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (read_errno 0,server_errno=65535) 010511 10:37:31 Slave thread killed while waiting to reconnect after a failed read Then I looked on the master: $ mysqlbinlog xxx-bin.040 | more # at 47032 #010511 8:26:40 server id 1 Query thread_id=1044 exec_time=0 error_code=0 use Xxx; SET TIMESTAMP=989562400; UPDATE xxx set n=n+1,date='2001-05-11 8:26:40' where id='72'; # at 47160 #010511 8:26:40 server id 1 Query thread_id=1044 exec_time=0 error_code=0 Note that the 47694 position does not exist. So I did the following on the slave (picked the valid position right before 47694): change master to master_log_pos = 47672; then restarted the slave and it now works. Suggestion: maybe the error message in the log could be changed from: * Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (read_errno 0,server_errno=65535) to: * Error: position 47694 does not exist in log 'xxx-bin.040' What do you think? -- Jean-Luc Fontaine SQL MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Aborted connection to db:(got an error reading communication packets)
Sir, We are using mysql-3.23.38 and are using Red Hat Linux 7.0. The linux kernel version is 2.2.16-22.We are using an IBM-PC with 128 Mb RAM,intel PIII processor. We are presently using kannel SMS gateway-1.0.3 and are using Mysql as database. We are using a C API to connect to the database.The C API forms part of the gateway code.Whenever the gateway startup script is placed in a cronfile, the connection to the database gets aborted resulting in the error message Got an error reading communication packets. When the gateway script is NOT PLACED IN THE CRONFILE the above error message does not come and WE CAN USE THE DATABASE NORMALLY. However, the moment the database access script becomes part of the cronfile, the connection to the database is aborted. 1) The mysqld is configured to start up at system startup time. 2) We copied the file my-medium.conf to /etc/my.conf. 3) We have two Ethernet cards on our machine. One of these connects to a local LAN and the other connects to a global IP address. We use the global IP in the mysql_real_connect() function. 4) The mysqladmin variables are attached herewith. Regards, Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie abhay1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Benchmarks
he development team I am currently with is considering using MySql. However, as part of the we require the actual benchmarks that were used as well as the results. Is it possible to have a set of the SQL queries in the form CREATE TABLE t ( n NOT NULL VARCHAR(100)); INSERT INTO t VALUES (1); SELECT * FROM t; rather than in the Perl script format. ___ FSmail - Get your free web-based email from Freeserve: www.fsmail.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL++: Any ideas why this code causes the program to crash?
David Ayliffe writes: I wrote this program in VC++ using the MYSQL++ API for VC. I have a generic function (below) which I call numerous times each time with a different query string. It works fine the first time around. But the second time I call this function it causes the program to crash. I think it could be that a constructor is called but no deconstructor. Could this be the problem? What deconstructor should I use?? I have trimmed the code for functionality: --CODE-- void main() { bool j = ExecQuery(select * from stock); } bool ExecQuery(string sQuery) { Connection con(def_db_name, def_host_name, def_user_name, def_password); Query query = con.query(); // This creates a query object that is bound to con. query sQuery; // You can write to the query object like you would any other ostrem cout endl Query: query.preview() endl; // Show the query before it is executed // Query::preview() simply returns a string with the current query // string in it. Result res = query.store(); // Query::store() executes the query and returns the results Row row; cout.setf(ios::left); //cout setw(17) Database Name endl endl; Result::iterator i; for (i = res.begin(); i != res.end(); i++) { row = *i; cout setw(17) row[0] setw(4) row[1] setw(7) row[2] setw(7) row[3] row[4] endl; } cout endl Records Found: res.size() endl; return 1; } --END OF CODE-- ANY INPUT APPRECIATED Thanks lots David Ayliffe ([EMAIL PROTECTED]) Hi! No, destructor is not a problem. In C++, you do not have to call destructor except implicitely, e.g. with delete operator on dynamic objects. In your program you only use local objects, so C++ itself generates calls to destructors. Your problem is may be that you do send queries to the above method that do not return result sets. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql++
Stepan Havel writes: Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own appliacations core dumps if they can not connect to mysql, in other words the try block does not work! I have tried gcc 2.95 (recommended in the manual) and 2.95.3! Does any has experience with this, or am I allone in the dark as always in my sysadmin job? :-) Stepan Stepan Havel Nextra Telekom GmbH Kirchberggasse 33 1070 Wien Tel: +43-1-52533-837 Fax: +43-1-52533-100 Mobile: +43-699-15253-837 Hi! This problem has been diagnosed fully. The above always happens if current libstdc++ (as resolved by symlinks) is not the one built with and for 2.95.3. The same goes for any other C++ library that is linked in your program. This scenario has been noted and problems cleared out many times so far. Once you solve this, your program will have no problems. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Benchmarks
Roger Norton writes: he development team I am currently with is considering using MySql. However, as part of the we require the actual benchmarks that were used as well as the results. Is it possible to have a set of the SQL queries in the form CREATE TABLE t ( n NOT NULL VARCHAR(100)); INSERT INTO t VALUES (1); SELECT * FROM t; rather than in the Perl script format. Hi! Just make a script, like the above and feed it to mysql client : mysql -u user -ppassword database script Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: raid tables
Isn't this something that RAID O does for you on a larger scale anyway? I would expect that most would have some sort of raid on their mutliple drive system. On Monday 18 June 2001 01:52 am, you wrote: On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: Is there a way to tell MySQL to automatically spread its tables over a number of disks without going through the trouble of symbolic linking the chunks to the different disks? There isn't yet, no. It'd certainly be a nice addition, though, wouldn't it? Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some question about the MySQL...Akira
Dear : Sir There are a message error display ... Can't connect to database : Can't connect t local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How and where that I can trouble shooting it ? Best Rgards
mysqld 3.23.36 -- new connections get stuck in Open Tables
I've been experiencing some strange behaviour in which mysqld will get into an odd state. When doing certain long-running operations (see below) on large tables (5-10 million rows; 20-30 columns per row -- mix of varchar and int) with unique indeces mysqld will occasioanlly get into a confused state where new table accesses will hang forever in the Opening Tables state; and other medium-to-long running writers (and delayed-insert threads) will get stuck in the Closing Tables state. Once mysql has entered this state, the only way to clear the problem is to kill -9 the daemon. (Though data corruption can usually be avoided by first doing a flush tables, then wating a minute, then doing a kill -TERM on the daemon, then waiting another minute, THEN doing the kill -9.) I have not yet been able to isolate the exact conditions which cause this behavoiur. Perhaps other people have experienced something simmilar. I have seen it happen during alter table, optimize table and load data infile into an empty table. In call cases, the table had 5-10 million rows and handful of indeces -- including a primary key or unique index. This is happening with 3.23.36 an 3.23.34 running on Solaris 7 / sparc. I'll post a follow-up if I can isolate a simple test case which demonstrates the problem. - Jamie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: raid tables
Hi Samuel I would do this in sql. I thinks this would be much more convenient to administrate. It would be great if you would see these informations also in with the command eg: show database storage and you can see as return, where the files are located. Thanks Philip On Mon, 18 Jun 2001 12:13:50 +0200 (CEST) Tonu Samuel [EMAIL PROTECTED] wrote: On Mon, 18 Jun 2001, Jamie Krasnoo wrote: Yes. It definitely would. I didn't know Yahoo uses MySQL. What would be great for an interim is if a script could determine the space available and suggest the settings to create the table. I see that by setting RAID_CHUNKS you could tell how many directories MySQL should make. The script could evenly distribute those directories and make the links and directories for MySQL. Sent: Sunday, June 17, 2001 11:53 PM To: Jamie Krasnoo Cc: MySQL Subject: Re: raid tables On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: Is there a way to tell MySQL to automatically spread its tables over a number of disks without going through the trouble of symbolic linking the chunks to the different disks? There isn't yet, no. It'd certainly be a nice addition, though, wouldn't it? As author of this RAID code I would like to know, how did you see this in your mind: - As MySQL command DISTRIBUTE TABLES ? - As some kind of external script? - Other way? I would like to implement this feature but currently I do not see an smooth way to do it. Maybe something like LINK RAID DIR 1 to /mnt/bigdisk ? -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Besten Dank Philip Markwalder == Markwalder Philip Consultant [EMAIL PROTECTED] Trivadis AG Kanalstrasse 5 CH-8152 Glattbrugg Tel.: +41- 1-808 70 20 Fax : +41- 1-808 70 21 Mobile: +41-79-445 77 87 http://www.trivadis.com == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump bug during regenerate enum field.
mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | e_test | enum('0','1') | | | | | ++---+--+-+-+---+ and use mysqldump to regenerate the sql statement, you obtain: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '' ); this new declaration is not correct and refused by MySQL. MySQL accept the value '' for insert but not for create table. I'm not sure if it's normal to authorize empty values in enum. If this is normal, the bug is in mysqldump. Originator:Guillaume Fougnies Organization: Profile For You Ltd. MySQL support: licence Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.39 (Source distribution) System: Linux db-am-001 2.2.19 #3 SMP lun jun 18 10:53:11 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentiumpro -s' CXX='c++' CXXFLAGS='-O6 -mpentiumpro -s' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 12 11:15 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101005 Sep 3 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20268874 Sep 3 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 3 2000 /usr/lib/libc.so Configure command: ./configure --with-libwrap --enable-thread-safe-client --enable-assembler --disable-large-files --without-debug --with-mysqld-user=db --without-raid --disable-large-files --prefix=/usr/local/mysql-3.23.39 --localstatedir=/usr/local/mysql_var - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump bug during regenerate enum field.
[EMAIL PROTECTED] writes: mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | e_test | enum('0','1') | | | | | ++---+--+-+-+---+ and use mysqldump to regenerate the sql statement, you obtain: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '' ); this new declaration is not correct and refused by MySQL. MySQL accept the value '' for insert but not for create table. I'm not sure if it's normal to authorize empty values in enum. If this is normal, the bug is in mysqldump. Hi! The above is expected behaviour. ENUM and SET types can take values only in the form of literals. If you supply non-literal, like integer 0, MySQL tries it's best to find the most approximate value. Internally, MySQL does store both types as integers, but can insert / update / display only it's representations of literals or set of literals. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump bug during regenerate enum field.
Hi, mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | e_test | enum('0','1') | | | | | ++---+--+-+-+---+ and use mysqldump to regenerate the sql statement, you obtain: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '' ); If you use default 0, 0 is an integer. But ENUM only accept strings, so try to use default '0' when you create the table. Have a nice day, Thomas Karcher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump bug during regenerate enum field.
Try quoting (' ') the 0 in your create: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '0' ); -^ You should then get the result you want. Have a great day... John On Monday 18 June 2001 08:54, [EMAIL PROTECTED] wrote: mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | e_test | enum('0','1') | | | | | ++---+--+-+-+---+ and use mysqldump to regenerate the sql statement, you obtain: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '' ); this new declaration is not correct and refused by MySQL. MySQL accept the value '' for insert but not for create table. I'm not sure if it's normal to authorize empty values in enum. If this is normal, the bug is in mysqldump. Originator: Guillaume Fougnies Organization: Profile For You Ltd. MySQL support: licence Severity:non-critical Priority:low Category:mysql Class: sw-bug Release: mysql-3.23.39 (Source distribution) System: Linux db-am-001 2.2.19 #3 SMP lun jun 18 10:53:11 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentiumpro -s' CXX='c++' CXXFLAGS='-O6 -mpentiumpro -s' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 12 11:15 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101005 Sep 3 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20268874 Sep 3 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 3 2000 /usr/lib/libc.so Configure command: ./configure --with-libwrap --enable-thread-safe-client --enable-assembler --disable-large-files --without-debug --with-mysqld-user=db --without-raid --disable-large-files --prefix=/usr/local/mysql-3.23.39 --localstatedir=/usr/local/mysql_var - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Have a great day... John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to setup passwords for mysql
how to setup passwords for mysql On Mon, 18 June 2001, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump bug during regenerate enum field.
Le Mon, Jun 18, 2001 at 04:04:52PM +0300, Sinisa Milivojevic a écrit: [EMAIL PROTECTED] writes: mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | e_test | enum('0','1') | | | | | ++---+--+-+-+---+ and use mysqldump to regenerate the sql statement, you obtain: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '' ); this new declaration is not correct and refused by MySQL. MySQL accept the value '' for insert but not for create table. I'm not sure if it's normal to authorize empty values in enum. If this is normal, the bug is in mysqldump. Hi! The above is expected behaviour. ENUM and SET types can take values only in the form of literals. If you supply non-literal, like integer 0, MySQL tries it's best to find the most approximate value. Internally, MySQL does store both types as integers, but can insert / update / display only it's representations of literals or set of literals. ok so it's a failure from mysqldump. I know this declaration is not really correct but mysqldump must regenerate a correct sql statement (good when pipe in mysql client i mean at least ;) ). It's not the case. Regards, -- Guillaume FOUGNIES Research Development Profile For You Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump bug during regenerate enum field.
but mysqldump generates an invalid statement. mysql CREATE TABLE TESTBADDUMP ( - e_test enum('0','1') NOT NULL default '' - ); ERROR 1067: Invalid default value for 'e_test' mysql I think that's what the orignator is trying to show. That mysqldump is generating an invalid statement. thanks, -- Andrew - Original Message - From: Thomas Karcher [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 18, 2001 9:08 AM Subject: Re: mysqldump bug during regenerate enum field. Hi, mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | e_test | enum('0','1') | | | | | ++---+--+-+-+---+ and use mysqldump to regenerate the sql statement, you obtain: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '' ); If you use default 0, 0 is an integer. But ENUM only accept strings, so try to use default '0' when you create the table. Have a nice day, Thomas Karcher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database size limit
Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my.cnf and tuning
Hi, Could someone please e-mail me a copy of the example cnf files, as they did not come with my distribution. Thanks. For a Sun E450 with a single 300Mhz processor and 256Mb of RAM which .cnf file would you suggest I used? The machine is being used for a MRP server as well as a ODBC mysql server, although most of the time the processor is running at 5%. However, large data uploads into mysql are very slow, and at which time the processor id running 95%. The config of mysql is out of the box. Thanks for any help in advance. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some question about the MySQL...Akira
Start with the troubleshooting section of the manual. Is the server running? Where did it put the socket file? What program gave you that error? What system are you running? What version of MySQL is this? Where did you get it? How did you install it? So many questions. So few answers. CSHAkira wrote: Dear : Sir There are a message error display ... Can't connect to database : Can't connect t local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How and where that I can trouble shooting it ? Best Rgards -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump bug during regenerate enum field.
Guillaume Fougnies writes: ok so it's a failure from mysqldump. I know this declaration is not really correct but mysqldump must regenerate a correct sql statement (good when pipe in mysql client i mean at least ;) ). It's not the case. Regards, -- Guillaume FOUGNIES Research Development Profile For You Ltd. No, it is not mysqldump failure. If you specify integers where literals are expected, then it is your fault. Use quotes and a problem will dissapear. Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump bug during regenerate enum field.
Sinisa, A good way to prove that mysqldump is doing what it should, might be to do a describe TESTBADDUMP; I think this will prove that mysqldump is just dumping what is in the table def, which is all you can expect. Have a great day... John On Monday 18 June 2001 09:46, Sinisa Milivojevic wrote: Guillaume Fougnies writes: ok so it's a failure from mysqldump. I know this declaration is not really correct but mysqldump must regenerate a correct sql statement (good when pipe in mysql client i mean at least ;) ). It's not the case. Regards, -- Guillaume FOUGNIES Research Development Profile For You Ltd. No, it is not mysqldump failure. If you specify integers where literals are expected, then it is your fault. Use quotes and a problem will dissapear. Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Have a great day... John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my sql and patter matching ....bug(Urgent)
Hi, I am facing the following problem in pattern matching: I want to check the pattern matching using LIKE on a field that is declared as Binary and also contains back slashes. eg: ID INT, NAME VARCHAR(128) BINARY I am using C-API of mysql to escape the characters like '\' for this field. The samples field values for the above are: XYZ\ABC,PQR\ABC,DEFABC. If I use the follwoing statement for pattrn matching: SELECT NAME FROM [TABLE-NAME] WHERE NAME LIKE %\\ABC% . Tried the other way too like this: SELECT NAME FROM [TABLE-NAME] WHERE NAME LIKE %\\ABC% it returns all the three values instead of only two Is this a bug or what is the solution. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help!
Hi, Fairly new at this so i need all the help i could get. I created a admin page where admin can add/mod/del/view from this page. But now I need to give access to other admins but from diffrent companies where I need to grant diffrent username and passwords to the original admin page. Each company have to be redircted to there personal admin page. How do i go around this? I'm using PHP AND mysql. Do i make a table where these diffrent usernames and passwords are inserted to and then do a sort statement by company Lost - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my sql pattern search and support for backslash??
On Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM Ravikumar Sarma Chengalvala wrote: Hi, Did mysql pattern search support a backslash character? Yes. Since it is a special character, make sure it is properly escaped. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 15,340,381 queries (78/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my sql pattern search and support for backslash??
It depends on what you mean by pattern search? You probably have to escape the \ character. If you put a \ in front of a character it means this next character is what I say it is not it's MySQL representation. This would allow you to put a ; or ) in your query. Simply put \\ to mean a backslash. Scott At 04:15 PM 6/18/2001 +0100, VVM Ravikumar Sarma Chengalvala wrote: Hi, Did mysql pattern search support a backslash character? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] PGP KeyID: 0xC2153655 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my sql pattern search and support for backslash??
It is not working even after escaping it.I am working on WINNT4.0 and mysql 3.23 --Regards, Ravi --- Scott Baker [EMAIL PROTECTED] wrote: It depends on what you mean by pattern search? You probably have to escape the \ character. If you put a \ in front of a character it means this next character is what I say it is not it's MySQL representation. This would allow you to put a ; or ) in your query. Simply put \\ to mean a backslash. Scott At 04:15 PM 6/18/2001 +0100, VVM Ravikumar Sarma Chengalvala wrote: Hi, Did mysql pattern search support a backslash character? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] PGP KeyID: 0xC2153655 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gnu tar
I am trying to evaluate mySql. I am told that if I am on Solaris, I must obtain gnu tar because of a bug in Solaris tar. I have downloaded the mySql distribution as well as 2 different versions of gnu tar that available at the site. gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz The reason I downloaded 2 different versions of the gnu tar is that I can't get anyone of these to deflate using gzip. I has successfully deflated the mySql distribution but all attempts at deflating the gnu tar stuff results in gzip: name_of_gzipped_file: not in gzip format What Gives [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?
Alex, did you change any my.cnf parameters? Version .39 should actually be a littel bit faster than .38. What does Unix 'top' say? What are the CPU usage %? The biggest change performance-wise in .39 is that you can now specify the parameter innodb_unix_file_flush_method in my.cnf. You could try the following values for it: innodb_unix_file_flush_method=O_DSYNC or innodb_unix_file_flush_method=littlesync Does it work fast now? Regards, Heikki -Original Message- From: BAUMEISTER Alexandre [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, June 18, 2001 6:24 PM Subject: 3.23.39+InnoDB = slower than 3.23.389InnoDB ? Bonjour, Environment: Solaris 2.8 on SPARC 64bit, Mysql-3.23.39+InnoDB. Mysql 3.23.38 with InnoDB support have been running for a while now on one of my servers (for a month in fact, since the release of 3.23.38). It worked perfectly well and was able to handle the job (intensive insert/update of a few tables. intensive = about 800 inserts/updates per second nearly all day long). Last week-end I upgraded to 3.23.39. And today Mysql seems to have some difficulties with the load :( Today I have symptoms like : * Mysql is verly (VERY) long to answer queries like mysqladmin stat or mysqladmin proc * When I do a mysqladmin proc I can see that a few thread are in UPDATE state since about 20 or even more seconds. This has never been the case with 3.23.38 :( Any idea ? Any reason ? Regards, Alex. --- Alexandre BAUMEISTERStandard : +333-83-36-58-67 Email : [EMAIL PROTECTED]Fax: +333-83-36-69-44 FINANCE NET - 1,rue St Dizier 54000 NANCY - FRANCE (www.finance-net.fr) --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connection Timeout Limit.
Title: Blank I currently have several different systems accessing a mysql server 3.23.34 somewhere in there is a process that forgets about connections that it has open. So after a few days I get a "too many connections open error". Is there a way that I can set connections to time out after a while on the server? I have looked at all of the variables that are already set in the my.cnf and can't seem to find anything that would limit the length of time Thanks Michael BloodMatraex Technologies
my sql and pattern search--bug(most urgent)
Hi, Can someone get back to me at the earliest regarding mysql's support for backslash characters in pattern search.I am not able to search based on the string which contains a backslash character even after escaping.. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my sql pattern search and support for backslash??
On Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM Ravikumar Sarma Chengalvala wrote: Even after escaping mysql just seems to be ignoring it. Odd. I'm seeing something other than what I first expected. Watch this... ---snip--- mysql CREATE TABLE slash_test ( foo VARCHAR(30) ); Query OK, 0 rows affected (0.02 sec) mysql INSERT INTO slash_test VALUES ('blah\\blah'); Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM slash_test; +---+ | foo | +---+ | blah\blah | +---+ 1 row in set (0.01 sec) mysql SELECT * FROM slash_test where foo like blah\\%; Empty set (0.00 sec) mysql SELECT * FROM slash_test where foo like blah\\\%; +---+ | foo | +---+ | blah\blah | +---+ 1 row in set (0.01 sec) ---snip--- Hm. I needed one more '\' than I would have thought necessary. Is that what you see as well? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 15,793,960 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql Problem
Hello I run mysql on a multi proccesoor server and when I run queries from different servers, I see it uses under 100% cpu, even thought it sometimes take 50% from each cpu. how can I get it to use 100% for each query? Thanks Tomer Grassyani. Internet Driver. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my sql pattern search and support for backslash??
try some more then.. try // or / or .. . Hi, I donot even get that with an additional backslash also.In my case it just ignores the backslash and goes ahead with the search . Regards, Ravi --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM Ravikumar Sarma Chengalvala wrote: Even after escaping mysql just seems to be ignoring it. Odd. I'm seeing something other than what I first expected. Watch this... ---snip--- mysql CREATE TABLE slash_test ( foo VARCHAR(30) ); Query OK, 0 rows affected (0.02 sec) mysql INSERT INTO slash_test VALUES ('blah\\blah'); Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM slash_test; +---+ | foo | +---+ | blah\blah | +---+ 1 row in set (0.01 sec) mysql SELECT * FROM slash_test where foo like blah\\%; Empty set (0.00 sec) mysql SELECT * FROM slash_test where foo like blah\\\%; +---+ | foo | +---+ | blah\blah | +---+ 1 row in set (0.01 sec) ---snip--- Hm. I needed one more '\' than I would have thought necessary. Is that what you see as well? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 15,793,960 queries (79/sec. avg) Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql does not start
i have recently installed the red hat 7.1 in my computer, althought i have not installed the mysql durring the os installations, naw i installed the mysql database but its giving me a socket error like this: /etc/rc.d/init.d/mysqld status mysql dead but subsys locked mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) i went on the mysql site and there it tells me to start like mysqld -h viuva-negra ERROR 2003: Can't connect to MySQL server on 'viuva-negra' (111) here viuva-negra is the name of my host, but it doent work just as the ip neither whork. i checked the log file and there it says can't find file ./mysql/host.frm, this file is in the /var/lib/mysql/mysql directory, wich the /var/lib/mysql is the datadir, what wuold be wrong ? i dont know what to do to correctly install the mysql. Does someone have been passing thru this too, or know haw to fix the problem ? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Data
ola como faço p/ mudar a data padrao do mysql?? ele esta como -dd-mm eu gostaria de mudar p/ dd-mm- falow valeu
Re: apache/php/modperl incomp?
Greg wrote: Le jeudi 14 juin 2001, à 08:14, Daniel a écrit : I believe that i've seen this on the list before. Read the php docs before compiling, don't use the builtin mysql support, specify --with-mysql=/path/to/mysqllibs Yes, I've compiled with this option. Is it possible that it doesn't actually use this parameter ? Dunno. If you've done that and it's still not working, make sure you've compiled DBD::mysql against the same libraries. -- Daniel Bohling NewsFactor Network - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database size limit
No need to worry.On NT each table can have upto4GB.Database there is predefined limit.It can go even upro 20GB or more also. --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Oddity with building 3.23.38 on Tru64 4.0f
I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f Alpha box from 3.22.25 to 3.23.38. As in the past, I used the Compaq cc as CC and gcc (2.95.3) as CXX with appropriate flags set. I do not have the GNU binutils installed, so it is the Compaq ld that is used. I am, however, using GNU make. I wanted to build with both BDB and InnoDB, so I configured as: ./configure --prefix=/usr/local/mysql --enable-assembler \ --with-low-memory --with-innodb --with-berkeley-db The configure proceded just fine and I typed make. Quite a while later I got this: gcc -O3 -DDBUG_OFF -O3 -fno-implicit-templates -mieee -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o procedure.o item_uniq.o sql_test.o log.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_isam.o ha_isammrg.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o md5.o log_event.o mini_client.o mini_client_errors.o -L../bdb/build_unix -ldb ../innobase/usr/libusr.a ../innobase/odbc/libodbc.a ../innobase/srv/libsrv.a ../innobase/que/libque.a ../innobase/srv/libsrv.a ../innobase/dict/libdict.a ../innobase/ibuf/libibuf.a ../innobase/row/librow.a ../innobase/pars/libpars.a ../innobase/btr/libbtr.a ../innobase/trx/libtrx.a ../innobase/read/libread.a ../innobase/usr/libusr.a ../innobase/buf/libbuf.a ../innobase/ibuf/libibuf.a ../innobase/eval/libeval.a ../innobase/log/liblog.a ../innobase/fsp/libfsp.a ../innobase/fut/libfut.a ../innobase/fil/libfil.a ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/com/libcom.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/libut.a ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lm -lpthread -lmach -lexc /usr/bin/ld: Unresolved: db_env_create log_archive db_create txn_abort txn_commit txn_begin log_flush txn_checkpoint collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory `/usr2/sources/util/mysql-3.23.38/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr2/sources/util/mysql-3.23.38/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr2/sources/util/mysql-3.23.38' make: *** [all-recursive-am] Error 2 It appeared the libdb.a in the bdb/build_unix directory was not being searched. I edited sql/Makefile and replaced the two occurrences of: -L$(top_builddir)/bdb/build_unix -ldb with $(top_builddir)/bdb/build_unix/libdb.a and the make proceded without further incident. I'm not sure if this is a problem with Compaq's ld or something else, but I found it curious. D= -- Dave FitzPatrick [EMAIL PROTECTED] Webmaster 978-681-1599 Quantic Communications An MHI Company http://www.quantic.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with mysql_query in C API
hi all, i have a small problem im using mysql_query to access my mysql database. now then, i have 2 queries, 1 just after the other. the first one goes ok, the second one never does. doesnt matter if i switch the queries, the one that is last never works. if i write the query in an xterm (using linux), which has a sesstion towards the mysql database then it works fine. im clearly missing something here. anyone know what ? any replies appriciated. regards kenneth johansen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help!
(assuming you're using PHP...) The best idea would probably be to create a column in your users table which indicates which company each user belongs to. Then, using select company_name from users where username EQ .$username; If you're not using PHP, the idea is still the same. Use a MySQL query to bring up the name of the company in a record with a username specified in a variable. Easy as pie. Benji Smith [EMAIL PROTECTED] Technical Director Osenta, Inc. www.osenta.com - Original Message - From: Taline Makssabo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 18, 2001 9:18 AM Subject: help! Hi, Fairly new at this so i need all the help i could get. I created a admin page where admin can add/mod/del/view from this page. But now I need to give access to other admins but from diffrent companies where I need to grant diffrent username and passwords to the original admin page. Each company have to be redircted to there personal admin page. How do i go around this? I'm using PHP AND mysql. Do i make a table where these diffrent usernames and passwords are inserted to and then do a sort statement by company Lost - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: gnu tar
I have downloaded the mySql distribution as well as 2 different versions of gnu tar that available at the site. gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz The reason I downloaded 2 different versions of the gnu tar is that I can't get anyone of these to deflate using gzip. I has successfully deflated the mySql distribution but all attempts at deflating the gnu tar stuff results in gzip: name_of_gzipped_file: not in gzip format If you are downloading them via FTP, are you using binary mode? If so, try compiling GNU tar from source (ftp://ftp.gnu.org/gnu/tar/tar-1.13.tar). I just extracted both of those .gz files successfully so the copies on the server are fine. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql does not start
Ricardo, Heh... Watch out, RH 7.x is notorious itself for being the src of a problem. Cheers -v. --EOF Ricardo Striquer Soares wrote: i have recently installed the red hat 7.1 in my computer, althought i have not installed the mysql durring the os installations, naw i installed the mysql database but its giving me a socket error like this: /etc/rc.d/init.d/mysqld status mysql dead but subsys locked mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) i went on the mysql site and there it tells me to start like mysqld -h viuva-negra ERROR 2003: Can't connect to MySQL server on 'viuva-negra' (111) here viuva-negra is the name of my host, but it doent work just as the ip neither whork. i checked the log file and there it says can't find file ./mysql/host.frm, this file is in the /var/lib/mysql/mysql directory, wich the /var/lib/mysql is the datadir, what wuold be wrong ? i dont know what to do to correctly install the mysql. Does someone have been passing thru this too, or know haw to fix the problem ? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting mysql
Hello all, I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I am having is that when I start it from the command line using safe_mysql -u mysql, it says: Starting mysqld daemin with databases from /usr/local/mysql/var It never reports anything else. The database starts, but the terminal window I used to startd it never finishes up. I have to open a new terminal window up. Has anyone experienced this? Dale - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
left outer join query question
Hi, I am having a small formatting problem maybe someone can help with. I have a query that does a left outer join, which generates a table with a few NULL values in some columns. All okay so far. But what I need to do is sort on this column, and I need to put NULL values at the end. Normally I would just set all NULL values to be some number like 100, but since they do not exist before the join I cannot do this. Is there a way to assign a value in the query? Like if col2=NULL col2=100? Or maybe some other nice little trick? I looked in the manual, the Paul DuBois book, and usenet. Didn't find anything useful. Thanks! What I have: col1col2 a 1 b 3 c NULL d 2 e NULL f 4 What I want: col1col2 a 1 d 2 b 3 f 4 c NULL e NULL What I get: col1col2 c NULL e NULL a 1 d 2 b 3 f 4 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting mysql
That's what it's supposed to do. End the command with a so it will spawn into the background. Scott At 11:05 AM 6/18/2001 -0700, Dale Schell wrote: Hello all, I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I am having is that when I start it from the command line using safe_mysql -u mysql, it says: Starting mysqld daemin with databases from /usr/local/mysql/var It never reports anything else. The database starts, but the terminal window I used to startd it never finishes up. I have to open a new terminal window up. Has anyone experienced this? Dale - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] PGP KeyID: 0xC2153655 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql does not start
Ricardo Striquer Soares [EMAIL PROTECTED] writes: i have recently installed the red hat 7.1 in my computer, althought i have not installed the mysql durring the os installations, naw i installed the mysql database but its giving me a socket error like this: From our RPMs, or did you download it from somewhere else? /etc/rc.d/init.d/mysqld status mysql dead but subsys locked Have you done anything manual yourself, like my_install_db or something similar? One thing you could try (will remove all your current data, but it didn't sound like you had anything there): Go to /var/lib/mysql, and rm -fr * in that directory. After that, start it the normal way (service mysqld start), and everything should be fine. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: left outer join query question
You could try using the IFNULL() function on that column before you do the join. http://www.mysql.com/doc/C/o/Control_flow_functions.html --jfarr - Original Message - From: Bryan Coon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 18, 2001 11:12 AM Subject: left outer join query question Hi, I am having a small formatting problem maybe someone can help with. I have a query that does a left outer join, which generates a table with a few NULL values in some columns. All okay so far. But what I need to do is sort on this column, and I need to put NULL values at the end. Normally I would just set all NULL values to be some number like 100, but since they do not exist before the join I cannot do this. Is there a way to assign a value in the query? Like if col2=NULL col2=100? Or maybe some other nice little trick? I looked in the manual, the Paul DuBois book, and usenet. Didn't find anything useful. Thanks! What I have: col1 col2 a 1 b 3 c NULL d 2 e NULL f 4 What I want: col1 col2 a 1 d 2 b 3 f 4 c NULL e NULL What I get: col1 col2 c NULL e NULL a 1 d 2 b 3 f 4 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unknown column in 'where clause' error
Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql_query in C API
Kenneth Johansen ([EMAIL PROTECTED]) writes: hi all, i have a small problem im using mysql_query to access my mysql database. now then, i have 2 queries, 1 just after the other. the first one goes ok, the second one never does. doesnt matter if i switch the queries, the one that is last never works. if i write the query in an xterm (using linux), which has a sesstion towards the mysql database then it works fine. Can you be a little more specific? Post code?? :) You're obviously doing more than just calling mysql_query - what are you doing with the results? Are you calling mysql_free_result after you use the results? Code here is really, really important - please post some! Your question as it stands is almost useless without code... -- Ed Carp, N7EKG [EMAIL PROTECTED] 214/986-5870 cell phone http://www.pobox.com/~erc I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting MySQL on boot
Hello all, I am running the new Mac OSX Server. In the mysql docs, it says to put the mysql.server file in the correct place for your system. Does anyone know what the right place on OSX Server is? I placed it in /Library/Startup/MySQL, as the other databases I am experimenting with have their startup files there. Dale - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Design question
I have a design problem I was hoping some of you could help me out with. I am writing a shopping cart system (as if there wasn't enough already) and I have one problem that has me stumped. A person can order more than one item of course. So let's say they order a kite and some string. Both of these have product numbers, and the overall order has an order number. I am trying to figure out how to design a table ( or tables ) so I can keep track of the different products that are ordered during one order. I need to keep track of the product number, quantity, and price for that product. For instance: Order # Products - -- 1 222 : Qty 1: 12.00 # 333 : Qty 2 : 14.00 That is order number 1 and that person ordered one of product # 222 @ 12.00 and 2 of product # 333 @14.00. I would appreciate any assistance any of you might be able to offer. If I wasn't clear enough, let me know and I will try and explain it better. Thanks. Jeff Jones - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unknown column in 'where clause' error
On Mon, Jun 18, 2001 at 02:44:00PM -0400, Shrout, Ryan wrote: Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Try: SELECT * FROM customers WHERE Customer_No = CMET3558539239; Greetz, Peter -- Against Free Sex! http://www.dataloss.nl/Megahard_en.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unknown column in 'where clause' error
Put quotes around the Customer_No: SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' - TIM Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unknown column in 'where clause' error
Try SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Enviada: Segunda-feira, 18 de Junho de 2001 19:44 Para: '[EMAIL PROTECTED]' Assunto: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unknown column in 'where clause' error
Thanks for the suggestions, but this is actually a variable that is passed via a URL. For example: http://localhost/cus-lookup.php?id=CMET3558539239 Then in the code it looks like this: $customer_select=SELECT * FROM customers WHERE Customer_No = $id; How can I 'put quotes around' a variable? Ryan Shrout -Original Message- From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 3:20 PM To: Shrout, Ryan Subject: RE: Unknown column in 'where clause' error WHERE Customer_No = 'CMET3558539239' you need to use quotes when trying to reference data that is not 100% numeric, otherwise MySQL thinks you are trying to reference a column. Bill Elvis Gibbs goEbusiness.com - putting e-motion in your business email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938 -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 2:44 PM To: '[EMAIL PROTECTED]' Subject: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unknown column in 'where clause' error
Hello, Your field(column) is a CHAR and therefore the parameter to it should be in single quotes: Change your query to: SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: 18 June 2001 19:44 To: '[EMAIL PROTECTED]' Subject: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Design question
This looks like an order-lineitem situation, which I would imagine would look like this: ORDERS ORDER_ID CUSTOMER_ID ORDER_DATE LINEITEM ORDER_ID PRODUCT_ID LINEITEM_QUANTITY At 02:00 PM 6/18/2001 -0500, you wrote: I have a design problem I was hoping some of you could help me out with. I am writing a shopping cart system (as if there wasn't enough already) and I have one problem that has me stumped. A person can order more than one item of course. So let's say they order a kite and some string. Both of these have product numbers, and the overall order has an order number. I am trying to figure out how to design a table ( or tables ) so I can keep track of the different products that are ordered during one order. I need to keep track of the product number, quantity, and price for that product. For instance: Order # Products - -- 1 222 : Qty 1: 12.00 # 333 : Qty 2 : 14.00 That is order number 1 and that person ordered one of product # 222 @ 12.00 and 2 of product # 333 @14.00. I would appreciate any assistance any of you might be able to offer. If I wasn't clear enough, let me know and I will try and explain it better. Thanks. Jeff Jones - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Crashes
Hi, I am new to MySQL. I downloaded MySQL for Windows version 3.23.38. When I installed in MyISAM mode, mysqld was running fine. Then I uncommented the configure parameters for innoDB in my.cnf. Mysqld initialized the database the folowing messages printed on screen. Can anyone help ? Thanks, Woyou InnoDB: The first specified data file \cygwin\usr\local\mysql\var\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata1 size to 26214400 InnoDB: Database physically writes the file full: wait... InnoDB: Data file \cygwin\usr\local\mysql\var\ibdata2 did not exist: new to be c reated InnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata2 size to 38797312 InnoDB: Database physically writes the file full: wait... InnoDB: Data file \cygwin\usr\local\mysql\var\ibdata3 did not exist: new to be c reated InnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata3 size to 104857600 InnoDB: Database physically writes the file full: wait... InnoDB: Data file \cygwin\usr\local\mysql\var\ibdata4 did not exist: new to be c reated InnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata4 size to 314572800 InnoDB: Database physically writes the file full: wait... InnoDB: Log file \cygwin\usr\local\mysql\var\ib_logfile0 did not exist: new to b e created InnoDB: Setting log file \cygwin\usr\local\mysql\var\ib_logfile0 size to 5242880 InnoDB: Log file \cygwin\usr\local\mysql\var\ib_logfile1 did not exist: new to b e created InnoDB: Setting log file \cygwin\usr\local\mysql\var\ib_logfile1 size to 5242880 InnoDB: Log file \cygwin\usr\local\mysql\var\ib_logfile2 did not exist: new to b e created InnoDB: Setting log file \cygwin\usr\local\mysql\var\ib_logfile2 size to 5242880 Innobase: Assertion failure in thread 4294535455 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010618 15:56:21 c:\MYSQL\BIN\mysqld.exe: Got signal 11. Aborting! 010618 15:56:21 Aborting InnoDB: Warning: shutting down not properly started database 010618 15:56:22 c:\MYSQL\BIN\mysqld.exe: Shutdown Complete __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL protocol
Hi there, Where can I get the MySQL protocol? Thanks! Yue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unknown column in 'where clause' error
You are using PHP. Well PHP is not ASP :-) clever and you can enclose your variable in single quotes as in: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; Hope this helps. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: 18 June 2001 20:14 To: '[EMAIL PROTECTED]' Subject: RE: Unknown column in 'where clause' error Thanks for the suggestions, but this is actually a variable that is passed via a URL. For example: http://localhost/cus-lookup.php?id=CMET3558539239 Then in the code it looks like this: $customer_select=SELECT * FROM customers WHERE Customer_No = $id; How can I 'put quotes around' a variable? Ryan Shrout -Original Message- From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 3:20 PM To: Shrout, Ryan Subject: RE: Unknown column in 'where clause' error WHERE Customer_No = 'CMET3558539239' you need to use quotes when trying to reference data that is not 100% numeric, otherwise MySQL thinks you are trying to reference a column. Bill Elvis Gibbs goEbusiness.com - putting e-motion in your business email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938 -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 2:44 PM To: '[EMAIL PROTECTED]' Subject: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unknown column in 'where clause' error
Like this: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; Jorge Oliveira [EMAIL PROTECTED] --- © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Enviada: Segunda-feira, 18 de Junho de 2001 20:14 Para: '[EMAIL PROTECTED]' Assunto: RE: Unknown column in 'where clause' error Thanks for the suggestions, but this is actually a variable that is passed via a URL. For example: http://localhost/cus-lookup.php?id=CMET3558539239 Then in the code it looks like this: $customer_select=SELECT * FROM customers WHERE Customer_No = $id; How can I 'put quotes around' a variable? Ryan Shrout -Original Message- From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 3:20 PM To: Shrout, Ryan Subject: RE: Unknown column in 'where clause' error WHERE Customer_No = 'CMET3558539239' you need to use quotes when trying to reference data that is not 100% numeric, otherwise MySQL thinks you are trying to reference a column. Bill Elvis Gibbs goEbusiness.com - putting e-motion in your business email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938 -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 2:44 PM To: '[EMAIL PROTECTED]' Subject: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Articles... (MySQL) - Call for Submission
Hello All, Sorry if this is the wrong place to post this request. I represent ADEMKA and in September we are launching a publication which has both a LIFESTYLE and a TECHNICAL angle to it for Computer Professionals. We are looking for articles relating to MySQL and are paying between £50(GBP) and £100 (GBP) per article that we use. If anyone using this list is interested in contributing an article, then please contact me on the email below. Besides the obvious financial gain from the article one can bolster his or her image with an article in a publication that will be read in excess of over 100,000 Computer Professionals. I look forward to any contributors etc... Mail me @ [EMAIL PROTECTED] * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unknown column in 'where clause' error
Ok, in your PHP code, do this: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; This will add quotes around the variable... -TIM On Mon, 18 Jun 2001, Shrout, Ryan wrote: Thanks for the suggestions, but this is actually a variable that is passed via a URL. For example: http://localhost/cus-lookup.php?id=CMET3558539239 Then in the code it looks like this: $customer_select=SELECT * FROM customers WHERE Customer_No = $id; How can I 'put quotes around' a variable? Ryan Shrout -Original Message- From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 3:20 PM To: Shrout, Ryan Subject: RE: Unknown column in 'where clause' error WHERE Customer_No = 'CMET3558539239' you need to use quotes when trying to reference data that is not 100% numeric, otherwise MySQL thinks you are trying to reference a column. Bill Elvis Gibbs goEbusiness.com - putting e-motion in your business email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938 -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 2:44 PM To: '[EMAIL PROTECTED]' Subject: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: raid tables
On Mon, Jun 18, 2001 at 03:56:32AM -0700, Jamie Krasnoo wrote: [mysqld] datadir=/data1;/data2;/data3 - or - datadir=/data1:/data2:/data3 As it stands now, both will produce an error and MySQL will not start. Other ways could be like: RAID_DIRS=/data1:/data2:/data3 Well, I'll throw my thoughts in as well... I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or entries) woudl list the available directories, like others have suggested. Then, using SQL, you could: * Mark a table to be spread out at creation time vis some attribute. * Possibly do it after the fact using ALTER TABLE. As for the exact syntax, I don't know what might be best. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 16,991,404 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
seeking clever php / mySql generic method
Hi All! While this is not a huge problem, it is a recurring one so I thought I would see if someone else has a nice generic way of handling this situation. I often set up database tables with a PHP4 interface to handle insertions. It is always set up on a CGI basis, wherein a form blasts variable names and values to the interface, which does the insert. Often a table consists of a few hundred variables. Clearly when entering the variables by name into the statements below, there is room for little errors to creep in, even though I copy the var names from a table export.For example, in a list of 500 variable names I might accidentally not copy a variable or miss part of one inadvertantly. This takes a while to find. $Entry=MYSQL_QUERY(INSERT INTO seniors(interviewer, surveynum, dat, q1_1, q1_2, q1_3, q1_4) VALUES('$interviewer', '$surveynum', '$dat', '$q1_1', '$q1_2', '$q1_3', '$q1_4')); Being a klutz, I frequently make assorted little errors and it takes some time to figure where I have screwed up each and every time I set up one of these things. I'm wondering therefore if there is a Better Way than using the exact variable names. For example, using something like a while statement including : while(list($key, $val) = each($HTTP_GET_VARS)) { clever stuff here } Does anyone have ideas on how to do this better? I don't think that I am being efficient. . . Thanks! -Warren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Data
Ola Ricardo, Não sei ao certo se o formato padrao do MySQL voce consegue mudar. Entretanto voce pode resolver o problema utilizando o DATE_FORMAT no select. Veja o exemplo abaixo: SELECT DATE_FORMAT(NOW(), d/m/Y) AS DATA; []'s Crercio O. Silva -Original Message- From: Ricardo Ferrari (SPO-LAB) [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 18 de junho de 2001 14:01 To: MySQL (Correio eletrônico) Subject: Data ola como faço p/ mudar a data padrao do mysql?? ele esta como -dd-mm eu gostaria de mudar p/ dd-mm- falow valeu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I need to use the Load Data command to load the contents of ate xt file into a table.
The problem is the text file resides on a server that holds the website pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to specify the text file if it is loaded on another server? This is what I have: LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY '' TERMINATED BY ',' LINES TERMINATED BY ';'; I need to specify the path for the data.txt file if it is on the websites server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Design question
hi. the easiest way is to have an order table: (orderID, customer, address, etc., etc.) a item table: (itemID, description, price, etc.etc.) and an orderItems table: (orderID, itemID) this way you can select i.description, i.price from order o, item i, orderItems oi, where o.orderID = 1 and o.orderID = oi.orderID and oi.itemID = i.itemID or something like that. you could replace the customer/address columns in order with a customerID referencing a customer table as well... -ravi. -Original Message- From: Jeff Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 3:00 PM To: [EMAIL PROTECTED] Subject: Design question I have a design problem I was hoping some of you could help me out with. I am writing a shopping cart system (as if there wasn't enough already) and I have one problem that has me stumped. A person can order more than one item of course. So let's say they order a kite and some string. Both of these have product numbers, and the overall order has an order number. I am trying to figure out how to design a table ( or tables ) so I can keep track of the different products that are ordered during one order. I need to keep track of the product number, quantity, and price for that product. For instance: Order # Products - -- 1 222 : Qty 1: 12.00 # 333 : Qty 2 : 14.00 That is order number 1 and that person ordered one of product # 222 @ 12.00 and 2 of product # 333 @14.00. I would appreciate any assistance any of you might be able to offer. If I wasn't clear enough, let me know and I will try and explain it better. Thanks. Jeff Jones - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Start fails after upgrade to 3.23.32 - no host.ISM file
Description: Upgraded from 3.22.27 to 3.23.32. Built from source. When attempting to start the daemon, it immediately terminates. Log file shows Can't find file: 'host.ISM' (errno: 2). I checked the old data directory (from where I copied the database files) and there never has been a host.ISM file. I don't see a reference to this in the trouble shoot guides. Please note: I cannot go to the current version as this machine (development) cannot be on a higher version that the production machine, which is on 3.23.32. How-To-Repeat: Use either safe_mysqld or mysql.server to start. Same symptoms. Fix: Looking for fix. Submitter-Id: submitter ID Originator:Guy Smith Organization: FundTheCause, Inc. MySQL support: none Synopsis: Start fails after upgrade to 3.23.32 - no host.ISM file Severity: serious Priority: medium Category: mysql Class: support Release: mysql-3.22.32 (TCX binary) Environment: System: Linux linus 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary' --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: I need to use the Load Data command to load the contents ofa text file into a table.
Really the question is will the following work: LOAD DATA INFILE 'home/domain name/www/subdirectory/data.txt' INTO TABLE data FIELDS ENCLOSED BY '' TERMINATED BY ',' LINES TERMINATED BY ';'; -Original Message- From: Hamilton, Jay Sent: Monday, June 18, 2001 4:56 PM To: '[EMAIL PROTECTED]' Subject: I need to use the Load Data command to load the contents of a text file into a table. The problem is the text file resides on a server that holds the website pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to specify the text file if it is loaded on another server? This is what I have: LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY '' TERMINATED BY ',' LINES TERMINATED BY ';'; I need to specify the path for the data.txt file if it is on the websites server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Design question
Hi Jeff, If you visit my homepage at: www.geocities.com/hisiomara click Tutorials and select the first item Team5.com an ecommerce sample you will be able to see the ERD diagram that attends your ecommerce demand. Actually will will be able to see much more. The design is there,and I will post the codes after. Although I implemented in Oracle,the design is neutral and can be implemented in any database. Please let me know your opinion about it, I do appreciate it. Take care Sio PS: I would like to invite everybody to go there. This is a site intended to show my skills but I also share good stuffs with everybody. From: Jeff Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Design question Date: Mon, 18 Jun 2001 14:00:29 -0500 I have a design problem I was hoping some of you could help me out with. I am writing a shopping cart system (as if there wasn't enough already) and I have one problem that has me stumped. A person can order more than one item of course. So let's say they order a kite and some string. Both of these have product numbers, and the overall order has an order number. I am trying to figure out how to design a table ( or tables ) so I can keep track of the different products that are ordered during one order. I need to keep track of the product number, quantity, and price for that product. For instance: Order #Products - -- 1 222 : Qty 1: 12.00 # 333 : Qty 2 : 14.00 That is order number 1 and that person ordered one of product # 222 @ 12.00 and 2 of product # 333 @14.00. I would appreciate any assistance any of you might be able to offer. If I wasn't clear enough, let me know and I will try and explain it better. Thanks. Jeff Jones - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrade and start-up failures
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old mySQL /data directory, and there never was any such file. I can still start the old server without error. Any suggestions are welcome. OS:RedHat Linux 6.2 DIST: Built from source
MM JDBC driver: Server configuration denies access to data source
Hi, I'm connecting to a MySQL server through the MM JDBC driver on under Red Hat 6.2 using the below code. I keep getting an error message returned that says : Server configuration denies access to data . I'm connecting as the root user and I am definitely passing the correct password etc. in the url I send to the driver. The URL I'm using is : jdbc:mysql://localhost:3306//test. Can anyone suggest a solution to this problem please ? I have another server which is running WIN2K that I can connect to just fine and both servers were set up in similar ways. I thought that perhaps I would need to setup the host table in mysql, but that did not provide any useful results. I just can't figure it out. Thanks you in advance for any information, Regards, Todd G. Nist Email: [EMAIL PROTECTED] code: import java.sql.*; public class mysqltest { Connection Conn = null; ResultSet RS = null; Statement Stmt = null; static String DBUrl = null; public static void main(String[] args) throws Exception { DBUrl = args[0]; mysqltest T = new mysqltest(); } public mysqltest() throws Exception { try { System.out.println(preparing to conntect to datasource: + DBUrl); Class.forName(org.gjt.mm.mysql.Driver).newInstance(); Conn = DriverManager.getConnection(DBUrl); Stmt = Conn.createStatement(); System.out.println(got connection); System.out.println(Selecting Rows); RS = Stmt.executeQuery(SELECT * FROM user); System.out.println(Positioning before start of result set); RS.beforeFirst(); System.out.print(going forward through results: ); while (RS.next()) { String s = RS.getString(FirstName) + + RS.getString(LastName); System.out.println(s); } } catch (SQLException E) { throw E; } finally { if (RS != null) { try { RS.close(); } catch (SQLException SQLE) {} } if (Stmt != null) { try { Stmt.close(); } catch (SQLException SQLE) {} } if (Conn != null) { try { Conn.close(); } catch (SQLException SQLE) {} } } } } The information in this electronic mail (e-mail) message may be confidential and for use of only the named recipient. The information may be protected by privilege, work product immunity or other applicable law. If you are not the intended recipient the retention, dissemination, distribution or copying of this e-mail message is strictly prohibited. If you receive this e-mail message in error please notify us immediately by telephone at 770-723-1011 or [EMAIL PROTECTED] Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: seeking clever php / mySql generic method
You can. However, in these situations (in other languages) I've written code generators that generate either the entire HTML/PHP page for me or at the very least, the data object that I am talking to, complete with SELECT/INSERT/UPDATE and DELETE statements. That having been said, not trying to be a smart a** but if your table is 500 columns wide, you might revisit your design, if that's possible. it could be that you could normalize it more and reduce the number of columns you are working with. (or not, that may not be an option) My $.02 worth, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: WeAreUs [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, June 18, 2001 3:27 PM Subject: seeking clever php / mySql generic method Hi All! While this is not a huge problem, it is a recurring one so I thought I would see if someone else has a nice generic way of handling this situation. I often set up database tables with a PHP4 interface to handle insertions. It is always set up on a CGI basis, wherein a form blasts variable names and values to the interface, which does the insert. Often a table consists of a few hundred variables. Clearly when entering the variables by name into the statements below, there is room for little errors to creep in, even though I copy the var names from a table export.For example, in a list of 500 variable names I might accidentally not copy a variable or miss part of one inadvertantly. This takes a while to find. $Entry=MYSQL_QUERY(INSERT INTO seniors(interviewer, surveynum, dat, q1_1, q1_2, q1_3, q1_4) VALUES('$interviewer', '$surveynum', '$dat', '$q1_1', '$q1_2', '$q1_3', '$q1_4')); Being a klutz, I frequently make assorted little errors and it takes some time to figure where I have screwed up each and every time I set up one of these things. I'm wondering therefore if there is a Better Way than using the exact variable names. For example, using something like a while statement including : while(list($key, $val) = each($HTTP_GET_VARS)) { clever stuff here } Does anyone have ideas on how to do this better? I don't think that I am being efficient. . . Thanks! -Warren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using mysql_data_seek() is very slow
Hi. On Mon, Jun 18, 2001 at 08:16:45AM +1000, [EMAIL PROTECTED] wrote: What is the current way to move back and forwards and to any position in a recordset without losing performance There is no way. For effiency, the record set is hold in memory as linked list. Searching a position in linked lists has a complexity of O(n). If you really need random accesses, first copy the data or the pointers to an array, which then can be accessed randomly. Bye, Benjamin. [...] But if I want to use mysql_data_seek() it is very slow - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL query - not too complex?
Hi. On Mon, Jun 18, 2001 at 02:32:13AM +0100, [EMAIL PROTECTED] wrote: I need some help with a query to sum data for each id and write it into a new table. I have a source data table for each calendar month containing i.d.'s (not unique) and a value and I need to sum all the values for each i.d. for all months into a new table (where each i.d. will now be unique). The only way I could see of doing it was in two or more stages? If I read correctly, that there is currently a table for each month, there is no reasonable singe-stage way. If you can change the source tables, add a column to indicate the month, then create a MERGE table definition and run an appropriate CREATE TABLE ... SELECT ... GROUP BY query. If not, but the number of different ids is not too large (less than about 100.000 or so), I would create an appropriate target table (including a column for month) and run INSERT INTO target SELECT 1 as month, ... FROM ... GROUP BY ... and afterwards run the CREATE TABLE ... SELECT ... GROUP BY ... I just talked about above. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I know the version of mysql running on Linux (RedHat 6.2)
How can I know the version of mysql running on Linux (RedHat 6.2) thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Put mysql data from linux in Win98 mysql
I tried to put the data (.frm, .ISD and .ISM files) of my Linux into windows 98 put I can't use the data. When I open phpadmin2, he show how many registrys I have, but When I try to use/list the table is empty. Can I solve this problem? I need to use mysqldump to put the data into windows 98? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL 3.23.39 released
Steven Now I have a question: Does this also apply to automatic repair inside Steven mysqld? I'd finally use the feature if its true... If you just run CHECK TABLE, it will repair the open count (it should always have done that). myisamchk --fast --force is equal to: run CHECK TABLE on all tables Run REPAIR TABLE on tables which was not marked as ok. I was refering to --myisam-recover=FORCE As I remember, it would repair tables that had a open count 0 (at least back when I first tried using it). Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I know the version of mysql running on Linux (RedHat 6.2)
On Mon, 18 Jun 2001 20:19:20 -0300 (EST), Augusto Cesar Castoldi [EMAIL PROTECTED] wrote: SELECT VERSION(); te: Mon, 18 Jun 2001 20:19:20 -0300 (EST) How can I know the version of mysql running on Linux (RedHat 6.2) thanks, Augusto Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I know the version of mysql running on Linux (RedHat 6.2)
On Mon, Jun 18, 2001 at 08:19:20PM -0300, Augusto Cesar Castoldi wrote: How can I know the version of mysql running on Linux (RedHat 6.2) mysqladmin version -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 17,910,907 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transfering data
How can I transfer the data from a MySQL 3.22.32 running on RedHat 6.2 Linux to a MySQL 2.23.37 running on Windows 98? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock error
I'm receiving the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/httpd/html/phpadmin2/lib.inc.php on line 119 what could be? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I know the version of mysql running on Linux (RedHat 6.2)
If you're trying to check a 'remote' system, you can 'telnet' to port 3306 (IF you have remote 'telnet' access to the MySQL service, and IF it's listening on the default port 3306) which will display some garbage containing the version number telnet yubby.dubby.com 3306 3.23.37G\Tn#$(@%@#OR This server is running version 3.23.37. You could do this using 'localhost' if you ARE on the same machine as the MySQL service... Augusto Cesar Castoldi wrote: How can I know the version of mysql running on Linux (RedHat 6.2) thanks, Augusto
Re: Put mysql data from linux in Win98 mysql
In case you're not aware of it yet, Linux (and other UNIX operating systems) are not 'binary file compatible' with Microsoft products (including Windows 98). You should always 'dump' your database contents (using mysqldump) before 'moving' the data to build another database (unless you're moving between identical systems, and you've already 'shutdown' the MySQL program) How did you copy/move the files from the Linux system to the Windows 98 machine ? - If you used FTP, did you make sure that you were in 'text' mode ? Augusto Cesar Castoldi wrote: I tried to put the data (.frm, .ISD and .ISM files) of my Linux into windows 98 put I can't use the data. When I open phpadmin2, he show how many registrys I have, but When I try to use/list the table is empty. Can I solve this problem? I need to use mysqldump to put the data into windows 98? thanks, Augusto
SQL reference.
Hi, Is there a place where I can find a manual (not tutorial) of SQL Reference/Sintax, something like the PHP Manual... It could be about SQL in general, MySQL and/or Oracle. Thanks, Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com
Re: SQL reference.
At 01:08 AM 6/19/2001 +0100, © webfroggie.com wrote: Hi, Is there a place where I can find a manual (not tutorial) of SQL Reference/Sintax, something like the PHP Manual... It could be about SQL in general, MySQL and/or Oracle. Thanks, Jorge Oliveira [EMAIL PROTECTED] The MySQL manual is availible from the site in PDF format. John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrade and start-up failures
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old mySQL /data directory, and there never was any such file. I can still start the old server without error. Any suggestions are welcome. OS:RedHat Linux 6.2 DIST: Built from source
Re: Upgrade and start-up failures
It's looking for the host table (physical files) within the 'mysql' data area (not your own data area). Did you run mysql_install_db after installing the new version ? (or copy the mysql subdirectory from the old version) Guy Smith wrote: I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old mySQL /data directory, and there never was any such file. I can still start the old server without error. Any suggestions are welcome. OS:RedHat Linux 6.2 DIST: Built from source - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please help (dumb permissions thing?)
Access denied for user: '@localhost' to database 'netsloth'Could not drop database netsloth (i asume drop means to drop 'in' in this case?) is what i get back when i try to install the db 'netsloth.dump' from J Greenspan's book and CD. please tell this newcomer what he has to do to fix this so i can get on with it... i've been at this for 2 days and am thoroughly stuck. please tell me the most basic user accesses to check. TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: .dump files
i guess that is confusing to me because it says query. i'm really stuck though -see my recent 'please help' post to the mysql list. thanks. At 2:48 AM -0600 6/18/01, Chris Bolt wrote: thank you. that's sort of what i thought. now for the silly question: i know how to do it with 'monitor' (CLI), but where/how do you import using phpMyAdmin, please? (this i'd love to know :) i looked through the manual but didn't see anything for import db. Click a database on the left frame and it's under the query textarea (there's a browse button and a go button). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrade and start-up failures
Tried both. 1st copied the data tree (wherein there is a host.frm, host.MYD, and host.MYI files). When that didn't work, I did the mysql_install_db, but that had no effect. I suspect that there is a ./configure option I missed that declares the default data file format to use, and that they were built differently. But I cannot yet find that in the docs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Brazill Sent: Monday, June 18, 2001 6:11 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Upgrade and start-up failures It's looking for the host table (physical files) within the 'mysql' data area (not your own data area). Did you run mysql_install_db after installing the new version ? (or copy the mysql subdirectory from the old version) Guy Smith wrote: I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old mySQL /data directory, and there never was any such file. I can still start the old server without error. Any suggestions are welcome. OS:RedHat Linux 6.2 DIST: Built from source - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Failed when doing 'make test'
Description: Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.12 0.06 0.99 [ pass ] alter_table 0.04 0.03 0.55 [ pass ] analyse 0.08 0.05 1.14 [ pass ] auto_increment0.03 0.05 0.61 [ pass ] backup0.07 0.03 0.57 [ pass ] bdb-crash 0.06 0.01 0.50 [ pass ] bdb [ skipped ] bench_count_dist 0.05 0.06 0.35 [ pass ] bigint [ fail ] Error at line 13: Result length mismatch Below are the diffs between actual and expected results: --- *** r/bigint.result Wed May 9 23:44:13 2001 --- r/bigint.reject Tue Jun 19 05:34:13 2001 *** *** 1,5 0 256 000655362147483647 -2147483648 2147483648 +4294967296 ! 0 256 65536 2147483647 -2147483648 2147483648 4294967296 9223372036854775807 -009223372036854775808 9223372036854775807 -9223372036854775808 +999 -999 --- 1,5 0 256 000655362147483647 -2147483648 2147483648 +4294967296 ! 0 256 65536 2147483647 -2147483648 2147483648 0 9223372036854775807 -009223372036854775808 9223372036854775807 -9223372036854775808 +999 -999 --- Please e-mail the above, along with the output of mysqlbug and any other relevant info to [EMAIL PROTECTED] How-To-Repeat: Fix: Submitter-Id: Marnix A. van Ammers Originator:Marnix A. van Ammers Organization: Flickering Star Research MySQL support: none Synopsis: Failed 'bigint' test during 'make test' Severity: Priority: Category: mysql Class: Release: mysql-3.23.38 (Source distribution) Environment: System: Linux delli7k 2.2.13-22mdk #1 SMP Fri Oct 22 02:06:33 CEST 1999 i686 unknown Architecture: i686 Some paths: /home/mav6/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.91.66/specs gcc version pgcc-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 6 1999 /lib/libc.so.6 - libc-2.1.1.so -rwxr-xr-x 1 root root 1286208 Sep 9 1999 /lib/libc-2.1.1.so -rw-r--r-- 1 root root 2297380 Sep 9 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 9 1999 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.38 --with-mysqld-user=mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php