Bug report
Disclaimer: I am new to MySQL, and don't know the correct procedure for submitting bugs. A quick search on Google and the MySQL site provided no clear answer to my problem. My setup: Pentium II 350 MHz, running Win98. 64MB RAM. What I tried to do: I attempted to run C:\mysql\bin\mysqld from a Dos window. I installed everything according to the default instructions. The error messages (quoted verbatim): C:\mysql\binmysqld Innobase: Assertion failure in thread 4294395831 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] 010604 11:01:09 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010604 11:01:09 Aborting InnoDB: Warning: shutting down not properly started database 010604 11:01:09 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete I'd be most grateful if someone could reply (to [EMAIL PROTECTED]) with an answer or point me to some decent documentation. I am a programmer, and would love to move to an open source database, though for the moment I have to stick with Windows. I'd like to investigate replacing our company's Access databases with MySQL, but this is a showstopper. If you need anything else, please let me know. - Chris
problem with distinct, group by, and join all together
mysql desc logs ; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | USERNAME | varchar(8)| | PRI | | | | TITLE | varchar(40) | YES | | NULL| | | FILEPATH | varchar(35) | YES | | NULL| | | ENTRIESPERPAGE | int(2)| YES | | NULL| | | BACKTEXT | varchar(30) | YES | | NULL| | | FORWARDTEXT| varchar(30) | YES | | NULL| | mysql desc log_entries; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | USERNAME | varchar(8)| | MUL | || | TITLE| varchar(60) | YES | | NULL|| | date | timestamp(14) | YES | | NULL|| | entry_id | int(11) | | PRI | 0 | auto_increment | +--+---+--+-+-++ ok i have the above two tables the username field in both should be of the same set of valid usernames, but in logs username is unique (one row per user) and in log_entries it is not (one row per entry that each user has posted). the title fields in both tables are never the same. the query that i want to do is to select the 5 most recent unique usernames from log_entries (using distinct and date desc) and then join that to logs (using the fact that every username in log_entries has an entry in logs somewhere) to get their overall log title. i have tried all sorts of variations but cant seem to get them to come out in the right order in one sql statement. if anyone has time to investigate this further, i can send you some 30 rows of test data... many thanks, -will w.
RE: emergency help
Thank you very much for your help. I got it fixed with the command 'safe_mysqld--old-protocol ' Thank YOU!!! -Original Message- From: Nico D [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:44 AM To: Simon Green Cc: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: RE: emergency help thats because your server isn't running. mysql is the client (AFAIK). But if your running redhat, you can /etc/rc.d/init.d/mysql start and it should work -nico -Original Message- From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 15:10 To: 'Simon Green'; '[EMAIL PROTECTED]' Subject: RE: emergency help no. Not at all. I logged into Linux server, type mysql. the server gave the message says : error 2002: can't connect to local MYSQL server through socket '/tmp/mysql.sock. Anyone has idea what's wrong with it? -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:52 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: RE: emergency help Is mysqld runing? Simon -Original Message- From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:56 To: '[EMAIL PROTECTED]' Subject: emergency help Hi, I am seeking emergency help to start up mysql database server. I tried to use myodbc to connect mysql database from windows. I added a user on mysql database user table and db table. Last Saturday when I rebooted Red Hat Linux, mysql database server didn't come back any more. I don't know whether what I did causes this problem. Now I can not connect to mysql when I use mysql command. Please help me! All of our users rely on this database. I would appreciate it if someone could give me help. Thank you!!! Sunny Ouyang Orion System, Inc 525 Avis Dr. Ann Arbor, MI 48108 (734)214-2967 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Nico Darrow RHCE CEO DeckerNET LLC Network Engineer/Programmer email:[EMAIL PROTECTED] ph:706.254.2128 The software said it worked with windows 95 or better, so I installed linux. - NA I'm not saying Bill Gates is the devil, its just that if he ever went to hell, he wouldn't need a translator. -LJ I'll do that just now. -nico Never trust a engineer that tatoo's his IP address on his arm, especially if its DHCP. - /. - 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
auto start
Somebody install Mysql and apache for me, but forgot to set it auto-boot Each time i reboot i need to do # safe_mysqld --log --user=mysql and # apachectl restart I want it auto-boot, what can i do? François Boucher [EMAIL PROTECTED]
RE: emergency help
You have old style passwords in your mysql.user table.. you need to add --old-protocol to the start line in the startup script in /etc/rc.d/init.d then you should update the passwords to the new style.. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:23 AM To: 'Rafal Jank' Cc: '[EMAIL PROTECTED]' Subject: RE: emergency help Yes. Here it is: mysqld started on Sat May 5 14:02:18 EDT 2001 /usr/local/libexec/mysqld: ready for connections mysqld started on Wed May 9 19:19:34 EDT 2001 /usr/local/libexec/mysqld: ready for connections 010524 10:41:04 Found invalid password for user: '[EMAIL PROTECTED]'; Igno ring user 010524 10:44:30 Found invalid password for user: '[EMAIL PROTECTED]'; Igno ring user 010524 11:00:51 Found invalid password for user: 'ouyang@2000ouyang'; Ignoring user 010524 13:24:04 Found invalid password for user: 'amir@2000ouyang'; Ignoring us er 010524 13:30:38 Found invalid password for user: 'amir@2000ouyang'; Ignoring us er 010524 13:30:54 Found invalid password for user: 'amir@2000ouyang'; Ignoring us er 010524 15:24:45 Found invalid password for user: 'amir@%'; Ignoring user 010524 15:31:28 Found invalid password for user: 'amir@%'; Ignoring user mysqld started on Sat Jun 2 22:18:02 EDT 2001 010602 22:18:05 Found old style password for user 'helpdesk'. Restart using --o ld-protocol mysqld ended on Sat Jun 2 22:18:05 EDT 2001 mysqld started on Mon Jun 4 09:09:20 EDT 2001 010604 9:09:22 Found old style password for user 'helpdesk'. Restart using --o ld-protocol mysqld ended on Mon Jun 4 09:09:22 EDT 2001 mysqld started on Mon Jun 4 09:44:39 EDT 2001 010604 9:44:41 Found old style password for user 'helpdesk'. Restart using --o ld-protocol 010604 9:44:41 /usr/local/libexec/mysqld: Normal shutdown 010604 9:44:41 /usr/local/libexec/mysqld: Shutdown Complete mysqld ended on Mon Jun 4 09:44:41 EDT 2001 mysqld started on Mon Jun 4 10:27:28 EDT 2001 010604 10:27:28 Found old style password for user 'helpdesk'. Restart using --o ld-protocol mysqld ended on Mon Jun 4 10:27:29 EDT 2001 [root@mothra var]# -Original Message- From: Rafal Jank [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:18 AM To: Ouyang, Sunny Cc: '[EMAIL PROTECTED]' Subject: Re: emergency help "Ouyang, Sunny" wrote: Yes. All of our mysql databases are there. Do you have error log file? It should be in /usr/local/var -Original Message- From: Luca Accomazzi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:28 AM To: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: Re: emergency help I got the message: [root@mothra /tmp]# safe_mysqld [1] 3922 [root@mothra /tmp]# Starting mysqld daemon with databases from /usr/local/var mysqld daemon ended Are your databases in there? If you do a ll /usr/local/var Do you see a directory for each database of yours, with the same names? L.A. - 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 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Bug report
Chris, you should run mysqld-max.exe on Win 98. mysqld.exe was accidentally compiled with __NT__ defined, and that causes the assertion failure. This is fixed in 3.23.39: InnoDB asks from the OS whether it is Win 95, 98, ME, or NT, 2000. MySQL documentation you find at www.mysql.com, and InnoDB at www.innodb.com. You should look at InnoDB startup options and specify them in my.cnf. Best regards, Heikki Tuuri Innobase Oy Disclaimer: I am new to MySQL, and don't know the correct procedure for submitting bugs. A quick search on Google and the MySQL site provided no clear answer to my problem. My setup: Pentium II 350 MHz, running Win98. 64MB RAM. What I tried to do: I attempted to run C:\mysql\bin\mysqld from a Dos window. I installed everything according to the default instructions. The error messages (quoted verbatim): C:\mysql\binmysqld Innobase: Assertion failure in thread 4294395831 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] 010604 11:01:09 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010604 11:01:09 Aborting InnoDB: Warning: shutting down not properly started database 010604 11:01:09 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete I'd be most grateful if someone could reply (to [EMAIL PROTECTED]) with an answer or point me to some decent documentation. I am a programmer, and would love to move to an open source database, though for the moment I have to stick with Windows. I'd like to investigate replacing our company's Access databases with MySQL, but this is a showstopper. If you need anything else, please let me know. - Chris - 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: Can't find file: './mysql/host.frm' (errno: 13)
Neglected to mention the host.frm file _does_ exist. @ ls -al /usr/local/pkg/mysql/var/mysql/ total 134 drwx-- 2 root other512 Jun 1 07:53 . drwxr-xr-x 4 mysqlmysql512 Jun 4 09:17 .. -rw-rw 1 root other 0 Jun 1 07:53 columns_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 columns_priv.MYI -rw-rw 1 root other 8778 Jun 1 07:53 columns_priv.frm -rw-rw 1 root other302 Jun 1 07:53 db.MYD -rw-rw 1 root other 3072 Jun 1 07:53 db.MYI -rw-rw 1 root other 8982 Jun 1 07:53 db.frm -rw-rw 1 root other 0 Jun 1 07:53 func.MYD -rw-rw 1 root other 1024 Jun 1 07:53 func.MYI -rw-rw 1 root other 8641 Jun 1 07:53 func.frm -rw-rw 1 root other 0 Jun 1 07:53 host.MYD -rw-rw 1 root other 1024 Jun 1 07:53 host.MYI -rw-rw 1 root other 8958 Jun 1 07:53 host.frm -rw-rw 1 root other 0 Jun 1 07:53 tables_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 tables_priv.MYI -rw-rw 1 root other 8877 Jun 1 07:53 tables_priv.frm -rw-rw 1 root other428 Jun 1 07:53 user.MYD -rw-rw 1 root other 2048 Jun 1 07:53 user.MYI -rw-rw 1 root other 9148 Jun 1 07:53 user.frm On Mon, 4 Jun 2001, Mike Broxterman wrote: Downloaded, compiled, installed, ran mysql_install_db. However, when I try to start using safe_mysqld I get the Can't find file error. root@qsv-cmxdb1:...pkg/mysql bin/safe_mysqld Starting mysqld daemon with databases from /usr/local/pkg/mysql/var 010604 08:44:28 mysqld ended root@qsv-cmxdb1:...pkg/mysql tail var/qsv-cmxdb1.err 010604 08:44:28 mysqld started 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Normal shutdown 010604 08:44:28 mysqld ended mysqld Ver 3.23.38 for sun-solaris2.6 on sparc basedir: /usr/local/pkg/mysql/ datadir: /usr/local/pkg/mysql/var/ tmpdir: /var/tmp/ language:/usr/local/pkg/mysql/share/mysql/english/ pid file:/usr/local/pkg/mysql/var/qsv-cmxdb1.pid binary log: replication.log binary log index: TCP port:3306 Unix socket: /tmp/mysql.sock Options used to build mysql; sh CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/pkg/mysql --without-bench --without-debug --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
mysqlgui 1.7.5
I have been unable to use the create table or edit table features of mysqlgui. Are this meant to work out of the box or is there more configuration I must do? I have tried with both 1.7.4 for Windows and 1.7.5 for Linux. Thanks - 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 more questions on Replication
database,sql Hi again I have some questions re: Replication My sites are all connected via a dial-up modem, so I have a program what once a day will dialup and connect Site A to Site B, 1. how do I get the slave to start updating right there on the spot without having to wait 2. how do I know when the slave is finished, so that I can disconnect the dial-up line? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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
Replication out of sync
Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct address. Now the question is, what is the easiest way of getting them in sync? Do I delete the table from the one server reload it? Currently my set it is :- Server A is a slave of Server B Server B is a slave of Server A I have done it like this, because I will soon be changing it to : Server A is a slave of Server B Server B is a slave of Server C Server C is a slave of Server A I want all three sites to run replicated databases, and all three sites add/amend/delete records. I currently have the first setup running and working well. Kind Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug: mysql uses temp filesort instead of index
SM == Sinisa Milivojevic [EMAIL PROTECTED] wrote the following on Mon, 4 Jun 2001 13:41:08 +0300 (EEST) SM One more thing. SM Can you try to run ANALYZE TABLE on sequence_data and see if SM that changes anything ... I got the +--+-+--+--+ | Table| Op | Msg_type | Msg_text | +--+-+--+--+ | sqmail.sequence_data | analyze | status | OK | +--+-+--+--+ message, but everything is the same as before (query still takes a long time and explain says it is still using filesort). JDZ What about if you use BETWEEN()? JDZ I meant to suggest that earlier, too, but I, uh... forgot. Sorry, no dice. It probably converts BETWEEN to standard comparisons anyway. -- Ben Escoto - 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
Serious security bug?
Description: User able to (accidentally!!) change/reset their own password despite not having *any* access to the mysql database How-To-Repeat There's the trick. We can't reproduce but this happened twice. However the setup of our (very recent) mysql installation is so simple that it's very clear this did in fact happen. I installed mysql, ran it using the default (no arg) safe_mysqld script, and immediately set the root password (for the machine name and for localhost), and then added a single user paul, again setting his password for both machine name and localhost. I gave him SELECT, INSERT, DELETE, CREATE, DROP, ALTER, UPDATE privs for a single database, also named paul (could this be related to the bug?), and double-checked that he had no permissions for the mysql database (all columns set to N in user; 2 entries in db specifying access to Db paul. The user set up some PHP (4) scripts to work with his database, and I didn't do anything further to mysql until a week later he emailed me complaining that he was suddenly getting permission denied errors from his scripts, and from his own installation of phpMyAdmin (which I had previously verified was working fine). I checked in mysql database and saw that the password for paul@localhost had been removed. Since his scripts were still using the password, he was being refused. This made a somewhat uneasy, but I reasoned that perhaps I had erroneously set him up with no password for localhost, but only for the machine name, and that DNS or identd was (for no good reason) suddenly resolving his connection host differently. I reset his password. A few days later he emailed me again -- same problem. I looked in mysql and saw that *both* his passwords (identical) had been replaced with the cleartext versions instead of the encrypted. At this point I figured he was hacking the system himself, as why would anyone else accidentally set his passwords to the cleartext version? Yet from talking with him (and given the fact that he keeps reporting the problem to me as soon as it occurs) I don't think he knows what is going on. Unfortunately I hadn't run the server with logging enabled (I had mistakenly thought this would be a default) so my ability to troubleshoot was hindered. I did see on both occasions that the filesystem modification times for the USER.xxx files for the mysql database were shortly before the user reported the problem. To further add to my confusion, the database he had set up (again having the same name as his username) contained tables named users, and authdb. He was storing his own passwords for his users and doing MD5 encryption with PHP funtions. So he has since renamed his tables thinking superstitiously that maybe MySQL was getting confused at some statement (I am increasingly inclined to believe him) and I've enabled logging and reset the root password. He remains the *only* non-root user and I am the *only* one with the root password. The problem so far has not recurred (it last happened last Thursday). Fix: ??? Submitter-Id: submitter ID Originator: Jason Boyd Organization: Boston University MySQL support: none Synopsis: User changing his password without permission Severity: serious Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.37 (Official MySQL binary) Environment: Intel PIII, BU Linux (a RedHat 6.2-derived installation) System: Linux louis-xiv.bu.edu 2.2.16-3smp #1 SMP Mon Jun 19 19:00:35 EDT 2000 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/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='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Mar 1 09:56 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101804 Jan 18 11:05 /lib/libc-2.1.3.so -rw-r--r--1 root root 20276140 Jan 18 11:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 18 11:05 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Mar 1 10:05 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - 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: RE: UPDATE and ORDER BY troubles
Well, Jeff you are right! I've just taken the wrong line from .mysql_history file. It was one of my thousands of tries to make the ORDER BY work with UPDATE. What I really try to do is ORDER BY the 'received' column, which is a timestamp. The point is if I have plenty of alarm messages which are not parsed I would like to take and parse the one that has come first in time. And because this is done from concurent clients it is crucial to parse it with just one update query and not with ordered select and then update. So here is the real query: mysql UPDATE alarms SET is_parsed=1 WHERE is_parsed=0 ORDER BY received LIMIT 1; ERROR 1064: You have an error in your SQL syntax near 'ORDER BY received LIMIT 1' at line 1 What I found is that UPDATE SET WHERE ORDER BY never works in MySQL no matter what your table looks like. And according to MySQL manual the UPDATE synthax is: UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [ORDER BY ...] [LIMIT #] Is this a bug in MySQL or the manual is not correct?!? Has anyone managed to use ORDER BY with an UPDATE statement? Thank you in advance! George Jeff wrote: Why do you need the ORDER BY clause? Can you take it out? For example: UPDATE alarms SET is_parsed=1 WHERE is_parsed=0 LIMIT 1; I just don't think the ORDER BY clause could serve any useful purpose there and appears to actually cause problems. Good luck, Jeff -Original Message- Hi! The MySQL manual states that you can use ORDER BY in combination with the UPDATE statement. So I tried to use it, but it didn't work. Here is the sql query that's causing the trouble: mysql UPDATE alarms SET is_parsed=1 WHERE is_parsed=0 ORDER BY is_parsed LIMIT 1; ERROR 1064: You have an error in your SQL syntax near 'order by is_parsed limit 1' at line 1 The same error happens when I don't use LIMIT: mysql UPDATE alarms SET is_parsed=1 WHERE is_parsed=0 ORDER BY is_parsed; ERROR 1064: You have an error in your SQL syntax near 'order by is_parsed' at line 1 Here is the table's structure: CREATE TABLE alarms ( serial int(10) unsigned NOT NULL auto_increment, sys_num tinyint(2) unsigned NOT NULL default '1', rtu_num smallint(4) unsigned NOT NULL default '0', status char(2) NOT NULL default 'XX', received datetime default NULL, device tinyint(2) unsigned NOT NULL default '0', is_parsed tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (serial), KEY is_parsed (is_parsed), KEY rtu_num (rtu_num) ) TYPE=MyISAM; Áåçïëàòíà ïîùåíñêà ñëóæáà http://mail.Rambler.bg/ - 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
restore table?
I accidently overote a table in my database. I need to restore an individual table from a backup that I made on tape drive with dump. How can I restore just the individual table with restore -i. Richard - 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
Logging
Hi All, I'm trying to turn on logging for MySQL 3.23.36 and upon running /etc/rc.d/init.d/mysqld start --log=/var/log/somefilename I still get Log|OFF when I run mysqladmin variables I'm running MySQL 3.23.36 on RedHat 7.1 Thanks! Glenn - 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
newbie theory question
Hi all, I have recently set up a linux box with red hat 7.1. i installed mysql and php and apache and have a really cool development area that works nicely. i am running mysql 3.23.32 and would like to upgrade it ... on the mysql site it has patches and full server rpm's ... what should i be doing to upgrade? do i download a patch with the newest version or do a complete install of the latest server rpm? i've read the section in the manual and it helps me with the actual install but not this patch vs full rpm idea ... sorry if i missed something really obvious ... i am off to tinker with it but any help would be great! thanks, august simonelli - 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 how to undo concat
Hi, I have a database column of char(250); I can insert enmass a string into said column using: update tablename set columnname = concat(columnname, 'string'); but how do I undo that? Is there a function that is exactly the reverse of concat such that: update tablename set columnname = unconcat(columnname, 'string'); will actually delete 'string' pattern from columnname? thanks Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query Help
I have a database which has about 100,000 emails. I need to write some function to retrieve the domains of all these emails, and the count of each, to help catch cheaters. I began by just selecting all the emails with my query, and trying to use PHP to do all the work, but I think this could all be done w/ mysql. I'm thinking there must be some way, using the string functions, to write a query that just retrieves the domain of each email, and then I could use DISINCT and COUNT for the rest. By domain, I mean this: [EMAIL PROTECTED] becomes yahoo.com, [EMAIL PROTECTED] becomes subdomain.domain.com. If anyone could help me out with this query, I'd really appreciate it. TIA, Daren Cotter - 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
ODBC problem
Dear Sir, For many times, I encountered the same problem as the follow. Maybe it is a general question for you. Would you please reply me the method to correct the program? Best Regards, Freda -- Error prompt==after running several days,ODBC configuration Windows appear and stay there, application blocked. Once start the MySql server again, it is normal. MySQL Version=MySql 3.23.30 MyODBC VersionODBC 2.50.29 ODBC configurationall tags off Pletform OS===Microsoft NT/2000 Pletform CPU==PII/PIII Pletform Memory===256KB Pletform HD===30GB Application===multi-threads read/write database, running in the same machine with MySql server. Language==VC 6.0 Users=Max 5 users Running periodseveral days My.cnf= My.cnf=== # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = connect_timeout=2000 set-variable = max_connections=16384 set-variable = max_connect_errors=65536 set-variable = delayed_insert_limit=1 set-variable = delayed_insert_timeout=6000 set-variable = long_query_time=1000 set-variable = max_delayed_threads=500 set-variable = table_cache=256 set-variable = back_log=500 set-variable = wait_timeout=2073600 #set-variable = max_user_connections=0 low-priority-updates log-update log # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb === MySql.err MySql.err== 010531 16:28:50 Aborted connection 11960 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 16:40:09 Aborted connection 12187 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 16:53:16 Aborted connection 12257 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 16:59:19 Aborted connection 12330 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 17:31:16 Aborted connection 12953 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 17:46:35 Aborted connection 13112 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010601 17:05:32 Aborted connection 17760 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010601 18:14:35 Aborted connection 17821 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 27416 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12387 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12430 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12513 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12583 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12558 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12603 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12632 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12652 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12855 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 13349 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 14676 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 14810 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 14835 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection
RE: I can't un-subscribe
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: June 04, 2001 11:27 AM To: Darin E. Sease Subject: Re: I can't un-subscribe 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 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: I have tried to unsubscribe several times. I would like to be taken off this list. - 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
Can mysql_close (conn) Be Modified to Close the Handle Immediately? (Possible Feature Request)
Greetings: I haven't seen any discussions on reducing the duration of a network connection on port 3306 after issuing a mysql_close, so it makes sense to inquire whether anyone has addressed this. The code follows: // main.c #include mysql.h if ((conn = do_connect (BTIME_HOST, USER, BTIME_PW, BTIME_DB, 0, NULL, 0)) == 0); // trivial processing of a quick insert, or update; no output mysql_close (conn); do_connect does the usual, such as mysql_init(), and some error checking (trivial), then, passes back: return(conn) on success. My question (probably best addressed by someone with intimate knowledge of the mysql_close code) is that while testing, I found the connection stays present for about a minute: vanboers@sedona:~$ while true; do date; netstat -tn | grep 3306; sleep 1; done Mon Jun 4 23:55:52 MST 2001 tcp0 0 192.168.1.12:38012 192.168.1.14:3306 TIME_WAIT snipped Mon Jun 4 23:56:52 MST 2001 tcp0 0 192.168.1.12:38012 192.168.1.14:3306 TIME_WAIT Mon Jun 4 23:56:53 MST 2001 Mon Jun 4 23:56:54 MST 2001 It's not a big deal, but, the question remains that, if the connection has been closed (meaning processing is complete), then, there should be no reason for the network connection to remain in TIME_WAIT state. The application in question has potential to create a large volume of such connections on an ongoing basis, and, particularly at times when there is high volume of logging in and logging out of the network at large (i.e. 9 am, 12pm, 1pm, 5pm), which could become an issue on available connections depending on scale and installation base. Perhaps this is more a function of the 2.4.5 linux kernel TCP code, than mysql_close, but, I'm not aware of any such 60 second implementation in the kernel code. If this is a MySQL issue, please advise. I've no problem with disseminating the full source to any interested party. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.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
Need Japanese character set files
Hi, I am storing Japanese data inside MySQL. MySQL supports all the Europian languages and other languages like korian and Hebru, and you have all the character set files for all these languages inside the C:\mysql\share\charsets directory. But this directory does not contain Japanese character set files. Where can I get these files? Waiting for the reply. Thanks, Narendra Phadke - 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
Error From JBDC Driver
I am running the attached file on Red Hat 7.1 and getting the following error SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 Thanks Anthony __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.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: auto start
Francois Boucher wrote: Somebody install Mysql and apache for me, but forgot to set it auto-boot Each time i reboot i need to do # safe_mysqld --log --user=mysql and # apachectl restart I want it auto-boot, what can i do? François Boucher [EMAIL PROTECTED] Francois: This is a UNIX/Linux question, but, I see your dilemma. It's a shame you're finding it necessary to reboot. The following should save you for now: cat /etc/rc.d/rc.local safe_mysqld --log --user=mysql apachectl restart [ctrl][d] That should take care of it. Mind the double redirect , or you may lose something else. You might want to brush up on the *n*x init process, also. Just a tip. Regards, Van -- = Linux rocks!!! http://www.dedserius.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: auto start
On Mon, 4 Jun 2001, Francois Boucher wrote: Somebody install Mysql and apache for me, but forgot to set it auto-boot Each time i reboot i need to do # safe_mysqld --log --user=mysql and # apachectl restart I want it auto-boot, what can i do? If you want to auto-boot, you should first tell us your OS type. In most linuxes commands ntsysv and linuxconf can do the thing but not always. Tonu - 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
problemi compiling simpl1.cpp for borland
i download the borland compiler ver 5.5 but i've got some problems... Anyone have a sample line for compiling with bcc32? this is the line that i'm trying but it doesn't work...(i attach the log) bcc32 -Ic:\borland\bcc55\include;c:\mc\include\mysql;c:\mc\include\sqlplus - Lc:\borland\bcc55\lib;c:\mc\lib\deb simple1.cpp log.txt thanks Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland simple1.cpp: Warning W8038 c:\mc\include\sqlplus\type_info1.hh 23: Constant member 'mysql_ti_sql_type_info::_base_type' is not initialized in function mysql_ti_sql_type_info::mysql_ti_sql_type_info() Warning W8038 c:\mc\include\sqlplus\type_info1.hh 23: Constant member 'mysql_ti_sql_type_info::_default' is not initialized in function mysql_ti_sql_type_info::mysql_ti_sql_type_info() Warning W8027 c:\mc\include\sqlplus\const_string1.hh 39: Functions containing while are not expanded inline Warning W8027 c:\mc\include\sqlplus\const_string1.hh 63: Functions containing while are not expanded inline Warning W8027 c:\mc\include\sqlplus\const_string1.hh 54: Functions containing some if statements are not expanded inline in function const_string::at(unsigned int) const Warning W8026 c:\mc\include\sqlplus\bad_query.hh 7: Functions taking class-by-value argument(s) are not expanded inline in function MysqlBadQuery::MysqlBadQuery(string) Warning W8026 c:\mc\include\sqlplus\sql_query1.hh 92: Functions taking class-by-value argument(s) are not expanded inline in function SQLParseElement::SQLParseElement(string,char,char) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\sql_query1.hh 195: Functions containing some return statements are not expanded inline in function SQLQuery::str(const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ,const SQLString ) Warning W8027 c:\mc\include\sqlplus\row1.hh 250: Functions containing for are not expanded inline Warning W8027 c:\mc\include\sqlplus\row1.hh 269: Functions containing some if statements are not expanded inline in function MysqlRow::operator [](int) const Warning W8027
PHP with MySQL and RPM files
$ MYSQL=/usr/local/mysql $ ./configure --with-mysql=$MYSQL Then PHP finds the following files in $MYSQL/lib: $ ls $MYSQL/lib libdbug.a libmygcc.a libmysqlclient.a libmystrings.a libmysys.a With the RPM files one finds: $ ls /usr/lib/mysql libdbug.a libmerge.a libmyisammrg.alibmysqlclient.la libmysys.a libheap.a libmyisam.a libmysqlclient.a libmystrings.a libnisam.a and the file libmygcc.a seems to be missing. It appears to me that it is impossible to specify the following when compiling PHP because configure will look in /usr/lib/mysql/lib which will not exist: ./configure --with-mysql=/usr/lib/mysql This is wrong but it is quite unfortunate that it is wrong because this makes the RPM installation virtually unusable with PHP. Perhaps the configure script in PHP should be patched (?). Other than that it is important to compile --with-zlib when using --with-mysql or the programs will compile fine but when starting apache you will get an error about uncompress. Also make sure that /usr/src/linux is a symbolic link to the kernel source tree or make will not find some .h files and compilation will not be possible. The easiest way to recompile PHP with MySQL support is probably to add --with-mysql=/usr/local/mysql to the php.spec file and run rpm -ba php.spec and then install the RPM files. Any feedback is welcome, Neil - 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
Newbie problems:I blew it up *sigh*
Hi! I just installed mysql 3.23.38b max to my Suse Linux 6.2. Everything worked fine until I wanted row locking. I created innodb table and tried the instructions from manual and curiosly, those did not work - transactions committed automatically regardless what I did. Then I looked the manual up for more and found out it said - set the innodb options. I did. I set these on the root directory of mysql (/usr/local/mysql) .my.cnf. # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:25M;ibdata2:25M;ibdata3:25M;ibdata4:25M innodb_data_home_dir = /usr/local/mysql/var/ innodb_log_group_home_dir = /usr/local/mysql/var/ innodb_log_arch_dir = /usr/local/mysql/var/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 ... After this the system segmentation faults: mysql@bonn:~ ./support-files/mysql.server ./support-files/mysql.server: @HOSTNAME@: command not found usage: ./support-files/mysql.server start|stop mysql@bonn:~ ./support-files/mysql.server start ./support-files/mysql.server: @HOSTNAME@: command not found mysql@bonn:~ Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld: line 274: 15129 Segmentation fault $NOHUP_NICENESS $ledi r/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTIO N --pid-file=$pid_file --skip-locking $err_log 21 010605 11:24:54 mysqld ended And even if I recomment the innodb's it still crashes : mysql@bonn:~ ./support-files/mysql.server start ./support-files/mysql.server: @HOSTNAME@: command not found mysql@bonn:~ Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld: line 274: 15163 Segmentation fault $NOHUP_NICENESS $ledi r/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTIO N --pid-file=$pid_file --skip-locking $err_log 21 010605 11:26:11 mysqld ended Any clue, anyone ? ___ To get your own FREE ZDNet Onebox - FREE voicemail, email, and fax, all in one place - sign up today at http://www.zdnetonebox.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 C API and mysql
hello everybody. Ive been working with perl and mysql for some time, but recently i had to move over to C and as such i wrote a small test program, just to get to know the mysql C API. Well, things didnt go as i thought. i kept getting linking problems and in the end my test program was limited to the few lines bellow: #include stdlib.h #include mysql.h #include unistd.h #include stdio.h int main(){ MYSQL *mysql; mysql = mysql_init(NULL); if (mysql == NULL) { fprintf(stderr,mysql_init() failed (foobar\n); exit(1); } } + i compile this with: gcc -I/usr/local/mysql/include/ -L/usr/local/mysql/lib/ program.c -lmysqlclient but i always get the error message: /usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status doing an nm on libmysqlclient.a does reveal that the compress functions are there,but for some reason it wont work. appriciate any/all help regards [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
Replication out of sync
Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct address. Now the question is, what is the easiest way of getting them in sync? Do I delete the table from the one server reload it? Currently my set it is :- Server A is a slave of Server B Server B is a slave of Server A I have done it like this, because I will soon be changing it to : Server A is a slave of Server B Server B is a slave of Server C Server C is a slave of Server A I want all three sites to run replicated databases, and all three sites add/amend/delete records. I currently have the first setup running and working well. Kind Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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: PHP and MySQL result set navigation
If you want to repeatedly loop through a result set in PHP, you can use mysql_data_seek($result, 0); to reset the pointer to the first row. See http://www.php.net/manual/en/function.mysql-data-seek.php -steve At 9:33 AM +0800 6/4/01, Rolf Hopkins wrote: Yep, that's the way you do it. Put it into a 2D array or even better, a class. That's if you are familiar with OOP. - Original Message - From: Marco Bleeker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 04, 2001 6:57 Subject: PHP and MySQL result set navigation I do something like this, where $result is the result of a mysql_query(): ?php while ($row = mysql_fetch_array($result)) { if ($row[col] == 1) { print_entry($row); } } ? This is to fill one column on screen. Now I would like to do the same for the second column: if ($row[col] == 2). But the $result pointer has moved to the end. How to move it back to the start again? reset() won't work, because it's not an array, just an integer pointing to a MySQL result set. How to move through this result set using PHP? Or should I just run a seperate query for each column with a 'where col =' clause? That looks like pretty intensive use of computer resources... I could also turn the result set into a 2D array of rows and work with that. Sounds a bit voluminous as well... Thanks, marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! -- +--- So long, and thanks for all the fish - -+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- Douglas Adams 1952 - 11 may 2001 ---+ - 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: Can't find file: './mysql/host.frm' (errno: 13)
Mike Broxterman wrote: Neglected to mention the host.frm file _does_ exist. @ ls -al /usr/local/pkg/mysql/var/mysql/ total 134 drwx-- 2 root other512 Jun 1 07:53 . drwxr-xr-x 4 mysqlmysql512 Jun 4 09:17 .. -rw-rw 1 root other 0 Jun 1 07:53 columns_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 columns_priv.MYI -rw-rw 1 root other 8778 Jun 1 07:53 columns_priv.frm -rw-rw 1 root other302 Jun 1 07:53 db.MYD -rw-rw 1 root other 3072 Jun 1 07:53 db.MYI -rw-rw 1 root other 8982 Jun 1 07:53 db.frm -rw-rw 1 root other 0 Jun 1 07:53 func.MYD -rw-rw 1 root other 1024 Jun 1 07:53 func.MYI -rw-rw 1 root other 8641 Jun 1 07:53 func.frm -rw-rw 1 root other 0 Jun 1 07:53 host.MYD -rw-rw 1 root other 1024 Jun 1 07:53 host.MYI -rw-rw 1 root other 8958 Jun 1 07:53 host.frm -rw-rw 1 root other 0 Jun 1 07:53 tables_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 tables_priv.MYI -rw-rw 1 root other 8877 Jun 1 07:53 tables_priv.frm -rw-rw 1 root other428 Jun 1 07:53 user.MYD -rw-rw 1 root other 2048 Jun 1 07:53 user.MYI -rw-rw 1 root other 9148 Jun 1 07:53 user.frm Mike: Any possibility you could have root do a chown mysql.mysql /usr/local/pkg/mysql/var/mysql/ -R? Then rerun the install_db. Looks like your package missed a step: chown. Regards, Van -- = Linux rocks!!! http://www.dedserius.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
how to create username/password in mysql for linux???
hello, i'm new to mysql, so please bear with me. i installed the mysql 3.23.38 rpm package for linux. how do i create a username and password? from which directory should this be done from? also, from which directory can i connect to mysql? tia if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript } - 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: Clarification wanted
On Mon, Jun 04, 2001 at 02:44:28PM +0530, [EMAIL PROTECTED] wrote: Hi, We are developing a portal which has pictures of machines in the form of HTML pages. I want to know whether I can store HTML in You can. 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 10 days, processed 62,627,116 queries (71/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_install_db.sh
Hello , my name is helene daignault ,I wsould like to know if I can receive more explicit explication to install mysql server on my mandrake 7.2 , I've done everithing in the manual , but I always got the error when I try to install mysql_install_db.sh you should do a make install before executing this script , well . Tell me , or send me explicit information or any referenced cause IO really need Mysql installed . Thancks a lot and sorry for my english . Helene - 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
ODBC question, please reply to an new email address.
Dear Sir, For many times, I encountered the same problem as the follow. Maybe it is a general question for you. Would you please reply me the method to correct the program? Because the network reason, please reply to [EMAIL PROTECTED]. Best Regards, Freda -- Error prompt==after running several days,ODBC configuration Windows appear and stay there, application blocked. Once start the MySql server again, it is normal. MySQL Version=MySql 3.23.30 MyODBC VersionODBC 2.50.29 ODBC configurationall tags off Pletform OS===Microsoft NT/2000 Pletform CPU==PII/PIII Pletform Memory===256KB Pletform HD===30GB Application===multi-threads read/write database, running in the same machine with MySql server. Language==VC 6.0 Users=Max 5 users Running periodseveral days My.cnf= My.cnf=== # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = connect_timeout=2000 set-variable = max_connections=16384 set-variable = max_connect_errors=65536 set-variable = delayed_insert_limit=1 set-variable = delayed_insert_timeout=6000 set-variable = long_query_time=1000 set-variable = max_delayed_threads=500 set-variable = table_cache=256 set-variable = back_log=500 set-variable = wait_timeout=2073600 #set-variable = max_user_connections=0 low-priority-updates log-update log # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb === MySql.err MySql.err== 010531 16:28:50 Aborted connection 11960 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 16:40:09 Aborted connection 12187 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 16:53:16 Aborted connection 12257 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 16:59:19 Aborted connection 12330 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 17:31:16 Aborted connection 12953 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010531 17:46:35 Aborted connection 13112 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010601 17:05:32 Aborted connection 17760 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010601 18:14:35 Aborted connection 17821 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 27416 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12387 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12430 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12513 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12583 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12558 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12603 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12632 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12652 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 12855 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 13349 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 14676 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 14810 to db: 'ctidb' user: 'root' host: `localhost' (Unknown error) 010604 16:38:14 Aborted connection 14835 to db: 'ctidb' user: 'root' host:
RE: Some more questions on Replication
Hi Warren I think what you what to do is more of a backup. Replication is set up to be connected all the time. It helps with redundancy and load sheared. Do you what to merge the DB's one a day? Simon -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 17:52 To: [EMAIL PROTECTED] Subject: Some more questions on Replication database,sql Hi again I have some questions re: Replication My sites are all connected via a dial-up modem, so I have a program what once a day will dialup and connect Site A to Site B, 1. how do I get the slave to start updating right there on the spot without having to wait 2. how do I know when the slave is finished, so that I can disconnect the dial-up line? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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
What is the error in this sql query
What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID), INDEX(page_ID) ) - 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
mysqlhotcopy ..
but i still got no idea how to run mysqlhotcopy ? run in where ? how ? Original Message- On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote: i have no idea on how to run mysqlhotcopy in the query tool or it is not suppose to run in query tool. is this correct ? mysqlhotcopy db_name '/downloads/backupDB/' It's a stand-alone tool. If you run it without any command-line arguments, it will give you usage information (like all good tools do). 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 7 days, processed 44,321,200 queries (72/sec. avg) /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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
Select query
Database... SElect Query. Please subcribe me in digest mode Thanks - 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 more questions on Replication
database,sql Hi again I have some questions re: Replication My sites are all connected via a dial-up modem, so I have a program what once a day will dialup and connect Site A to Site B, 1. how do I get the slave to start updating right there on the spot without having to wait 2. how do I know when the slave is finished, so that I can disconnect the dial-up line? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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: Serious security bug?
On Mon, 4 Jun 2001 [EMAIL PROTECTED] wrote: Description: User able to (accidentally!!) change/reset their own password despite not having *any* access to the mysql database How-To-Repeat There's the trick. We can't reproduce but this happened twice. However the setup of our (very recent) mysql installation is so simple that it's very clear this did in fact happen. Fix: ??? Hello! I am the MySQL Security Administrator and responsible for security stuff. I carefully read through your bugreport and understood it. Meanwhile like youself I do not know how to reproduce this bug. Next I will check the code in related places but I don't think that this will be successful. But on comment I have: Environment: Intel PIII, BU Linux (a RedHat 6.2-derived installation) System: Linux louis-xiv.bu.edu 2.2.16-3smp #1 SMP Mon Jun 19 19:00:35 EDT 2000 i686 unknown All linux kernels below 2.2.19 contain buffer overflow problem which allows any shell user to get a root. Maybe someone is already in your system and MySQL problem appeared because he makes backdoors for himself? Tonu - 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: Logging
Have a look at /etc/my.cnf Simon -Original Message- From: Glenn Emery [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 19:14 To: [EMAIL PROTECTED] Subject: Logging Hi All, I'm trying to turn on logging for MySQL 3.23.36 and upon running /etc/rc.d/init.d/mysqld start --log=/var/log/somefilename I still get Log|OFF when I run mysqladmin variables I'm running MySQL 3.23.36 on RedHat 7.1 Thanks! Glenn - 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: Some more questions on Replication
Hi Nope you are wrong. I want it exactly the way it is. I have three sites, all must have access to the same data, within 24 hours. Therefore I don't want to have to backup and restore, I want to dialin, receive the latest, and disconnect. My setup will be triangular, so that once Site A has updated Site B, Site B will dialin and update Site C, and then C will update A. It works fine, except the two questions I have asked. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 09:52 To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: Some more questions on Replication Hi Warren I think what you what to do is more of a backup. Replication is set up to be connected all the time. It helps with redundancy and load sheared. Do you what to merge the DB's one a day? Simon -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 17:52 To: [EMAIL PROTECTED] Subject: Some more questions on Replication database,sql Hi again I have some questions re: Replication My sites are all connected via a dial-up modem, so I have a program what once a day will dialup and connect Site A to Site B, 1. how do I get the slave to start updating right there on the spot without having to wait 2. how do I know when the slave is finished, so that I can disconnect the dial-up line? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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
JDBC - UnknownHostException
Hello, I am running RedHat=7.1, MySQL= 3.23.36, JDBC = mm.mysql-2.0.4 and Java =1.3.1. I am trying to open MySQL through the JDBC driver and get the java.net.UnknownHostException error...this is all on one machine I have used the MySQL db with perl and it seems fine. I have tried localhost, 127.0.0.1, the host name and the real IP address in the host part of the URL to no avail. I do have port 3306 in the URL and have checked the mysql config file to make sure it agrees...so there seems to be a MySQL server running on the machine/port that I am trying to connect toBUT java.net.InetAddress.getAllByName0.java:571 throws the exception. I have now gone through the archives and can't find a similar problem...RedHat has fixed the localhost.localdomain problem in 7.1. What am I missing? TIA Jim - 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
Can't find file: './mysql/host.frm' (errno: 13)
Downloaded, compiled, installed, ran mysql_install_db. However, when I try to start using safe_mysqld I get the Can't find file error. root@qsv-cmxdb1:...pkg/mysql bin/safe_mysqld Starting mysqld daemon with databases from /usr/local/pkg/mysql/var 010604 08:44:28 mysqld ended root@qsv-cmxdb1:...pkg/mysql tail var/qsv-cmxdb1.err 010604 08:44:28 mysqld started 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Normal shutdown 010604 08:44:28 mysqld ended mysqld Ver 3.23.38 for sun-solaris2.6 on sparc basedir: /usr/local/pkg/mysql/ datadir: /usr/local/pkg/mysql/var/ tmpdir: /var/tmp/ language:/usr/local/pkg/mysql/share/mysql/english/ pid file:/usr/local/pkg/mysql/var/qsv-cmxdb1.pid binary log: replication.log binary log index: TCP port:3306 Unix socket: /tmp/mysql.sock Options used to build mysql; sh CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/pkg/mysql --without-bench --without-debug --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
RE: Query Help
select distinct substring_index(email, @, -1) as Domain from users Hope this helps Simon -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 04:02 To: [EMAIL PROTECTED] Subject: Query Help I have a database which has about 100,000 emails. I need to write some function to retrieve the domains of all these emails, and the count of each, to help catch cheaters. I began by just selecting all the emails with my query, and trying to use PHP to do all the work, but I think this could all be done w/ mysql. I'm thinking there must be some way, using the string functions, to write a query that just retrieves the domain of each email, and then I could use DISINCT and COUNT for the rest. By domain, I mean this: [EMAIL PROTECTED] becomes yahoo.com, [EMAIL PROTECTED] becomes subdomain.domain.com. If anyone could help me out with this query, I'd really appreciate it. TIA, Daren Cotter - 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
mysqldump
i saw % myswldump samp_db /usr/archieves.mysql.samp_db.1999-10-02 syntax in the Paul Dubois mySQL book, but this is command for unix, how abt windows syntax ?? /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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
Embedded System
Hallo, I only got one question: Will there be an embedded version of MySQL for PDAs, like Palm or Compaq. Greetings Richard Cochius
Re: I can't un-subscribe
Darin E. Sease wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: June 04, 2001 11:27 AM To: Darin E. Sease Subject: Re: I can't un-subscribe 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 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: I have tried to unsubscribe several times. I would like to be taken off this list. - 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 Darin: That's because you use this particular e-mail client: X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) It limits and compromises you in many ways, but, we won't go into that. Hit this link: http://lists.mysql.com/php/unsubscribe.php It's all right there in front of you, unless you use Outlook. And, you do. But, we won't go into that. Once unsubscribed, you'll no longer have to endure warnings against using Outlook at your peril. Who wants to be warned that they're using software that compromises them. Would make me shudder to receive such bad news. Better to not know, I'd think. Regards, Van -- = Linux rocks!!! http://www.dedserius.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: What is the error in this sql query
have_vote ENUM (3), must be this: have_vote ENUM ('3'), Greetings, Ansgar What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID), INDEX(page_ID) ) - 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
Scripts
Hi, I created some Scripts of the Type *.sql. In these Scripts there are pure SQL Statements, seperated by a ';'. How can I execute those Scripts (automated) in mySQL? Is there a possibility to make one Script, that starts other scripts... Can anybody help me? thanx Manuel - 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: What is the error in this sql query
I believe the ENUM-length is faulty! It should be somthing like this: have_vote ENUM(yes, no), Check the manual: http://www.mysql.com/doc/E/N/ENUM.html \d -Original Message- From: Syed sumair [mailto:[EMAIL PROTECTED]] Sent: den 1 juni 2001 01:11 To: MySQL List Subject: What is the error in this sql query What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID), INDEX(page_ID) ) - 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
Query - Performing a Join with a Count()
Hi, I have two tables: TBPersons IDPERSON NAME AGE TBCOURSES IDCOURSE IDPERSON TITLE DESCRITION Each Person have (or may have) many courses. I want to perform a query that retrieves the total of courses for each person, displaying also the name and age. Can someone please help me with this?! Many Thanks, Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com --=_NextPart_000_0046_01C0ED6F.25159CA0 Content-Type: text/html; charset=Windows-1252 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Dwindows-1252 META content=3DMSHTML 5.50.4611.1300 name=3DGENERATOR/HEAD BODY DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2Hi,/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial size=3D2I have = two=20 tables:/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2lt;TBPersonsgt;/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2IDPERSON/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2NAME/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2AGE/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2lt;TBCOURSESgt;/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2IDCOURSE/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2IDPERSON/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2TITLE/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2DESCRITION/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial size=3D2Each = Person have (or=20 may have) many courses./FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial size=3D2I want = to perform a=20 SELECT that retrieves the total of courses for each person, displaying = also the=20 name and age./FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial size=3D2Can = someone please=20 help me with this?!/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial size=3D2Many=20 Thanks,/FONT/SPAN/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D650042102-05062001 DIVFONT face=3DArial size=3D2Jorge Oliveira/FONT/DIV DIVFONT face=3DArial size=3D2A=20 href=3Dmailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A/FONT/DIV= DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial=20 size=3D2/FONT= /DIV DIVFONT face=3DArial size=3D2FONT face=3DVerdana size=3D1=A9 = /FONTwebfroggie.com -=20 Recursos Online!/FONT/DIV DIVFONT face=3DArial size=3D2web: A=20 href=3Dhttp://www.webfroggie.com/;http://www.webfroggie.com/A/FONT= /DIV DIVFONT face=3DArial size=3D2wap: A=20 href=3Dhttp://www.webfroggie.com/;http://www.webfroggie.com/A/FONT= /DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIVFONT face=3DArial=20 size=3D2/FONT/SPAN/DIV/BODY/HTML --=_NextPart_000_0046_01C0ED6F.25159CA0-- - 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
URGENT Disappear - Reappear Problem
We have a table whose entries seem to be disappearing at random. We are accessing our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine. Up until yesterday, we would lose about one entry per week in a single table. The rest of the tables seem fine. However, yesterday one of our entries reappeared. Our affected table has 39 fields with one auto-increment primary key zerofill field. isamchk returned that everything was fine. Has anyone seen this happen before? Thanks in advance. Shawn McKenney [EMAIL PROTECTED]
Re: Problem with C API and mysql
kenneth johansen wrote: } + i compile this with: gcc -I/usr/local/mysql/include/ -L/usr/local/mysql/lib/ program.c -lmysqlclient add -lz -- 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: JDBC - UnknownHostException
Jim, Could you post the whole exception frame? Also, run ping whatever JDBC driver uses and make sure the name/address can be resolved. Kevin Bombardier Systems Consulting wrote: Hello, I am running RedHat=7.1, MySQL= 3.23.36, JDBC = mm.mysql-2.0.4 and Java =1.3.1. I am trying to open MySQL through the JDBC driver and get the java.net.UnknownHostException error...this is all on one machine I have used the MySQL db with perl and it seems fine. I have tried localhost, 127.0.0.1, the host name and the real IP address in the host part of the URL to no avail. I do have port 3306 in the URL and have checked the mysql config file to make sure it agrees...so there seems to be a MySQL server running on the machine/port that I am trying to connect toBUT java.net.InetAddress.getAllByName0.java:571 throws the exception. I have now gone through the archives and can't find a similar problem...RedHat has fixed the localhost.localdomain problem in 7.1. What am I missing? TIA Jim - 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
Have you seen this error message?
Hi, When I try to start mysqld.exe under Win98 I get error: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set Can anyone help with this? Thanks, Sean .
Re: Embedded System
If you are running Linux on your iPaq, I believe I saw someone had actually compiled it on that platform. Cal - Original Message - From: Richard Cochius [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 05, 2001 4:03 AM Subject: Embedded System Hallo, I only got one question: Will there be an embedded version of MySQL for PDAs, like Palm or Compaq. Greetings Richard Cochius - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug: mysql uses temp filesort instead of index
Ben Escoto writes: message, but everything is the same as before (query still takes a long time and explain says it is still using filesort). -- Ben Escoto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Hi! Can you make a gzipped tarball of your table and send it to : ftp://support.mysql.com:/pub/mysql/Incoming and just let me know a file name. Thanx. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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:Have you seen this error message?
Hi! If you are running on Win 98 you should run mysqld-max.exe, because mysqld.exe was accidentally compiled with __NT__ defined. If you do not want to use InnoDB transactional tables, you should put the line skip-innodb in my.cnf. If you want to use InnoDB tables you can look at the manual at www.innodb.com about how to specify the InnoDB config parameters. Regards, Heikki Tuuri Innobase Oy Hi, When I try to start mysqld.exe under Win98 I get error: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb data file path' is not set Can anyone help with this? Thanks, Sean . - 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
Cannot compile MySQL 3.23.38 on solaris.
Description: checking for restartable system calls... no checking need of special linking flags... none checking for working const... yes checking for inline... inline checking for off_t... yes checking for st_rdev in struct stat... yes checking whether time.h and sys/time.h may both be included... yes checking whether struct tm is in sys/time.h or time.h... time.h checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! How-To-Repeat: ./configure (Even with all options suggested on the web page) Fix: Submitter-Id: [EMAIL PROTECTED] Originator: Organization: Mvh Petter Lindquist, Unix-/Nätverkstekniker Högskolan i Gävle Tel 026-648914 / 070-549 8914 MySQL support: none Synopsis: Can not compile MySQL on Solaris Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.38 (Source distribution) Environment: Machine 1: news(petter): uname -a SunOS news 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-5_10 news(petter): make -v GNU Make version 3.77, by Richard Stallman and Roland McGrath. Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Report bugs to [EMAIL PROTECTED]. news(petter): gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) news(petter): Machine 2: adeptus(petter): uname -a SunOS adeptus 5.7 Generic_106541-12 sun4u sparc SUNW,Ultra-4 adeptus(petter): gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.1/specs gcc version 2.95.1 19990816 (release) adeptus(petter): make -v GNU Make version 3.76.1, by Richard Stallman and Roland McGrath. Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Report bugs to [EMAIL PROTECTED]. adeptus(petter): Machine 3: mentos(petter): uname -a SunOS mentos 5.7 Generic_106541-05 sun4u sparc SUNW,Ultra-4 mentos(petter): gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) mentos(petter): make -v GNU Make version 3.77, by Richard Stallman and Roland McGrath. Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Report bugs to [EMAIL PROTECTED]. mentos(petter): System: SunOS adeptus 5.7 Generic_106541-12 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.1/specs gcc version 2.95.1 19990816 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1694308 Nov 2 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Dec 21 21:36 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1115940 Nov 2 2000 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1694308 Nov 2 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Dec 21 21:36 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1115940 Nov 2 2000 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.004_03 - 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
Creating functions
Hi all, I need some help. I would like to create a procedure, which will transform input parameters into a query string and this string execute like a SQL command. I see a functionality of UDF but I mean, that it is useable only like ABS() functions etc. I would like to bind advantages of dynamic .so objects (and C language facilities) with something like Oracle procedural SQL. Is it possible? --Jira P.S. Sorry for my english :-) - 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: problemi compiling simpl1.cpp for borland
Hi! Please use MySQL++ version for Borland and when you do, use the .mak files that are provided in the package. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Need Japanese character set files
On 2001 Jun 04, Narendra Phadke [EMAIL PROTECTED] wrote: I am storing Japanese data inside MySQL. MySQL supports all the Europian languages and other languages like korian and Hebru, and you have all the character set files for all these languages inside the C:\mysql\share\charsets directory. But this directory does not contain Japanese character set files. Where can I get these files? Only single-byte character sets with simple sorting rules can be described by the *.conf files. More complex character sets must be compiled into the server. The binaries that MySQL distributes have all supported character sets included. You can see what character sets are available with this command: mysql show variables like 'character_sets'; You should notice ujis and sjis there, if you are using one of our binaries. If you compile MySQL yourself, you must specify the character sets you want when you run 'configure', like this: sh configure --with-charset=sjis --with-extra-charsets=ujis,gbk When you start mysqld, you use the --default-character-set=ujis option to change the character set being used. Our binaries use latin1 by default. With the configuration line from above, the default would be sjis, but you could specify ujis, gbk, or any of the simple character sets in share/charsets/*.conf. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ 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
Slave Stop
Hi there When issuing this command it seems like MYSQL process hangs. The server still responds, etc etc but the process that issued that command says waiting for slave to die and that takes a long time, eventually after 20 minutes I just disconnected the two servers and the process continued once the network connection was interrupted. Any ideas? Thanks ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 database,sql - 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: mysqlgui 1.7.5
Dennis M. Gray writes: I have been unable to use the create table or edit table features of mysqlgui. Are this meant to work out of the box or is there more configuration I must do? I have tried with both 1.7.4 for Windows and 1.7.5 for Linux. Thanks No wonder you could not do it. It is still in the works ;O) Regards, Sinisa For technical support contracts, goto http://order.mysql.com __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 C API and mysql
kenneth johansen writes: hello everybody. Ive been working with perl and mysql for some time, but recently i had to move over to C and as such i wrote a small test program, just to get to know the mysql C API. Well, things didnt go as i thought. i kept getting linking problems and in the end my test program was limited to the few lines bellow: #include stdlib.h #include mysql.h #include unistd.h #include stdio.h int main(){ MYSQL *mysql; mysql = mysql_init(NULL); if (mysql == NULL) { fprintf(stderr,mysql_init() failed (foobar\n); exit(1); } } + i compile this with: gcc -I/usr/local/mysql/include/ -L/usr/local/mysql/lib/ program.c -lmysqlclient but i always get the error message: /usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status doing an nm on libmysqlclient.a does reveal that the compress functions are there,but for some reason it wont work. appriciate any/all help regards [EMAIL PROTECTED] Just add -lz to linker command. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Embedded System
Richard Cochius writes: Hallo, I only got one question: Will there be an embedded version of MySQL for PDAs, like Palm or Compaq. Greetings Richard Cochius Hi! The answer is Yes in MySQL 4.0. What would you need it for ?? Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: What is the error in this sql query
I would say line 2, DEFAULT 0 not DEFAULT '0'. - Original Message - From: Syed sumair [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, June 01, 2001 7:11 Subject: What is the error in this sql query What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID), INDEX(page_ID) ) - 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: Scripts
Manuel Dugué wrote: Hi, I created some Scripts of the Type *.sql. In these Scripts there are pure SQL Statements, seperated by a ';'. How can I execute those Scripts (automated) in mySQL? mysql -u ... -p.. -h ... scr1.sql etc. Is there a possibility to make one Script, that starts other scripts... Can anybody help me? put them in a shell script, say run.csh (or sh or bash or ksh ...): mysql -u ... -p.. -h ... scr1.sql . mysql -u ... -p.. -h ... scr100.sql then just run run.csh thanx Manuel - 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: Help! MySQL variables laugh at me
if faq had a sequenced primary key you could do the following select a.sezione, IF(a.sezione = b.sezione, no,yes) as hasChanged from faq as a, faq as b where faq.id = faq.id -1 -Original Message- From: Luca Accomazzi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:02 AM To: [EMAIL PROTECTED] Subject: Help! MySQL variables laugh at me I've been frying my brain over this problem for the past 24 hours and I'll be very grateful for any hints. I'm trying to recognize when the value for a field is changing value from one record to the next. For an example, look at this: mysql select sezione from faq limit 20; +---+ | sezione | +---+ | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Macintosh | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | +---+ 20 rows in set (0.01 sec) As you see, the field's value is almost always Internet, but it becomes Macintosh in the middle. I'd like to recognize this change (and, later, act on it). I thought I had found the solution by employing a bit of variable magic. And it seemed to work just fine: mysql select sezione, IF(@a=sezione, no, yes) as hasChanged, (@a:=sezione) as newValueForMemory from faq limit 20; +---++---+ | sezione | hasChanged | newValueForMemory | +---++---+ | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Macintosh | yes| Macintosh | | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | +---++---+ 20 rows in set (0.01 sec) I keep a copy of the previous value in a variable, then check that variable against the current value for the field. All is well. BUT, as soon as I tackle my real problem (on a nasty database, complex queries, and the real problem, all hell breaks loose: mysql select ordine, IF(@oldOrdine=ordine, no, yes) as hasChanged, (@oldOrdine:=ordine) as newValueForMemory from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +++---+ | ordine | hasChanged | newValueForMemory | +++---+ | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | no | 3 | +++---+ 13 rows in set (0.10 sec) WHY OH WHY is MySQL behaving like this? I tried a bunch on variations (using two variables, applying a function on the field and ever weirder ones), to no avail. It gets even more unpredictable, as if the variables refused to be set and reset. mysql select @a, ordine, @b:=ordine, @b, IF (@a=@b, 'Very Thin', 'Thin') as divider, @a:=@b from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +--+++--+---++ | @a | ordine | @b:=ordine | @b | divider | @a:=@b | +--+++--+---++ | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1
RE: URGENT Disappear - Reappear Problem
I have only seen this when some thing was looking are the db files independed of mysqld. This was when I used isamchk to resort and fix a table but did not flush tables after. Hope this helps Simon -Original Message- From: Richard McKenney [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 13:09 To: [EMAIL PROTECTED] Subject: URGENT Disappear - Reappear Problem We have a table whose entries seem to be disappearing at random. We are accessing our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine. Up until yesterday, we would lose about one entry per week in a single table. The rest of the tables seem fine. However, yesterday one of our entries reappeared. Our affected table has 39 fields with one auto-increment primary key zerofill field. isamchk returned that everything was fine. Has anyone seen this happen before? Thanks in advance. Shawn McKenney [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
create username/password with mysqladmin???
hello, i'm running mysql 3.23.38 on linux. how do i create a username and password with mysqladmin? from which directory do i do this? tia if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript } - 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
occasionaly over-riding values
Hi, we have a database where users sign up to one program of several (eg. in the user table there is a field prog_id referencing the auto_increment key of the program table) The program table holds a multitude of information (text, varchar, decimal, int, date fields) For some users they need a customised program - where one (or possibly a few) of the fields in program need to be uniq for that user. But by far the majority of users use a generic program What is the best way of handling this? Up to now we have been creating a separate entry for each of these users in a table called custom_program (the same field structure as program) and populating this. However it gets difficult to maintain. We have thought of just putting the changed fields into custom_program but this complicates selects (eg. if the non changed fields are NULL we need to select * from custom_program where user=x and then loop through each field and if it is not null we modify the value we've previously taken from program. The other idea I had was to create a table CREATE TABLE overrides ( user varchar(10) NOT NULL, field_name varchar(30), field_value varchar(30) ) TYPE=MyISAM PACK_KEYS=1; and then select field_name, field_value from overrides where user=x and loop through each over-ride. This seems a bit of a cludge because the different fields are really different types (text, varchar, decimal, int, date fields). Anyone got a clever way of dealing with this? /Dave - 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
convert microsoft sql
hi there, my client has some databases on a m$ sql server and wants them to be converted to mysql (to use on a cheaper provider). has anyone ever done this before? are there many differences in the syntax or would it be easy to translate? maybe there's tool? thanks for your help! christian _ 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
PHP/MySQL running out of memory
Hi all: I'm not sure if this script is really running out of memory because of MySQL doesn't have enough memory, or if it's because it's a poorly written script. I was hoping that someone might be able to take a look at the script for me and let me know if they could find any ways to optimize it. The Script: http://xtrinsic.com/scripting/engine.04.txt (previous versions at 03.txt and 02.txt). The script in action: http://www.tri-drs.org/engine.phtml I seem to get either Bork, bork, bork. All I do is bork OR You came to see me about a zero? The first error message is associated with: $data_check = select row_id from lookup where word_id = $gotten_word_id and table_id = $table_name; $data_back = mysql_query($data_check) or die (Bork, bork, bork. All I do is bork. $eachword[$k]. mysql_error()); $data_check_array = mysql_fetch_array($data_back); The second is associated with (which actually comes first in the script): $word_check = select word_id from words where word = '$eachword[$k]'; $any_words = mysql_query($word_check) or die (You came to see me about a zero. $eachword[$k] mysql_error()); $anything_back = mysql_num_rows($any_words); These are both selects... I have no problem with any of my insert queries. Although I've put in the PHP mysql_error(), I've only seen an error once. And it said something to the effect of MySQL is out of memory. I didn't think to copy and paste it because I thought I'd be able to replicate it. :( Any help on this would be very much appreciated!!! emma - 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: Select Letter/Number
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:54 PM To: Marcus Ouimet Subject: Re: Select Letter/Number 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 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: I am wondering if it is possible to use the select command to bring up a field that has any letter or number in it and not the blank fields. Ie. SELECT products_id,products_name,products_info from products where 1 and products_info like % That brings up everything including blank fields. I just need all the fields with any information in them (letters, numbers, etc.), not the blank ones. Any help would be appreciated. Thanks in advance. - 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
Newbie with PHP
I apologize if this seems simple, or stupid, or if there is an answer in the archives. I am under an extreme deadline to get my PHP generated form into MySQL. I am trying to collect an order then pass the variables in to a validation page where the customer will review the information then submit it for the database. When I submit the information from the validation page, everything appears to run fine, but no data are inserted in the table. I was getting some parsing errors, but I sorted those out. Now it looks like things are good, but no data are inserted. Any help or guidance is very much appreciated. Harry www.technologytrust.org http://www.technologytrust.org www.technologytrust.net http://www.technologytrust.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
Help us make MySQL better
MySQL is taking a survey of MySQL users. As a bribe to get more people to fill out the survey, we are giving away three Palm PDAs and ten autographed MySQL books. Please take about ten minutes to fill out the web page: http://www.mysql.com/survey/ MySQL is an Open Source Database Server. Anyone can download it from our website, use it and pass it along to friends and associates. This means that we, the core developers and others at MySQL AB, don't really know who is using MySQL and for what. We need this information to help us develop MySQL to suit future needs. This information will also help us know what services we may sell to support our development work. You can provide this, so please help us! We will give three randomly-chosen persons filling out our survey a color Palm Pilot IIIc and ten others a copy of Paul DuBois' best-selling MySQL book, autographed by Michael Monty Widenius and the rest of the MySQL Development Team. Winners will be drawn on Monday July 16, 2001. All winners will be notified personally by email. We really do appreciate your taking the time to do this. If you know of anyone using MySQL who probably didn't get this message, you might forward the above URL to them as a favor to us. With Kind Regards, Tim, for the MySQL team -- Need MySQL help? https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ 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
Best Column Type for Currency Calculations
I've been having some problems with currency calculations in SQL queries. I've been using Double, but often get some very small rounding errors. What is the recommended column type for currency in MySQL? Aaron - 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: safe_mysqld not working properly
Hello! I have just installed mysql-3.23.38 from source on a Mandrake 8 Linux box. I installed the db tables with mysql_install_db the user mysql owns the files in the mysql dir. when I go to start up the mysql daemon using ./safe_mysqld --user=mysql I get this Starting mysqld daemon with databases from /usr/local/mysql/var 010605 11:12:14 mysqld ended [1]+ Done./safe_mysqld --user=mysql and the daemon does not start. I have checked to processes and it is not listed. Anyone have and ideas where I may have gone wrong or what I need to do to fix this. Thanks. Chad - 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
Inserting 307,284 lines. Is this ok?
Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. I don't know how to make it show 256 and running redhat 6.1. The table has 12 colums and does not have much data in each record. My question is should I break this up into a couple of tables so that each table will have say 50,000 records and I can just search through them with dates. Thanks for any help. --Mike __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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
RE: convert microsoft sql
Mysql has a converter in it's package. Look under the scripts directory for MySQL. --- Brad Dameron Network Account Executive TSCNet Inc. www.tscnet.com Silverdale, WA. 1-888-8TSCNET -Original Message- From: Christian Schäfer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 8:03 AM To: [EMAIL PROTECTED] Subject: convert microsoft sql hi there, my client has some databases on a m$ sql server and wants them to be converted to mysql (to use on a cheaper provider). has anyone ever done this before? are there many differences in the syntax or would it be easy to translate? maybe there's tool? thanks for your help! christian _ 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
Re: Need Japanese character set files
Only single-byte character sets with simple sorting rules can be described by the *.conf files. More complex character sets must be compiled into the server. The binaries that MySQL distributes have all supported character sets included. You can see what character sets are available with this command: mysql show variables like 'character_sets'; You should notice ujis and sjis there, if you are using one of our binaries. When you start mysqld, you use the --default-character-set=ujis option to change the character set being used. Our binaries use latin1 by default. With the configuration line from above, the default would be sjis, but you could specify ujis, gbk, or any of the simple character sets in share/charsets/*.conf. I installed MySQL from an RPM file on Linux. When I use the mysqlshow variables like 'character_sets'; as you mentioned above, I do, indeed, show sjis. So, I shutdown mysql and restarted it like this: safe_mysqld --default-character-set=sjis This resulted in an error message (sorry I forgot the one however something it to do with missing charsets I believe). I had a look around and I noticed the following charsets in /usr/share/mysql/charsets: ./croat.conf*greek.conf* latin1.conf* win1251.conf* ../ danish.conf* hebrew.conf* latin2.conf* win1251ukr.conf* Index*dec8.conf* hp8.conf*latin5.conf* README* dos.conf* hungarian.conf* swe7.conf* cp1251.conf* estonia.conf* koi8_ru.conf*usa7.conf* cp1257.conf* german1.conf* koi8_ukr.conf* win1250.conf* Alas, no sjis, but I imagine that is because it a double-byte character set. So, I'm left with the following question: 1. What do you mean by More complex character sets must be compiled into the server. And how would I go about doing this? TIA Anatole - 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: Newbie with PHP
Can you post some code? - Original Message - From: Harry Bakken [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 05, 2001 8:09 AM Subject: Newbie with PHP I apologize if this seems simple, or stupid, or if there is an answer in the archives. I am under an extreme deadline to get my PHP generated form into MySQL. I am trying to collect an order then pass the variables in to a validation page where the customer will review the information then submit it for the database. When I submit the information from the validation page, everything appears to run fine, but no data are inserted in the table. I was getting some parsing errors, but I sorted those out. Now it looks like things are good, but no data are inserted. Any help or guidance is very much appreciated. Harry www.technologytrust.org http://www.technologytrust.org www.technologytrust.net http://www.technologytrust.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 - 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: convert microsoft sql
Hi, You can use DBTools (for windows http://dbtools.vila.bol.com.br)) to convert the structure (without indexes) and data to mySQL by using ODBC DSN, or you can dump the data into a TXT file and then import it into mysql with LOAD DATA ... I'm working on a wizard to convert a completely structure/data from MSSQL to mySQL, since many people have requested that, but I have no idea yet how much time I will spend to finish this job. []'s Crercio O. Silva -Original Message- From: Christian Schäfer [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 5 de junho de 2001 12:03 To: [EMAIL PROTECTED] Subject: convert microsoft sql hi there, my client has some databases on a m$ sql server and wants them to be converted to mysql (to use on a cheaper provider). has anyone ever done this before? are there many differences in the syntax or would it be easy to translate? maybe there's tool? thanks for your help! christian _ 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
Re: Need Japanese character set files
On 2001 Jun 06, Anatole [EMAIL PROTECTED] wrote: I installed MySQL from an RPM file on Linux. When I use the mysqlshow variables like 'character_sets'; as you mentioned above, I do, indeed, show sjis. This means that the sjis character set is compiled into the server already, so you do not need to recompile MySQL in order to use the sjis character set. So, I shutdown mysql and restarted it like this: safe_mysqld --default-character-set=sjis This resulted in an error message (sorry I forgot the one however something it to do with missing charsets I believe). I would need to know the error message in order to guess what is going wrong. I had a look around and I noticed the following charsets in /usr/share/mysql/charsets: cut Alas, no sjis, but I imagine that is because it a double-byte character set. Yes. If you had the source distribution, you would see the file called strings/ctype-sjis.c, which contains the code needed to handle the sjis character set. So, I'm left with the following question: 1. What do you mean by More complex character sets must be compiled into the server. In order to use the more complex character sets, such as sjis, extra code must be linked into the mysqld binary. When we build our binary distributions, we do link in the extra code for all of the more complex character sets. And how would I go about doing this? You do not need to do this, since you are using a standard binary that already includes all of the more complex character sets. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ 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
Creating functions
Hi all, I need some help. I would like to create a procedure, which will transform input parameters into a query string and this string execute like an SQL command. I see a functionality of UDF but I think, that it is useable only like ABS() functions etc. I would like to bind advantages of dynamic .so objects (and C language facilities) with something like Oracle procedural SQL. Is it possible? --Jira P.S. Sorry for my english :-) - 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: Best Column Type for Currency Calculations
convert everything to pennies and use integers? Aaron Clausen wrote: I've been having some problems with currency calculations in SQL queries. I've been using Double, but often get some very small rounding errors. What is the recommended column type for currency in MySQL? Aaron - 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
FW: [Fwd: (no subject)]
hello everyone.. RedHat LInux 6.2. PC. mysql. when i start mysql with 'safe_mysqld ' i get the following: [root@kauai bin]# safe_mysqld [1] 872 [root@kauai bin]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended [1]+ Donesafe_mysqld __ but there is no process started ___ [root@kauai bin]# ps -aux | grep mysql root 959 0.0 0.4 1360 516 pts/2S07:54 0:00 grep mysql when i try to ping the admin i get: [root@kauai bin]# ./mysqladmin -p ping Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ___ when i try to start mysql command line i get: ___ [root@kauai bin]# ./mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [root@kauai bin]# ___ so the MYSQL DAMEON is not starting.. Can anyoine help me?.. - 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: Best Column Type for Currency Calculations
On 05-Jun-01 Aaron Clausen wrote: I've been having some problems with currency calculations in SQL queries. I've been using Double, but often get some very small rounding errors. What is the recommended column type for currency in MySQL? DECIMAL(9,2) 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. - 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: Newbie with PHP
Just a few thoughts. Does the user who needs to insert have enough rights to do so. Is your mysql server up and running.. If you want to take a look at a tutorial: www.devshed.com Bye, B. At 09:09 5-6-01 -0600, Harry Bakken wrote: I apologize if this seems simple, or stupid, or if there is an answer in the archives. I am under an extreme deadline to get my PHP generated form into MySQL. I am trying to collect an order then pass the variables in to a validation page where the customer will review the information then submit it for the database. When I submit the information from the validation page, everything appears to run fine, but no data are inserted in the table. I was getting some parsing errors, but I sorted those out. Now it looks like things are good, but no data are inserted. Any help or guidance is very much appreciated. Harry www.technologytrust.org http://www.technologytrust.org www.technologytrust.net http://www.technologytrust.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 - 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: Inserting 307,284 lines. Is this ok?
On Tue, 5 Jun 2001, Mike Mike wrote: I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG Yes. This is not so much at all. File. I have a 550 with 256MEG ram but it only shows 64. I don't know how to make it show 256 and running redhat 6.1. The table has 12 colums and does not have This is uaually prblem in hardware but can also be problem of old linux kernel. Add into file /etc/lilo.conf such line: append=mem=256M and rerun lilo. After reboot you should have 256M accessible. Some computers need to use something bit less like mem=250M or similar or they crash. much data in each record. My question is should I break this up into a couple of tables so that each table will have say 50,000 records and I can just search through them with dates. Thanks for any help. Read manual about both optimization and MERGE tables. Tonu - 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: Newbie with PHP
Harry Bakken [EMAIL PROTECTED] wrote: snip form into MySQL. I am trying to collect an order then pass the variables in to a validation page where the customer will review the information then submit it for the database. When I submit the /snip If you post your code to the list, perhaps someone will help. And before you do, before to echo your SQL statement to the browser so you can see whether it is in fact correct - test by pasting it into the MySQL commandline to ensure it works. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: Inserting 307,284 lines. Is this ok?
At boot time you can pass a flag to lilo to force a certian amount of ram.. i think it's something like this: lilo: linux mem=256 307,000 rows in mysql is easy, mysql can handle a lot more rows than that. You shouldn't have any trouble with this amount of data. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Mike Mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 11:38 AM To: [EMAIL PROTECTED] Subject: Inserting 307,284 lines. Is this ok? Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. I don't know how to make it show 256 and running redhat 6.1. The table has 12 colums and does not have much data in each record. My question is should I break this up into a couple of tables so that each table will have say 50,000 records and I can just search through them with dates. Thanks for any help. --Mike __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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
events that i can trigger on intervals.
Hi, I have a room inventory. Clients can block rooms them but I want to release them after a specified time if they do not release them normally via the given link. I want to be able to trigger an event to release the rooms after the time limit. Is there any way I can do this with MySQL or PHP. Thanks, Hasan ps. I use a PHP interface. - 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
Need help on mysql/php
I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the neccessary fields. Now I am at a total loss at what to do. I want to use PHP scripts to pull info from the db and search the db etc. I have contacted my support from FWS, but they point me to MySQL.com for Mysql commands technical support. Seems to me I would need to know how to set username/password to access the db from script etc. The bottom line question is can someone point me to information on what I need to do to be able to access(open/close) the db, retrieve/store information, etc. in this type of environment (i.e. MySQL provide by my host service, not installed by me)? Ed - 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
exporting from MS Access
Hi, Has anybody perfected a method of exporting tables from Ms Access to a MySQL database? Every time I export my tables I lose the primary key definition. Is there a trick to stop this from happening? thanks in advance. - 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: Inserting 307,284 lines. Is this ok?
---Reply to mail from Mike Mike about Inserting 307,284 lines. Is this ok? Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. [] I have a database with 20-30 tables. One of them has almost 2.000.000 entries and it use around 6GB (17 columns). Another has more than 2.500.000 and uses around 100MB (1 column) No problems at all. I suppose this answer your question. Sincerely Rafael Martinez ---End reply - 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