Re: Mysql 3.23.51 on Solaris
Connection Failed 2003 - Cannot Connect to MySQL server on 10.1.1.95 (10061) Hi, it seems that the MySQL Server is not running. Try to start the server. Best regards, Roland -- [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: slow count queries
On Tue, Jul 16, 2002 at 07:49:27PM -0500, mos wrote: With InnoDb you need to pre-allocate file space so all the tables get put into one file. This is a good idea when you have a lot of people accessing the database because it reduces the file handles (less work for the operating system). In recent versions, InnoDB will grow the space as needed (if you tell it to do so). You need to unload the database data with MySQLDump or an SQL statement. Or the InnoDB hot backup tool (an add-on commercial product). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 48 days, processed 1,026,565,214 queries (245/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
paging of records.. any suggestions?
Hi list, I would like to get any suggestion on how i can go about my problem the most efficient way. I have a program that reads the log file and displays it for the user. At the moment, it retrieves all the data in mysql database. I would want to add paging capabilities to it. I am wondering what would be advisable... to make a database query every time I change page, or do a one time data retrieval and just store it in temporary variable(probably session or class) and access it from there. What will take more time and resources? repeated access to DB or storing all the records in a temporary var/class? what would be the best to use in my SELECT statement to retrieve only a certain number of record (from record 1 to record n and so on). This may be basic.. im relatively new in this.. Any input will be appreciated. TIA Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: paging of records.. any suggestions?
Hi, Not sure which language you are using, but I hope this will give you some ideas: http://www.phpbuilder.com/columns/rod20001214.php3 Hope this is useful, Shashank -- sql, query, select etc. all the jazz that will make this message go through to the list. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL in different OSes
Hi, I just want to know if I can just copy a MySQL database from, say Windows 2000 to Linux. Will it still work? Does it has binary data compabilities? Thank you Yours Truly, Hanxue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 versions are the same?
Hi, I've downloaded mysql-max-4.0.2-alpha-win.zip (Anyway, the size of this file is the same as mysql-max-4.0.1-alpha-win.zip) When I unzip this file and start to install it, I can see in the setup window that it is MySQL-max-4.0.1 What is the problem. Guys at MySQL did a mistake, or I downloaded it from a wrong mirror site, or what??? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 FreeBSD LinuxThreads
Hi Ken I have had a look on FreeBSD.org and can only find a ref to polling as a subroutine that is used if the system crashing. What douse this number? And so how will it effect MySQL? Thanks Simon -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 16:07 To: Oleg Borodkin; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL FreeBSD LinuxThreads Hi Oleg, I have similar problems on FreeBSD with one or two slow queries hogging the CPU. I am running native threads. I am looking at a parameter in the kernel (/usr/src/sys/i386/conf/LINT). It is the HZ parameter and has to do with polling frequency. The default is 100, I am experimenting with values from 1000 to 5000. You might give this a try. You will need to build a new kernel. I am not sure this will have any effect on MySQL. This is only a suggestion. Best of Luck, Ken - Original Message - From: Oleg Borodkin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 15, 2002 3:24 PM Subject: MySQL FreeBSD LinuxThreads Hello, I have noticed that MySQL server almost hangs up the system while processing a big table (perl script using fetchrow). I didn't experienced this before - may be it's because of LinuxThreads? MySQL launches 38 running processes, but shows only 10 mysql query threads (they are all sleeping except 2 or 3). Thanking you in advance, Oleg Borodkin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Windows CE MySQL
Hi, Has anyone tried building a MySQL server for Windows CE ? I have found a really good client for CE called DALP (http://www.kalpadrum.com/dalp/) but no server. It would be really good to have a cut down MySQL server on PDAs. I have had a go at compiling the server using Embedded Visual C++ 3 but my C skills are no where near good enough to get anywhere. Thanks -- Nick Miles - [EMAIL PROTECTED] Database Developments Ltd Client/Server Web Database Apps Tel +44 1453 861155Fax +44 1453 861166 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0.2 replication going bonkers?
Jon, replication 4.0.1 - 4.0.2 does not work because the format in the 4.0 series has evolved. Currently, if your master of the 4.0 series, your slave must be of the exact same release. All 3.23 versions after 3.23.33 can be replicated from each other 4.0.0 can only replicate to/from 4.0.0. 4.0.1 slave can replicate from a 3.23.33 and newer 3.23 master, and can only replicate from a 4.0.1 master in the 4.0 branch. 4.0.2 slave can replicate from a 3.23 master, and can only replicate from a 4.0.2 master in the 4.0 branch. || Master || 3.23.33 and up | 4.0.0 | 4.0.1 | 4.0.2 Slave | 3.23.33 and up | yes| no| no| no | 4.0.0 | no | yes | no| no | 4.0.1 | yes| no| yes | no | 4.0.2 | yes| no| no| yes 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 - Original Message - From: Jon Frisby [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 16, 2002 4:30 AM Subject: RE: MySQL 4.0.2 replication going bonkers? This seems to have not gotten through... Perhaps the spam filter ate it? (sql, query) -JF -Original Message- From: Jon Frisby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0.2 replication going bonkers? We recently set up a 4.0.2 slave, which worked fine -- we loaded our data snapshot (taken via mysqldump) and were able to perform complex queries without problems... However, as soon as we tried to get this machine to act as a slave to a 4.0.1 server it crashed. Immediately upon executing SLAVE START, we get messages like this in the error log: 020714 01:32:03 mysqld started 020714 1:32:05 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 020714 8:00:28 Slave SQL thread initialized, starting replication in log 'server2-bin.035' at position 579285542, relay log './db1-relay-bin.001' position: 4 020714 8:00:29 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'server2-bin.035' at position 579285542 ERROR: 1146 Table 'test.response' doesn't exist 020714 8:00:30 Slave: error 'Table 'test.response' doesn't exist' on query 'INSERT INTO response SET connect_time=0.073868989944458, page_time=1.53695404529572, site_id='Apt'', error_code=1146 020714 8:00:30 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'server2-bin.035' position 579285542 020714 8:00:30 Slave SQL thread exiting, replication stopped in log 'server2-bin.035' at position 579285542 020714 8:00:54 Error reading packet from server: (server_errno=1159) 020714 8:00:54 Slave I/O thread killed while reading event 020714 8:00:54 Slave I/O thread exiting, read up to log 'server2-bin.035', position 579993154 020714 8:01:58 /usr/sbin/mysqld-max: Normal shutdown 020714 8:01:58 InnoDB: Starting shutdown... 020714 8:02:05 InnoDB: Shutdown completed 020714 8:02:06 /usr/sbin/mysqld-max: Shutdown Complete 020714 08:02:06 mysqld ended 020714 08:02:16 mysqld started 020714 8:02:17 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 020714 8:02:34 Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './db1-relay-bin.001' position: 4 ERROR: 1146 Table 'test.response' doesn't exist 020714 8:02:34 Slave: error 'Table 'test.response' doesn't exist' on query 'INSERT INTO response SET connect_time=0.073868989944458, page_time=1.53695404529572, site_id='Apt '', error_code=1146 020714 8:02:34 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'FIRST' position 0 020714 8:02:34 Slave SQL thread exiting, replication stopped in log 'FIRST' at position 0 020714 8:02:34 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'server2-bin.035' at position 579993154 020714 8:03:02 Error reading packet from server: (server_errno=1159) 020714 8:03:02 Slave I/O thread killed while reading event 020714 8:03:02 Slave I/O thread exiting, read up to log 'server2-bin.035', position 579993478 020714 8:03:25 /usr/sbin/mysqld-max: Normal shutdown 020714 8:03:25 InnoDB: Starting shutdown... 020714 8:03:28 InnoDB: Shutdown completed 020714 8:03:28 /usr/sbin/mysqld-max: Shutdown Complete 020714 08:03:28 mysqld ended 020714 08:03:36 mysqld started 020714 8:03:38 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 020714 8:04:02 Slave SQL thread initialized, starting
replication problem
Description: I am testing the replication of one database from this host to a slave MySQL server. Some of the queries that ALTER a table structure are not replicated to the slave, causing a stop of the replication. I said some because while I was troubleshooting my problems I could successfully add/change some fields to my tables (this means that the add/change was replicated) but other times a similar operation (eg ALTER of a column with the same definition of one that I had successfully altered) gave me a failure. How-To-Repeat: I just tested this and had problems: # ON MASTER FLUSH MASTER; # ON SLAVE FLASH SLAVE; # ON MASTER CREATE TABLE `replication_test` ( `f1` TEXT DEFAULT NULL, `f2` VARCHAR(50) DEFAULT NULL, `f3` BIGINT DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, `f4` TIMESTAMP DEFAULT NULL, `f5` VARCHAR(50) DEFAULT 'Spaghetti, pizza e mandolino' NOT NULL, INDEX (`f2`) ) TYPE = MYISAM; INSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('record number one', 'massimo ferrario', '123456789', NULL, 'Spaghetti, pizza e mandolino'); INSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('recordn number two', NULL, '987654321', NULL, 'Pizza margherita'); UPDATE `replication_test` SET `f1` = 'record number two' , `f2` = NULL, `f4` = NOW('20020717110024') WHERE `f3` = '987654321'; # THIS QUERY IS NOT REPLICATED TO THE SLAVE ALTER TABLE `eigest_euro`.`replication_test` CHANGE `f5` `f5` TEXT # INSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('record number three', 'paolino paperino', NULL, NOW(), 'Spaghetti all\'amatriciana'); NSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('record number four', NULL, NULL, NOW(), ' This is a very long string that should fit the text field in the master database but should be truncated in the varchar(50) field of the slave database. '); Fix: I don't know Submitter-Id: inforeti Originator:root Organization: Inforeti srl via Pellizzo 39 35100 Padova (PD) Italy MySQL support: licence Synopsis: replication not working for every ALTER TABLE query Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.49a (Official MySQL RPM) Environment: System: Linux php3 2.2.19-6.2.12 #1 Fri Oct 26 12:20:51 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Sep 5 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Jan 15 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273324 Jan 15 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 15 2001 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Aug 1 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Different versions are the same?
Daniel, thank you for noticing this. Apparently the Win distribution of MySQL-Max-4.0.2 is accidentally the same file as MySQL-Max-4.0.1. Workaround if you do not need BDB tables: download the Win distribution of MySQL-4.0.2 (without the 'Max'). 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 - Original Message - From: Kiss Dániel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 17, 2002 11:27 AM Subject: Different versions are the same? Hi, I've downloaded mysql-max-4.0.2-alpha-win.zip (Anyway, the size of this file is the same as mysql-max-4.0.1-alpha-win.zip) When I unzip this file and start to install it, I can see in the setup window that it is MySQL-max-4.0.1 What is the problem. Guys at MySQL did a mistake, or I downloaded it from a wrong mirror site, or what??? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Error in Windows download of MySQL-Max-4.0.2; download MySQL-4.0.2 instead
Hi! There is an error in the Windows download of MySQL-Max-4.0.2. It is a wrong file, the same as MySQL-Max-4.0.1. If you do not need BDB tables, please download the Windows version of MySQL-4.0.2 (without the 'Max') instead. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query too slow
I've this query that is too slow, how can I optimize this sintax ? SELECT * FROM table_1 INNER JOIN table_2 ON ID_table_2=table_1_ID INNER JOIN table_3 ON ID_table_3=table_2_ID INNER JOIN table_4 ON ID_table_4=table_3_ID INNER JOIN table_5 ON ID_table_5 = table_4_ID INNER JOIN table_6 ON ID_table_6 = table_5_ID WHERE ID_table_2 1000 AND ID_table_5 700; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Help with mysqlimport please-urgent!
Hello, Here is my problem, I would like to use mysqlimport (which i have compiled as a batch file to run) from a client side to load data onto the database on a server side, meaning that I would normally access my server through the pc and running the batch file. Problem is that there are no errors but the tables on the server side does not get updated but instead points to updating my local database, data are loaded into my tables instead (i have the exact replica database on my own pc). Here is a sample command line from my batch file @h:\mysql\bin\MYSQLI~1.EXE --replace --host=host_name --user=root --fields-terminated-by=, --fields-enclosed-by=\ --lines-terminated-by =\r\n BO h:\mysql\data\BO\outnum i've mapped h:\ as pointing to the c:\ of my server..is that possible? [The error relates to 'access denied for @pc_id (i think its the same network id used for login to a NT domain) to BO database' or at times 'the mysql does not support this version'] P.S. My table name is outnum which is the same as the file name, MySQL version is 3.23.51. What am i doing wrong here? Need help please (could someone guide me what to do from the very beginning. I need to run mysqlimport as if i'm running any program from the console itself but only from a remote terminal). To simplify, what i need here is a way to run mysqlimport from my pc to pump data into the tables on the MySQL server instead of the data being thrown in my local MySQL server.Urgent! Thank you. Regards, Eric Loe. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Q] about GRANT
Hello. In mysql tables Db, User, Host I can use templates as host ,for example. But can I use templates in tables_priv as table name? For example I want to set INSERT permission to H_% tables. How can I set it? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Help with mysqlimport please-urgent!
Don't use 'root' ... create a new user, and make sure you GRANT the proper privs (i.e.: USE mysql; GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'password' WITH GRANT OPTION; - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 5:42 AM Subject: Need Help with mysqlimport please-urgent! Hello, Here is my problem, I would like to use mysqlimport (which i have compiled as a batch file to run) from a client side to load data onto the database on a server side, meaning that I would normally access my server through the pc and running the batch file. Problem is that there are no errors but the tables on the server side does not get updated but instead points to updating my local database, data are loaded into my tables instead (i have the exact replica database on my own pc). Here is a sample command line from my batch file @h:\mysql\bin\MYSQLI~1.EXE --replace --host=host_name --user=root --fields-terminated-by=, --fields-enclosed-by=\ --lines-terminated-by =\r\n BO h:\mysql\data\BO\outnum i've mapped h:\ as pointing to the c:\ of my server..is that possible? [The error relates to 'access denied for @pc_id (i think its the same network id used for login to a NT domain) to BO database' or at times 'the mysql does not support this version'] P.S. My table name is outnum which is the same as the file name, MySQL version is 3.23.51. What am i doing wrong here? Need help please (could someone guide me what to do from the very beginning. I need to run mysqlimport as if i'm running any program from the console itself but only from a remote terminal). To simplify, what i need here is a way to run mysqlimport from my pc to pump data into the tables on the MySQL server instead of the data being thrown in my local MySQL server.Urgent! Thank you. Regards, Eric Loe. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: internal MYSQL clock?
MySQL doesn't have an internal clock. It uses the O/S's clock. Each of our servers (both Linux and Win32) running MySQL logs into a time server to set the system clock twice a day. Time references in the MySQL databases are always dead-on. - Original Message - From: Paul Wallace [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 9:07 PM Subject: internal MYSQL clock? Hi, I just encountered a problem when entering a datetime field. Using 'now()' in my SQL string input a time about 13 minutes before my other method (a JSP System.currentTimeMillis() method - one that generates the time from the CPU clock) Can anyone tell me why the time generated by now() differed significantly to the time generated by the method above that uses the CPU clock?! To me, that would suggest MySQL has some kind of internal clock? Or am I barking up the wrong bush? Thanks for any input P. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
still not a simple sql-question ! ...
Well, by now i have found a way to work around the problem, still the problem is not solved, you may want continue thinking about it: start with this: iSession iUser sSession -- -- - 1 41 no 2 41 wanted 3 42 no 4 42 wanted 5 43 no 6 43 wanted and end up with that: iSession iUser sSession -- -- - 2 41 wanted 4 42 wanted 6 43 wanted Do it without a subselect and do it with one sql statement SELECT * FROM O_Sessions AS first, O_Sessions AS second WHERE first.iSession=MAX(second.iSession) AND first.iUser=second.iUser so far is the only solution, but does not work with mysql :-( rain outside, 14:45, three hours after breakfast and now heading for some new problems, robo :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query too slow
Have you tried explain? Do all of your ID fields have indexes? Have you tried breaking it into multiple statements? Each statement creating a temp table except the last? =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Lorenzo De Vito [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 4:44 AM To: [EMAIL PROTECTED] Subject: Query too slow I've this query that is too slow, how can I optimize this sintax ? SELECT * FROM table_1 INNER JOIN table_2 ON ID_table_2=table_1_ID INNER JOIN table_3 ON ID_table_3=table_2_ID INNER JOIN table_4 ON ID_table_4=table_3_ID INNER JOIN table_5 ON ID_table_5 = table_4_ID INNER JOIN table_6 ON ID_table_6 = table_5_ID WHERE ID_table_2 1000 AND ID_table_5 700; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Windows CE MySQL
I can see where accessing the server from a handheld would be cool but I question the concept of actually RUNNING the server on a handheld. Write a cool lightweight client with the library and leave the server on beefier HW. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Nick Miles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:34 AM To: [EMAIL PROTECTED] Subject: Windows CE MySQL Hi, Has anyone tried building a MySQL server for Windows CE ? I have found a really good client for CE called DALP (http://www.kalpadrum.com/dalp/) but no server. It would be really good to have a cut down MySQL server on PDAs. I have had a go at compiling the server using Embedded Visual C++ 3 but my C skills are no where near good enough to get anywhere. Thanks -- Nick Miles - [EMAIL PROTECTED] Database Developments Ltd Client/Server Web Database Apps Tel +44 1453 861155Fax +44 1453 861166 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in different OSes
Yes and no. No, you can't (shouldn't) copy the file from one server to another. Bad Mojo. It MAY work if you are only using MyISAM file types but no promises there. You would be much better off using mysqldump to dump the contents of your databases to a text file and then re-importing them on the other machine. master mysqldump -opt everything.sql slave mysql everything.sql Warning this will wipe everything on your slave machine as it imports from the master. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Hanxue Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:39 AM To: [EMAIL PROTECTED] Subject: MySQL in different OSes Hi, I just want to know if I can just copy a MySQL database from, say Windows 2000 to Linux. Will it still work? Does it has binary data compabilities? Thank you Yours Truly, Hanxue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Error Codes
Hello All, I m using mysql server and myodbc driver in linux. I wud like to print the correct error message if any error occur while we r communicating with server eg. access denied, connection failure, no data is available , table does not exits, duplicate data etc. How can i see the return error code value and which file contains all these error codes?? I m using function SQLGetDiagRec() to see the error messages, Can i use the same for error code? Thx in advance, Rgds, Jenny __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.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: paging of records.. any suggestions?
Depends on the language you are writing in and the acceptable latency of the user. If you are writing in PHP or another scripting language for a web based application where the server will have to artificially preserve stat then I would not attempt to cache the recordset, I would get a new one each time. This has the added advantage of always serving the freshest data. If you are using a more traditional language that will be running on the client's desktop and is stateful AND the user can accept the fact that the data may have changes since they first requested it then I would cache the recordset on the client side. This has the advantage of only going to the server once per client instead of once per page. However, depending on how often your data changes, it is possible that the data will change after the user requested the recordset but before they view the data. HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: forum mail [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:30 AM To: [EMAIL PROTECTED] Subject: paging of records.. any suggestions? Hi list, I would like to get any suggestion on how i can go about my problem the most efficient way. I have a program that reads the log file and displays it for the user. At the moment, it retrieves all the data in mysql database. I would want to add paging capabilities to it. I am wondering what would be advisable... to make a database query every time I change page, or do a one time data retrieval and just store it in temporary variable(probably session or class) and access it from there. What will take more time and resources? repeated access to DB or storing all the records in a temporary var/class? what would be the best to use in my SELECT statement to retrieve only a certain number of record (from record 1 to record n and so on). This may be basic.. im relatively new in this.. Any input will be appreciated. TIA Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: still not a simple sql-question ! ...
From: Robo [EMAIL PROTECTED] Well, by now i have found a way to work around the problem, still the problem is not solved, you may want continue thinking about it: start with this: iSession iUser sSession -- -- - 1 41 no 2 41 wanted 3 42 no 4 42 wanted 5 43 no 6 43 wanted and end up with that: iSession iUser sSession -- -- - 2 41 wanted 4 42 wanted 6 43 wanted Do it without a subselect and do it with one sql statement I'm new to this thread, so bear with me if this has already been suggested, but I just did the following and it worked fine: mysql CREATE TABLE `O_Sessions` ( `iSession` int(11) NOT NULL auto_increment, `iUser` int(11) NOT NULL default '0', PRIMARY KEY (`iSession`) ) TYPE=MyISAM; mysql INSERT INTO O_Sessions (iSession,iUser) VALUES (1,41),(2,41),(3,42),(4,42),(5,43),(6,43); mysql SELECT * FROM O_Sessions ORDER BY iSession; +--+---+ | iSession | iUser | +--+---+ |1 |41 | |2 |41 | |3 |42 | |4 |42 | |5 |43 | |6 |43 | +--+---+ 6 rows in set (0.01 sec) mysql SELECT MAX(iSession), iUser FROM O_Sessions GROUP BY iUser; +---+---+ | MAX(iSession) | iUser | +---+---+ | 2 |41 | | 4 |42 | | 6 |43 | +---+---+ 3 rows in set (0.00 sec) Does that last query help? -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Permissions problems
If mysql owns them, 0770 should be fine. System Administrator a.k.a. The Root of the Problem wrote: USually all the databases sets up fine BUT recently, I have had to adjust databases to 0777 in order to get them to work and change the ownership. I prefer the more secure model of mysql. How can I fix this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in different OSes
Another option is to use a program like mysqlfront, open both server and local versions of mysql and use export facility in mysqlfront. I've found this particularly useful. -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:13 PM To: Hanxue Lee; [EMAIL PROTECTED] Subject: RE: MySQL in different OSes Yes and no. No, you can't (shouldn't) copy the file from one server to another. Bad Mojo. It MAY work if you are only using MyISAM file types but no promises there. You would be much better off using mysqldump to dump the contents of your databases to a text file and then re-importing them on the other machine. master mysqldump -opt everything.sql slave mysql everything.sql Warning this will wipe everything on your slave machine as it imports from the master. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Hanxue Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:39 AM To: [EMAIL PROTECTED] Subject: MySQL in different OSes Hi, I just want to know if I can just copy a MySQL database from, say Windows 2000 to Linux. Will it still work? Does it has binary data compabilities? Thank you Yours Truly, Hanxue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
how to change root password
Hi i have a simple question. how can i change mysql root password? if i change it using winmysqladmin.exe, and changing it in my.ini, nothing happens. i can change passwords using phpmyadmin, but i would like to change it without it. thanx 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
RE: MySQL in different OSes
From MySQL manual: http://www.mysql.com/doc/M/o/Moving.html http://www.mysql.com/doc/U/p/Upgrading-to-arch.html I have tried and it works in HP-Solaris and LINUX, but I tend to agree with Cal, my recomendation is to use an alternative procedure such as dumping and importing. Bye and Good Luck. --- Cal Evans [EMAIL PROTECTED] wrote: Yes and no. No, you can't (shouldn't) copy the file from one server to another. Bad Mojo. It MAY work if you are only using MyISAM file types but no promises there. You would be much better off using mysqldump to dump the contents of your databases to a text file and then re-importing them on the other machine. master mysqldump -opt everything.sql slave mysql everything.sql Warning this will wipe everything on your slave machine as it imports from the master. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Hanxue Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:39 AM To: [EMAIL PROTECTED] Subject: MySQL in different OSes Hi, I just want to know if I can just copy a MySQL database from, say Windows 2000 to Linux. Will it still work? Does it has binary data compabilities? Thank you Yours Truly, Hanxue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.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: Error Codes
From: Jenny Christy [EMAIL PROTECTED] I m using mysql server and myodbc driver in linux. I wud like to print the correct error message if any error occur while we r communicating with server eg. access denied, connection failure, no data is available , table does not exits, duplicate data etc. How can i see the return error code value and which file contains all these error codes?? I m using function SQLGetDiagRec() to see the error messages, Can i use the same for error code? I don't know about anything included in the MyODBC driver, but included with the server is a program called perror that takes a MySQL error code and returns an explanation of it. Usage: [mike@localhost ~]$ perror 13 Error code 13: Permission denied [mike@localhost ~]$ perror 27 Error code 27: File too large Does that help, maybe with a system() or backticks call? -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 for AIX 4.3.3
I still need to get a version of mysql working on AIX 4. I have been watching the mail list and have seen nothing about a new release. I recently looked at the web site and found that the current download binary release is now 3.23.49 and it previously was 3.23.51. Does this mean that .49 is now a working version? Morris Ford __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.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: help me with this query
See comments below... -- Arul [EMAIL PROTECTED] wrote: Hi I Dont think this will work coz I need the company which has serviceid = 1 AND serviceid = 2 and serviceid = 3 I think that you are mixing natural language with logical expression, right? The expression above always returns FALSE, that is, no record will be returned. So let's take this Query , Select companyid, count(*) from CompanyServices where serviceid = 1 or serviceid = 2 or serviceid = 3 group by companyid having count(*) = 3 If i have another company say companyid = 5 ,who has serviceid = 1 AND serviceid = 6 AND serviceid = 7 , even this company will be retrieved which will be against the search criteria. This company won't be retrieve because just services 1. Look the query again Arul, we are filtering the records: serviceid = 1 or serviceid = 2 or serviceid = 3 Only records with serviceid 1, 2, or 3 will be returned in the query. Then we are grouping to count the records for each group, and finally (with the HAVING COUNT), we are making sure that only company with the three services are shown. Have you really tried this query? Because I tried and it worked unless I misunderstood what you want to do. Also another company whose companyid = 7 has serviceid = 1 AND serviceid = 2 AND serviceid = 3 AND serviceid = 5 .This company will not be retrieved since the count is not 3.But by search criteria , this company should be retrieved. The count for this company will be 3 because the same reason as above. Look this simple table: id1,id2 1,1 1,2 1,3 2,3 3,4 3,5 3,6 Select * from tblService where id2 = 1 or id2 = 2 or id2 = 3 will return: id1,id2 1,1 1,2 1,3 2,3 Select id1, count(*) from tblService where id2 = 1 or id2 = 2 or id2 = 3 group by id1 returns: id1,count(*) 1,3 2,1 and finally Select id1, count(*) from tblService where id2 = 1 or id2 = 2 or id2 = 3 group by id1 having count(*) = 3 id1,count(*) 1,3 Only and only id1 (company) 1 services the three service type. Let me know if this is not what you wanted. Bye and Good Luck. So how do we handle these situations -Arul - Original Message - From: Francisco Reinaldo [EMAIL PROTECTED] To: Arul [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Cc: Arul [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 3:27 AM Subject: Re: help me with this query Hi, Select companyid, count(*) from CompanyServices where serviceid = 1 or serviceid = 2 or serviceid = 3 group by companyid having count(*) = 3 Bye and Good Luck. --- Arul [EMAIL PROTECTED] wrote: Hi All The Table design goes like this Company Table companyid integer name varchar(100) Services Table ServiceIDinteger Servicevarchar(50) Company Services --- companyidinteger - References Company(companyid) serviceid integer - References Services(ServiceID) The Values in Company table are companyidname 1'ABC' 2'XYZ' 3'CDE' The Values in Services table are serviceidservice 1'Ebiz' 2'MainFrames' 3'CAD' 4'Maintenance' The Values in Company Services table are companyidserviceid 1 1 1 2 1 3 2 1 2 2 3 4 I have a List Box where the user selects his Need for Services. Suppose the User selects 1 , 2 and 3 , then i need to show him the company which provides him all 1 , 2 and 3 services . By our data , its company 1 I cant search by using IN coz it would select a record even if the company is providing any one of the services. I did this by using self join for ex: select distinct(c.companyid) , c.name from company c , companyservices cs1, companyservices cs2, companyservices cs3 where cs1.serviceid = 1 AND cs2.serviceid = 2 AND cs3.serviceid = 3 AND c.companyid = cs1.companyid Is there any other way , i could achive the result without using a self join -Arul 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: create tmp table privileges
Daniel, Wednesday, July 17, 2002, 8:20:30 AM, you wrote: DK I've been trying to grant users the right to create temporary tables: DK grant create temporary table on mydatabase.* to user; DK flush privileges; DK I've also tried: DK grant create temporary table on mysql.* to user; DK flush privileges; DK When I check in the user table, the Create_tmp_table_priv is not set. If DK I set this and flush privileges, it still doesn't work. DK How can I grant this permission? CREATE TEMPORARY TABLES is a global privilege, not a database ... GRANT CREATE TEMPORARY TABLES ON *.* TO 'user'@'host' IDENTIFIED BY 'password'; -- 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: Lost connection to mysql server
Defryn, Wednesday, July 17, 2002, 12:56:31 AM, you wrote: D I have a build an ASP page to enter data in a mysql database. D When I open the page I get the following error : D Error Type: D Microsoft OLE DB Provider for ODBC Drivers (0x80004005) D [TCX][MyODBC]Lost connection to MySQL server during query D /centraladmin/products.asp, line 88 D When I refresh it works fine. It seems to me it's like a D Timeout thing. Yeah, it can be a cause of this error: http://www.mysql.com/doc/G/o/Gone_away.html http://www.mysql.com/doc/P/a/Packet_too_large.html D This is my connection to the database D set oconn = server.createobject(Adodb.connection) D oconn.connectionstring = server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd D oconn.open -- 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: internal MYSQL clock?
Paul, Wednesday, July 17, 2002, 5:07:44 AM, you wrote: PW I just encountered a problem when entering a datetime field. Using PW 'now()' in my SQL string input a time about 13 minutes before my other PW method (a JSP System.currentTimeMillis() method - one that generates the PW time from the CPU clock) Can anyone tell me why the time generated by now() PW differed significantly to the time generated by the method above that uses PW the CPU clock?! To me, that would suggest MySQL has some kind of internal PW clock? Or am I barking up the wrong bush? PW Thanks for any input No, MySQL doesn't have internal clock. It uses environment variable TZ -- 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 in different OSes
Hanxue, Wednesday, July 17, 2002, 8:39:03 AM, you wrote: HL I just want to know if I can just copy a MySQL database from, say Windows 2000 HL to Linux. Will it still work? Does it has binary data compabilities? Yes, you can just copy from Win to Linux, but I suggest you to use mysqldump instead and copy a dump file. -- 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: customizing user table
J.M.Roth, Tuesday, July 16, 2002, 11:46:29 PM, you wrote: JMR will it work if I add some custom fields to the mysql user table? In some code MySQL checks a number of columns, so you might have a problems if you add some custom fields ... As far as I remember my own experiments with MySQL I got access denied error after addition of several columns to the table user ;-) -- 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: RE: RE: Mysql wil lnot load
Aaron, Tuesday, July 16, 2002, 11:05:09 PM, you wrote: AA [root@Alpha mysql]# pwd AA /usr/local/mysql AA [root@Alpha mysql]# ls -al AA total 48 AA drwxr-xr-x 12 root mysql4096 Jul 15 01:31 . AA drwxr-xr-x 14 root root 4096 Jul 15 01:27 .. AA drwxr-xr-x2 root mysql4096 Jul 15 01:57 bin AA drwxr-xr-x3 root mysql4096 Jul 15 01:27 include AA drwxr-xr-x2 root mysql4096 Jul 15 01:57 info AA drwxr-xr-x3 root mysql4096 Jul 15 01:27 lib AA drwxr-xr-x2 root mysql4096 Jul 15 01:57 libexec AA drwxr-xr-x3 root mysql4096 Jul 15 01:28 man AA drwxr-xr-x6 root mysql4096 Jul 15 01:57 mysql-test AA drwxr-xr-x3 root mysql4096 Jul 15 01:28 share AA drwxr-xr-x7 root mysql4096 Jul 15 01:57 sql-bench AA drwx--4 root mysql4096 Jul 15 23:38 var AA [root@Alpha mysql]# cd var AA [root@Alpha var]# ls -al AA total 28 AA drwx--4 root mysql4096 Jul 15 23:38 . AA drwxr-xr-x 12 root mysql4096 Jul 15 01:31 .. AA -rw---1 mysqlmysql9555 Jul 16 05:23 Alpha.err AA drwx-- 25 root mysql4096 Jul 15 23:38 mysql AA drwx--2 root mysql4096 Jul 15 23:38 test AA [root@Alpha var]# AA Mysql is the owner of the directories .. I really don't know why this AA isnt working Group is mysql, but the onwer is root. Do you run MySQL as 'root'? AA --- AA Aaron Axelsen AA AIM: AAAK2 AA Email: [EMAIL PROTECTED] AA URL: www.amadmax.com AA It said, Insert disk #3, but only two will fit! AA One picture is worth 128K words. AA -Original Message- AA From: Egor Egorov [mailto:[EMAIL PROTECTED]] AA Sent: Tuesday, July 16, 2002 6:48 AM AA To: [EMAIL PROTECTED] AA Subject: Re: RE: Mysql wil lnot load AA Aaron, AA Tuesday, July 16, 2002, 1:25:23 PM, you wrote: AA The instructions where followed from the website exaactly and all AA the file premissions are correct, but I still get the following AA errors in ther log file: AA 020716 05:23:59 mysqld started AA ^G/usr/local/mysql/libexec/mysqld: File './Alpha-bin.1' not found AA (Errcode: 13) AA 020716 5:23:59 Could not use Alpha-bin for logging (error 13) AA 020716 5:23:59 /usr/local/mysql/libexec/mysqld: Can't create/write AA to file '/usr/local/mysql/var/Alpha.pid' (Errcode: 13) 020716 AA 5:23:59 /usr/local/mysql/libexec/mysqld: Can't find file: AA './mysql/host.frm' (errno: 13) 020716 5:23:59 AA /usr/local/mysql/libexec/mysqld: Error on delete of AA '/usr/local/mysql/var/Alpha.pid' (Errcode: 13) 020716 05:23:59 AA mysqld ended AA MySQL must be owner of the data dir, must have permissions to create AA socket file. -- 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: [Q] about GRANT
Andrey, Wednesday, July 17, 2002, 1:54:12 PM, you wrote: AK In mysql tables Db, User, Host I can use templates as host ,for example. AK But can I use templates in tables_priv as table name? AK For example I want to set INSERT permission to H_% tables. AK How can I set it? You can't. -- 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: Mysqlgui
luis, Tuesday, July 16, 2002, 8:18:04 PM, you wrote: l Do you have some information for install mysqlgui in Linux, i do not how do l it? Look into the README file .. -- 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: version
Narcis, Tuesday, July 16, 2002, 6:02:21 PM, you wrote: NG Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M) NG supports the subselect command. No, sub-selects will come in 4.1 How to re-write queries without sub-selects is described at: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL Problem (Will not write to but will read)
Hi, All of a sudden it seems that my MYSQL is incapable of being written to. I can still read from it, but cannot write to it. When I looked at the processes, all the processes that tried to write to the database are in a state of 'Locked'. Any ideas what to do? - Dan Relihan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to change root password
From: [EMAIL PROTECTED] i have a simple question. how can i change mysql root password? if i change it using winmysqladmin.exe, and changing it in my.ini, nothing happens. i can change passwords using phpmyadmin, but i would like to change it without it. Do you have access to the MySQL default client? If so, log in and use the following: SET PASSWORD FOR user@host = PASSWORD('newpassword'); -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: still not a simple sql-question ! ...
Add the sSession field and put in the not wanteds and wanteds you will see that the 3 rows your query returns is the first ones in the list per iUser that are the not wanteds. The query somehow needs to select the second ones. This is where the problem comes in. -- Original Message -- From: denonymous [EMAIL PROTECTED] Date: Wed, 17 Jul 2002 09:23:30 -0400 From: Robo [EMAIL PROTECTED] Well, by now i have found a way to work around the problem, still the problem is not solved, you may want continue thinking about it: start with this: iSession iUser sSession -- -- - 1 41 no 2 41 wanted 3 42 no 4 42 wanted 5 43 no 6 43 wanted and end up with that: iSession iUser sSession -- -- - 2 41 wanted 4 42 wanted 6 43 wanted Do it without a subselect and do it with one sql statement I'm new to this thread, so bear with me if this has already been suggested, but I just did the following and it worked fine: mysql CREATE TABLE `O_Sessions` ( `iSession` int(11) NOT NULL auto_increment, `iUser` int(11) NOT NULL default '0', PRIMARY KEY (`iSession`) ) TYPE=MyISAM; mysql INSERT INTO O_Sessions (iSession,iUser) VALUES (1,41),(2,41),(3,42),(4,42),(5,43),(6,43); mysql SELECT * FROM O_Sessions ORDER BY iSession; +--+---+ | iSession | iUser | +--+---+ |1 |41 | |2 |41 | |3 |42 | |4 |42 | |5 |43 | |6 |43 | +--+---+ 6 rows in set (0.01 sec) mysql SELECT MAX(iSession), iUser FROM O_Sessions GROUP BY iUser; +---+---+ | MAX(iSession) | iUser | +---+---+ | 2 |41 | | 4 |42 | | 6 |43 | +---+---+ 3 rows in set (0.00 sec) Does that last query help? -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on a Cobalt RAQ4
From: Brian P. Millett Technote for using mysql raq4: ftp://ftp.cobalt.sun.com/pub/developer/TechNotes/DTN15-0-0.pdf Thanks Brian! that is an excellent resource. I just joined this list 2 days ago and that was my first post yesterday. I was slapped on the wrist for posting multiple times yesterday when I only sent it once from my end. I have also noticed a few other duplicate posts that I suspect were not intentional. I also got a ton of replies from [EMAIL PROTECTED] rejecting the mail because I have a Yahoo address. - not to mention quite a few I'm on vacation ... autoresponces :) I belong and post to several lists (at sourceforge and others) and this does not occur. Anyone know why the multiple post happened? Thanks for your help, Kristy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to change root password
pornost4r, Wednesday, July 17, 2002, 4:45:18 PM, you wrote: p i have a simple question. how can i change mysql root password? if i p change it using winmysqladmin.exe, and changing it in my.ini, nothing p happens. i can change passwords using phpmyadmin, but i would like to p change it without it. Something like that: UPDATE TABLE user SET password=password('new_password') WHERE user='root' AND host='host'; -- 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: Windows CE MySQL
On Wednesday 17 July 2002 09:09, Cal Evans wrote: I can see where accessing the server from a handheld would be cool but I question the concept of actually RUNNING the server on a handheld. Write a cool lightweight client with the library and leave the server on beefier HW. There are actually reasonable reasons for wanting to have a lightweight server, but really what you want is simply an application with embedded MySQL in it. In other words you don't need a client/server database, you need access to tables and you want to reuse client code which works already with MySQL database, so what you do is compile the embedded server into your program. Effectively it has the same API as the client library, except it does all the work directly itself instead of talking to a server. I don't know how much resources it requires though, nor what the requirements would be as far as functionality the platform has to support in order to compile it. My guess would be you could fairly easily do this on a Linux based PDA like the Zaurus, and its not unlikely it might work in CE, but I doubt you'd have much luck with things like Palms since they have a pretty weird set of OS functions thats nothing like what you get on a normal desktop OS (ie you don't have a regular C standard library really...). =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Nick Miles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:34 AM To: [EMAIL PROTECTED] Subject: Windows CE MySQL Hi, Has anyone tried building a MySQL server for Windows CE ? I have found a really good client for CE called DALP (http://www.kalpadrum.com/dalp/) but no server. It would be really good to have a cut down MySQL server on PDAs. I have had a go at compiling the server using Embedded Visual C++ 3 but my C skills are no where near good enough to get anywhere. Thanks -- Nick Miles - [EMAIL PROTECTED] Database Developments Ltd Client/Server Web Database Apps Tel +44 1453 861155Fax +44 1453 861166 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How to Print from UDF to MySQL screen?
Dear all, I'm trying to write some UDFs and it will help a lot if I can print debugging information out directly to the screen so I can see what's going on. But printf() etc does not print to the mysql client screen. Is there an easy work around? Thanks for any tips, fei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
copy question
Can mysql copy from table1 to table2? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL Problem (Will not write to but will read)
I guess your harddisk ran out of space. Delete some stuffwithout restarting the database. Relihan, Daniel wrote: Hi, All of a sudden it seems that my MYSQL is incapable of being written to. I can still read from it, but cannot write to it. When I looked at the processes, all the processes that tried to write to the database are in a state of 'Locked'. Any ideas what to do? - Dan Relihan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Windows CE MySQL
Tod, This is exactly what I am looking for. The CE PocketPC platform is the one I could make good use of. Just the MyISAM table type and no client/server needed. The pocket access table functionality included in PocketPCs is very limited and SQL Server CE is great but expensive and slightly inflexible. I think I found a full MySQL server compiled for Debian ARM which ran on an iPaq with Linux on, but I need CE as linux is so unfriendly on PDAs compared with PocketPC 2002. Thanks -- Nick Miles - [EMAIL PROTECTED] Database Developments Ltd Client/Server Web Database Apps Tel +44 1453 861155Fax +44 1453 861166 -- -Original Message- From: Tod Harter [mailto:[EMAIL PROTECTED]] Sent: 17 July 2002 16:40 To: Cal Evans; Nick Miles; [EMAIL PROTECTED] Subject: Re: Windows CE MySQL On Wednesday 17 July 2002 09:09, Cal Evans wrote: I can see where accessing the server from a handheld would be cool but I question the concept of actually RUNNING the server on a handheld. Write a cool lightweight client with the library and leave the server on beefier HW. There are actually reasonable reasons for wanting to have a lightweight server, but really what you want is simply an application with embedded MySQL in it. In other words you don't need a client/server database, you need access to tables and you want to reuse client code which works already with MySQL database, so what you do is compile the embedded server into your program. Effectively it has the same API as the client library, except it does all the work directly itself instead of talking to a server. I don't know how much resources it requires though, nor what the requirements would be as far as functionality the platform has to support in order to compile it. My guess would be you could fairly easily do this on a Linux based PDA like the Zaurus, and its not unlikely it might work in CE, but I doubt you'd have much luck with things like Palms since they have a pretty weird set of OS functions thats nothing like what you get on a normal desktop OS (ie you don't have a regular C standard library really...). =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Nick Miles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:34 AM To: [EMAIL PROTECTED] Subject: Windows CE MySQL Hi, Has anyone tried building a MySQL server for Windows CE ? I have found a really good client for CE called DALP (http://www.kalpadrum.com/dalp/) but no server. It would be really good to have a cut down MySQL server on PDAs. I have had a go at compiling the server using Embedded Visual C++ 3 but my C skills are no where near good enough to get anywhere. Thanks -- Nick Miles - [EMAIL PROTECTED] Database Developments Ltd Client/Server Web Database Apps Tel +44 1453 861155Fax +44 1453 861166 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to Print from UDF to MySQL screen?
print them to a log file, and tail -f logfile from another window. Fei Chen wrote: Dear all, I'm trying to write some UDFs and it will help a lot if I can print debugging information out directly to the screen so I can see what's going on. But printf() etc does not print to the mysql client screen. Is there an easy work around? Thanks for any tips, fei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: copy question
Yes, CREATE TABLE tbl SELECT * FROM tbl; Vivian Wang wrote: Can mysql copy from table1 to table2? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copy question
On Wednesday, 17. July 2002 18:07, Vivian Wang wrote: Can mysql copy from table1 to table2? Yes, if table t2 doesn't exist you have to create table2 first. Then you can use INSERT .. SELECT STAMENT. http://www.mysql.com/doc/I/N/INSERT_SELECT.html Regards Georg 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
Query
Sir, I am a PG student of Indian Institute Of Information techology And Management Kerala.I had been using your product.I would like to get an information. I would like to know the maximum number of rows and columns which can be inserted into a table in MYSQL. I hope you will reply to me at the earliest. Thanking You, Regards, Abhilash S Menon - This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myODBC BIGINT conversion
sql query We have data stored as BIGINT in unix, and there are 32bit unsigned values but nothing larger. I would assume if we convert this to integer in win98 it would seem that values over 31bits would be wrong. Are there workarounds for this? Is this also an issue in later version of windows? DB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Opposite of --skip-networking?
Hi, I've compiled mysql-4.0.2-alpha from source, and I cannot seem to get it to bind to an interface and allow TCP connections. When I do a SHOW VARIABLES I see skip_networking=ON yet I am not starting mysql with --skip-networking. To reverse this situation I tried putting: set-variable = skip_networking=OFF in my.cnf, but it told me it was an unknown variable. Anyone got any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris 9/GCC-3.1 Compile Problems
I recently download mysql-3.23.51 and compiled it on a solaris 9 (sparc) system using gcc-3.1. I ran into a couple of minor compile errors which were easily fixed by a couple of type casts.. so far, it seems like the casts are fine here are the diffs --- sql/mysqld.cc.orig Wed Jul 17 11:16:16 2002 +++ sql/mysqld.cc Wed Jul 17 11:53:27 2002 @@ -2391,7 +2391,7 @@ { size_socket length=sizeof(struct sockaddr_in); new_sock = accept(sock, my_reinterpret_cast(struct sockaddr *) (cAddr), - length); + (socklen_t *)length); if (new_sock != INVALID_SOCKET || (socket_errno != SOCKET_EINTR socket_errno != SOCKET_EAGAIN)) break; @@ -2457,7 +2457,7 @@ size_socket dummyLen; struct sockaddr dummy; dummyLen = sizeof(struct sockaddr); - if (getsockname(new_sock,dummy, dummyLen) 0) + if (getsockname(new_sock,dummy, (socklen_t *)dummyLen) 0) { sql_perror(Error on new connection socket); (void) shutdown(new_sock,2); --- sql/mini_client.cc.orig Wed Jul 17 11:49:19 2002 +++ sql/mini_client.cc Wed Jul 17 11:53:54 2002 @@ -315,7 +315,7 @@ */ s_err=0; - if (getsockopt(s, SOL_SOCKET, SO_ERROR, (char*) s_err, s_err_size) != 0) + if (getsockopt(s, SOL_SOCKET, SO_ERROR, (char*) s_err, (socklen_t *)s_err_size) != 0) return(-1); if (s_err) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query
From: [EMAIL PROTECTED] Sir, I am a PG student of Indian Institute Of Information techology And Management Kerala.I had been using your product.I would like to get an information. I would like to know the maximum number of rows and columns which can be inserted into a table in MYSQL. I hope you will reply to me at the earliest. According to Crash-Me (http://www.mysql.com/information/crash-me.php), the maximum number of columns allowed in a table is 3398. I don't know about a limit on the number of rows, but it would probably depend more on your filesystem than MySQL. If you can support file sizes greater than 2G or 4G, then there probably is no limit. And for the record, you should *not* direct questions like this to [EMAIL PROTECTED], [EMAIL PROTECTED], or [EMAIL PROTECTED] -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with spec-ing new MySQL server
Hello, I have been asked to spec out a new computer that will act as a dedicated MySQL server for a research cluster (running under RH Linux). To do that, I am trying to find information on the performance trade-offs between multiple processors (2 vs 4), the disk system (IDE vs SCSI; single vs RAID), and the memory system (1 GB, 2 GB, 2 GB). Specifically, is there a point above which you (typically) don't see a significant improvement? Is there a rational upper limit to the amount of physical memory that MySQL can effectively use or benefit from? Does an IDE RAID system significantly improve the database performance? Does SCSI RAID significantly outperform IDE? Should we concentrate on a system with an enormous amount of memory, or a very fast disk system? Based on current usage, I am expecting the database load to float around 200-400 simultaneous connections to a small number of databases (1-10). Each database will have several tables with a couple hundred thousand records each (each table will float between a MB and a GB). Thanks for any input, john - john Siirola Department of Chemical Engineering Carnegie Mellon University [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
using a php page to reboot linux
Hi mysql list members, Is it possible to reboot the linux server through a PHP page. Like a client clicking on a button in a php page and that would result in rebooting the linux server. Can this be done?? Pls help, Regards, Harpreet Kaur _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
more weird my.cnf foo???
i recompiled/reinstalled 3.23.51. i copied mysql.server /etc/rc3.d/S99mysql. i edited /usr/local/etc/my.cnf. i started mysql and it read the my.cnf file from that location and everything worked great. i created a solaris package and installed it on another system. the system the package was installed on is a clone (exact except ip address) of the system that it was compiled on. so i start mysql on the second system, and it doesn't see (load) /usr/local/etc/my.cnf. now why is that? yesterday when i posted, i figured that i must not have properly configured when i compiled. that seemed to be the case, but now i am not so sure. thanks, shon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a php page to reboot linux
Although this is the wrong forum for this question, you certainly can. PHP has functions available to execute programs or command lines. http://www.php.net/manual/en/ref.exec.php Mike -Original Message- From: Harpreet Kaur [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:38 PM To: [EMAIL PROTECTED] Subject: using a php page to reboot linux Hi mysql list members, Is it possible to reboot the linux server through a PHP page. Like a client clicking on a button in a php page and that would result in rebooting the linux server. Can this be done?? Pls help, Regards, Harpreet Kaur _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a php page to reboot Linux
Yes, but this would be better addressed on a PHP list. This is MySQL. * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Harpreet Kaur [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:38 PM To: [EMAIL PROTECTED] Subject: using a php page to reboot linux Hi mysql list members, Is it possible to reboot the linux server through a PHP page. Like a client clicking on a button in a php page and that would result in rebooting the linux server. Can this be done?? Pls help, Regards, Harpreet Kaur _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: still not a simple sql-question ! ...
Just playing around a little with this problem, I think I found something that works. Here it is, CREATE TABLE `o_sessions` ( `isession` int(11) NOT NULL auto_increment, `iuser` int(11) NOT NULL default '0', `ssession` varchar(50) NOT NULL default '', PRIMARY KEY (`isession`) ) TYPE=MyISAM; INSERT INTO o_sessions VALUES(1,41,not wanted); INSERT INTO o_sessions VALUES(2,41,wanted); INSERT INTO o_sessions VALUES(3,42,not wanted); INSERT INTO o_sessions VALUES(4,42,wanted); INSERT INTO o_sessions VALUES(5,43,not wanted); INSERT INTO o_sessions VALUES(6,43,wanted); SELECT iuser, MAX(isession) as isession, MAX(ssession) as ssession from o_sessions GROUP BY iuser; +--+--+ | iuser | isession | ssession +--+--+ |41 |2 | wanted |42 |4 | wanted |43 |6 | wanted +--+--+ Mike mysql - Original Message - From: Matthew Scarrow [EMAIL PROTECTED] To: Robo [EMAIL PROTECTED]; [EMAIL PROTECTED]; denonymous [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 10:53 AM Subject: Re: still not a simple sql-question ! ... Add the sSession field and put in the not wanteds and wanteds you will see that the 3 rows your query returns is the first ones in the list per iUser that are the not wanteds. The query somehow needs to select the second ones. This is where the problem comes in. -- Original Message -- From: denonymous [EMAIL PROTECTED] Date: Wed, 17 Jul 2002 09:23:30 -0400 From: Robo [EMAIL PROTECTED] Well, by now i have found a way to work around the problem, still the problem is not solved, you may want continue thinking about it: start with this: iSession iUser sSession -- -- - 1 41 no 2 41 wanted 3 42 no 4 42 wanted 5 43 no 6 43 wanted and end up with that: iSession iUser sSession -- -- - 2 41 wanted 4 42 wanted 6 43 wanted Do it without a subselect and do it with one sql statement I'm new to this thread, so bear with me if this has already been suggested, but I just did the following and it worked fine: mysql CREATE TABLE `O_Sessions` ( `iSession` int(11) NOT NULL auto_increment, `iUser` int(11) NOT NULL default '0', PRIMARY KEY (`iSession`) ) TYPE=MyISAM; mysql INSERT INTO O_Sessions (iSession,iUser) VALUES (1,41),(2,41),(3,42),(4,42),(5,43),(6,43); mysql SELECT * FROM O_Sessions ORDER BY iSession; +--+---+ | iSession | iUser | +--+---+ |1 |41 | |2 |41 | |3 |42 | |4 |42 | |5 |43 | |6 |43 | +--+---+ 6 rows in set (0.01 sec) mysql SELECT MAX(iSession), iUser FROM O_Sessions GROUP BY iUser; +---+---+ | MAX(iSession) | iUser | +---+---+ | 2 |41 | | 4 |42 | | 6 |43 | +---+---+ 3 rows in set (0.00 sec) Does that last query help? -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: using a php page to reboot linux
On Wednesday, 17. July 2002 21:38, Harpreet Kaur wrote: Hi mysql list members, Is it possible to reboot the linux server through a PHP page. Like a client clicking on a button in a php page and that would result in rebooting the linux server. Can this be done?? Pls help, Yes, its possible. But this the mysql-list, send you php-questions to [EMAIL PROTECTED] Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help with spec-ing new MySQL server
John, Going off the top of my head and what you posted I would suggest a dual processor machine with at least 1 GB of RAM. (Make sure you compile MySQL with threads) SCSI is going to be much faster than IDE. If this is a production machine I would highly recommend SCSI. Finally, I would recommend RAID 0+1 (Striped and mirrored) As that gives you the best overall combination of performance in a database server. If you have to start cutting then you could drop the RAID and one processor and still have a well-performing machine. Next thing you need to think about is how to configure MySQL. Give it as much RAM as you can. If you are using InnoDB tables then check out http://www.innodb.com/ibman.html#InnoDB_tuning for more suggestions. They used to have several versions of my.cnf suggestions (small, medium and large) but I can't seem to find them anymore. HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: John D Siirola [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Help with spec-ing new MySQL server Hello, I have been asked to spec out a new computer that will act as a dedicated MySQL server for a research cluster (running under RH Linux). To do that, I am trying to find information on the performance trade-offs between multiple processors (2 vs 4), the disk system (IDE vs SCSI; single vs RAID), and the memory system (1 GB, 2 GB, 2 GB). Specifically, is there a point above which you (typically) don't see a significant improvement? Is there a rational upper limit to the amount of physical memory that MySQL can effectively use or benefit from? Does an IDE RAID system significantly improve the database performance? Does SCSI RAID significantly outperform IDE? Should we concentrate on a system with an enormous amount of memory, or a very fast disk system? Based on current usage, I am expecting the database load to float around 200-400 simultaneous connections to a small number of databases (1-10). Each database will have several tables with a couple hundred thousand records each (each table will float between a MB and a GB). Thanks for any input, john - john Siirola Department of Chemical Engineering Carnegie Mellon University [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: more weird my.cnf foo???
could it be a system permissions problem? =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Shon Stephens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:38 PM To: '[EMAIL PROTECTED]' Subject: more weird my.cnf foo??? i recompiled/reinstalled 3.23.51. i copied mysql.server /etc/rc3.d/S99mysql. i edited /usr/local/etc/my.cnf. i started mysql and it read the my.cnf file from that location and everything worked great. i created a solaris package and installed it on another system. the system the package was installed on is a clone (exact except ip address) of the system that it was compiled on. so i start mysql on the second system, and it doesn't see (load) /usr/local/etc/my.cnf. now why is that? yesterday when i posted, i figured that i must not have properly configured when i compiled. that seemed to be the case, but now i am not so sure. thanks, shon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Fwd: Re: using a php page to reboot linux
Are you sure you want to do that? Since php can call local programs, you can call one to reboot your computer. I think it's not a good idea to allow it. Anderson Pereira Ataides Em Quarta 17 Julho 2002 16:38, you wrote: Hi mysql list members, Is it possible to reboot the linux server through a PHP page. Like a client clicking on a button in a php page and that would result in rebooting the linux server. Can this be done?? Pls help, Regards, Harpreet Kaur _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-4.0.2-alpha (Official MySQL binary) Environment: System: Linux localhost.localdomain 2.2.17-8wl2 #1 Sun Jan 14 22:01:31 KST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='ccc' CFLAGS='-fast' CXX='cxx' CXXFLAGS='-fast -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 7¿ù 18 2002 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 4761074 12¿ù 15 2000 /lib/libc-2.2.so -rw-r--r--1 root root 22855536 12¿ù 15 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 12¿ù 15 2000 /usr/lib/libc.so 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-mysqld-ldflags=-non_shared --with-client-ldflags=-non_shared --disable-shared CC=ccc CFLAGS=-fast 'CXXFLAGS=-fast -noexceptions -nortti' CXX=cxx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Opposite of --skip-networking?
On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote: Hi, I've compiled mysql-4.0.2-alpha from source, and I cannot seem to get it to bind to an interface and allow TCP connections. When I do a SHOW VARIABLES I see skip_networking=ON yet I am not starting mysql with --skip-networking. To reverse this situation I tried putting: set-variable = skip_networking=OFF in my.cnf, but it told me it was an unknown variable. Anyone got any ideas? Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? Could you post your my.cnf if it isn't long? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 48 days, processed 1,038,197,465 queries (246/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query
Hi, I would like to know the maximum number of rows and columns which can be inserted into a table in MYSQL. The maximum number of columns in a table is currently 3398. The maximum number of rows is not limited - the only limit is your hard disk space. By the way, you can see this and much more information about the limits of MySQL and other databases at our Crash-Me pages at: http://www.mysql.com/information/crash-me.php Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/?ref=mtfr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Uuemõisa, Haapsalu, Estonia ___/ 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
instance
When I want to run two servers with different configuration. Can I run in the same machine and two running? Alexander sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.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: Opposite of --skip-networking?
On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote: On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote: Hi, I've compiled mysql-4.0.2-alpha from source, and I cannot seem to get it to bind to an interface and allow TCP connections. When I do a SHOW VARIABLES I see skip_networking=ON yet I am not starting mysql with --skip-networking. To reverse this situation I tried putting: set-variable = skip_networking=OFF in my.cnf, but it told me it was an unknown variable. Anyone got any ideas? Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? Ah, you're absolutely right. In /etc/my.conf there appears skip-networking The problem is, I need to run multiple mysql servers on this machine. Is there a way I can reverse the effect of skip-networking, or else skip reading /etc/my.cnf (the one in the basedir and $HOME/.my.cnf is enough)? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL: Problem Installing on RH 7.3
The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Deleting foreign keys with Innodb tables
Hi, I'm having a problem dropping a foreign key constraint from an Innodb table. I am using MySQL 3.23.51 for Win32. Any help would be greatly appreciated I have a simple set up like the one below: CREATE TABLE mastertable ( masterkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT ) TYPE=innodb; CREATE TABLE othertable ( otherkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT masterkey INT NOT NULL, INDEX (masterkey), FOREIGN KEY (masterkey) REFERENCES mastertable (masterkey) ON DELETE CASCADE ) TYPE=innodb; Which works fine and all. However, if I go to remove a foreign key it won't let me - though it does not report any errors: ALTER TABLE othertable DROP FOREIGN KEY masterkey; I tried dropping the column entirely (which is what I'm aiming to do in the first place) and dropping the index, but Innodb won't let me do either of those because of the foreign key constraints. I've also tried setting the table to a MyISAM type, removing the constraints, index and column then setting it back to an Innodb table. No go there either. It wants that field and index in the table before it will change the type back to Innodb. So, how does one go about removing the foreign key constraint once it is in place? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
text
I'm working with MySQL and Delphi. I created the following table: Create table Ligacoes ( Lig_cod INTEGER NOT NULL, Lig_codate INTEGER NOT NULL, Lig_nomeat VARCHAR(20), Lig_data DATE NOT NULL, Lig_duv TEXT, Lig_resp TEXT, Lig_penden CHAR(1), Lig_codcli INTEGER, Lig_erro CHAR(1), Lig_os CHAR(1), Lig_orca CHAR(1), Lig_dura DATETIME, Lig_hora CHAR(8), Lig_versao CHAR(20), Lig_codmotivo INTEGER NOT NULL, Lig_duv_so CHAR(1), Lig_prob_rede CHAR(1), Lig_contat CHAR(20) , CONSTRAINT Ligacoes_pk PRIMARY KEY (Lig_cod) )TYPE=INNODB; But when I try to open in a TQuery the recordcount result -1. Note: This problem(-1) normally happen when the result set is so large. What is the solution? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Opposite of --skip-networking?
On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote: Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? Ah, you're absolutely right. In /etc/my.conf there appears skip-networking The problem is, I need to run multiple mysql servers on this machine. Is there a way I can reverse the effect of skip-networking, or else skip reading /etc/my.cnf (the one in the basedir and $HOME/.my.cnf is enough)? Put the most common stuff in /etc/my.cnf. Then put the instance-specific stuff in a my.cnf file in each server's data directory. That should do the trick. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 48 days, processed 1,040,734,389 queries (246/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL: Problem Installing on RH 7.3
Dig around for a log file or an error file. Whenever it won't start it tells you why (or gives you a hint) in the error file. tail it and post if you still need help. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Windows CE MySQL
At 03:34 AM 7/17/2002, you wrote: Hi, Has anyone tried building a MySQL server for Windows CE ? I have found a really good client for CE called DALP (http://www.kalpadrum.com/dalp/) but no server. It would be really good to have a cut down MySQL server on PDAs. I have had a go at compiling the server using Embedded Visual C++ 3 but my C skills are no where near good enough to get anywhere. Nick, I wasn't sure you were serious or not. Heck, April 1st is long gone.:) But you want to put a Client Server database on a PDA? Problem #1 is the processor is way too slow. Problem #2 is lack of memory. Problem #3 is you're running it on Windows CE??? It would crash and burn every 5 minutes. I think what you wanted to do was access a MySQL database using a PDA. The database would be stored on a conventional PC and the data would be displayed on the PDA. Someone did post an ad for a product like MySQLAdmin but it ran on a Palm device so you could monitor the status of the MySQL database with your Palm. I thought this was a neat idea. Maybe someone remembers the product. To access a MySQL database on a PDA you would be doing it through a browser or have it sync with a MySQL database on a PC (http://www.osk.3web.ne.jp/~nyasu/palmsync/e.html). Mike Thanks -- Nick Miles - [EMAIL PROTECTED] Database Developments Ltd Client/Server Web Database Apps Tel +44 1453 861155Fax +44 1453 861166 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem Installing on RH 7.3
On Wed, Jul 17, 2002 at 04:40:50PM -0400, Richard Fox wrote: : : The MySQL daemon does not run. I installed the binary RPM's from the RH cd, : MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to : execute correctly. The I run safe_mysqld , and I get: : : [root@thor rfox]# /usr/bin/safe_mysqld : [1] 2212 : [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql : 020717 15:21:28 mysqld ended : : That's it! I tried both the rpm and compiling it myself from source with : BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior If it's the RPMs from RH, have you tried /etc/init.d/mysqld start? That's the standard way of starting services on RH. Have you looked in /var/log/mysqld.log for any errors? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: Opposite of --skip-networking?
On Wed, Jul 17, 2002 at 02:42:23PM -0700, Jeremy Zawodny wrote: On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote: Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? Ah, you're absolutely right. In /etc/my.conf there appears skip-networking The problem is, I need to run multiple mysql servers on this machine. Is there a way I can reverse the effect of skip-networking, or else skip reading /etc/my.cnf (the one in the basedir and $HOME/.my.cnf is enough)? Put the most common stuff in /etc/my.cnf. Then put the instance-specific stuff in a my.cnf file in each server's data directory. That should do the trick. To expand on that, MySQL will read (in order): /etc/my.cnf datadir/my.cnf ~/my.cnf And use all the options in that order. Those read later in the process override those earlier in the process. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 48 days, processed 1,042,881,257 queries (246/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date query
Hello, I run the web site for a band, and I am currently working on the shows list for the band. I have all of the shows listed in a database right now. I don't want to remove the shows that occurred in the past, but instead I want to have a query find only the shows that occur in the future. I have the date of each show in a MySQL date field, formatted as such: year-month-day (2002-07-17). Is there a way to use a query to compare the show date to the current date and only return future events? I'm using PHP to pull the information into the shows section. Erick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Opposite of --skip-networking?
Hi, Andy Smith wrote: On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote: On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote: Hi, I've compiled mysql-4.0.2-alpha from source, and I cannot seem to get it to bind to an interface and allow TCP connections. When I do a SHOW VARIABLES I see skip_networking=ON yet I am not starting mysql with --skip-networking. To reverse this situation I tried putting: set-variable = skip_networking=OFF in my.cnf, but it told me it was an unknown variable. Anyone got any ideas? Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? Ah, you're absolutely right. In /etc/my.conf there appears skip-networking The problem is, I need to run multiple mysql servers on this machine. Is there a way I can reverse the effect of skip-networking, Yes, Comment out or remove the line or else skip reading /etc/my.cnf (the one in the basedir and $HOME/.my.cnf is enough)? Yes, Place the ``my.cnf'' file into the --datadir= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fwd: Re: using a php page to reboot linux
References: [EMAIL PROTECTED] Mail-Copies-To: nobody X-PGP-Fingerprint: E394 1C70 C7F9 B740 CD2E FAC2 18CD 25A5 22F3 8AF3 Organization: LinuxFr - http://linuxfr.org Date: Thu, 18 Jul 2002 01:28:26 +0200 In-Reply-To: [EMAIL PROTECTED] ([EMAIL PROTECTED]'s message of Thu, 18 Jul 2002 00:48:13 +0200) Message-ID: [EMAIL PROTECTED] Lines: 12 User-Agent: Gnus/5.090007 (Oort Gnus v0.07) Emacs/21.2 (i386-debian-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii sql,query Are you sure you want to do that? Since php can call local programs, you can call one to reboot your computer. I think it's not a good idea to allow it. It might be fun for us, he just has to not forget to drop us the url ;-) -- Fabien Penso [EMAIL PROTECTED] | LinuxFr a toujours besoin de : http://perso.LinuxFr.org/penso/ | http://linuxFr.org/dons/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Opposite of --skip-networking?
That sir, it the coolest hint I've seen in a while. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 5:47 PM To: [EMAIL PROTECTED] Cc: Andy Smith Subject: Re: Opposite of --skip-networking? On Wed, Jul 17, 2002 at 02:42:23PM -0700, Jeremy Zawodny wrote: On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote: Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? Ah, you're absolutely right. In /etc/my.conf there appears skip-networking The problem is, I need to run multiple mysql servers on this machine. Is there a way I can reverse the effect of skip-networking, or else skip reading /etc/my.cnf (the one in the basedir and $HOME/.my.cnf is enough)? Put the most common stuff in /etc/my.cnf. Then put the instance-specific stuff in a my.cnf file in each server's data directory. That should do the trick. To expand on that, MySQL will read (in order): /etc/my.cnf datadir/my.cnf ~/my.cnf And use all the options in that order. Those read later in the process override those earlier in the process. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 48 days, processed 1,042,881,257 queries (246/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date query
From: Erick Hitter [EMAIL PROTECTED] Hello, I run the web site for a band, and I am currently working on the shows list for the band. I have all of the shows listed in a database right now. I don't want to remove the shows that occurred in the past, but instead I want to have a query find only the shows that occur in the future. I have the date of each show in a MySQL date field, formatted as such: year-month-day (2002-07-17). Is there a way to use a query to compare the show date to the current date and only return future events? I'm using PHP to pull the information into the shows section. Add the following clause to your query: WHERE datefield = NOW() It'll compare each show's date (in datefield, or whatever you named it) to the current datetime, returned by the function NOW(), and only return those dates equal to or later than the current datetime. -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 , InnoDB, 3.23.51
Hello! I found a small thread from 2 years ago that said that replication was restricted to MyISAM table types. Is this true? Can I not replicate InnoDB table types? The reason I ask is that I am getting a the 1189: Net Read Error when I run: LOAD TABLE name FROM MASTER; Is there a work around for this at all? Replication is REALLY key here, as is InnoDB. (We need the foreign keys, and transaction support, as WELL as replication). Thanks a lot to anyone who replies! -James P.S. I am STILL looking in the doc's, but I just thought that I would ask! Thanks again! sql query (to satify 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: Replication , InnoDB, 3.23.51
On Wed, Jul 17, 2002 at 04:42:35PM -0700, James Kelty wrote: Hello! I found a small thread from 2 years ago that said that replication was restricted to MyISAM table types. Is this true? Can I not replicate InnoDB table types? It is no longer true. The reason I ask is that I am getting a the 1189: Net Read Error when I run: LOAD TABLE name FROM MASTER; Hmm. Haven't tried LOAD TABLE on a slave with InnoDB yet. I don't know if it is supposed to work or not (yet). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 49 days, processed 1,047,022,088 queries (247/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication on different SQL servers
Hi.. I'm working on a proyect to implement a SQL server with PHP to allow acces to a MySQL server on the web. The Master server (the server everybody work with) is a Windows 2000 CENTURA SQL server. I want to know how i can manage to export a database from that server to another server (The one who will allow access to the database on the WEB) With what funtion can i do this, and also install a script to make the slave server update from the master database (This can be done once a day, it doesnt have to be inmidiate) Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL in different OSes
Yes, you can just copy from Win to Linux, but I suggest you to use mysqldump instead and copy a dump file. I know it is probably not necessary to point this out, but you probably would have zero success directly copying the database files from MSWin to, say, linux/ppc. Definitely best to use mysqldump. Unless, of course, you're just curious to see what happens when bits aren't where the CPU thinks they're supposed to be. -- Joel Rees [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
how to fast rename column name.
mysql: how to rename column name exception that use alter table tablename column newcolumn expression. I want get fast to rename the column name, but use front idea is very slowly when my table has 1000 record. help me! thanks! qingfong [EMAIL PROTECTED] ¡¡2002-07-18 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Privileges Question
Hi fellows, I have a MySQL privileges question and hope someone can provide some input on it. I have setup a user who can access only one db, say 'DB1'. About the privileges, I set the account privilege like this: 1) In user table, this account has Host='%' User='user_name' Password='pwd' and all other privileges are set to 'N'. 2) In db table, this account has Host='%' Db='DB1' User='user_name' and all other privileges are set to 'Y' EXCEPT grant_priv. Through MySQL Front GUI, the user login and is allowed to access 'DB1' only and other dbs are not visible to this user. Very things look good at this point, however, when I have a piece of java code try to access 'DB1' with this user account through MM.MySQL JDBC I receive an access deny. Questions: 1) Why it behaves like this? I thought if I can access through GUI application with this account, I should have the same access through JDBC. 2) Does this mean I have to use an account which has a global access privilege(s) in order to access the db through JDBC?? Any input would be appreciated. Best regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: instance
Hello Alexander, You can easily have two or more instances (mysqld processes) of MySQL running on the physically same server as long as they have different data directories. You possibly could, in theory, have a system where several mysqld processess share the same data directory (still having different databases) but this approach is _extremely_ tricky to get working reliably. About the need of several server instances, you could use another MySQL for production use (possibly with the normal port, stable table handlers etc.), meanwhile having another instance for development use, running on a different port. The good point of this approach is that if the development instance crashes due to some strange experiment (as mine sometimes does :-), it won't affect the production instance in any way. Of course, you should try to separate your production and development environments, but it's not always affordable. Regards, Iikka ** * Iikka Meriläinen * * IT Support * * Vaalan kunta * * -- * * E-mail: [EMAIL PROTECTED] * ** On Wed, 17 Jul 2002, Alexander Burbello wrote: When I want to run two servers with different configuration. Can I run in the same machine and two running? Alexander sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innodb tables
I am not able to run the Mysql server on a NT server and the data in another NT server on the network. See my my.in innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend innodb_data_home_dir=d:\applicaz\mysql\InnoDB innodb_log_group_home_dir=d:\applicaz\mysql\InnoDB\InnoLog innodb_log_arch_dir=d:\applicaz\mysql\InnoDB\InnoLog If I change the disk d: with a network drive the Mysql server doesn't start. Of corse the NT server see the other network disk where I need to put the data. Is it a limit of Mysql to reside data and server in the same machine ? regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Privileges Question
Did you try: FLUSH PRIVILEGES; Also, to see what user can do with his permissions you can try this: SHOW GRANTS FOR username; Mihail Quoting Yat-Shing Tam [EMAIL PROTECTED]: Hi fellows, I have a MySQL privileges question and hope someone can provide some input on it. I have setup a user who can access only one db, say 'DB1'. About the privileges, I set the account privilege like this: 1) In user table, this account has Host='%' User='user_name' Password='pwd' and all other privileges are set to 'N'. 2) In db table, this account has Host='%' Db='DB1' User='user_name' and all other privileges are set to 'Y' EXCEPT grant_priv. Through MySQL Front GUI, the user login and is allowed to access 'DB1' only and other dbs are not visible to this user. Very things look good at this point, however, when I have a piece of java code try to access 'DB1' with this user account through MM.MySQL JDBC I receive an access deny. Questions: 1) Why it behaves like this? I thought if I can access through GUI application with this account, I should have the same access through JDBC. 2) Does this mean I have to use an account which has a global access privilege(s) in order to access the db through JDBC?? Any input would be appreciated. Best regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Database Designer
Hi all, I have created a Database Designer for the MySQL databases on Windows. I wanted to attach it to this mail, but it's more than 300K, so I wouldn't be a good idea to send it to the mailing list, I think. But I would like some of you to check it out. So, if you would like to be a beta tester :-), just send me an empty mail to [EMAIL PROTECTED] with the subject: MyDBDesigner and I'm gonna send the program to you. When you tested it I would be very pleased to write your notices and suggestions to make the program better and more useful. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php