installing Binaries under /usr/local
Hello, I was wondering if there is distribution or method for me that would allow me to install mysql with a --prefix of /usr/local instead of /usr/local/mysql Normally I would just compile it but I am getting lazy in my old age and this is my first time with 4.x series, so I'll the official binaries this time. Should I just copy all the binaries over to /usr/local/bin and /usr/local/libexec /usr/local/share and be done with it? Moving from 3.23.x to 4.0. Thanks. -- Vincent Stoessel Linux Systems Developer vincent xaymaca.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
Update = DEMO TIME: Need best options for source/smp/raid/x86 need to do a demo
the RAID arrays were built at RAID-0 90% of the time the db's will be doing only selects, the db's will be updated nightly. -pete Well I opened my big mouth and now have to do a demo of MySQL on an old server that was destined for the dumpster. It has 4 Pentium III, 512 MB of memory (bus unknown), an HP 3 channel RAID controller (Megatrends?), and 8 SCSI disks in an external array. I've configured the disks to have 4 disks on each channel, and created 2 arrays, the array that will be for data has 3 drives on each channel. I've installed RedHat 8.0 which gives me GCC 3.2 I want to build two versions one with out InnoDB (non-max) and one with. The size of the database will be between 2-4 Gb What I'm looking for are some suggestions on ./configure options and potentially GCC options. Thanks in advance, -pete - 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
Duplicating a table question
These spam filters are really annoying. It's hard to get an answer to my question when my message gets bounced 'cause it doesn't have MySQL or query in the message. In any event, Is there a way to duplicate a complete table. I am making some modifications and don't want to use the working table for testing. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.54 compile error
check Compiling 3.23.54-1 - new tools installed! thread... t GC GC When I start mysql with GC GC service mysql start GC GC I get this error: GC GC /usr/bin/safe_mysqld: 5: command not found GC What's that? GC GC By the way mysql seems up and running... GC GC GC GC - GC Before posting, please check: GChttp://www.mysql.com/manual.php (the manual) GChttp://lists.mysql.com/ (the list archive) GC GC To request this thread, e-mail [EMAIL PROTECTED] GC To unsubscribe, e-mail [EMAIL PROTECTED] GC Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GC GC - 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
a simple query
Hi, I have a table like this: --- | Code | Name | ParentFemale | ParentMale | --- |1 | Child| 2 | 3 | --- |2 | Mather | 0 | 0 | --- |3 | Father | 0 | 0 | --- and I need a query to obtain this table: -- | Name | ParentFemale | ParentMale | -- | Child | Mather | Father| -- and if in I have the next values in table 1 --- | Code | Name | ParentFemale | ParentMale | --- |1 | Child| 0 | 0 | --- |2 | Mather | 0 | 0 | --- |3 | Father | 0 | 0 | --- I need the next values for table 2: -- | Name | ParentFemale | ParentMale | -- | Child | Null| Null | -- Can you help me, please? Sincerely, Adrian --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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 Question
I have several databases that will be located in several different locations and they will be collecting data from various sources, and what I would like to do is be able to set up replication from all my data collection sites to a master database. The data collection databases only need to keep the data for their sites but the master needs to have the data from all the sites. So as I see it the data collections dbservers are the master servers and the master database is a big slave. Can I accomplish this with mysql replication? I am running RH 7.3 with MySQL 3.23.49 Thanks in advance Brad - 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 rebuilding 3.23.54 source rpm, glibc 2.1?
I've got an older redhat 6.2 box that has glibc 2.1.3-28 on it. The binary rpm's won't install (needs glibc 2.2), and rebuilding the source rpm gives: make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.54/readline' Making all in libmysql make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.54/libmysql' source='libmysql.c' object='libmysql.lo' libtool=yes \ depfile='.deps/libmysql.Plo' tmpdepfile='.deps/libmysql.TPlo' \ depmode=gcc /bin/sh ../depcomp \ /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/\ -DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3 -c -o libmysql.lo `test -f libmysql.c || echo './'`libmysql.c gcc -DDEFAULT_CHARSET_HOME=\/\ -DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -O3 -c libmysql.c -Wp,-MD,.deps/libmysql.TPlo -o libmysql.o libmysql.c: In function `mysql_real_connect': libmysql.c:1340: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1340: too few arguments to function `gethostbyname_r' libmysql.c:1340: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.54/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.54' make: *** [all] Error 2 error: Bad exit status from /var/tmp/rpm-tmp.94268 (%build) -- -- Daniel Bohling NewsFactor Network - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 12 Dec 2002, Mark Matthews wrote: Did the mysql team change tools versions? automake/autoconf? Yes. You need automake 1.5 / libtool 1.4. It appears this made it into the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing this to our build engineer, so he can correct the manual. Well, BCC'ing did not help here - please rather Cc: me on such things. Otherwise chances are high, that the message gets filtered in some less frequently read folders... Thanks for pointing this out - I've now added the respective entry to the ChangeLog in the manual. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+kBYSVDhKrJykfIRAu6SAJ9Ru/EtiPRmGWdYTgCLkTSMDQ1MUACfUc89 npy26FNK/8sdzFQkKqZxEwo= =w9z1 -END PGP SIGNATURE- - 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 Help - Initial Configuration
I'm fairly new to MySQL, and RDBMS's in general, but not to system administration nor linux. I'm running Gentoo, and I can't seem to get mySQL to work. Gallio root # /etc/init.d/mysql start * Starting mysqld... [ ok ] Then I: Gallio root # ps ax PID TTY STAT TIME COMMAND 1 ? S 0:04 init 2 ? SW 0:00 [keventd] 3 ? SWN 0:00 [ksoftirqd_CPU0] 4 ? SW 0:00 [kswapd] 5 ? SW 0:00 [bdflush] 6 ? SW 0:00 [kupdated] 7 ? SW 0:00 [khubd] 12 ? SW 0:02 [kjournald] 37 ? S 0:00 /sbin/devfsd /dev 1989 ? SW 0:00 [kjournald] 1990 ? SW 0:00 [kjournald] 1991 ? SW 0:00 [kjournald] 4711 ? SW 0:00 [eth0] 4907 ? S 0:00 /usr/sbin/smbd 4909 ? S 0:01 /usr/sbin/nmbd 4942 ? S 0:00 /usr/sbin/sshd 4996 ? S 0:00 /usr/sbin/syslogd -m 0 4999 ? S 0:00 /usr/sbin/klogd -c 3 -2 5001 ? S 0:00 /usr/sbin/cron 5007 vc/1 S 0:00 login -- root 5008 vc/2 S 0:00 login -- root 5010 vc/4 S 0:00 /sbin/agetty 38400 tty4 linux 5011 vc/5 S 0:00 /sbin/agetty 38400 tty5 linux 5012 vc/6 S 0:00 /sbin/agetty 38400 tty6 linux 5013 vc/1 S 0:00 -bash 5480 vc/2 S 0:00 -bash 1211 vc/3 S 0:00 /sbin/agetty 38400 tty3 linux 5487 ? S 0:00 /usr/sbin/sshd 5489 ? S 0:00 /usr/sbin/sshd 5490 pts/0 S 0:00 -sh 5497 pts/0 S 0:00 -bash 5604 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5605 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5606 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5607 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5608 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5570 pts/0 R 0:00 ps ax But it's not there. To make sure: Gallio root # nmap 10.10.10.10 Starting nmap V. 3.00 ( www.insecure.org/nmap/ ) Interesting ports on Gallio (10.10.10.10): (The 1599 ports scanned but not shown below are in state: closed) Port State Service 22/tcp open ssh 80/tcp open http 139/tcp open netbios-ssn Nmap run completed -- 1 IP address (1 host up) scanned in 2 seconds Gallio root # Nothin'. Nada. Nil. It's not starting. If I try to stop it... Gallio root # /etc/init.d/mysql stop * Stopping mysqld... [ !! ] My guess, it can't find the pid to stop it with. And the file /var/run/mysqld/mysqld.pid (or something like that) doesn't exist. Running 'safe_mysqld --user=mysql ' does the following: Gallio root # safe_mysqld --user=mysql [1] 5632 Gallio root # Starting mysqld daemon with databases from /var/lib/mysql 021213 11:47:23 mysqld ended When I escape out of that: [1]+ Done safe_mysqld --user=mysql I'm not sure what has gone wrong, but I'd like to get the mysql up and running. BTW, what would be a worthy book to get on mySQL? Ben -- __ http://www.linuxmail.org/ Now with POP3/IMAP access for only US$19.95/yr Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.54 compile error
i mean... MySQL 3.23.54 safe_mysqld fix thread, sorry! t GC GC When I start mysql with GC GC service mysql start GC GC I get this error: GC GC /usr/bin/safe_mysqld: 5: command not found GC What's that? GC GC By the way mysql seems up and running... GC GC GC GC - GC Before posting, please check: GChttp://www.mysql.com/manual.php (the manual) GChttp://lists.mysql.com/ (the list archive) GC GC To request this thread, e-mail [EMAIL PROTECTED] GC To unsubscribe, e-mail [EMAIL PROTECTED] GC Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GC GC - 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 replication
On Wednesday 11 December 2002 18:03, Natale Babbo wrote: I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 We had the same problem here at Ensita.NET. Installing MySQL server from the latest 4.0.6 tree solved this problem. So wait for the 4.0.6 release. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] InnoDB Lock status
Patricio, - Original Message - From: Patricio Díaz G. [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, December 13, 2002 4:20 AM Subject: [MySQL] InnoDB Lock status I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. SHOW LOCK STATUS is in the TODO, and I consider it an important feature. Currently the only way to get lock info is to use innodb_lock_monitor, but it prints the info to the .err log. There is no SQL query to determine if a row is locked or not. Thanks in advance, Patricio. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL crashes with foreign key restraints
Stefan, please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query Subject: MySQL crashes with foreign key restraints From: Stefan Hinz Date: Fri, 13 Dec 2002 16:17:56 +0100 Dear list, I am using MySQL-max 4.0.1 on Win 98 Second Edition with InnoDB as default table type. Using DeZign, I created the following SQL file with three tables (I left out all those other CHAR and TEXT fields here): CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)); CREATE TABLE Teilnehmer( id SMALLINT UNSIGNED NOT NULL, pid SMALLINT UNSIGNED, FOREIGN KEY (pid) REFERENCES Projekt (id), PRIMARY KEY (id), INDEX IDX_Teilnehmer_1 (pid)); CREATE TABLE Bewertung( pid SMALLINT UNSIGNED NOT NULL, #FOREIGN KEY (pid) REFERENCES Projekt (id), INDEX IDX_Bewertung_1 (pid)); Importing this in MySQL batch mode makes the MySQL server crash immediately. Everything works fine for table Projekt and Teilnehmer, but the line I commented out here for table Bewertung makes MySQL crash. Table Bewertung doesn't have a primary key, that's all the difference. Starting the server again and logging in, I find the first two tables are fine, but SHOW TABLE STATUS reports only NULL fields for table Bewertung, and InnoDB complains that it has no fields at all. Trying to drop this broken table results in 'table Bewertung doesn't exist'. To be able to delete the table (and the database), I have to delete Bewertung.frm manually. This makes InnoDB complain at server start like this: InnoDB: MySQL database directory from another database? InnoDB: Have you copied the .frm file of the table to the InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Error: table projekt/bewertung does not exist in the InnoDB internal InnoDB: MySQL database directory from another database? InnoDB: Have you copied the .frm file of the table to the InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Error: table projekt/bewertung does not exist in the InnoDB internal have moved .frm files to another database? Is there something wrong with my foreign key restraints, or is this a bug in InnoDB / MySQL? P.S. I tried the same with 4.0.3-max-nt on a Win2K box. Here, the server doesn't crash, but the response is can't create '.\projekt\teilnehmer.frm' with error 150 (unknown error). Commenting out the FOREIGN KEY lines solves the problem, but then again, I have no f.k.restraints :( Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - 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: The InnoDB on raw devices...
Dyego, from the documentation of CreateFile in old Visual C++ docs I found the following description how to specify in Windows the name of a disk drive or a partition on a disk drive. The name you used below looks more a Linux way to specify a disk partition. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com Disk Devices Windows NT: You can use the CreateFile function to open a disk drive or a partition on a disk drive. The function returns a handle to the disk device; that handle can be used with the DeviceIOControl function. The following requirements must be met in order for such a call to succeed: · The caller must have administrative privileges for the operation to succeed on a hard disk drive. · The lpFileName string should be of the form \\.\PHYSICALDRIVEx to open the hard disk x. Hard disk numbers start at zero. For example: String Meaning \\.\PHYSICALDRIVE2 Obtains a handle to the third physical drive on the users computer. · The lpFileName string should be \\.\x: to open a floppy drive x or a partition x on a hard disk. For example: String Meaning \\.\A: Obtains a handle to drive A on the users computer. \\.\C: Obtains a handle to drive C on the users computer. -- Subject: The InnoDB on raw devices... From: Dyego Souza do Carmo Date: Fri, 13 Dec 2002 08:18:19 -0200 I'm trying to use InnoDB on raw device under Windows XP Prof. my innodb_data_file_path is : innodb_data_file_path = /dev/hda2:5Gnewraw but mysql not create a database :( any idea ? my system is : MySQL 3.23.54 on Windows XP Tnks, sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: 4.0.5: can't disable any logs!
On Wednesday 11 December 2002 20:11, Nicolas MONNET (Tech) wrote: No matter what I do on the command line for mysqld, or in my.cnf, ALL logs get activated! I'm using the Gentoo ebuilds, with mysqld started from an svscan run script for supervision. Just don't specify any --log, --bin-log and others log options. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
/usr/bin/safe_mysqld: 5: command not found (WAS: Re: 3.23.54 compile error)
I got that as well., and like the case below, MySQL is up and running just fine. I tried looking in safe_mysqld for a spurious '5' but couldn't find anything. Does anyone know what's up with the most recent safe_mysqld? j-- k- On Thursday 12 December 2002 17:16, Gabriele Carioli wrote: When I start mysql with service mysql start I get this error: /usr/bin/safe_mysqld: 5: command not found What's that? -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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: Migration from Oracle
Its a small migration. -Satish Stefan Hinz wrote: Dear Satish, Thank you for your help. Your welcome. I used MyODBC 3.51, and successfully migrated to MySQL. Is this a MySQL user stories case, or just a small migration? Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Satish Vohra [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 12:27 PM Subject: Re: Migration from Oracle Dear Stefan, Thank you for your help. I used MyODBC 3.51, and successfully migrated to MySQL. Regards Satish Stefan Hinz, iConnect (Berlin) wrote: Dear Satish, I want to migrate from Oracle to MySQL. So I need to import the tables and data from Oracle. Can anyone suggest any tool which can do this. Any pointer regarding this will be appreciated. (1) I am not familiar with Oracle, but I assume (oh, that word again) that it has a dump utility to create SQL files (with CREATE TABLE / INSERT statements). If it has, you can dump table definitions + data out of Oracle and import them into MySQL like that (using the MySQL Monitor command line client): shell mysql dump_from_oracle.sql In this case, it's fairly easy (and fast), but you will have to make sure the Oracle column types (DECIMAL, NUMERIC, INT, CHAR etc.) in use are being supported by MySQL. (2) Another way is to create the table definitions manually (choke!), export the data from Oracle (SELECT ... INTO OUTFILE) and import them into MySQL using LOAD DATA INFILE. (3) Yet another way is an ODBC connection from Oracle to MySQL, if Oracle supports ODBC. ODBC is slow, but not as desperately slow as I sometimes hear. As reported before on this list, I did a 1.2 million records import a couple of days ago from MS Access into MySQL using MyODBC 3.51.04. Table size was 500 MBytes, and it took 4 minutes on a 2 GHz machine running Win2K (table create definition and import of all data). HTH, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Satish Vohra [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 5:12 PM Subject: Migration from Oracle Hi All, I want to migrate from Oracle to MySQL. So I need to import the tables and data from Oracle. Can anyone suggest any tool which can do this. Any pointer regarding this will be appreciated. Regards Satish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
chroot() in 3.23.54
Hi everyone, First off, please include my personal e-mail address in any responses, as i am not subscribed to the list. I run MySQL with the chroot option. Up until 3.23.54, it worked fine. 3.23.54 changed the ordering in which some files were accessed (before or after chroot()), which messed up the whole system -- entire directories have to be copied or sym linked, for example. In particular, it seems that older versions perhaps held an open file descriptor to the directory where the database files are (which is outside of the chroot() environment) and was therefore able to manipulate the databases after the call to chroot(). 3.23.54 accesses the databases after chroot(), which is certainly more secure, but it causes the following problem, abbreviated from strace: chdir(/usr/local/var/mysql/) = 0 chroot(/chroot/mysql) = 0 chdir(/) = 0 open(./mysql/host.frm, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) This forces me to copy all of my databases into the root directory of the chroot jail (or at least create sym links to all of them), and leads to output like the following: mysql show databases; +--+ | Database | +--+ | etc | | lib | | mysql| | tmp | | usr | | var | +--+ 6 rows in set (0.02 sec) Has anyone else had this problem, and is there an obvious work around that i'm missing? - -- GPG key / Schlüssel -- http://simultan.dyndns.org/~arjones/gpgkey.txt Encrypt everything. / Alles verschlüsseln. - 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: Merge Tables Across Databases
Can you create a merge table whose component tables exist in other databases? I am able to create merge tables for tables that are in one database but I want to be able to aggregate data from multiple databases. I am using 3.23 but I am migrating to 4.0.5a next week, if that makes a difference. The following is an example of what I am trying to do: Database Name: cust1 Table Name: logs Database Name: cust2 Table Name: logs Database Name: all CREATE TABLE all.combined_logs (column defs here) TYPE=MERGE UNION=(cust1.logs, cust2.logs) INSERT_METHOD=NO; Thanks Lou Query, sql -- to defeat the spam filter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL eats 99 CPU time problem help
Hi Shawn, Also under BSDi make sure you are not running out of file descriptors. MySQL behaves very badly on BSDi when file descriptors run out! Ken - Original Message - From: shawn xu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 11:12 AM Subject: MySQL eats 99 CPU time problem help We have MySQL 3.23.53 running on Intel machine with OS BSDI 4.3. The problem happened more often like this. MySQL eated up 99% cpu time which was told by running top. When this happened, I guess it still answer queries, but it is too slow to answer, which results in the customers complaining. What we have tried, none of them work except wiping the disk and reinstalling everything. I`d appreciate any suggestions to fix this problem. Shawn __ Post your free ad now! http://personals.yahoo.ca - 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: The Manual on MySQL is not updated...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 12 Dec 2002, Jocelyn Fournier wrote: About bk -r get -Sq, after a bk pull, is bk -r edit still needed or bk -r get -Sq could replace it ? I'd say it's still needed, if you want to be able to make modifications, too. By default, bk get does not check out the files in read-write mode - - this is what bk edit does. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+dARSVDhKrJykfIRAvJLAJ9CS7gOe+pN51l8DKt2g+SuEoyDVACeK7at HzJd+2J27x6SZyiz5VOexk8= =tVfj -END PGP SIGNATURE- - 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
Nested MySQL Statements
Hello All, Is it possible to do nested select statements with MySQL ? Basically I'm trying to display the last 5 rows that got inserted into a table. My SQL query looks like this: select * from tablename limit ((select count(*) from tablename) - 5), -1; In theory it works for me :) but MySQL complains. Is it possible to do nested queries with MySQL ? Does anyone have a better way of displaying the last x amount of rows inserted into a table ? Thanks in advance... -Pete Peter Vertes Beast Financial Systems 404 Fifth Avenue New York, NY 10018 - 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: MySQLd-nt -3.23.53 Max
I have some Access pages hooked to web, but a newbe with this [mysql] on laptop. Running NT, windows office '98. I have found some stuff going through tutorial, which I am impressed at how much is really working right out of the book. I am sure has been found. but I was not able to get [following] to work: LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet; {tutorial} not supported LOAD DATA INFILE c:\\mysql\\pet.txt INTO TABLE pet; works fine and the '\' is a delimiter, so must be repeated. Regards, Chuck = People are more violently opposed to fur than leather because it's safer to harass rich women than motorcycle gangs. - D Raasch - 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
MySQL4 user table not showing GRANT privileges correctly
Hi, Using MySQL 4.0.5a, GRANT is correctly adding users (and the privileges are working), but when you view the mysql.user table, all privileges are showing up as 'N', when some of them should be 'Y'. Anybody seen this or understand what's going on? For example: GRANT SELECT ON dbname.* TO test@localhost IDENTIFIED BY 'testpass'; flush privileges; SELECT * FROM USER WHERE User='test'; It will show 'N' in all privilege columns which is wrong. It should show a 'Y' in the select_priv column. Is this a bug/feature or what? Thanks, John Dell [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: problem with replication
hi check the master-slave replication compatibility see http://www.mysql.com/doc/en/Replication_Implementation.html maxime -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 17:49 À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Objet : RE: problem with replication Hi ... i have just tried by nothing's changed! ... i mean ... now in the show slave status i can see the right master_log_filename, log_position etc. but the error persists! What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE [EMAIL PROTECTED] ha scritto: hi, try this : mysql SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | | +--++--+--+ mysql CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='repl', MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file', MASTER_LOG_POS=XX; then restart the slave. -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 16:27 À : [EMAIL PROTECTED] Objet : Fwd: problem with replication Any suggestion about this error? Thanks to all. --- Natale Babbo [EMAIL PROTECTED] ha scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) Da: Natale Babbo [EMAIL PROTECTED] Oggetto: problem with replication A: [EMAIL PROTECTED] Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 Master my.cnf: log-bin=/usr/local/mysql/log/MySQL-bin server-id=1 Slave My.ini: server-id=2 master-host=sviluppo01 master-user=repl master-password=repl What's wrong? Thanks in advance. __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.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 __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.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: Syntax error in safe_mysqld (and safe_mysqld.sh)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 13 Dec 2002, imacat wrote: Description: I found 3 syntax errors found in safe_mysqld (and safe_mysqld.sh), in both source and binary distribution of MySQL 3.23.54. Since syntax errors are appearent, so I just post the patch file here to fix it. Thanks! diff -u -r mysql-3.23.54/scripts/safe_mysqld.sh mysql-3.23.54-fixsafemysqld/scripts/safe_mysqld.sh --- mysql-3.23.54/scripts/safe_mysqld.shThu Dec 5 17:37:05 2002 +++ mysql-3.23.54-fixsafemysqld/scripts/safe_mysqld.sh Fri Dec 13 12:11:30 2002 @@ -159,11 +159,11 @@ NOHUP_NICENESS=`nohup nice 21` if test $? -eq 0 test x$NOHUP_NICENESS != x0 nice --1 echo foo /dev/null 21 then -if $NOHUP_NICENESS -gt 0 +if test $NOHUP_NICENESS -gt 0 Applied. then - $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup + NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup Applied - both of these had already been reported to us. else - NOHUP_NICENESS=nice -$NOHUP_NICENESS nohup + NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup Actually, this is done intenionally. If the niceness is below zero, it already includes one minus-sign, so we only need to add one more instead of two. I was initally planning on rewriting this part to use nohup -n, but this parameter is not used on all platforms yet. Therefore Monty rewrote it to be more portable. Unfortunately he obviously did it in a hurry :( It's fixed in the BK tree now. Thanks for your contribution! Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+duLSVDhKrJykfIRAtjZAJ9uNzWLZu4vqS6lBhO4K55pfKrqCgCeLBB2 rvLFCzz3jaXnTzsse3A1ENM= =UCre -END PGP SIGNATURE- - 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: Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup
On Thu, 12 Dec 2002 18:41:05 -0700 Mariella Di Giacomo [EMAIL PROTECTED] wrote: Hello, I am running MySQL 4.0.5b 64 bits on a Solaris 2.8. The server used has 8 CPUs. MySQL DB has access (and menage) in that system 2DBs. The first DB is only is accessed only through SELECTS and the second one has been used for UPDATES and INSERTS. Initially I was running a process that was updating the tables. In the program there is no contention among tables and there is only one process that executes UPDATES AND INSERTS. Apparently as soon as people start accessing the other DB (quite heavily) the time spent by MySQL in lwp_mutex_wakeup lwp_mutex_lock increases a lot . This is a screen shot taken with truss of the process in a certain timeframe. As soon as all the shutdown all the users from the DB that is used for only SELECT, now the same process that runs MySQL updates on the other DB has hardly ever lwp_mutex_wakeup lwp_mutex_lock calls. Could someone, please, help me trying to understand why that is the behavior ? Thanks a lot, Mariella The above is not necessarily related to UPDATE's of DELETE's, but to the more frequent creation / destruction of threads. MySQL enforces quite a few locks in order to enable safe operation, safe statistics colletion, memory management etc. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Syntax error in safe_mysqld (and safe_mysqld.sh)
Description: I found 3 syntax errors found in safe_mysqld (and safe_mysqld.sh), in both source and binary distribution of MySQL 3.23.54. Since syntax errors are appearent, so I just post the patch file here to fix it. diff -u -r mysql-3.23.54/scripts/safe_mysqld.sh mysql-3.23.54-fixsafemysqld/scripts/safe_mysqld.sh --- mysql-3.23.54/scripts/safe_mysqld.shThu Dec 5 17:37:05 2002 +++ mysql-3.23.54-fixsafemysqld/scripts/safe_mysqld.sh Fri Dec 13 12:11:30 2002 @@ -159,11 +159,11 @@ NOHUP_NICENESS=`nohup nice 21` if test $? -eq 0 test x$NOHUP_NICENESS != x0 nice --1 echo foo /dev/null 21 then -if $NOHUP_NICENESS -gt 0 +if test $NOHUP_NICENESS -gt 0 then - $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup + NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup else - NOHUP_NICENESS=nice -$NOHUP_NICENESS nohup + NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup fi else NOHUP_NICENESS=nohup I think it is clear enough. Please mail me [EMAIL PROTECTED] if it is still not clear for any reason. How-To-Repeat: N/A Fix: Fix is above. Submitter-Id: [EMAIL PROTECTED] Originator:¨Ìº¿¿ß Organization: MySQL support: none Synopsis: Syntax error in safe_mysqld (and safe_mysqld.sh) Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: Linux 2.4.20, both Red Hat and Mandrake. System: Linux atlas.pristine.com.tw 2.4.20 #2 Sat Nov 30 22:51:59 CST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/3.2/specs Configured with: ./configure --quiet --prefix=/usr --sysconfdir=/etc --localstatedir=/var --libdir=/usr/lib --infodir=/usr/share/info --mandir=/usr/share/man Thread model: posix gcc version 3.2 Compilation info: CC='gcc' CFLAGS=' -g -O3' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2¤ë 6 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285480 9¤ë 10 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 1822532 9¤ë 10 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 9¤ë 10 2001 /usr/lib/libc.so Configure command: ./configure '--quiet' '--prefix=/usr' '--sysconfdir=/etc' '--localstatedir=/var/lib/mysql' '--libdir=/usr/lib' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-assembler' '--with-unix-socket-path=/var/run/mysql/mysql.sock' '--with-mysqld-user=mysql' '--with-mysqld-ldflags=-all-static' '--without-bench' '--with-extra-charsets=all' 'CFLAGS= -g -O3' - 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: access-mysql
MySQL-Front was super and has a built in utility. Can do it remotely or locally. To bad they stopped supporting it. - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: Crercio O. Silva [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 5:06 AM Subject: RE: access-mysql thnx to all! am checking this links out.. looks great! :) -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de Dezembro de 2002 12:30 To: MySQL List Subject: Re: access-mysql DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Using MS Access as front end to mysql database
We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS Access as the front end to the database. Our reasons are - we have an existing Access database with a small number of users at different locations that need to be entering data, running reports and queries. We also have a large number of agencies that would hit the database. It was our intent to migrate the data tables to mysql and leave MS Access as the front end. When we asked our web host about this, they responded this way: Due to security concerns you would not be able to connect to our mysql server thru an external terminal directly as a mysql client. You would be able to use mysql services only thru Web sevices i.e either thru php scripts or thru phpmyadmin in Control panel--Advanced Menu--Sql Databases _ My questions are - Is this true of all web hosts or just the one we are using? Our current hosting plan is a shared hosting plan. Do we have to have a dedicated database server to do this? Knowing that we want to keep MS Access as the front end, are there other options we have not explored? - 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
Compiling MySQL binary?
Hello, I'm interested in compiling my own MySQL binaries but I'm not quite sure of what all I will need to do so. From what I understand, thus far, I will need a MySQL source package and a compiler. Is there anything else I will need to complete this task and does anyone have a recommendation as to which compiler would be best suited to this task? I'm planning on compiling binaries for both Mac OS X and Windows XP. Thank you! Brian -- Brian S. Radford [EMAIL PROTECTED] __ Post your ad for free now! http://personals.yahoo.ca - 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
Addendum to the MySQL 3.23.54 release
I get an error after adding the test bit: /usr/local/mysql/bin/safe_mysqld: 5=nice --5 nohup: command not found - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.54 is released
On Thu, 12 Dec 2002, Lenz Grimmer wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Hello MySQL 3.23.54, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is a bugfix release for the current stable tree. Apart from fixing several bugs, this release also resolves multiple security vulnerabilities that have been found and reported to us by Stefan Esser from e-matters GmbH, Germany. You can read the full text of Stefans advisory here: http://security.e-matters.de/advisories/042002.html Can somebody issue a patch (or patches) for this vulnerabilities against a older (3.23.49) mysql version ? Problem is that we have to way to use the new versions as all MySQL versions starting from 3.23.50 freeze on high load. Thanks Mihai RUSU Disclaimer: Any views or opinions presented within this e-mail are solely those of the author and do not necessarily represent those of any company, unless otherwise specifically stated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL crashes with foreign key restraints
Dear list, I am using MySQL-max 4.0.1 on Win 98 Second Edition with InnoDB as default table type. Using DeZign, I created the following SQL file with three tables (I left out all those other CHAR and TEXT fields here): CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)); CREATE TABLE Teilnehmer( id SMALLINT UNSIGNED NOT NULL, pid SMALLINT UNSIGNED, FOREIGN KEY (pid) REFERENCES Projekt (id), PRIMARY KEY (id), INDEX IDX_Teilnehmer_1 (pid)); CREATE TABLE Bewertung( pid SMALLINT UNSIGNED NOT NULL, #FOREIGN KEY (pid) REFERENCES Projekt (id), INDEX IDX_Bewertung_1 (pid)); Importing this in MySQL batch mode makes the MySQL server crash immediately. Everything works fine for table Projekt and Teilnehmer, but the line I commented out here for table Bewertung makes MySQL crash. Table Bewertung doesn't have a primary key, that's all the difference. Starting the server again and logging in, I find the first two tables are fine, but SHOW TABLE STATUS reports only NULL fields for table Bewertung, and InnoDB complains that it has no fields at all. Trying to drop this broken table results in 'table Bewertung doesn't exist'. To be able to delete the table (and the database), I have to delete Bewertung.frm manually. This makes InnoDB complain at server start like this: InnoDB: MySQL database directory from another database? InnoDB: Have you copied the .frm file of the table to the InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Error: table projekt/bewertung does not exist in the InnoDB internal InnoDB: MySQL database directory from another database? InnoDB: Have you copied the .frm file of the table to the InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Error: table projekt/bewertung does not exist in the InnoDB internal have moved .frm files to another database? Is there something wrong with my foreign key restraints, or is this a bug in InnoDB / MySQL? P.S. I tried the same with 4.0.3-max-nt on a Win2K box. Here, the server doesn't crash, but the response is can't create '.\projekt\teilnehmer.frm' with error 150 (unknown error). Commenting out the FOREIGN KEY lines solves the problem, but then again, I have no f.k.restraints :( Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - 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
Hi, I'm running Redhat 8.0 and I'm installing apache, php, mysql, postgres, openssl etc. my first step is to install mysql. I want it to be perl enabled, which means I have downloaded, (this is in compliance with the INSTALL BINARY doc that comes with mysql), http://www.mysql.com/doc/en/Perl_installation.html, Data-Dumper-2.101 DBI-1.18 Msql-Mysql-modules-1.2218 Data-Dumper and DBI installed OK, then I start mysql and try to install Msql-Mysql-modules. However I get an error when doing a make, the error is /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status thanks in advance christmas cheers, -- Luke Vanderfluit - 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: combine data from two tables
On Thursday 12 December 2002 20:35, Mark Goodge wrote: I'm hoping that someone can give me some pointers on this problem. I have two tables that contain similar data (eg, people.employees and people.volunteers). I need to run a select statement to retrieve names from both tables, and then display the data sorted by name so that it doesn't matter which table it came from. For example, if people.employees contains Amy, Charles and Eric, while people.volunteers contains Brian, David and Fred, then the resulting output needs to be displayed in this order: Amy Brian Charles David Eric Fred I could do this by post-processing the data in the script which retrieves it, but I'd prefer to get it in the correct order direct from MySQL. Any suggestions? You can do it with UNION in 4.0.x: http://www.mysql.com/doc/en/UNION.html or with TEMPORARY tables in 3.23.xx -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: order results by count of searched expression
On Thursday 12 December 2002 20:20, Martin Hudec wrote: I am trying to figure out sql command for ordering results descending by counts of searched expressions found in result. like this: $search=some; TEXT | COUNTS | - Something has..| 4| Some have..| 3| Some take..| 1| Can anyone help me please? SELECT text, count(*) as counts FROM table_name GROUP BY text ORDER BY counts DESC; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Fastest way to get the number of rows in a table ?
Hi. I need to know the number of rows in a table. select count(*) from a_table works fine but it is slow when the table is big. I am trying instead show table status like 'a_table'. The column 'Rows' should give me the number of rows in the table 'a_table'. This works fine for most of the tables but with one table, the value displayed is wrong. Demonstration (the database is quiet) : mysql select count(*) from photo\G *** 1. row *** count(*): 700 1 row in set (0.00 sec) mysql show table status like 'photo'\G *** 1. row *** Name: photo Type: InnoDB Row_format: Dynamic Rows: 603700 != 603 Avg_row_length: 135 Data_length: 81920 Max_data_length: NULL Index_length: 98304 Data_free: 0 Auto_increment: 19314 Create_time: NULL Update_time: NULL Check_time: NULL Create_options: Comment: InnoDB free: 2940928 kB; (iddatephoto) REFER dbcourant/datephoto(iddatephoto) ON DELETE CASCADE 1 row in set (0.01 sec) How do you explain the difference between count(*): 700 and Rows: 603 ? About the table photo: mysql show create table photo\G *** 1. row *** Table: photo Create Table: CREATE TABLE `photo` ( `idphoto` bigint(20) NOT NULL auto_increment, `idpropriete` int(11) NOT NULL default '0', `iddatephoto` bigint(20) NOT NULL default '0', `valeur` double default NULL, `prefixe` varchar(16) default NULL, `min` double default NULL, `max` double default NULL, PRIMARY KEY (`idphoto`), UNIQUE KEY `idpropriete` (`idpropriete`,`iddatephoto`), KEY `iddatephoto` (`iddatephoto`), FOREIGN KEY (`iddatephoto`) REFERENCES `dbcourant.datephoto` (`iddatephoto`) ON DELETE CASCADE ) TYPE=InnoDB 1 row in set (0.01 sec) mysql show create table datephoto\G *** 1. row *** Table: datephoto Create Table: CREATE TABLE `datephoto` ( `iddatephoto` bigint(20) NOT NULL auto_increment, `datephoto` datetime NOT NULL default '-00-00 00:00:00', `idarchive` bigint(20) NOT NULL default '0', `jamaiseffacer` char(1) NOT NULL default '', PRIMARY KEY (`iddatephoto`) ) TYPE=InnoDB 1 row in set (0.00 sec) Thanks in advance for your help. Christophe. *** Christophe DIARRA Institut de Physique Nucleaire 15, Rue Georges Clemenceau Bat 102 - S2I 91406 ORSAY Cedex Tel: (33) 1 69 15 65 60 Fax: (33) 1 69 15 45 03 (33) 1 69 15 64 70 E-mail: [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
Load Data Local Infile
Thanks for the suggestions. So far I haven't been able to get this to work except on the client command line. I'm trying to use some PHP scripts with mysql_connect() and have added MYSQL_OPT_LOCAL_INFILE to the connection script as well, but no go. I added [client} local-infile=1 [mysql] local-infile=1 [mysqld] local-infile=1 to the my.cnf file but that still hasn't done it. Could it be that recompiling with --enable-local-infile is the only way to get this to work? Does anyone have any other suggestions? Thanks very much Jon Bertsch - 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
DEMO TIME: Need best options for source/smp/raid/x86 need to do a demo
Well I opened my big mouth and now have to do a demo of MySQL on an old server that was destined for the dumpster. It has 4 Pentium III, 512 MB of memory (bus unknown), an HP 3 channel RAID controller (Megatrends?), and 8 SCSI disks in an external array. I've configured the disks to have 4 disks on each channel, and created 2 arrays, the array that will be for data has 3 drives on each channel. I've installed RedHat 8.0 which gives me GCC 3.2 I want to build two versions one with out InnoDB (non-max) and one with. The size of the database will be between 2-4 Gb What I'm looking for are some suggestions on ./configure options and potentially GCC options. Thanks in advance, -pete - 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
weird auto increment behaviour (bug???)
Hi all, I have recently encountered some strange (to me) behaviour with an auto increment column. It resulted because of an oversight in table creation. Here is some SQL statements that will illustrate my issue: CREATE TABLE test ( ID INT AUTO_INCREMENT, Name CHAR(30), KEY (Name, ID) )TYPE=MyISAM; INSERT INTO test SET Name=bob; INSERT INTO test SET Name=tom; Now, both of those columns got ID=1 from the insert. A few observations: 1) MySQL requires AUTO_INCREMENT columns to have an index. This table uses ID as an index, but it's not a leftmost-prefix of any index, which i thought would give a create error. (is this a bug?) 2) considering this non auto increment behaviour, i would think that ID should be NULL, since ID is allowed NULL values, and no value was assigned to the ID in the insert statements. Also, this works the same if ID is defined asID INT NOT NULL AUTO_INCREMENT It seems that this is what's happening: When MySQL executes the insert queries, it correctly recognizes that ID is an AUTO_INCREMENT column, so it tries to get the new auto increment value. But, because ID isnt properly indexed for an auto increment column, the value is incorrectly reported, and the column is set to 1 every time. weird, huh? sean peters [EMAIL PROTECTED] mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug hpux 11.00
[wht20] ./mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1064 You have an error in your SQL syntax near 'TE TABLE db ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary D' at line 1 021213 9:34:57 Aborting 021213 9:34:57 /usr/local/mysql/libexec/mysqld: Shutdown Complete Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script! SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.52 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: HP-UX wht20 B.11.00 U 9000/800 103901517 unlimited-user license Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.2/specs Configured with: ./configure : (reconfigured) ./configure : (reconfigured) ./c onfigure : (reconfigured) ./configure : (reconfigured) ./configure : (reconfi gured) ./configure : (reconfigured) ./configure : (reconfigured) ./configure : (reconfigured) ./configure : (reconfigured) ./configure : (reconfigured) ./c onfigure Thread model: posix gcc version 3.2 Compilation info: CC='gcc' CFLAGS='-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT' CXX ='g++' CXXFLAGS='-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT' LDFLAGS='-L/usr/local /lib' LIBC: lrwxr-xr-x 1 root sys 8 Dec 2 22:00 /lib/libc.0 - ./libc. 1 -r-xr-xr-x 1 binbin1863680 Nov 19 1999 /lib/libc.1 -r-xr-xr-x 1 binbin1560576 Aug 13 10:06 /lib/libc.2 -r--r--r-- 1 binbin2187296 Aug 13 10:06 /lib/libc.a lrwxr-xr-x 1 root sys 15 Dec 2 21:49 /lib/libc.sl - /usr/l ib/libc.2 lrwxr-xr-x 1 root sys 8 Dec 2 22:00 /usr/lib/libc.0 - ./l ibc.1 -r-xr-xr-x 1 binbin1863680 Nov 19 1999 /usr/lib/libc.1 -r-xr-xr-x 1 binbin1560576 Aug 13 10:06 /usr/lib/libc.2 -r--r--r-- 1 binbin2187296 Aug 13 10:06 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Dec 2 21:49 /usr/lib/libc.sl - /u sr/lib/libc.2 Configure command: ./Configure --with-pthread --prefix=/usr/local/mysql --exec-p refix=/usr/local/mysql --with-libwrap=/usr/local --with-named-thread-libs=-lpthr ead --with-low-memory CC=gcc 'CFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT' 'CP PFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT' 'CXXFLAGS=-D_HPUX_SOURCE -D__hpux __ -D_REENTRANT' CXX=g++ LDFLAGS=-L/usr/local/lib M - 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 opening/finding default database when running mysqld through'safe_mysqld ' command...
Description: Firstly, I don't believe this is a bug, but I really can't figure it out. I've installed MySQL through the Red Hat 8 distribution CDs. When I run safe_mysqld, I have the following message: [root@localhost bin]# safe_mysqld [1] 25488 [root@localhost bin]# Starting mysqld daemon with databases from /var/lib/mysql 021213 01:53:09 mysqld ended I check the log file, /var/log/mysqld.log, and it says: /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) The log file changes each time I execute safe_mysqld, therefore I know this is the log file it is using. I have run the mysql_install_db script and it placed all of the default stuff (including host.frm) in /var/lib/mysql/mysql/. The permissions are all checked for 'User' and I am logged in as root. I've tried setting all the permissions completely for everyone and tried copying all the default database files to /var/lib/mysql/. My my.cnf file contains the following: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-innodb [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I'm also certain this file is being read, since I had to add skip-innodb, which was giving me another warning/error message. Well, I'm pretty sure this is just something stupid I'm missing, but I would really appreciate some help. I've been looking through the manual, reading over the sections about trouble starting up several times... No luck. Submitter-Id: Chris Wagner Originator:root Organization: None MySQL support: none Synopsis:Unable to run mysqld because it cannot find the default database which was installed with mysql_install_db Severity:non-critical Priority: low/medium Category:mysql Class: support ] Release:mysql-3.23.52 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 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/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Dec 9 19:12 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x2 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 18:50 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --datadir=/usr/share --libdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info --without-readline --without-debug --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-innodb --enable-local-infile --enable-large-files=yes --enable-largefile=yes --with-berkeley-db --with-thread-safe-client 'CFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' Thanks a ton. - 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: a simple query
SELECT a.Name,b.Name,c.Name FROM your_table a LEFT OUTER JOIN your_table b ON a.Code=b.ParentFemale LEFT OUTER JOIN your_table c ON a.Code=c.ParentMale -Original Message- From: Fam. Tarniceru [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 3:39 PM To: MySQL Mailing List Subject: a simple query Hi, I have a table like this: --- | Code | Name | ParentFemale | ParentMale | --- |1 | Child| 2 | 3 | --- |2 | Mather | 0 | 0 | --- |3 | Father | 0 | 0 | --- and I need a query to obtain this table: -- | Name | ParentFemale | ParentMale | -- | Child | Mather | Father| -- and if in I have the next values in table 1 --- | Code | Name | ParentFemale | ParentMale | --- |1 | Child| 0 | 0 | --- |2 | Mather | 0 | 0 | --- |3 | Father | 0 | 0 | --- I need the next values for table 2: -- | Name | ParentFemale | ParentMale | -- | Child | Null| Null | -- Can you help me, please? Sincerely, Adrian --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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
Major upgrade
Hi, I just became the database admin on this server, my first job was to upgrade the mysql install, it was running 3.22.30, I upgraded it to 3.23.54 Seemed to go OK, just want to check... I moved all the databases from var in the old install to data in the new install... all the databases seem to be there and user logins would appear to work fine... has there been any cases of loss of data? I have a full dump of all the data if it turns out i have to propogate the data that way instead... Regards Ewan -- Ewan Oughton [0143324] 2nd Year B.Sc. Comp Sys http://www.10xshot.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.54-max GLIBC errors
I am currently running MySQL3.23.53-max with no problems, well my_print_default complains about the same thing that MySQL-3.23.54 complains about, but MySQLd runs fine. I am attempting to upgrade to MySQL3.23.54 (mysql-max-3.23.54-pc-linux-i686.tar.gz) and MySQLd does not run at all, below are the errors I receive: /usr/local/sqldrive/mysql-3.23.54-max/bin/my_print_defaults: /lib/libc.so.6: version `GLIBC_2.1.3' not found (required by /usr/local/sqldriv) /usr/local/sqldrive/mysql-3.23.54-max/bin/my_print_defaults: /lib/libc.so.6: version `GLIBC_2.2' not found (required by /usr/local/sqldrive/) rhea:/usr/local/sqldrive/mysql-3.23.54-max/data ./bin/my_print_defaults: /lib/libc.so.6: version `GLIBC_2.1.3' not found (required by ./bi) ./bin/my_print_defaults: /lib/libc.so.6: version `GLIBC_2.2' not found (required by ./bin/my_print_defaults) 021213 12:34:25 mysqld started /usr/local/sqldrive/mysql-3.23.54-max/bin/mysqld: /lib/libpthread.so.0: version `GLIBC_2.2' not found (required by /usr/local/sqldrive/mysql- 3.23.54-max/bin/mysqld) /usr/local/sqldrive/mysql-3.23.54-max/bin/mysqld: /lib/libc.so.6: version `GLIBC_2.1.3' not found (required by /usr/local/sqldrive/mysql-3.23 .54-max/bin/mysqld) /usr/local/sqldrive/mysql-3.23.54-max/bin/mysqld: /lib/libc.so.6: version `GLIBC_2.2' not found (required by /usr/local/sqldrive/mysql-3.23.5 4-max/bin/mysqld) 021213 12:34:25 mysqld ended Does anyone else receive these errors and/or know a fix? Also, I only have this problem with MAX, I can run the regular version of 3.23.54 fine. Example: rhea:/tmp/mysql-3.23.54-pc-linux-i686/bin ./mysqld ./mysqld: Can't change dir to '/usr/local/sqldrive/mysql-3.23.53-max/var/' (Errcode: 2) 021213 12:39:29 Aborting 021213 12:39:29 ./mysqld: Shutdown Complete rhea:/tmp/mysql-3.23.54-pc-linux-i686/bin cd /usr/local/sqldrive/mysql-3.23.54-max/ rhea:/usr/local/sqldrive/mysql-3.23.54-max/bin ./mysqld ./mysqld: /lib/libpthread.so.0: version `GLIBC_2.2' not found (required by ./mysqld) ./mysqld: /lib/libc.so.6: version `GLIBC_2.1.3' not found (required by ./mysqld) ./mysqld: /lib/libc.so.6: version `GLIBC_2.2' not found (required by ./mysqld) Thanks Nickg - 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: Nested MySQL Statements
On Friday 13 December 2002 14:43, Peter Vertes wrote: Is it possible to do nested select statements with MySQL ? Basically I'm trying to display the last 5 rows that got inserted into a table. My SQL query looks like this: select * from tablename limit ((select count(*) from tablename) - 5), -1; In theory it works for me :) but MySQL complains. Is it possible to do nested queries with MySQL ? Does anyone have a better way of displaying the last x amount of rows inserted into a table ? Thanks in advance... There is no internal order in the table, there is no last record and nope the first row in the table. If you have auto_increment column, you can do it like SELECT ORDER BY id DESC LIMIT 5; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: MySQLd-nt -3.23.53 Max
On Friday 13 December 2002 04:47, Charles Mabbott wrote: I have some Access pages hooked to web, but a newbe with this [mysql] on laptop. Running NT, windows office '98. I have found some stuff going through tutorial, which I am impressed at how much is really working right out of the book. I am sure has been found. but I was not able to get [following] to work: LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet; {tutorial} not supported Add local-infile=1 into [mysqld] and [mysql] sections of my.cnf(my.ini) or start MySQL server and client with --local-infile option: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html LOAD DATA INFILE c:\\mysql\\pet.txt INTO TABLE pet; works fine and the '\' is a delimiter, so must be repeated. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: MySQL4 user table not showing GRANT privileges correctly
On Saturday 14 December 2002 02:49, John Dell wrote: Using MySQL 4.0.5a, GRANT is correctly adding users (and the privileges are working), but when you view the mysql.user table, all privileges are showing up as 'N', when some of them should be 'Y'. Anybody seen this or understand what's going on? For example: GRANT SELECT ON dbname.* TO test@localhost IDENTIFIED BY 'testpass'; flush privileges; SELECT * FROM USER WHERE User='test'; It will show 'N' in all privilege columns which is wrong. It should show a 'Y' in the select_priv column. Is this a bug/feature or what? It's not a bug ;) Table 'user' contains only global privileges and you give to user only database level privileges ;) Take a look in the table 'db'. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: relational is relational is relational, but ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, all -- ...and then David T-G said... % % I apologize in advance for asking kindergarten-level questions on the % list, but my head is getting really bruised from this one. I'm trying to I still don't understand it all ;-) but I have a somewhat better grasp. I've just returned from a trip and caught up here and also caught up on some digging on my system (we do not have innodb support compiled in). The cascading association of two keys (a parent and a child were helpful descriptors for me) is what I wanted to acheive, and for now I'll just have to enforce that in software (manually updating SALES.cust when I for some reason change CUSTOMERS.num in my example). I don't actually foresee these fields changing their values, so I'm not too worried anyway. When I actually roll out a system for a client, I'll be installing all of the LAMP components and can compile in innodb support and then update my schema (hey, I used some jargon! ;-) appropriately. I don't want to muck with either the installed mysql, thereby potentially screwing up others on the server, or the installation of a parallel innodb-enabled mysqld on the box. Thanks again! mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9+yiIGb7uCXufRwARAkIJAJ9HeubT6+spkxJVTSzzs4qdZosQwwCg4xwW rVyr8H7CnTlxeFmx+a0znVc= =xULn -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL Help - Initial Configuration
On Friday 13 December 2002 22:19, Benjamin Fisher wrote: I'm fairly new to MySQL, and RDBMS's in general, but not to system administration nor linux. I'm running Gentoo, and I can't seem to get mySQL to work. [skip] My guess, it can't find the pid to stop it with. And the file /var/run/mysqld/mysqld.pid (or something like that) doesn't exist. Running 'safe_mysqld --user=mysql ' does the following: Gallio root # safe_mysqld --user=mysql [1] 5632 Gallio root # Starting mysqld daemon with databases from /var/lib/mysql 021213 11:47:23 mysqld ended Look in the error log file to see what is wrong with MySQL start. When I escape out of that: [1]+ Done safe_mysqld --user=mysql I'm not sure what has gone wrong, but I'd like to get the mysql up and running. BTW, what would be a worthy book to get on mySQL? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
The InnoDB on raw devices...
I'm trying to use InnoDB on raw device under Windows XP Prof. my innodb_data_file_path is : innodb_data_file_path = /dev/hda2:5Gnewraw but mysql not create a database :( any idea ? my system is : MySQL 3.23.54 on Windows XP Tnks, sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [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: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?
Hello, I've tried your way, but my SQL reports error, that I have specified more than ONE primary key, so I can't do the primary key on both fields. Is that a mySQL 3.X limitation ? My tables are ISAM. Following your advice, I've deleted the relation_person_carID, so only cardID and personID are left i nthe table, with no primary key. Is it a good idea, and is it safe, not to have a primary key ? Cheers, Damien COLA -Message d'origine- 3) table relation_person_car personID int 11 carID int 11 PRIMARY KEY (personID,carID) something like : table relation_person_car relation_personID primary int 11 autoincrement personID int 11 carID int 11 - 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: Nested MySQL Statements
Not until version 4.1 -Original Message- From: Peter Vertes [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 8:43 AM To: MySQL Help List (E-mail) Subject: Nested MySQL Statements Hello All, Is it possible to do nested select statements with MySQL ? Basically I'm trying to display the last 5 rows that got inserted into a table. My SQL query looks like this: select * from tablename limit ((select count(*) from tablename) - 5), -1; In theory it works for me :) but MySQL complains. Is it possible to do nested queries with MySQL ? Does anyone have a better way of displaying the last x amount of rows inserted into a table ? Thanks in advance... -Pete Peter Vertes Beast Financial Systems 404 Fifth Avenue New York, NY 10018 - 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: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?
Could you post your create table statement? It should be something like: CREATE TABLE relation_person_car( personID int 11 NOT NULL, carID int 11 NOT NULL, PRIMARY KEY (personID,carID) ); -Original Message- From: Alliax [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 9:16 AM To: Adolfo Bello; [EMAIL PROTECTED] Subject: RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ? Hello, I've tried your way, but my SQL reports error, that I have specified more than ONE primary key, so I can't do the primary key on both fields. Is that a mySQL 3.X limitation ? My tables are ISAM. Following your advice, I've deleted the relation_person_carID, so only cardID and personID are left i nthe table, with no primary key. Is it a good idea, and is it safe, not to have a primary key ? Cheers, Damien COLA -Message d'origine- 3) table relation_person_car personID int 11 carID int 11 PRIMARY KEY (personID,carID) something like : table relation_person_car relation_personID primary int 11 autoincrement personID int 11 carID int 11 - 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
Unable to start mysqld
Description: Running most or all of the mysql binaries results in the error: dynamic linker: my_print_defaults: relocation error: symbol not found: main illed I've installed pthreads 3.5c, but am unsure of their proper destination. How-To-Repeat: ./mysqld Fix: Submitter-Id: submitter ID Originator:Nachman Yaakov Ziskind Organization: _ Nachman Yaakov Ziskind, EA, LLM [EMAIL PROTECTED] Attorney and Counselor-at-Law http://yankel.com Economic Group Pension Services http://egps.com Actuaries and Employee Benefit Consultants Support: None Synopsis: Unable to run program Severity: Priority: Category: mysql Class: Release: mysql-3.23.53 (Official MySQL binary) Environment: System: SCO_SV egps 3.2 5.0.6 i386 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-sco3.2v5.0.5/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root sys 35 Jul 12 16:29 /lib/libc.a - /opt/K/SCO/unixds/5.1.2A/lib/libc.a lrwxrwxrwx 1 root sys 36 Jul 12 16:29 /lib/libc.so - /opt/K/SCO/unixds/5.1.2A/lib/libc.so lrwxrwxrwx 1 root sys 39 Jul 12 16:29 /usr/lib/libc.a - /opt/K/SCO/unixds/5.1.2A/usr/lib/libc.a lrwxrwxrwx 1 root sys 40 Jul 12 16:29 /usr/lib/libc.so - /opt/K/SCO/unixds/5.1.2A/usr/lib/libc.so lrwxrwxrwx 1 root root 41 Sep 5 2000 /usr/lib/libc.so.1 - /opt/K/SCO/Unix/5.0.6Ga/usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --with-named-z-libs=no --enable-thread-safe-client --disable-shared --without-innodb 'CFLAGS=-O3 -mpentium' 'CXXFLAGS=-O3 -mpentium -felide-constructors' CXX=gcc LDFLAGS=-static Perl: This is perl, version 5.003 with EMBED - 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: Error rebuilding 3.23.54 source rpm, glibc 2.1?
Hi I've got an older redhat 6.2 box that has glibc 2.1.3-28 on it. The binary rpm's won't install (needs glibc 2.2), and rebuilding the source rpm gives: [...] error: Bad exit status from /var/tmp/rpm-tmp.94268 (%build) You don't need a newer glibc version but a newer compiler. RedHat 6.2 comes with the egcs compiler. You need gcc 2.95. I'm using gcc-2.95.4-4h (but gcc-2.95.2-1i works, too). You can find all you need at www.rpmfind.net. Look for YellowDog linux SOURCE packages. YellowDog is for PowerPC, but it's fully RedHat compatible and rebuilding source packages works perfectly. 1. download gcc-2.95.4-4h.src.rpm from http://rpmfind.net/ (gcc-2.95.2-1i.src.rpm works, too) 2. built rpms for gcc-2.95-4 on your RH62 box executing: # rpm --rebuild gcc-2.95.4-4h.src.rpm(*) You will find rebuilded packages in /usr/src/redhat/RPMS/i386/ 3. Remove old egcs and install the gcc-2.95-4 rpms you've built. You will need to install gperf-2.7-6.i386.rpm if it is not already installed (it's on your RedHat CD-ROM). # rpm -e egcs-c++-1.1.2-30 # rpm -e egcs-objc-1.1.2-30 # rpm -e egcs-1.1.2-30 # rpm -e cpp-1.1.2-30 # rpm -ivh cpp-2.95.4-4h.i386.rpm # rpm -ivh gcc-2.95.4-4h.i386.rpm # rpm -ivh libstdc++-2.10.0-4h.i386.rpm # rpm -ivh gcc-c++-2.95.4-4h.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm 4. Optional: at this time you may want to rerebuild your gcc 2.95.4 with itself. 5. Rebuild MySQL (*): # rpm --rebuild MySQL-3.23.xx-1.src.rpm 6. Finally install MySQL binaries (*) To rebuild MySQL-2.23.54-1 you also need to upgrade a few packages. Look at the Compiling 3.23.54-1 - new tools installed ! thread. - 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: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?
Hello, you're right, creating the table with 2 primary keys works fine. What I was doing is try to convert my personID and carID fields into primary, and it says: Error MySQL : Invalid SQL: ALTER TABLE `varmalinalliax`.`tgl_rel_rest_card` CHANGE `restID` `restID` INT (11) DEFAULT '0' NOT NULL , CHANGE `cardID` `cardID` INT (11) DEFAULT '0' NOT NULL , ADD PRIMARY KEY(`restID`), ADD PRIMARY KEY(`cardID`) Error My SQL number: 1068 (Multiple primary key defined) What simple query could I make to transform the fields in primary ? I don't have access to the mysql server via command line, I use a php package (eSKUeL, it's like phpMyAdmin) Cheers, Damien COLA -Message d'origine- Could you post your create table statement? It should be something like: CREATE TABLE relation_person_car( personID int 11 NOT NULL, carID int 11 NOT NULL, PRIMARY KEY (personID,carID) ); - 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: REGEXP emal address query
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard -- ...and then Richard Baskett said... % % Ok finally found the answer after many hours of searching :) Here is the % MySQL query that works great! % % SELECT * FROM table_name % WHERE Email NOT % REGEXP ^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3} Boy, is this convoluted. Ick :-) One thing that should be clarified is that ^[abc] looks for 'a' or 'b' or 'c' at (the beginning of the line), while [^abc] looks for (anything except 'a' or 'b' or 'c') at that position, and ^[^abc] looks for (anything except 'a' or 'b' or 'c') at (the beginning of the line). Another is that there are 4-char TLDs such as .info which your regexp does not accept; you'll probably need to change that (and, meanwhile, something like .xx is probably not a real TLD and so you shouldn't accept that if you're really trying to ensure valid addresses or at least valid domains). If not, not only badaddre.ss but even [EMAIL PROTECTED] would be selected, and the latter certainly has the '@' that you've said you want to exclude from your results. I don't know the MySQL regexp rules, but are searches case-insensitive (probably) and is '.' within a character class treated literally (maybe)? Finally, I am not at all sure that you can't have an email address beginning with [-_\.] (though I don't have time to test it at the moment). Wouldn't something simple like ... WHERE Email NOT REGEXP .*@.* do the job nicely (if not the 'NOT REGEXP @' of another reply)? It certainly would be easier to read :-) % % Thanks to all that replied! HTH HAND % % Rick mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9+zhHGb7uCXufRwARAtDyAJsFeRprjoHpgLcc4f2YEK56ziBDNACeMk2w gXldQg3pFKLD8B4ovNHFt7Q= =+ZuC -END PGP SIGNATURE- - 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: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?
Using the ALTER statement: Step 1.- DROP the primary key Step 2.- ADD the new primary key Adolfo -Original Message- From: Alliax [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 9:54 AM To: Adolfo Bello; [EMAIL PROTECTED] Subject: RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ? Hello, you're right, creating the table with 2 primary keys works fine. What I was doing is try to convert my personID and carID fields into primary, and it says: Error MySQL : Invalid SQL: ALTER TABLE `varmalinalliax`.`tgl_rel_rest_card` CHANGE `restID` `restID` INT (11) DEFAULT '0' NOT NULL , CHANGE `cardID` `cardID` INT (11) DEFAULT '0' NOT NULL , ADD PRIMARY KEY(`restID`), ADD PRIMARY KEY(`cardID`) Error My SQL number: 1068 (Multiple primary key defined) What simple query could I make to transform the fields in primary ? I don't have access to the mysql server via command line, I use a php package (eSKUeL, it's like phpMyAdmin) Cheers, Damien COLA -Message d'origine- Could you post your create table statement? It should be something like: CREATE TABLE relation_person_car( personID int 11 NOT NULL, carID int 11 NOT NULL, PRIMARY KEY (personID,carID) ); - 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
Automatically totalling columns.
Hi, I have two tables, one with peoples names in it and one with data associated to these people. What I need to do is to be able to automatically total certain items in the data table that correspond with a name in the first table and then update the name table.. i.e. This is a crude example, but you get the picture. When I add an item to the data table I want to have it so it automatically gets added to the correct person in the name table. I also have a third table which references these two tables. Can this be done from within MySQL. Names Data Col. 1 Col 2 Col. 1Col. 2 Fred$2.24Milk$1.00 Wilma $4.25Bread $1.24 Barney $1.00Eggs $2.19 Betty$3.19Butter $3.25 - 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: Addendum to the MySQL 3.23.54 release
Does this also affects the 3.23.54 source? Or only the binary packages? With kind regards, Richard Pijnenburg Klik-on Internet Solutions -Original Message- From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 16:19 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Addendum to the MySQL 3.23.54 release -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, unfortunately the MySQL 3.23.54 release includes a buglet in the mysqld_safe startup script that can lead to a syntax error message on startup. This does only apply to the Unix binaries, the Windows packages are not affected by this - they do not use this script at all. We will provide updated binary packages labelled as 3.23.54a which will fix this error ASAP. In the meanwhile, you can also correct this typo manually by following the instructions below. Please change into the directory where MySQL has been installed into (e.g. /usr/local/mysql) and open the file bin/safe_mysqld with a text editor. Now look for the following text at line 162: [SNIP] if $NOHUP_NICENESS -gt 0 then $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup [SNIP] This needs to be changed to: [SNIP] if test $NOHUP_NICENESS -gt 0 then NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup [SNIP] In other words, please add the word test to the line beginning with if and remove the dollar sign in front of NOHUP_NICENESS in the last line here. Alternatively, simply apply the following patch to safe_mysqld: [SNIP] - --- safe_mysqld.org Mon Nov 25 11:49:31 2002 +++ safe_mysqld Fri Dec 13 13:09:16 2002 @@ -159,9 +159,9 @@ NOHUP_NICENESS=`nohup nice 21` if test $? -eq 0 test x$NOHUP_NICENESS != x0 nice --1 echo foo /dev/null 21 then - -if $NOHUP_NICENESS -gt 0 +if test $NOHUP_NICENESS -gt 0 then - - $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup + NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup else NOHUP_NICENESS=nice -$NOHUP_NICENESS nohup fi [SNIP] We apologize for this mistake and for any inconveniences this may have caused you. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+fpLSVDhKrJykfIRAqXtAJ97stZCr2MwCEHgB6OVJ9Dcyq8ASQCfbZt4 XSqqje6wHmkCocGcV9O2EbQ= =3CXW -END PGP SIGNATURE- - 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 mysql-unsubscribe- [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: Fastest way to get the number of rows in a table ?
The numbers reported by SHOW TABLE STATUS in the case of an InnoDb table are *approximate*, not the real count. Note that the statistics SHOW gives about InnoDB tables are only approximate: they are used in SQL optimization. Table and index reserved sizes in bytes are accurate, though. See section 4 of the InnoDb manual. http://www.innodb.com/ibman.html Hope this helps = - Benoit St-Jean [EMAIL PROTECTED] Yahoo! Messenger: bstjean http://cactus.swiki.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
Different thread states in 3.23.54
Hi. Version downloads/mysql-3.23.htm3.23.54 seems to run the mysqld processes in the SN state (as opposed to S state that the previous versions did) - negative nice values. There is no reference to anything like this in the change logs - any reasons why? Please cc reply to my email address. Cheers, Luci - 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
English version of EasyPHP ??
I want to install EasyPHP with Apache-MySQL-PHP on a Windows laptop for use over the holidays... I am a newbie at all this. I installed EasyPHP on an extra Windows Desktop here to try it and all the doc's are in French. (It also installed phpmyadmin... doc's for this also in French) 1 - Is there a version of EasyPHP in English? 2 - Is there an EasyPHP mail list or other online user to user support(in English) ? Thanks in advance for any help. tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Portuguese Characters
Hi. I'm using MySql+MyODBC. When reading data in VB (ADO) from the database, the Portuguese characteres (çÇáãé, etcc) appear in a strange way. Any Ideas? Regards Luis Damas [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: MySQL 3.23.54 safe_mysqld fix
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 12 Dec 2002, Nick wrote: The following code is incorrect in safe_mysqld on 3.23.54 at least (that is all I have checked) Line 162: if $NOHUP_NICENESS -gt 0 then $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup This needs to be: if test $NOHUP_NICENESS -gt 0 then NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup Thanks for spotting this! I've now fixed it for the next release. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9+Z38SVDhKrJykfIRAr/DAJ4+YfJFYOtp4nhvxgYlXeA8O/GuZwCcD728 xlOjQ4JJ2KANXH11EHx/Nqs= =dd/k -END PGP SIGNATURE- - 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
âÍ¡ÒÈ·Ò§¸ØÃСԨ 15/12/2002 0:46:16
Dear mysql , á¹Ð¹Ó¸ØáԨ International e-Business ! àÃÕ¹ÃÙéÇÔ¸Õ¡Ò÷ӧҹ ¸ØáԨ¹Ò¹ÒªÒµÔ º¹ Internet àÃÕ¹ÃÙéá¼¹¡Ò÷ӧҹà¾ÔèÁÃÒÂä´é¾ÔàÈÉã¹áµèÅÐà´×͹ á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹¹Í¡àÇÅÒ 17,000 ¶Ö§ 100,000 ºÒ·/à´×͹ àÇÅÒ·Õèµéͧãªé : 7-14 ªÁ./ÊÑ»´ÒËì á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹àµçÁàÇÅÒ 50,000 ¶Ö§ 170,000 ºÒ·/à´×͹ àÇÅÒ·Õèµéͧãªé : 20-40 ªÁ./ÊÑ»´ÒËì á¼¹·ÓÃÒÂä´éàÃ觡ÓÅѧàµçÁ·ÕèẺ·Ó§Ò¹àµçÁàÇÅÒ ¤Ø³ÊÒÁÒö·ÓÃÒÂä´é 100,000 ºÒ·ã¹à´×͹áá ¤Ø³ÊÒÁÒö·ÓÃÒÂä´é 350,000 ºÒ·/à´×͹ ÀÒÂã¹ 6 à´×͹áá ´ÙÃÒÂÅÐàÍÕ´ä´é·Õè www.geocities.com/thaigetrich1/tgr076 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ á¹Ð¹Ó¸ØáԨ International e-Business ! Ready Made International e-Business ! Learn how to make extra money each month Part-Time Serious Income Plan. ß17,000 to ß100,000 a month. Time Needed: 7 to 14 hours a week. Full-Time Serious Income Plan. ß50,000 to ß170,000 a month. Time Needed: 20 to 40 hours a week. Full-Time Accelerated Plan. You could earn: ß100,000 in your first month. You could earn: ß350,000 a month within first 180 days. By doing a real ready-made business on net. Click now www.geocities.com/thaigetrich1/tgr076 http://www.geocities.com/thaigetrich1/tgr076 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ ¢ÍÍÀÑ ËÒ¡¢éͤÇÒÁ¹Õé¶Ù¡Êè§ä»Âѧ¤Ø³â´ÂºÑ§àÍÔ ËÒ¡¤Ø³µéͧ¡ÒÃãËéÃÒª×èͶ١źÍÍ¡¡ÃسÒÊè§ email ¢Í§¤Ø³ÁÒ·Õè [EMAIL PROTECTED] â´Âà¢Õ¹ËÑÇ¢éÍÇèÒUnsubscribe - 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: Fastest way to get the number of rows in a table ?
Dear Christophe, Type: InnoDB Rows: 603700 != 603 How do you explain the difference between count(*): 700 and Rows: 603 You don't have to explain this, the manual does ;-) http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#U sing_InnoDB_tables Note that the statistics SHOW gives about InnoDB tables are only approximate: they are used in SQL optimisation. Table and index reserved sizes in bytes are accurate, though. HTH! -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Christophe DIARRA [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, December 13, 2002 9:38 PM Subject: Fastest way to get the number of rows in a table ? Hi. I need to know the number of rows in a table. select count(*) from a_table works fine but it is slow when the table is big. I am trying instead show table status like 'a_table'. The column 'Rows' should give me the number of rows in the table 'a_table'. This works fine for most of the tables but with one table, the value displayed is wrong. Demonstration (the database is quiet) : mysql select count(*) from photo\G *** 1. row *** count(*): 700 1 row in set (0.00 sec) mysql show table status like 'photo'\G *** 1. row *** Name: photo Type: InnoDB Row_format: Dynamic Rows: 603700 != 603 Avg_row_length: 135 Data_length: 81920 Max_data_length: NULL Index_length: 98304 Data_free: 0 Auto_increment: 19314 Create_time: NULL Update_time: NULL Check_time: NULL Create_options: Comment: InnoDB free: 2940928 kB; (iddatephoto) REFER dbcourant/datephoto(iddatephoto) ON DELETE CASCADE 1 row in set (0.01 sec) How do you explain the difference between count(*): 700 and Rows: 603 ? About the table photo: mysql show create table photo\G *** 1. row *** Table: photo Create Table: CREATE TABLE `photo` ( `idphoto` bigint(20) NOT NULL auto_increment, `idpropriete` int(11) NOT NULL default '0', `iddatephoto` bigint(20) NOT NULL default '0', `valeur` double default NULL, `prefixe` varchar(16) default NULL, `min` double default NULL, `max` double default NULL, PRIMARY KEY (`idphoto`), UNIQUE KEY `idpropriete` (`idpropriete`,`iddatephoto`), KEY `iddatephoto` (`iddatephoto`), FOREIGN KEY (`iddatephoto`) REFERENCES `dbcourant.datephoto` (`iddatephoto`) ON DELETE CASCADE ) TYPE=InnoDB 1 row in set (0.01 sec) mysql show create table datephoto\G *** 1. row *** Table: datephoto Create Table: CREATE TABLE `datephoto` ( `iddatephoto` bigint(20) NOT NULL auto_increment, `datephoto` datetime NOT NULL default '-00-00 00:00:00', `idarchive` bigint(20) NOT NULL default '0', `jamaiseffacer` char(1) NOT NULL default '', PRIMARY KEY (`iddatephoto`) ) TYPE=InnoDB 1 row in set (0.00 sec) Thanks in advance for your help. Christophe. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Using MS Access as front end to mysql database
they can do it. they just dont want to. firewall rules can be established to allow connects to the mysql port from only the ip's assoc with your remote offices, etc etc the answer is you can do what you want. You just need a business partner who can service his customer properly. mysqlODBC can do what you want. where mysql is located is irrelevant, in the grand sense. you just point to an ip and a port. etc etc James Danforth -Original Message- From: Donna Flanders [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 6:59 AM To: [EMAIL PROTECTED] Subject: Using MS Access as front end to mysql database We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS Access as the front end to the database. Our reasons are - we have an existing Access database with a small number of users at different locations that need to be entering data, running reports and queries. We also have a large number of agencies that would hit the database. It was our intent to migrate the data tables to mysql and leave MS Access as the front end. When we asked our web host about this, they responded this way: Due to security concerns you would not be able to connect to our mysql server thru an external terminal directly as a mysql client. You would be able to use mysql services only thru Web sevices i.e either thru php scripts or thru phpmyadmin in Control panel--Advanced Menu--Sql Databases _ My questions are - Is this true of all web hosts or just the one we are using? Our current hosting plan is a shared hosting plan. Do we have to have a dedicated database server to do this? Knowing that we want to keep MS Access as the front end, are there other options we have not explored? - 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: MySQL crashes with foreign key restraints
Dear Heikki, thanks for the hint! please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. But please note what I said about 4.0.3: P.S. I tried the same with 4.0.3-max-nt on a Win2K box. Here, the server doesn't crash, but the response is can't create '.\projekt\teilnehmer.frm' with error 150 (unknown error). I had the same problems with 4.0.4 on Win2K. Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 9:47 PM Subject: Re: MySQL crashes with foreign key restraints Stefan, please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query Subject: MySQL crashes with foreign key restraints From: Stefan Hinz Date: Fri, 13 Dec 2002 16:17:56 +0100 -- -- Dear list, I am using MySQL-max 4.0.1 on Win 98 Second Edition with InnoDB as default table type. Using DeZign, I created the following SQL file with three tables (I left out all those other CHAR and TEXT fields here): CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)); CREATE TABLE Teilnehmer( id SMALLINT UNSIGNED NOT NULL, pid SMALLINT UNSIGNED, FOREIGN KEY (pid) REFERENCES Projekt (id), PRIMARY KEY (id), INDEX IDX_Teilnehmer_1 (pid)); CREATE TABLE Bewertung( pid SMALLINT UNSIGNED NOT NULL, #FOREIGN KEY (pid) REFERENCES Projekt (id), INDEX IDX_Bewertung_1 (pid)); Importing this in MySQL batch mode makes the MySQL server crash immediately. Everything works fine for table Projekt and Teilnehmer, but the line I commented out here for table Bewertung makes MySQL crash. Table Bewertung doesn't have a primary key, that's all the difference. Starting the server again and logging in, I find the first two tables are fine, but SHOW TABLE STATUS reports only NULL fields for table Bewertung, and InnoDB complains that it has no fields at all. Trying to drop this broken table results in 'table Bewertung doesn't exist'. To be able to delete the table (and the database), I have to delete Bewertung.frm manually. This makes InnoDB complain at server start like this: InnoDB: MySQL database directory from another database? InnoDB: Have you copied the .frm file of the table to the InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Error: table projekt/bewertung does not exist in the InnoDB internal InnoDB: MySQL database directory from another database? InnoDB: Have you copied the .frm file of the table to the InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Error: table projekt/bewertung does not exist in the InnoDB internal have moved .frm files to another database? Is there something wrong with my foreign key restraints, or is this a bug in InnoDB / MySQL? P.S. I tried the same with 4.0.3-max-nt on a Win2K box. Here, the server doesn't crash, but the response is can't create '.\projekt\teilnehmer.frm' with error 150 (unknown error). Commenting out the FOREIGN KEY lines solves the problem, but then again, I have no f.k.restraints :( - 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
Root user password changing
how exactly do I change the Root user's password for mysql? like this? : mysqladmin -u root -p'newpasswd' ? (without a space between -p and 'newpasswd' ?) and, if that is correct, I guess I'd then be presented with a prompt for the old passwd, right? Then, the new one would take effect? TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL crashes with foreign key restraints
Stefan, are you sure you used the script: CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)) TYPE=InnoDB; CREATE TABLE Teilnehmer( id SMALLINT UNSIGNED NOT NULL, pid SMALLINT UNSIGNED, FOREIGN KEY (pid) REFERENCES Projekt (id), PRIMARY KEY (id), INDEX IDX_Teilnehmer_1 (pid)) TYPE=InnoDB; SHOW CREATE TABLE Teilnehmer; ? On Linux I get: heikki@hundin:~/mysql-4.0.3-beta-pc-linux-gnu-i686/bin mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.3-beta-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE TABLE Projekt( - id SMALLINT UNSIGNED NOT NULL, - PRIMARY KEY (id)) TYPE=InnoDB; Query OK, 0 rows affected (0.22 sec) mysql mysql CREATE TABLE Teilnehmer( - id SMALLINT UNSIGNED NOT NULL, - pid SMALLINT UNSIGNED, - FOREIGN KEY (pid) REFERENCES Projekt (id), - PRIMARY KEY (id), - INDEX IDX_Teilnehmer_1 (pid)) TYPE=InnoDB; Query OK, 0 rows affected (0.01 sec) mysql mysql SHOW CREATE TABLE Teilnehmer; ++-- --+ | Table | Create Table | ++-- --+ | Teilnehmer | CREATE TABLE `Teilnehmer` ( `id` smallint(5) unsigned NOT NULL default '0', `pid` smallint(5) unsigned default NULL, PRIMARY KEY (`id`), KEY `IDX_Teilnehmer_1` (`pid`), FOREIGN KEY (`pid`) REFERENCES `test.Projekt` (`id`) ) TYPE=InnoDB | ++-- --+ 1 row in set (0.00 sec) mysql Please test again! Do you have the default charset set to german? The default is latin1 which I use. Note that The syntax of a foreign key constraint definition in InnoDB: [CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE CASCADE | ON DELETE SET NULL | RESTRICT] Both tables have to be InnoDB type and there must be an index where the foreign key and the referenced key are listed as the first columns. InnoDB does not auto-create indexes on foreign keys or referenced keys: you have to create them explicitly. Corresponding columns in the foreign key and the referenced key must have similar internal data types inside InnoDB so that they can be compared without a type conversion. The size and the signedness of integer types has to be the same. The length of string types need not be the same. ... If MySQL gives the error number 1005 from a CREATE TABLE statement, and the error message string refers to errno 150, then the table creation failed because a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails and it refers to errno 150, that means a foreign key definition would be incorrectly formed for the altered table. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 10:37 PM Subject: Re: MySQL crashes with foreign key restraints Dear Heikki, thanks for the hint! please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. But please note what I said about 4.0.3: P.S. I tried the same with 4.0.3-max-nt on a Win2K box. Here, the server doesn't crash, but the response is can't create '.\projekt\teilnehmer.frm' with error 150 (unknown error). I had the same problems with 4.0.4 on Win2K. Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 9:47 PM Subject: Re: MySQL crashes with foreign key restraints Stefan, please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at
RE: Using MS Access as front end to mysql database
Yup, agreed. MySQLODBC works over TCP/IP fine. I'm currently tunneling through a Linksys router to a database I have at home. If your provider is unwilling to compromise, it maybe time to look for another host. There are plenty of MySQL and MS SQL hosts who allow TCP/IP connections. At 11:56 AM 12/14/2002 -0800, JamesD wrote: they can do it. they just dont want to. firewall rules can be established to allow connects to the mysql port from only the ip's assoc with your remote offices, etc etc the answer is you can do what you want. You just need a business partner who can service his customer properly. mysqlODBC can do what you want. where mysql is located is irrelevant, in the grand sense. you just point to an ip and a port. etc etc James Danforth -Original Message- From: Donna Flanders [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 6:59 AM To: [EMAIL PROTECTED] Subject: Using MS Access as front end to mysql database We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS Access as the front end to the database. Our reasons are - we have an existing Access database with a small number of users at different locations that need to be entering data, running reports and queries. We also have a large number of agencies that would hit the database. It was our intent to migrate the data tables to mysql and leave MS Access as the front end. When we asked our web host about this, they responded this way: Due to security concerns you would not be able to connect to our mysql server thru an external terminal directly as a mysql client. You would be able to use mysql services only thru Web sevices i.e either thru php scripts or thru phpmyadmin in Control panel--Advanced Menu--Sql Databases _ My questions are - Is this true of all web hosts or just the one we are using? Our current hosting plan is a shared hosting plan. Do we have to have a dedicated database server to do this? Knowing that we want to keep MS Access as the front end, are there other options we have not explored? - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on Mac OS X S 10.2
Well, I think I ALMOST have figured out how to get the Apple installed MySQL running on Mac OS X Server 10.2 (not an XServe). I have it running but still have some issues: (Apple installs the mysql in /usr/share as opposed to /usr/local... as far as I can tell.) I am having trouble with 2 things: 1) Apple has also already created a user named mysql -this can be seen in the NetInfo Manager, no where else that I am aware of. This user's passwd is listed in NetInfo as * (an asterisk)... I do not know what that means unless it means one has not been set, i.e., anything. So that is one question I have, about the password and how to check it AND how to set it. Also, should I do a chown -R on Mysql/* to the user: mysql ? (Once I know or have set its passwd?) 2) Then I would like to know what to do to make THAT user the one who starts mysqld, instead of the mysql Root user which I am doing manually if I had to reboot. Thanks a lot for any help, TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: weird auto increment behaviour (bug???)
On Friday 13 December 2002 20:43, you wrote: Hi Sean, this is not a bug: http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html For MyISAM and BDB tables you can specify AUTO_INCREMENT on secondary column in a multi-column key. In this case the generated value for the autoincrement column is calculated as MAX(auto_increment_column)+1) WHERE prefix=given-prefix. This is useful when you want to put data into ordered groups. Regards Georg Hi all, I have recently encountered some strange (to me) behaviour with an auto increment column. It resulted because of an oversight in table creation. Here is some SQL statements that will illustrate my issue: CREATE TABLE test ( ID INT AUTO_INCREMENT, Name CHAR(30), KEY (Name, ID) )TYPE=MyISAM; INSERT INTO test SET Name=bob; INSERT INTO test SET Name=tom; Now, both of those columns got ID=1 from the insert. A few observations: 1) MySQL requires AUTO_INCREMENT columns to have an index. This table uses ID as an index, but it's not a leftmost-prefix of any index, which i thought would give a create error. (is this a bug?) 2) considering this non auto increment behaviour, i would think that ID should be NULL, since ID is allowed NULL values, and no value was assigned to the ID in the insert statements. Also, this works the same if ID is defined asID INT NOT NULL AUTO_INCREMENT It seems that this is what's happening: When MySQL executes the insert queries, it correctly recognizes that ID is an AUTO_INCREMENT column, so it tries to get the new auto increment value. But, because ID isnt properly indexed for an auto increment column, the value is incorrectly reported, and the column is set to 1 every time. weird, huh? sean peters [EMAIL PROTECTED] mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: chroot() in 3.23.54
Hi! On Dec 13, Andrew Rucker Jones wrote: Hi everyone, First off, please include my personal e-mail address in any responses, as i am not subscribed to the list. I run MySQL with the chroot option. Up until 3.23.54, it worked fine. Up until 3.23.54 it simply didn't work, as mysqld was able to access files outside chroot jail :( 3.23.54 changed the ordering in which some files were accessed (before or after chroot()), which messed up the whole system -- entire directories have to be copied or sym linked, for example. In particular, it seems that older versions perhaps held an open file descriptor to the directory where the database files are (which is outside of the chroot() environment) and was therefore able to manipulate the databases after the call to chroot(). That's, naturally, was totally wrong, and broke the whole idea of chroot(). 3.23.54 accesses the databases after chroot(), which is certainly more secure, but it causes the following problem, abbreviated from strace: chdir(/usr/local/var/mysql/) = 0 chroot(/chroot/mysql) = 0 chdir(/) = 0 open(./mysql/host.frm, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) This forces me to copy all of my databases into the root directory of the chroot jail (or at least create sym links to all of them), and leads Symlinking doesn't work. But you can hardlink, if you'd like. to output like the following: mysql show databases; +--+ | Database | +--+ | etc | | lib | | mysql| | tmp | | usr | | var | +--+ 6 rows in set (0.02 sec) Has anyone else had this problem, and is there an obvious work around that i'm missing? Obvious workaround is not to chroot to datadir, but to datadir/.. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Root user password changing
After loging in mysql as root, enter the command: SET PASSWORD FOR root=password('the_new_password'); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 5:07 PM To: [EMAIL PROTECTED] Subject: Root user password changing how exactly do I change the Root user's password for mysql? like this? : mysqladmin -u root -p'newpasswd' ? (without a space between -p and 'newpasswd' ?) and, if that is correct, I guess I'd then be presented with a prompt for the old passwd, right? Then, the new one would take effect? TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
INSERT confirmation? PHP
I'm designing a user database for PHP 4 and MySQL 3.32 or whatever. Users enter a class and it's workshops for their students. The 'Class' table has fields 'Name' and 'ID'. ID is the primary key and its an auto-incremented integer The 'Workshop' table has a field ID, Number, ClassID, Date, etc. The 'ClassID' should be the value of the ID field of its parent class. After I use an insert to create the Class data, how do I get the appropriate ClassID for the 'Workshop' table inserts? I could assume to use the very latest one, but that *might* break, as this is a multi-user database. Is there a way I can issue an insert statement, and get a return of the ID value it got? - 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: INSERT confirmation? PHP
hi mysql_insert_id http://www.php.net/manual/en/function.mysql-insert-id.php should do it! Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Steve Lefevre [mailto:[EMAIL PROTECTED]] Sent: 14 December 2002 21:28 To: [EMAIL PROTECTED] Subject: INSERT confirmation? PHP I'm designing a user database for PHP 4 and MySQL 3.32 or whatever. Users enter a class and it's workshops for their students. The 'Class' table has fields 'Name' and 'ID'. ID is the primary key and its an auto-incremented integer The 'Workshop' table has a field ID, Number, ClassID, Date, etc. The 'ClassID' should be the value of the ID field of its parent class. After I use an insert to create the Class data, how do I get the appropriate ClassID for the 'Workshop' table inserts? I could assume to use the very latest one, but that *might* break, as this is a multi-user database. Is there a way I can issue an insert statement, and get a return of the ID value it got? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL doesn't use named pipe on Win2K
Dear list, MySQL 4.0.5 seems to be the first version that does not use named pipes on my Win2K box ... Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 395 to server version: 4.0.5-beta-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql STATUS; -- mysql Ver 12.16 Distrib 4.0.5-beta, for Win95/Win98 (i32) Connection id: 395 Current database: Current user: gast@localhost SSL:Not in use Server version: 4.0.5-beta-max-nt-log Protocol version: 10 Connection: localhost via TCP/IP I can even use the pipe and socket option to mysql, and it will still use TCP/IP ... Can someone explain this? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL crashes with foreign key restraints
Dear Heikki, are you sure you used the script: CREATE TABLE Projekt( ... Yep. I tried 4.0.1 (on Win98), 4.0.3 and 4.0.4 (on Win2K with SP2), and tonight I tried 4.0.5a-max-nt on Win2K (with SP2, but another machine). Here's the result: C:\mysql\binmysql -usuperuser -p projekt my.dump.projekt.sql Enter password: C:\mysql\binmysql -usuperuser -p projekt Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 277 to server version: 4.0.5-beta-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql SHOW TABLES; +---+ | Tables_in_projekt | +---+ | bewertung | | projekt | | teilnehmer| +---+ 3 rows in set (0.00 sec) Hmm ... seems like 4.0.5 is the first MySQL/InnoDB working for me ... Thanks alot for your help, anyway! Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 10:28 PM Subject: Re: MySQL crashes with foreign key restraints Stefan, are you sure you used the script: CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)) TYPE=InnoDB; CREATE TABLE Teilnehmer( id SMALLINT UNSIGNED NOT NULL, pid SMALLINT UNSIGNED, FOREIGN KEY (pid) REFERENCES Projekt (id), PRIMARY KEY (id), INDEX IDX_Teilnehmer_1 (pid)) TYPE=InnoDB; SHOW CREATE TABLE Teilnehmer; ? On Linux I get: heikki@hundin:~/mysql-4.0.3-beta-pc-linux-gnu-i686/bin mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.3-beta-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE TABLE Projekt( - id SMALLINT UNSIGNED NOT NULL, - PRIMARY KEY (id)) TYPE=InnoDB; Query OK, 0 rows affected (0.22 sec) mysql mysql CREATE TABLE Teilnehmer( - id SMALLINT UNSIGNED NOT NULL, - pid SMALLINT UNSIGNED, - FOREIGN KEY (pid) REFERENCES Projekt (id), - PRIMARY KEY (id), - INDEX IDX_Teilnehmer_1 (pid)) TYPE=InnoDB; Query OK, 0 rows affected (0.01 sec) mysql mysql SHOW CREATE TABLE Teilnehmer; ++-- -- -- -- -- --+ | Table | Create Table | ++-- -- -- -- -- --+ | Teilnehmer | CREATE TABLE `Teilnehmer` ( `id` smallint(5) unsigned NOT NULL default '0', `pid` smallint(5) unsigned default NULL, PRIMARY KEY (`id`), KEY `IDX_Teilnehmer_1` (`pid`), FOREIGN KEY (`pid`) REFERENCES `test.Projekt` (`id`) ) TYPE=InnoDB | ++-- -- -- -- -- --+ 1 row in set (0.00 sec) mysql Please test again! Do you have the default charset set to german? The default is latin1 which I use. Note that The syntax of a foreign key constraint definition in InnoDB: [CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE CASCADE | ON DELETE SET NULL | RESTRICT] Both tables have to be InnoDB type and there must be an index where the foreign key and the referenced key are listed as the first columns. InnoDB does not auto-create indexes on foreign keys or referenced keys: you have to create them explicitly. Corresponding columns in the foreign key and the referenced key must have similar internal data types inside InnoDB so that they can be compared without a type conversion. The size and the signedness of integer types has to be the same. The length of string types need not be the same. ... If MySQL gives the error number 1005 from a CREATE TABLE statement, and the error message string refers to errno 150, then the table creation failed because a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails and it refers to errno 150, that means a foreign key definition would be incorrectly formed for the altered table. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and
Binary Compilers? (was: Compiling MySQL binary?)
Maybe it's just me, but I'm getting this sinking feeling I just asked another google question! :-/ How about I simplify my request to any recommendations for compiler(s) that would be suitable to compile Binaries for Mac OS X's Darwin 6.1 and/or... Windows XP... Thank you! Brian -- Brian S. Radford [EMAIL PROTECTED] On Friday, December 13, 2002, at 12:01 AM, Brian Radford wrote: Hello, I'm interested in compiling my own MySQL binaries but I'm not quite sure of what all I will need to do so. From what I understand, thus far, I will need a MySQL source package and a compiler. Is there anything else I will need to complete this task and does anyone have a recommendation as to which compiler would be best suited to this task? I'm planning on compiling binaries for both Mac OS X and Windows XP. __ Post your ad for free now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL doesn't use named pipe on Win2K
At 00:49 15/12/2002 +0100, Stefan Hinz wrote: Hi, Dear list, MySQL 4.0.5 seems to be the first version that does not use named pipes on my Win2K box ... Use the --enable-named-pipe at command prompt or in your configuration file my.ini/my.cnf: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. c:\mysql\binmysqld-nt --standalone --console --enable-named-pipe 021214 22:50:04 InnoDB: Started mysqld-nt: ready for connections c:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.54-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like %pipe%; +---+---+ | Variable_name | Value | +---+---+ | named_pipe| ON| +---+---+ 1 row in set (0.05 sec) mysql -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ 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
Binary Compilers? (was: Compiling MySQL binary?)
Maybe it's just me, but I'm getting this sinking feeling I just asked another google question! :-/ How about I simplify my request to any recommendations for compiler(s) that would be suitable to compile binaries for Mac OS X's Darwin 6.1 and/or... Windows XP... Thank you! Brian -- Brian S. Radford [EMAIL PROTECTED] On Friday, December 13, 2002, at 12:01 AM, Brian Radford wrote: I'm interested in compiling my own MySQL binaries but I'm not quite sure of what all I will need to do so. From what I understand, thus far, I will need a MySQL source package and a compiler. Is there anything else I will need to complete this task and does anyone have a recommendation as to which compiler would be best suited to this task? I'm planning on compiling binaries for both Mac OS X and Windows XP. __ Post your ad for free now! http://personals.yahoo.ca - 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: INSERT confirmation? PHP
Peter Lovatt wrote: mysql_insert_id should do it! According to documentation somewhere, last insert can sometimes return a different value than the most recent insert if the most recent insert failed. What is a better solution? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
running mysql (mysql users)
I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a mysql user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also, why is a mysql root user needed and what mysql privileges does that user need? I do not know how this fits in with the above users (root mysql) but I usually make myself a mysql superuser, should I do that? Thanks, TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL losing connection on WinXP
Hello, I have an application that reads and writes to a local MySQL database. On Wondows 2000, I have no problems, but on WinXP I am running into a situation where after executing 3000-4000 select queries, all of a sudden the application cannot connect to MySQL. I am using the ZeosLib components for Delphi. Does anyone know what could cause this to happen? Thanks, Dan Cumpian - 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
DBI or CGI perl error?
My database layout is as follows: mysql show columns from music; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | mrecno| int(6)| | PRI | 0 | | | title | varchar(45) | | | | | | artist| varchar(30) | | | | | | source| char(1) | | | | | | peak | int(3)| YES | | NULL| | | peakdate | date | YES | | NULL| | | entrydate | date | YES | | NULL| | | length| int(3)| YES | | NULL| | | stereo| char(1) | YES | | NULL| | | cut | tinyint(1)| | | 0 | | | album | varchar(45) | YES | | NULL| | | trackno | int(2)| YES | | NULL| | | notes | varchar(40) | YES | | NULL| | | mcreated | date | YES | | NULL| | | mamended | timestamp(14) | YES | | NULL| | +---+---+--+-+-+---+ Yet I get the following error: Error The Database Routines returned the following error The reason given was: updating music - You have an error in your SQL syntax near 'mamended = '20021214013349' where mrecno = '1' ' at line 2 The command being executed was: update music set cut = '' mamended = '20021214013349' where mrecno = '1' I get it when I do a web page reload. Two things are wrong: 1) cut is defined as an integer, yet it is trying to store nothing, while the default is set to zero and nothing should be attempted to the mamended field, as that is an auto-update field from within MySQL. The following are the RPMs that I have installed on my Linux 7.1 system: MySQL-3.23.53a-1.i386.rpm MySQL-Max-3.23.53a-1.i386.rpm MySQL-client-3.23.53a-1.i386.rpm MySQL-devel-3.23.53a-1.i386.rpm MySQL-shared-3.23.53a-1.i386.rpm perl-DBD-MySQL-1.2215-1.i386.rpm perl-DBI-1.14-10.i386.rpm The Perl CGI package was part of the Perl 5.0.6 installation. Any pointers/suggestions will be greatly appreciated. Thanks. MB -- e-mail: [EMAIL PROTECTED] /~\ The ASCII \ / Ribbon Campaign X Against Visit - URL: http://vidiot.com// \ HTML Email - 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: INSERT confirmation? PHP
At 20:08 -0500 12/14/02, Michael T. Babcock wrote: Peter Lovatt wrote: mysql_insert_id should do it! According to documentation somewhere, last insert can sometimes return a different value than the most recent insert if the most recent insert failed. Why is this a problem? If the most recent insert failed, you wouldn't expect to get a reasonable ID value. If you were wanting to get the value from the previous insert, you should have gotten its ID before attempting another insert anyway. What is a better solution? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: DBI or CGI perl error?
At 20:34 -0600 12/14/02, Vidiot wrote: My database layout is as follows: mysql show columns from music; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | mrecno| int(6)| | PRI | 0 | | | title | varchar(45) | | | | | | artist| varchar(30) | | | | | | source| char(1) | | | | | | peak | int(3)| YES | | NULL| | | peakdate | date | YES | | NULL| | | entrydate | date | YES | | NULL| | | length| int(3)| YES | | NULL| | | stereo| char(1) | YES | | NULL| | | cut | tinyint(1)| | | 0 | | | album | varchar(45) | YES | | NULL| | | trackno | int(2)| YES | | NULL| | | notes | varchar(40) | YES | | NULL| | | mcreated | date | YES | | NULL| | | mamended | timestamp(14) | YES | | NULL| | +---+---+--+-+-+---+ Yet I get the following error: Error The Database Routines returned the following error The reason given was: updating music - You have an error in your SQL syntax near 'mamended = '20021214013349' where mrecno = '1' ' at line 2 The command being executed was: update music set cut = '' mamended = '20021214013349' where mrecno = '1' The problem here is the lack of a comma between cut = '' and mamended = 20021214013349'. The statement is malformed, it has to fail. It's not a DBI error *or* a CGI error. I get it when I do a web page reload. Two things are wrong: 1) cut is defined as an integer, yet it is trying to store nothing, while the default is set to zero and nothing should be attempted to the mamended field, as that is an auto-update field from within MySQL. The following are the RPMs that I have installed on my Linux 7.1 system: MySQL-3.23.53a-1.i386.rpm MySQL-Max-3.23.53a-1.i386.rpm MySQL-client-3.23.53a-1.i386.rpm MySQL-devel-3.23.53a-1.i386.rpm MySQL-shared-3.23.53a-1.i386.rpm perl-DBD-MySQL-1.2215-1.i386.rpm perl-DBI-1.14-10.i386.rpm The Perl CGI package was part of the Perl 5.0.6 installation. Any pointers/suggestions will be greatly appreciated. Thanks. MB -- e-mail: [EMAIL PROTECTED] /~\ The ASCII \ / Ribbon Campaign X Against Visit - URL: http://vidiot.com// \ HTML Email - 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: DBI or CGI perl error?
You are missing a comma update music set cut = '' , mamended = '20021214013349' where mrecno = '1' HTH Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Vidiot [mailto:[EMAIL PROTECTED]] Sent: 15 December 2002 02:34 To: MySQL mail list Subject: DBI or CGI perl error? My database layout is as follows: mysql show columns from music; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | mrecno| int(6)| | PRI | 0 | | | title | varchar(45) | | | | | | artist| varchar(30) | | | | | | source| char(1) | | | | | | peak | int(3)| YES | | NULL| | | peakdate | date | YES | | NULL| | | entrydate | date | YES | | NULL| | | length| int(3)| YES | | NULL| | | stereo| char(1) | YES | | NULL| | | cut | tinyint(1)| | | 0 | | | album | varchar(45) | YES | | NULL| | | trackno | int(2)| YES | | NULL| | | notes | varchar(40) | YES | | NULL| | | mcreated | date | YES | | NULL| | | mamended | timestamp(14) | YES | | NULL| | +---+---+--+-+-+---+ Yet I get the following error: Error The Database Routines returned the following error The reason given was: updating music - You have an error in your SQL syntax near 'mamended = '20021214013349' where mrecno = '1' ' at line 2 The command being executed was: update music set cut = '' mamended = '20021214013349' where mrecno = '1' I get it when I do a web page reload. Two things are wrong: 1) cut is defined as an integer, yet it is trying to store nothing, while the default is set to zero and nothing should be attempted to the mamended field, as that is an auto-update field from within MySQL. The following are the RPMs that I have installed on my Linux 7.1 system: MySQL-3.23.53a-1.i386.rpm MySQL-Max-3.23.53a-1.i386.rpm MySQL-client-3.23.53a-1.i386.rpm MySQL-devel-3.23.53a-1.i386.rpm MySQL-shared-3.23.53a-1.i386.rpm perl-DBD-MySQL-1.2215-1.i386.rpm perl-DBI-1.14-10.i386.rpm The Perl CGI package was part of the Perl 5.0.6 installation. Any pointers/suggestions will be greatly appreciated. Thanks. MB -- e-mail: [EMAIL PROTECTED] /~\ The ASCII \ / Ribbon Campaign X Against Visit - URL: http://vidiot.com// \ HTML Email - 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
Connecting M. Access Forms to insert data into mysql
I am trying to find a package to insert data. And was wondering if I can use odbc drivers to connect Access to mysql in real time? - 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: Connecting M. Access Forms to insert data into mysql
I've installed about 12 client gui's and here's my conclusion. DBQwikEdit - has the best editor for Data Entry - nice form to add one record at a time - similar to access forms (I want this) - As far as I can tell, is the only product that has this feture http://www.mysqlstudio.com/ - nice for management - but the shit for a single user wanting to add data like access in forms. My problem is if I use Access for the front end it doesn't always out put the memo fields right. So I want a client GUI that specifically will allow one record / page. Making it very user friendly. Is using Access the way to go or is there a product I'm missing? - Original Message - From: Grant Cooper [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 6:49 PM Subject: Connecting M. Access Forms to insert data into mysql I am trying to find a package to insert data. And was wondering if I can use odbc drivers to connect Access to mysql in real time? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4 for Mandrake 9
Hi Can anyone recommend a binary source for Mandrake 9, or the correct options to compile and install the latest version of MySQL on Mandrake 9. I appreciate that the 'standard' Redhat 386 binaries will work, but I would rather stick to Mandrakes specific (pentium) version. Simon -- Simon Windsor Email: [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 hell.
Greetings, I have followed the replication section of the mysql manual, and all went fine except replication will not happen. In my logs I find: 021215 0:33:32 Slave thread: error connecting to master: Can't connect to MySQL server on '192.168.1.9' (22) (22), retry in 60 sec I can telnet to the mysql port on the machine, and its available. I did a perror on 22 and it tells me invalid argument. What's going on?? Thanks, - 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: replication hell.
Mysql works on port 3306 by default. for example, my mysql server is on 10.10.10.1 so you would use this command to test your mysql server. telnet 10.10.10.1 3306 you will get special garbage or host not allowed if testing a remote server. But at least you know your mysql server is open. You could also try a sockstat -4 if you are on Unix and see if 3306 is open. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 7:43 PM Subject: replication hell. Greetings, I have followed the replication section of the mysql manual, and all went fine except replication will not happen. In my logs I find: 021215 0:33:32 Slave thread: error connecting to master: Can't connect to MySQL server on '192.168.1.9' (22) (22), retry in 60 sec I can telnet to the mysql port on the machine, and its available. I did a perror on 22 and it tells me invalid argument. What's going on?? Thanks, - 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 - 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: replication hell.
I know it runs on 3306 :) I can telnet to the host on port 3306. - Chris On Sat, 14 Dec 2002, Grant Cooper wrote: Mysql works on port 3306 by default. for example, my mysql server is on 10.10.10.1 so you would use this command to test your mysql server. telnet 10.10.10.1 3306 you will get special garbage or host not allowed if testing a remote server. But at least you know your mysql server is open. You could also try a sockstat -4 if you are on Unix and see if 3306 is open. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 7:43 PM Subject: replication hell. Greetings, I have followed the replication section of the mysql manual, and all went fine except replication will not happen. In my logs I find: 021215 0:33:32 Slave thread: error connecting to master: Can't connect to MySQL server on '192.168.1.9' (22) (22), retry in 60 sec I can telnet to the mysql port on the machine, and its available. I did a perror on 22 and it tells me invalid argument. What's going on?? Thanks, - 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 - 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 lost connection
filter-fodder: mysql, query Hi, I have a persistent connection. but when a query fails for whatever reason, ( eg. user doesnt have permission to delete a row ) I lose the connection. HOW can I stop this happening, and WHY is it happening? Donna - 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
Getting timestamp to work with Perl CGI
How does one get the MySQL timestamp type to work with the Perl CGI interface script? I've been trying a couple of things, but all I get back is zeros for the value of the field. Does the CGI interface even support timestamp? MB -- e-mail: [EMAIL PROTECTED] /~\ The ASCII \ / Ribbon Campaign X Against Visit - URL: http://vidiot.com// \ HTML Email - 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