New To MySql
Hello everybody! I am new to mysql and am totally confused as how to proceed? Is it installed automatically like perl or do I have to install and configure? in the docs its often referred as shell mysql but when I type it on c: prompt it says access denied. can anybody help? Thanks Abdul Sheikh 14 Mahmood Cr. Maple, ON L6A 3A4 H# 905.303.5442 F# 905 417 9495 C# 647.222.4795 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Speed !
On Saturday, 3. August 2002 06:44, Lord Loh wrote: Hi, I have a database of mysql with 3 million records. No query is performed in less than 10 seconds!(With Index and all that) Some more information like your table structure, indexes and a sample query and an explain could help to give you an answer. 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: Crashing under high load
Shane, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, August 03, 2002 2:21 AM Subject: Re: Crashing under high load On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) (again, I acknowledge this is an old article) says flat out that MySQL tends to die under high load. Also, when I say high load, I am talking 15-30. I have yet to see an application (other than MySQL when it's loaded down with queries) die under this level of load. it is not normal for MySQL or any other program to die under a high load. I regularly run stress tests on MySQL/InnoDB on our 4-way Linux-2.4.16 server, and a load of 20 is common in those tests. Tim Perdue's article in PHPBuilder is old. And I am not sure he knew about the problem of glibc allocating memory over thread stacks in Linux. The most common cause of crashing under a high load is that on Linux the memory allocation of MySQL approaches 2 GB. There is a bug in glibc which allows glibc to allocate memory over thread stacks without giving any error message. Other common causes are buggy disk drivers. In your my.cnf max_connections has a very big value 2500. You have compiled MySQL yourself, but have not set thread stack size lower than the default 2 MB? Then just the thread stacks can occupy 5 GB of memory. Sort buffer is set to 5 MB. Under a high load sort queries can pile up and eat up 12.5 GB of memory. You should try setting sort_buffer and record_buffer to 1M. . [mysqld] skip-locking set-variable= max_connections=2500 set-variable= query_cache_size=64M set-variable= wait_timeout=3600 set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=3000 # NOTE: Record buffer and Sort buffer are NOT shared among threads # They are per-thread memory buffers. set-variable= sort_buffer=5M set-variable= record_buffer=5M .. That's not normal at all. MySQL shouldn't care about the system load. It may run *slower* but it shouldn't die. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 64 days, processed 1,352,421,911 queries (240/sec. avg) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB: Looong pause when log file is full?
Pete, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, August 02, 2002 2:40 AM Subject: Re: InnoDB: Looong pause when log file is full? On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote: Hi, I've read the performance tuning tips for InnoDB (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit when the log files are full and the buffer pool is checkpointed. InnoDB does 'fuzzy checkpoints'. That means modified database pages in the buffer pool are flushed to disk in small batches. The time when a physical log file becomes full does not affect this continuous background checkpointing activity, since InnoDB sees all the log files as one catenated log file. The pauses you experience are probably caused by high load in general, probably too much disk i/o. You should study your queries, use the InnoDB Monitor, watch 'top', adjust buffer pool size, spread disk i/o. If the load is CPU-bound and you have many queries running simultaneously, you may experience 'thread thrashing'. Then you can try to set innodb_thread_concurrency lower than the default 8, even to 1. By 'geting bit', I mean for several minutes the db server basically stops, and our website stops serving pages. Does anyone have advice about what we can do to alleviate this? Instead of having three 150mb log files, would we be better off with 30 15mb log files? It shouldn't matter how many files you have. InnoDB sees them as one striped file anyway. Our log files are on the same raid array as the data, but would it really make that much difference to move them to a separate disk? It can if things are I/O bound, and they likely are. Alternately, is there a way to trigger this action at night, so we can avoid it happening during the day? It shut us down for about five minutes today. You could increase the size of your logs. That'll increase recovery time if there's ever a crash, but it should give InnoDB more breathing room. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 63 days, processed 1,335,360,828 queries (241/sec. avg) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: THIS IS NOT AN ADVERTISEMENT: BugReport..Need Help
At 23:19 2/8/2002 +, Tien Lim wrote: Hi, To Whom It May Concern: Environment: Operating System Windows XP Home Edition Using MySQL 3.23 Using Apache 1.3.12 Initially it started working suddenly after trying all of the commands below... : ) The next day I started the computer and it does not work : ( Tried to intall from the C:\Progra~1\MySQL\bin prompt 'mysqld-nt --install'. Resulted in a pop-up windows MySQL error Failed To Install Service. Since you had installed the MySQL stuff on another directory than the default C:\mysql, you need to have either the \winnt\my.ini file or c:\my.cnf file with the below section and keys: [mysqld] basedir=C:/Progra~1/MySQL datadir=C:/Progra~1/MySQL/data # ? Typed 'mysql-nt' alone at the bin prompt..., the prompt comes back with no stated errors. At the command prompt should be: mysqld-nt --standalone --console Typed at prompt 'net start mysql' Resulted in The MySql service is starting. The MySql service could not be started. A system error has occured. A System error 1067 has occurred. The process terminated unexpectedly. The above means that the server has aborted for something wrong, for example you don't have the configuration file above mentioned with the basedir and datadir keys. Anyway starting the server at the command prompt (see above) you should see the error message. Try to fix them or send to the list the messages error. When using at the prompt 'mysqladmin ping'...the following message resulted: MYSQLADMIN: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' 10061' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306'. The above happens because the server wasn't started. Regards, -- For technical support contracts, visit https//order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hey
hope its okey for me too ask you an question regarding linking of tables... i have been building the tables that are in the manual http://www.mysql.com/doc/en/example-Foreign_keys.html Still i cant understand why i can add and new shirt for an person that isnt there, i am using the mysql 3.23.49 I can even delete a person that has an shirt, any pointers on howto solve 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
FW: trouble getting started
Hi Installed Mysql (from mysql-3.23.51-win.zip) to c:\mysql on my pc (running Windows XP Professional) Started Apache (1.3.20) that I got with mod_perl . runs ok (can do perl scripts on it ok) Tried to execute c:\mysql\binmysqld (as in the manual) after about 5 seconds, comes back with normal prompt i.e. c:\mysql\bin but any mysql command entered, i.e. mysql test is responded with: ERROR 2003:Cant connect to MySQL server on localhost (10061) Ive obviously missed something basic, please help Thanks in advance Glyn --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using MySQL for a destop application
Hi, What I would like to do is use MySQL for a desktop application. So not with a remote SQL Server. I'm using VB.NET and Native MySQL support to connect to mysql servers, which works just fine. But I would like to distribute an application which runs only on the local machine and uses mySQL as a backstorage. (Instead of lets say an access database) What would be the best way to do this ? I don't want to have the user installing MySQL seperatly and then having to configure it and creating the database and stuff I just one 1 clean install with everything preconfigured and the server only running when the desktop application is running. Is there special support for this ? Please not that I can't use C/C++ code. Thnx. TP. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 2/08/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Socket Error
Here's my bug report Version: MySql 3.23.51. OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown Memory: 64MB + 256MB(Swap) Distibution Name: mysql-3.23.51-pc-linux-gnu-i686 I runned MySQL with the command: bin/safe_mysqld --user=mysql , and all was done. When I tried to access to the MySQL server through the command: mysql, I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) Please help me. Alessandro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using MySQL for a destop application
First, make sure you purchase the necessary licenses and support contract. Building your own installer is a piece of cake. We use InstallConstruct, but InstallShield, Wise, etc. will do just fine. Create the database(s) the way you want them, and include them in your installer package. Make sure you create a small app to create and write out the my.ini file ... ours is written in WinBatch, but there are many ways to accomplish this. In our case, the person doing the install runs the setup wizard, clicks through a few screens, and voila ... they're done. Gerald Jensen - Original Message - From: [XG]Boomer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 03, 2002 6:23 AM Subject: Using MySQL for a destop application Hi, What I would like to do is use MySQL for a desktop application. So not with a remote SQL Server. I'm using VB.NET and Native MySQL support to connect to mysql servers, which works just fine. But I would like to distribute an application which runs only on the local machine and uses mySQL as a backstorage. (Instead of lets say an access database) What would be the best way to do this ? I don't want to have the user installing MySQL seperatly and then having to configure it and creating the database and stuff I just one 1 clean install with everything preconfigured and the server only running when the desktop application is running. Is there special support for this ? Please not that I can't use C/C++ code. Thnx. TP. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 2/08/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot
Sergey S. Kostyliov writes: Description: Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege not working ERROR 1142 How-To-Repeat: 1) (under root) mysql GRANT CREATE TEMPORARY TABLES ON *.* TO test_user@localhost IDENTIFIED BY 'test_pass'; Query OK, 0 rows affected (0.01 sec) 2) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); Query OK, 0 rows affected (0.00 sec) 3) (under root) mysql CREATE TABLE t (i INT); Query OK, 0 rows affected (0.00 sec) mysql GRANT SELECT ON test.t TO test_user@localhost; Query OK, 0 rows affected (0.00 sec) 4) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); ERROR 1142: create command denied to user: 'test_user@localhost' for table 'tmp_table' Hi! Thank you for your bug report. Thanks to it, the above bug was fixed and fix will come up in 4.0.3. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hey
Are you using InnoDB type tables? The default table type is MyIsam which does not support foreign keys. Regards, Bhavin. - Original Message - From: muad [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 03, 2002 5:52 AM Subject: hey hope its okey for me too ask you an question regarding linking of tables... i have been building the tables that are in the manual http://www.mysql.com/doc/en/example-Foreign_keys.html Still i cant understand why i can add and new shirt for an person that isnt there, i am using the mysql 3.23.49 I can even delete a person that has an shirt, any pointers on howto solve 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Repetitive link error when making
Description: The following command is invoked by make: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/lib/mysql And it reports: mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTB9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' This happens every time. How-To-Repeat: (./configure; make all) Fix: Unknown Submitter-Id: submitter ID Originator:Fredrik Tolf Organization: None MySQL support: none Synopsis: Linking errors at compile time Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.51 (Source distribution) Environment: Modified RedHat 7.1 system. glibc-2.2.4-24 gcc-3.1 System: Linux pc7 2.4.2-2 #11 Wed Mar 13 00:52:03 CET 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pld-linux/3.1/specs Configured with: ../configure --prefix=/usr --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --enable-threads=posix --enable-languages=c,c++,f77,gcov,java,objc,ksi,ada --enable-long-long --enable-multilib --with-gnu-as --with-gnu-ld --with-system-zlib --with-slibdir=/lib --without-x i686-pld-linux Thread model: posix gcc version 3.1 20020408 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 14 19:28 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5734740 Apr 2 18:44 /lib/libc-2.2.4.so -rw-r--r--1 root root 27332668 Apr 2 18:42 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 2 18:42 /usr/lib/libc.so Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb CC=gcc CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 CF5 - auto increment??
Hi, I'm trying to get mySQL 4/myODBC working properly with CF5 on a Win2k machine, but am having problems with auto_increment. I've set up some tables using auto_increment for the ID field, and when I insert a record using mySQLgui or the MSDOS mysql command line tool, it increments correctly. However, if I insert a record using an HTML or Flash form, posting to a CF insert statement, the values get inserted in the correct fields, but the ID doesnt increment, instead taking its default value of 0. A simple statement would be as follows: INSERT INTO myTable(fname,lname) VALUES('fred','smith') - I'm probably missing something obvious, so I'd be grateful if anyone can shed any light on this and offer a solution (urgently, if possible) - Cheers, FlashG _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.: Socket Error
Are you sure that you are running the server at all? Nikodim Here's my bug report Version: MySql 3.23.51. OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown Memory: 64MB + 256MB(Swap) Distibution Name: mysql-3.23.51-pc-linux-gnu-i686 I runned MySQL with the command: bin/safe_mysqld --user=mysql , and all was done. When I tried to access to the MySQL server through the command: mysql, I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) Please help me. Alessandro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ___ NOCC, http://nocc.sourceforge.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re.: Socket Error
Are you sure that you are running the server at all? Nikodim Here's my bug report Version: MySql 3.23.51. OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown Memory: 64MB + 256MB(Swap) Distibution Name: mysql-3.23.51-pc-linux-gnu-i686 I runned MySQL with the command: bin/safe_mysqld --user=mysql , and all was done. When I tried to access to the MySQL server through the command: mysql, I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) Please help me. Alessandro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ___ NOCC, http://nocc.sourceforge.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL CF5 - auto increment??
Hi Flash: This is a shot in the dark, but when I set up some tables using phpMyAdmin, I set a field to auto_increment and a default value of 0, phpMyAdmin created the table, but without the default value. When I add records from a form, it increments correctly. Perhaps the default value should not be set? HTH Cheers David On Saturday, August 3, 2002, at 01:18 PM, Gordon McGowan wrote: Hi, I'm trying to get mySQL 4/myODBC working properly with CF5 on a Win2k machine, but am having problems with auto_increment. I've set up some tables using auto_increment for the ID field, and when I insert a record using mySQLgui or the MSDOS mysql command line tool, it increments correctly. However, if I insert a record using an HTML or Flash form, posting to a CF insert statement, the values get inserted in the correct fields, but the ID doesnt increment, instead taking its default value of 0. A simple statement would be as follows: INSERT INTO myTable(fname,lname) VALUES('fred','smith') - I'm probably missing something obvious, so I'd be grateful if anyone can shed any light on this and offer a solution (urgently, if possible) - Cheers, FlashG _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New To MySql
Hello everybody! I am new to mysql and am totally confused as how to proceed? Is it installed automatically like perl or do I have to install and configure? in the docs its often referred as shell mysql but when I type it on c: prompt it says access denied. can anybody help? Thanks Abdul Sheikh 14 Mahmood Cr. Maple, ON L6A 3A4 H# 905.303.5442 F# 905 417 9495 C# 647.222.4795 Your best bet is to get yourself some reference material if you haven't already. I suggest 'MySQL' by Paul DuBois. But for starters, what OS are you planning to install on? From your message, I gather you're installing on some flavour of Windows? Is your purpose to provide a development platform just for yourself, or to open it up to the world? When you see a reference to 'shell mysql', that's referring to the client - remember there are 2 things going on. First you have to start the server (mysqld for example), then you need to start a client (mysql) to access the server. -- Amer Neely, Softouch Information Services Perl / PHP / MySQL / CGI Programming e: [EMAIL PROTECTED] w: www.softouch.on.ca/ v: 519.438.5887 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Bug in UNION clause]
Here is the dump of those tables being used: allusa: +--++--+-+--+--- + | Field| Type | Null | Key | Default | Extra | +--++--+-+--+--- + | id | int(10) unsigned | | PRI | 0| | | line | enum('FULL','LINE','NSHW') | | MUL | FULL | | | name | varchar(50)| | MUL | | | | address | varchar(50)| YES | | NULL | | | paddress | varchar(50)| YES | | NULL | | | city | varchar(50)| | MUL | | | | listcity | varchar(50)| | MUL | | | | state| varchar(4) | | MUL | | | | liststate| varchar(4) | | MUL | | | | statename| varchar(20)| | MUL | | | | zip | varchar(10)| YES | | NULL | | | country | enum('','USA','Canada')| | MUL | | | | phone| varchar(20)| YES | | NULL | | | rs | varchar(20)| YES | | NULL | | | fax | varchar(20)| YES | | NULL | | | email| varchar(100) | YES | | NULL | | | url | varchar(150) | YES | | NULL | | | innkeeper| varchar(50)| YES | | NULL | | | season | varchar(24)| YES | | All Year | | | cost_range_low | decimal(8,2) | | | 0.00 | | | cost_range_high | decimal(8,2) | | | 0.00 | | | rooms| smallint(5) unsigned | YES | | NULL | | | pb | smallint(5) unsigned | YES | | NULL | | | visa | enum('Visa') | YES | | NULL | | | mc | enum('MC') | YES | | NULL | | | amex | enum('AmEx') | YES | | NULL | | | disc | enum('Disc') | YES | | NULL | | | mostcc | enum('Most CC')| YES | | NULL | | | rated| enum('y') | YES | | NULL | | | tac | char(2)| YES | | NULL | | | child| enum('yes','no','ltd') | YES | | NULL | | | smoke| enum('yes','no','ltd') | YES | | NULL | | | pets | enum('yes','no','ltd') | YES | | NULL | | | wc | enum('yes','no','ltd') | YES | | NULL | | | bb_code | enum('AP','BB','EP','MAP') | YES | | NULL | | | language | varchar(100) | YES | | NULL | | | breakfast| varchar(35)| YES | | NULL | | | otherfood| varchar(50)| YES | | NULL | | | amenities| varchar(76)| YES | | NULL | | | attraction | text | YES | | NULL | | | desc1| varchar(255) | YES | | NULL | | | ex_desc | text | YES | | NULL | | | room1desc| varchar(255) | YES | | NULL | | | room2desc| varchar(255) | YES | | NULL | | | ongoing_specials | varchar(255) | YES | | NULL | | | airport | varchar(40)| YES | | NULL | | | bookable | varchar(10)| YES | | NULL | | | latitude | float(10,6)| | MUL | 0.00 | | | longitude| float(10,6)| | | 0.00 | | | mat_type | tinyint(3) unsigned| YES | | NULL | | | keywords | varchar(100) | | | | | | region1 | tinyint(3) unsigned| YES | | 0| | | region2 | tinyint(3) unsigned| YES | | 0| | | last_updated | timestamp(14) | YES | | NULL | | | showmap | tinyint(1) | YES | | 1| | | showlink | tinyint(1) unsigned| YES | | 0| | | updated_by | char(1)| YES | | NULL | | | comments | varchar(200) | YES | | NULL | | | coupons | enum('yes','no') | | | no | | | reservations | enum('yes','no') | YES | | NULL | | | newsletter | enum('yes','no') | YES | | NULL | |
Re: Do you run multiple servers on WIndows?
At 3:03 -0300 7/26/02, miguel solorzano wrote: At 19:07 25/7/2002 -0700, Bhavin Vyas wrote: Hi, From what little I know of MySql on Windows, it runs as a service and you can't run multiple services on the same Win Server. cut From 4.0.2 release you are able to run several services. For example: For to run two services: the first one using mysqld-nt.exe and the second one using the mysqld-max-nt.exe. Installing mysqld-nt.exe command at the prompt: mysqld-nt --install or mysqld-nt --install-manual Installing mysqld-max-nt.exe command at the prompt: mysqld-max-nt --install mysqldopt or mysqld-max-nt --install-manual mysqldopt Now you have the default service called mysql for to run mysqld-nt.exe and the service mysqldopt for to run mysqld-max-nt.exe. Now you edit the /winnt/my.ini file: [mysqld] #for to set the server mysqld-nt.exe port=3306 basedir=c:/mysql datadir=c:/mysql/data . [mysqldopt] #for to set the server mysqld-max-nt.exe the same name of #the service port=3307 basedir=c:/mysql datadir=d:/mysqldopt/data skip-innodb skip-bdb . Thanks, Miguel. This sounds promising. I don't see anything about this in the 4.0.2 change notes, and I have some questions about how this works: - What does the argument after the --install argument represent? Is it a service name? Does it cause the server to use a different default named pipe name? Is this value case sensitive? - When an argument is given after --install, that argument becomes the name of the option file group that the server reads from option files? Does it still read [mysqld], or *only* [mysqlopt]? - How do you remove the service? Do you give the same argument after --remove, for example: mysqld-max-nt --remove mysqldopt Notes: 1- You can use the same basedir but not the same executable. 2- You must to have a different datadir (the whole directory) for each server. You can't to mix the mysql database and the working databases. 3- You need to have a different port. In this way for example you can use one server as master and the other as slave on the same machine; of course both handling the same type of tables. In the example above only MyISAM tables. Regards, -- For technical support contracts, visit https//order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
users and db visibilty
how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' they only are shown the db(s) they have access to. ? 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
users and db visibility
how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' they only are shown the db(s) they have access to. ? 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: Do you run multiple servers on WIndows?
At 16:05 3/8/2002 -0500, Paul DuBois wrote: Hi Paul, cut Thanks, Miguel. This sounds promising. I don't see anything about this in the 4.0.2 change notes, Sorry Indeed it wasn't mentioned. and I have some questions about how this works: - What does the argument after the --install argument represent? Represents the service name and the server group set on mysql.ini. Is it a service name? Yes and the server group section. Does it cause the server to use a different default named pipe name? No, for optional service must be used TCP/IP. The problem here is that the service and group server section is an user choice and the client library is compiled only for the current named pipe. Is this value case sensitive? No. - When an argument is given after --install, that argument becomes the name of the option file group that the server reads from option files? Does it still read [mysqld], or *only* [mysqlopt]? The server which was installed without the argument uses the default server group section called [mysqld] and the optional one the same name of the service. In another words both server use the same my.ini file but with different group server section - How do you remove the service? Do you give the same argument after --remove, for example: mysqld-max-nt --remove mysqldopt Yes. I also can be use for to remove the default service: mysqld-max-nt --remove mysql Regards, -- For technical support contracts, visit https//order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
benchmark to my MySQL
Is there any standard method or benchmark to run localy or remotly to my host to help me to setup MySQL better or to check various computer/configurations? I could find anything on http://www.mysql.com/information/benchmarks.html links. Only at third part software but it is in C++, not .sql. What that means? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump --xml does not generate well formed XML
mysqldump invoked with --xml/-X omits the backslash from closing tags for columns of type: enum, varchar and date. Martin Tsachev Web developer http://martin.f2o.org MySQL support: none Synopsis: mysqldump --xml generates opening tags instead of closing for data, varchar and enum Severity: non-critical Priority: low Category: mysqldump Class: sw-bug Release: mysql-3.23.49 (Source distribution) Environment: System: Linux localhost 2.4.18 #1 Sat Aug 3 13:08:07 EEST 2002 i686 unknown Architecture: i686 (Pentium III, Slackware 8.1) Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 10 22:40 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 4783716 May 26 2001 /lib/libc-2.2.3.so -rwxr-xr-x1 root root 5029105 May 18 06:54 /lib/libc-2.2.5.so -rw-r--r--1 root root 24991240 May 18 06:53 /usr/lib/libc.a -rw-r--r--1 root root 178 May 18 06:53 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php