Error configuring myodbc ver 3.51
New list member and mysql newbie with first time post. I'm running into a problem getting MyODBC ver3.51 configured on my RH7.3 server running mysql 4.0.12. Anyone happen to be familiar with this error when configuring MyODBC: Could not find 'libmysqlclient' from '/usr/local/mysql/lib/mysql' or '/usr/local/mysql'. Try another location. I attempted to configure myodbc with the following: $./configure --prefix=/usr/local --with-iodbc=/usr/local --with-mysql-dirs=/usr/local/mysql/lib/mysql --with-mysql-includes=/usr/local/mysql/include/mysql --without-debug --enable-thread-safe I tried to change --with-mysql-dirs to --with-mysql-libs and got this error: Could not find the mysql include file So I changed --with-mysql-includes=/usr/local/mysql/include/mysql to --with-mysql-includes=/usr/local/mysql/include and got this error: Unable to find iodbc headers in /usr/local/include I changed --with-iodbc=/usr/local to --with-iodbc=DIR That returned the same error so I tried to change it to: --with-iodbc-includes=INCDIR and got this error: Unable to find iodbc headers in INCDIR So I try to remove the iodbc option and still get that error. I'm tapped as these are all steps outlined in the install document. Can anyone else here assist with this? Any responses are appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Insert problem
Have you tried single quotes (ie. registry_program='EA')? Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Mon, 30 Jun 2003, Sparky Kopetzky wrote: Greetings!! I'm trying this insert and it will not run in batch mode. I think the '' syntax is right but what else am I missing?? insert into registry set registry_program=EA, registry_key=BASE_PATH, registry_value=f:auction; Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CHAR() versus VARCHAR() Table Speed
From the manual: If you don't have any variable-length columns (VARCHAR, TEXT or BLOB columns), a fixed-size record format is used. This is much faster but unfortunately may waste some space. Can anyone more precisely quantify how significant is the difference in performance if the table uses all CHAR fields versus all VARCHAR fields? Also, if VARCHAR() is used in a table, what would be the reason to use, say VARCHAR(25) rather than always simply using VARCHAR(255)? V Harris
UDF-Functions crashes DB-Engine
Description: since a few days the start of a UDF-Function crashes the DB-Engine which results in a Restart. I have a Version from 2003-06-03 (Bitkeeper-Archive) without any Problems. How-To-Repeat: starting any UDF-Function Fix: Submitter-Id: Originator:[EMAIL PROTECTED] Organization: Kfz-Innung-Schwaben MySQL support: none Synopsis: DB-Engine craches Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.1.1-alpha (Source distribution) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux dasisrv 2.4.20 #1 Thu Dec 19 14:24:14 MET 2002 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='-O3 -mpentium -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS='' LIBC: -rwxr-xr-x 1 root root 1382179 Jan 19 2001 /lib/libc.so.6 -rw-r--r-- 1 root root 19190164 May 10 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 May 10 2001 /usr/lib/libc.so -rw-r--r-- 1 root root 2032004 Jul 29 2000 /usr/lib/libc-client.a lrwxrwxrwx 1 root root 20 Nov 4 2000 /usr/lib/libc-client.so - ./libc-client.so.4.7 -rwxr-xr-x 1 root root 668784 Jul 29 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-assembler' '--with-thread-safe-client' '--enable-shared' '--with-charset=latin1' '--with-mysqld-user=mysqld' '--without-debug' '--without-bench' '--without-docs' '--with-mysqld-ldflags=-all-static' 'CXXFLAGS=-O3 -mpentium -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' Perl: This is perl, version 5.005_03 built for i586-linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A question about mysql_real_connect()
Hi! I read mysql doc (4.0.5-beta.) and see this: Note that upon connection, mysql_real_connect() sets the reconnect flag (part of the MYSQL structure) to a value of 1. This flag indicates, in the event that a query cannot be performed because of a lost connection, to try reconnecting to the server before giving up. Thus, When I use mysql_real_connect () and get these error code: CR_SERVER_GONE_ERROR CR_SERVER_LOST Is it no use to write some code to do a reconnection? riso -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
restrictions?
Hi, Sometimes I want to restrict the structure of my data. Let's say that I need to some records does not contain NULL values, or some numbers are not longer then 10 digits. But when I try to use login char(32)NOT NULL default 'tralala', or id bigint NOT NULL default 5000, and then try to insert some data into the table with some definitions like above with some NULL 'login' values or with too long 'id' integer I have no problems with inserting it. In this two cases I will insert it anyway. But in postgresql databases with similar table definitions I will not be able to insert such a data. Is there a way to restrict it hurder, that when I say that in this column in this table there can not be any NULL values? And I will not be able to insert any data into the table with NULL values? Regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
simplify query?
hi Sorry for this newbie-question: is it possible to simplifiy the following (working) query? SELECT * FROM mytable WHERE ((col1 LIKE '%test%') OR (col2 LIKE '%test%') OR (col3 LIKE 'test%')) AND (col5 = 'y' OR col6 = 'y' OR col7 = 'y') ORDER BY col1 Thanks for any suggestions! Reto Baudenbacher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
deleting old records from table without subquery
Hi, I'm having problems trying to construct a delete query from a table. Below is a scaled down version of the table host userdateid - mars john 27-6 1 pluto dave 27-6 2 venus jane 27-6 3 mars john 28-6 4 saturntom28-6 5 pluto dave 29-6 6 What I want to do is purge old records for each host from the table. If I use the query: SELECT max(date), host FROM table GROUP BY host; Then I can get the latest record produced for each host. There are never two records for a host produced on the same date. So basically I want to remove all records *other than* the latest records. If MySQL supported sub queries then this would be easy: DELETE from table where id not in (SELECT max(date) FROM table GROUP BY host) Is this something I'm just going to have to do client side? I figured I could run the query above to get all id's of records to keep and then form a long string of them i.e. keepString = (1, 4, 7, 9, 12, 15, 17 etc.) and then run (DELETE FROM table WHERE date NOT IN + keepString) . This seems a bit messy tho, and keepstring would contain over 100 id's if used. All ideas greatly appreciated __ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems POST-installation
Hi I am having problems POST-installation with MySQL. A bit about my setup: SUSE Linux 8.1 MySQL 4.0.13 (installed from tar ball) MySQL installed in /usr/local/mysql Everything on the installation worked fine. I then ran mysql_install_db I then changed ownership of everything in /usr/local/mysql to mysql I then started the server: mysqld_safe I then changed the root password to something nice. Everything is fine and I have some nice and happy mysqld processes. BUT when I try to connect: % mysql -u root -p ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) OK, I even know why it can't connect using that mysql.sock - because it DOESN'T EXIST!! However, /tmp/mysql.sock DOES exist. OK, so questions: 1) Why doesn't /var/lib/mysql/mysql.sock exist? (mysql user has all the right priveleges to that directory) 2) Why is my mysql.sock in /tmp/ (I don't want it there!) 3) How can i get mysql to put it's mysql.sock in /var/lib/mysql/ (or specify where to put it) ? Thanks in advance for all your help! By the way, the reason I am using the 4.0.13 tar ball is that I can't get the download SUSE rpms to work, and the version of mysql that came with my SUSE CDs doesn't work either! Oh joy! Thanks again :-D Michael Watson Head of Informatics Institute for Animal Health, Compton Laboratory, Compton, Newbury, Berkshire RG20 7NN UK Phone : +44 (0)1635 578411 ext. 2535 Mobile: +44 (0)7764 490236 E-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Full /tmp directory
Hi! Yesterday mysql created 5 big temp files. This resulted in a full /tmp directory. In normal condition, it is nothing in the /tmp directory. Do someone knows what files these are, and how to prevent mysql to create big tmp-files? -rw-rw1 mysqlmysql697434112 Jun 30 20:03 #sql343_2ed58a_0.MYD -rw-rw1 mysqlmysql1024 Jun 30 18:53 #sql343_2ed58a_0.MYI -rw-rw1 mysqlmysql569638912 Jun 30 20:05 #sql343_2ed59d_0.MYD -rw-rw1 mysqlmysql1024 Jun 30 18:53 #sql343_2ed59d_0.MYI -rw-rw1 mysqlmysql484048896 Jun 30 20:06 #sql343_2ed5c4_0.MYD -rw-rw1 mysqlmysql1024 Jun 30 18:54 #sql343_2ed5c4_0.MYI -rw-rw1 mysqlmysql403308544 Jun 30 20:07 #sql343_2ed5f6_0.MYD -rw-rw1 mysqlmysql1024 Jun 30 18:55 #sql343_2ed5f6_0.MYI -rw-rw1 mysqlmysql308109312 Jun 30 20:08 #sql343_2ed63d_0.MYD -rw-rw1 mysqlmysql1024 Jun 30 18:56 #sql343_2ed63d_0.MYI (RedHat 7.3 with rpm mysql 3.23.56-1.72) --- Lars Andre
Building DBD-mysql on HPUX 11.11
Hi, I am trying to build DBD-mysql-2.1012 perl and mysql database driver on HPUX 11.11 operating system. I am getting this error, if I say 'make'. Can you help me to resolve this. Mysql 3.23.42 and DBI 1.37 are installed on the machine. ipvbs:/tmp/DBD-mysql-2.1012make /bin/sh -c true /bin/sh -c true rm -f blib/arch/auto/DBD/mysql/mysql.sl LD_RUN_PATH=/opt/mysql/lib/mysql:/lib /opt/perl5/bin/perl myld ld -b -s -a shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.sl -L/opt/mysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm chmod 755 blib/arch/auto/DBD/mysql/mysql.sl chmod: can't access blib/arch/auto/DBD/mysql/mysql.sl *** Error exit code 1 Stop. Thanks and regards, Umesh
Re: Problems connecting to server
[EMAIL PROTECTED] wrote: Description: I have just installed MySQL 4.0.4 on Linux kernel 2.4.2-2 on a Hewlett-Packard Kayak machine. I ran the mysql_install_db script with no problems, but am unable to create a root password as directed by the script. I have started MySQL with ./bin/mysqld_safe as directed by the script, but when I try to create a root user with ./bin/mysqladmin -u root password 'thepword', I get: ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! This is the first install of MySQL on this server (and my first try at installing). Check where is mysql.sock is located and specify path to the socket file with --socket option of mysqladmin or add appropriate entry to the my.cnf file. I'm also wondering where you copy the support-files/mysql.server in Linux? Copy it to the /etc/rc.d/init.d: http://www.mysql.com/doc/en/Automatic_start.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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with privilege tables - IMPORTANT
Twibell, Cory L [EMAIL PROTECTED] wrote: I have the user table which contains user record | Host | User| Pass | Select...| --- |% || | N... | The db record is | Host | Db| User | Select...| -- | %| Test1 || 'Y'... | | %| Test2 || 'Y'... | All privileges are Y in the db table. When I try to do a MULTI table update like: update Test1 A, Test2 B set A.value = 'VALUE' where A.ID = B.ID; All I get is 'update not allowed for user (@localhost)'. When I changed the user table to allow the global update and select privilege, it worked. Is the multi table update correct for the privileges tables? I don't want the user to have global access, only db access. You show grants for user ''@'%', but according to error message you connect as ''@'localhost'; -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems POST-installation
michael watson (IAH-C) [EMAIL PROTECTED] wrote: I am having problems POST-installation with MySQL. A bit about my setup: SUSE Linux 8.1 MySQL 4.0.13 (installed from tar ball) MySQL installed in /usr/local/mysql Everything on the installation worked fine. I then ran mysql_install_db I then changed ownership of everything in /usr/local/mysql to mysql I then started the server: mysqld_safe I then changed the root password to something nice. Everything is fine and I have some nice and happy mysqld processes. BUT when I try to connect: % mysql -u root -p ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) OK, I even know why it can't connect using that mysql.sock - because it DOESN'T EXIST!! However, /tmp/mysql.sock DOES exist. OK, so questions: 1) Why doesn't /var/lib/mysql/mysql.sock exist? (mysql user has all the right priveleges to that directory) 2) Why is my mysql.sock in /tmp/ (I don't want it there!) as MySQL server was compiled .. 3) How can i get mysql to put it's mysql.sock in /var/lib/mysql/ (or specify where to put it) ? Add to the my.cnf [mysqld] socket=/var/lib/mysql/mysql.sock or you --socket option of mysqld -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: deleting old records from table without subquery
Rupert Stokoe [EMAIL PROTECTED] wrote: I'm having problems trying to construct a delete query from a table. Below is a scaled down version of the table host userdateid - mars john 27-6 1 pluto dave 27-6 2 venus jane 27-6 3 mars john 28-6 4 saturntom28-6 5 pluto dave 29-6 6 What I want to do is purge old records for each host from the table. If I use the query: SELECT max(date), host FROM table GROUP BY host; Then I can get the latest record produced for each host. There are never two records for a host produced on the same date. So basically I want to remove all records *other than* the latest records. If MySQL supported sub queries then this would be easy: DELETE from table where id not in (SELECT max(date) FROM table GROUP BY host) Is this something I'm just going to have to do client side? I figured I could run the query above to get all id's of records to keep and then form a long string of them i.e. keepString = (1, 4, 7, 9, 12, 15, 17 etc.) and then run (DELETE FROM table WHERE date NOT IN + keepString) . This seems a bit messy tho, and keepstring would contain over 100 id's if used. If you use 4.0.x you can retrieve max date into temporary table and then use DELETE with LEFT JOIN to remove records. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: restrictions?
Maciej Bobrowski [EMAIL PROTECTED] wrote: Sometimes I want to restrict the structure of my data. Let's say that I need to some records does not contain NULL values, or some numbers are not longer then 10 digits. But when I try to use login char(32)NOT NULL default 'tralala', or id bigint NOT NULL default 5000, and then try to insert some data into the table with some definitions like above with some NULL 'login' values or with too long 'id' integer I have no problems with inserting it. In this two cases I will insert it anyway. But in postgresql databases with similar table definitions I will not be able to insert such a data. Is there a way to restrict it hurder, that when I say that in this column in this table there can not be any NULL values? And I will not be able to insert any data into the table with NULL values? If you define column as NOT NULL and try to insert NULL, default value will be inserted. As to numaric columns, the best possible values will be inserted: http://www.mysql.com/doc/en/constraint_NOT_NULL.html -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: simplify query?
Reto Baudenbacher [EMAIL PROTECTED] wrote: hi Sorry for this newbie-question: is it possible to simplifiy the following (working) query? SELECT * FROM mytable WHERE ((col1 LIKE '%test%') OR (col2 LIKE '%test%') OR (col3 LIKE 'test%')) AND (col5 = 'y' OR col6 = 'y' OR col7 = 'y') ORDER BY col1 What do you mean 'simplifiy'? You can rewrite the above query using UNION instead of OR, but the new query will not be very simple, too. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Starting MySQL 4.0 ?
Peter Moscatt [EMAIL PROTECTED] wrote: I have just installed 'MySQL-server' and 'MySQL-client' onto a Mandrake 9.1 system. The two RPMs installed without error and running mysql from the shell was fine and did what was expected of it. I have now rebooted the system and when I go to the shell to issue the 'mysql' command I get the following error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Check if mysqld is running and where file mysql.sock is located. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
REGEXP in replace()?
I have a field where I want to remove non-alphanumeric characters at the end of the field. I thought of using a query like: UPDATE table SET field=REPLACE(field, ., ) where It does not seem possible to use regexes inside the replace() function. I have two questions on possible improvements of this query: 1. Can I expand the from_str (second parameter) in replace() to the collection of non-alphanumeric characters? 2. How can I ensure that only non-alphanumeric characters at the end of the string are removed, and not those at earlier positions in the string. Maybe someone has a imple solution? Thanks for any help, Piet Wesselman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied for User: root@127.0.0.1(Using password: NO)
For Mysql, 127.0.0.1 is not the same as localhost. Localhost refers to the socket file on the operating system, and is faster than 127.0.0.1. Use 'root'@'127.0.0.1' in your grant statements. Ola Ogunneye wrote: Please somebody help me. I have installed MySql 4.0.13 and it works up until I try to apply security settings to the root user at localhost. I see the mysql database and I check the privileges and there is no password for the roo user. But when I assign a password to make it secure, I can run phpmyadmin, but I cannot get into the database anymore. All I get is: MySql Said: Access Denied for user: [EMAIL PROTECTED] (Using password: NO) This situation has happened 3 times and I had to reinstall MySql and start from scratch. Can someone please point me in the right direction, this is my first try and it has been quite a serious learning experience. Thank you in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: load_file
Seth Redmond [EMAIL PROTECTED] wrote: sorry, should have said - I get the record created, but with a null value in the blob - as you would for a file larger than the max_allowed. but I've checked numerous times (and have gone up to longblob) and still can't load above around 1mb. I should also mention that it's running on the same machine, so I shouldn't be having any problems from the server. Are you sure that max_allowed_packet is set to 16M? What is the output of SHOW VARIABLES LIKE max_allowed_packet? On Friday, June 27, 2003, at 02:06 PM, [EMAIL PROTECTED] wrote: Seth Redmond [EMAIL PROTECTED] wrote: I've been having a few problems loading blobs via the LOAD_FILE function I've tried things along the lines of: UPDATE table SET binaryRecord=LOAD_FILE(/Users/shared/filename.mov) where refNo=1; It only seems to happen when loading something over 1-1.5mb, as I've been able to load smaller files no problem but can't do anything with files of around 4mb. I'm using mediumblob (and have tried long), max allowed packet is set at 16mb. The files are readable by all, and I have file permissions Did you get any error message or what? -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems POST-installation
michael watson (IAH-C) [EMAIL PROTECTED] wrote: Hi Victoria Thanks for your reply! However, I don't seem to have a my.cnf file? I have /etc/mysqlaccess.cnf - is that it? But that doesn't have anything that looks like [mysqld] socket=/var/lib/mysql/mysql.sock in it. Has my my.cnf file somehow gone missing? If so, how did that happen? You should create it by yourself. You can find examples of my.cnf (my-large.cnf, my-medium.cnf etc.) in the 'support-files' directory. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Temporary Table Issues
Phil Dowson [EMAIL PROTECTED] wrote: Very good question, I believe I do since it does work 90% of the time. Only occasionally it doesnt work, and thats why I need help In wich cases it doesn't work? We need repeatable test cases. - Original Message --- -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1999
Which Version of MySQL was used in 1999?
max_allowed_packet error
hello, I'm exporting a very big table from ACCESS to MySQL using ODBC. I was able to do it by increasing the value of the max_allowed_packet variable in mysql since otherwise ODBC lost the connection and I was getting an error. But the thing is I dropped the table for a test and now I'm not being able to export it back. Wehn I try exporting from ACCESS I get the error : (mysqld-4.013 -max-debug]Lost connection to MYSQL server during query (#2013) I don't understand why I'm getting this again even if I change the value of the max_allowed_packet!! Any help would be welcome. Thanks.
Re: 1999
On Tue, Jul 01, 2003 at 04:14:17PM +0200, Maunza Kater wrote: Which Version of MySQL was used in 1999? Looking at the MySQL Change History in the docs: - 3.22.7 went gamma in februari 1999 (some people would use it) - 3.22.19 was the first production release in march 1999 - 3.23.0 was the first alpha release in august 1999 (few people would use that) I see no dates for 3.21.x, but it should have been the production release in the beginning of 1999 and was probably supported for a while after 3.22.x was the production release in march. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
date format
today´s date: 2003-07-01 Hi there,,, I wrote down this statement select (current_date - 1 ) and the result was: (Currentdate -1) --- 20030700 when i write select (current_date ) I have: (Currentdate) --- 2003-07-01 but actually, I wanna a result like that select (current_date - 1 ) as result (Currentdate -1) --- 2003-06-30 can you help me, please?
RE: date format
mysql select date_sub(curdate(), interval 1 day) as wibble; ++ | wibble | ++ | 2003-06-30 | ++ 1 row in set (0.00 sec) -Original Message- From: Fabio Bernardo [mailto:[EMAIL PROTECTED] Sent: Tuesday 01 July 2003 15:32 To: Mysql (E-mail) Subject: date format today´s date: 2003-07-01 Hi there,,, I wrote down this statement select (current_date - 1 ) and the result was: (Currentdate -1) --- 20030700 when i write select (current_date ) I have: (Currentdate) --- 2003-07-01 but actually, I wanna a result like that select (current_date - 1 ) as result (Currentdate -1) --- 2003-06-30 can you help me, please? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: date format
On 1 Jul 2003 at 11:31, Fabio Bernardo wrote: select (current_date - 1 ) and the result was: (Currentdate -1) --- 20030700 Use this instead: SELECT CURRENT_DATE() - INTERVAL 1 DAY; The documentation for DATE_ADD() and other date and time functions is here: http://www.mysql.com/doc/en/Date_and_time_functions.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL List Archives Stats for June 2003
MySQL List Archives Stats June, 2003 Note: Up/Down % as compared with May, 2003 Posts: 2723 (Up 12%) Authors: 745 (Up 10%) Threads: 900 (Up 6%) Top 20 Contributors by Number of Posts Nils Valentin147 Paul DuBois 126 Becoming Digital 113 Mike Hillyer 89 Jeremy Zawodny72 Victoria Reznichenko 55 Egor Egorov 52 Roman Neuhauser 48 gerald_clark 44 Heikki Tuuri 34 Jay Blanchard 29 Bruce Feist 26 Mark Matthews 25 Don Read 25 Keith C. Ivey 20 Curtis Maurand20 Christensen, Dave 19 tlr7425 15 Primaria Falticeni15 Dathan Vance Pattishall 14 Top 20 Threads by Number of Posts RAID hardware suggestions/experience 26 mysql.sock doesn't exist 23 mysql query output get wrapped22 Best Pratices for mySQL Backups in Enterprise 18 mySQL GUIs17 Triggers 17 mysql ended error 16 Odd thing 15 Anyone had a chance to try an Opteron yet?14 Practice test 13 Which database? 13 Set no root password 12 Can we crypt passwords on MySQL 12 XML in MySQL 12 URGENT problem with mysql processes 12 Advanced Query Help (My brain hurts!) 12 SELECTing last occurences from a table11 I thought single UPDATE statements were atomic11 forming foreign keys 10 alter table blocks other tables! 10 Top 20 Search Terms by Number of Requests table 37 mysql 30 index 23 error 22 tables21 load 21 import20 file 19 foreign 18 innodb17 Blob 16 key 16 not 14 select13 mysqldump 13 insert13 data 12 windows 12 mysql.server 11 from 11 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Date query optimization
Hi folks, I do a considerable amount of queries based on a date, and or date range. I have not had much luck with optimizing these queries. In some cases I use a date field and others a datetime field. The following query searches through 34,000 + records, while specifiying the exact date searches through 9 records. 'ROWS: 9 SEARCHED explain select a.submitid,a.url,a.submitdate,a.name,a.company,a.address1,a.city,a.state,a.z ipcode,a.country,a.email,a.phone,a.keywords,a.title,a.description,a.submitte dby from submit as a inner join re_idx as b on a.submitid = b.submitid where a.submitdate = '2003-07-01'; ROWS: 34,000 + searched explain select a.submitid,a.url,a.submitdate,a.name,a.company,a.address1,a.city,a.state,a.z ipcode,a.country,a.email,a.phone,a.keywords,a.title,a.description,a.submitte dby from submit as a inner join re_idx as b on a.submitid = b.submitid where year(a.submitdate)=2003 and month(a.submitdate)=7 and dayofmonth(a.submitdate)=1; --and year(a.submitdate)=2003 and month(a.submitdate)=7 and dayofmonth(a.submitdate)15; Notice the 2nd where statement, this is how I typically do my date queries (and it is slow). This is because I might also be searching for a range of dates (as in the commented out and clause above). Is the to_days function faster than these date functions, or have any effect whatsoever? Thanks for the help. Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help with privilege tables - IMPORTANT
Egor, It says 'update command denied to user: 'any user i put here' for table 'test2' No matter what user/host combination I use I ALWAYS get this error. -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 5:13 AM To: [EMAIL PROTECTED] Subject: Re: Help with privilege tables - IMPORTANT Twibell, Cory L [EMAIL PROTECTED] wrote: I have the user table which contains user record | Host | User| Pass | Select...| --- |% || | N... | The db record is | Host | Db| User | Select...| -- | %| Test1 || 'Y'... | | %| Test2 || 'Y'... | All privileges are Y in the db table. When I try to do a MULTI table update like: update Test1 A, Test2 B set A.value = 'VALUE' where A.ID = B.ID; All I get is 'update not allowed for user (@localhost)'. When I changed the user table to allow the global update and select privilege, it worked. Is the multi table update correct for the privileges tables? I don't want the user to have global access, only db access. You show grants for user ''@'%', but according to error message you connect as ''@'localhost'; -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Date query optimization
On 1 Jul 2003 at 9:25, Karl J. Stubsjoen wrote: ROWS: 34,000 + searched explain select a.submitid,a.url,a.submitdate,a.name,a.company,a.address1,a.city,a.sta te,a.z ipcode,a.country,a.email,a.phone,a.keywords,a.title,a.description,a.su bmitte dby from submit as a inner join re_idx as b on a.submitid = b.submitid where year(a.submitdate)=2003 and month(a.submitdate)=7 and dayofmonth(a.submitdate)=1; --and year(a.submitdate)=2003 and month(a.submitdate)=7 and dayofmonth(a.submitdate)15; Notice the 2nd where statement, this is how I typically do my date queries (and it is slow). This is because I might also be searching for a range of dates (as in the commented out and clause above). The normal way to do a search for a range of dates would be ... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14'; Is that what you're looking for? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A quick help
Two databases data1 data2 data1 has table1 and data2 has table2 both the tables have uid field common I want to list out common uid's from table1 annd table2 Tried many commands as i understood from documentations but somewhere i m always wrong. thanks regards -- harsh http://www.cse.iitb.ac.in/~harsh -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
License?
The MySQL homepage says: 2. Free use for those who never copy, modify or distribute As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI approved license or not. More specifically: Modifying - You are allowed to modify MySQL Software source code any way you like. If you distribute the modified version, all changes, all interface code and all code that connects directly or indirectly to the interface code fall under GPL. Copying - You are allowed to copy MySQL binaries and source code, but when you do so, the copies will fall under the GPL license. What does internal distribution mean? Is it another thing than copying? Consider this example: A company has 2 database servers and want to install MySQL on both servers. Is MySQL free for the first server, but require a license for the second server? Or are MySQL free for both servers? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Date query optimization
Keith, The normal way to do a search for a range of dates would be ... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14'; Is that what you're looking for? submitdate happens to be a DATETIME field. Your suggested query doesn't pull any results. Must I convert the field first? But then is my query unoptimized? Should I consider storing date parts into my database; seperate column for year - month - date and (time parts..) Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL gets slower over time
HIdey Ho. I have a fairly large mysql database (a few million records) and queries run pretty damn fast. However, over time (say, over the course of a month), performance gets slower and slower. I am not sure why! I suspected a memory leak so i restarted mysql. No dice. Now, if I reboot the whole *server*, then performance jumps back up. I have a ton of RAM (3 gigs). But could it be that the server is using more and more RAM for a memory cache and thus giving less of it to mysql over time, thus making it go slower? This is my theory, but not sure why. Here is are some tops: First day: Mem: 3098984K av, 1159340K used, 1939644K free, 0K shrd,8168K buff Swap: 1052248K av, 0K used, 1052248K free 1068688K cached a week and a half later: Mem: 3098984K av, 1764340K used, 1334644K free, 0K shrd, 66416K buff Swap: 1052248K av, 0K used, 1052248K free 1585156K cached 40 days later: Mem: 3098984K av, 2487488K used, 611496K free, 0K shrd, 70360K buff Swap: 1052248K av, 0K used, 1052248K free 2274124K cached Seems the memory free keeps on getting lower. Also I did *not* copy my-huge.cnf to my.cnf. The server is a production machien and I didn't realize this later. I am thinking this might help my problem, but would like some feedback. - Steve
Re: MySQL gets slower over time
MySQL OS version and hardware ? Jerry - Original Message - From: Steve Quezadas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 6:36 PM Subject: MySQL gets slower over time HIdey Ho. I have a fairly large mysql database (a few million records) and queries run pretty damn fast. However, over time (say, over the course of a month), performance gets slower and slower. I am not sure why! I suspected a memory leak so i restarted mysql. No dice. Now, if I reboot the whole *server*, then performance jumps back up. I have a ton of RAM (3 gigs). But could it be that the server is using more and more RAM for a memory cache and thus giving less of it to mysql over time, thus making it go slower? This is my theory, but not sure why. Here is are some tops: First day: Mem: 3098984K av, 1159340K used, 1939644K free, 0K shrd,8168K buff Swap: 1052248K av, 0K used, 1052248K free 1068688K cached a week and a half later: Mem: 3098984K av, 1764340K used, 1334644K free, 0K shrd, 66416K buff Swap: 1052248K av, 0K used, 1052248K free 1585156K cached 40 days later: Mem: 3098984K av, 2487488K used, 611496K free, 0K shrd, 70360K buff Swap: 1052248K av, 0K used, 1052248K free 2274124K cached Seems the memory free keeps on getting lower. Also I did *not* copy my-huge.cnf to my.cnf. The server is a production machien and I didn't realize this later. I am thinking this might help my problem, but would like some feedback. - Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Date query optimization
On 1 Jul 2003 at 10:28, Karl J. Stubsjoen wrote: The normal way to do a search for a range of dates would be ... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14'; Is that what you're looking for? submitdate happens to be a DATETIME field. Your suggested query doesn't pull any results. If it's a DATETIME field, you'll want something like ... WHERE a.submitdate BETWEEN '2003-07-01 00:00:00' AND '2003-07-14 23:59:59'; or ... WHERE a.submitdate = '2003-07-01 00:00:00' AND a.submitdate '2003-07-15 00:00:00'; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: max_allowed_packet error
Do you have a waittimeout set in you're my.cnf file? If so mysql would of forced closed a connection that it determines was inactive for waittimeout seconds. ---Original Message- --From: Tina Motaye [mailto:[EMAIL PROTECTED] --Sent: Tuesday, July 01, 2003 5:28 AM --To: [EMAIL PROTECTED] --Subject: max_allowed_packet error -- --hello, -- --I'm exporting a very big table from ACCESS to MySQL using ODBC. -- --I was able to do it by increasing the value of the max_allowed_packet --variable in mysql since otherwise ODBC lost the connection and I was --getting an error. --But the thing is I dropped the table for a test and now I'm not being --able to export it back. -- --Wehn I try exporting from ACCESS I get the error : --(mysqld-4.013 -max-debug]Lost connection to MYSQL server during query --(#2013) -- --I don't understand why I'm getting this again even if I change the value --of the max_allowed_packet!! -- --Any help would be welcome. -- --Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL gets slower over time
Run the Analyze table command. It will recalculate the Cardinality of a key structure. ---Original Message- --From: Steve Quezadas [mailto:[EMAIL PROTECTED] --Sent: Tuesday, July 01, 2003 10:37 AM --To: [EMAIL PROTECTED] --Subject: MySQL gets slower over time -- --HIdey Ho. -- --I have a fairly large mysql database (a few million records) and queries --run pretty damn fast. However, over time (say, over the course of a --month), performance gets slower and slower. I am not sure why! I --suspected a memory leak so i restarted mysql. No dice. Now, if I reboot --the whole *server*, then performance jumps back up. I have a ton of RAM --(3 gigs). But could it be that the server is using more and more RAM for --a memory cache and thus giving less of it to mysql over time, thus making --it go slower? This is my theory, but not sure why. Here is are some tops: -- --First day: --Mem: 3098984K av, 1159340K used, 1939644K free, 0K shrd, 8168K --buff --Swap: 1052248K av, 0K used, 1052248K free 1068688K --cached -- --a week and a half later: --Mem: 3098984K av, 1764340K used, 1334644K free, 0K shrd, 66416K --buff --Swap: 1052248K av, 0K used, 1052248K free 1585156K --cached -- --40 days later: --Mem: 3098984K av, 2487488K used, 611496K free, 0K shrd, 70360K --buff --Swap: 1052248K av, 0K used, 1052248K free 2274124K --cached -- --Seems the memory free keeps on getting lower. Also I did *not* copy --my-huge.cnf to my.cnf. The server is a production machien and I --didn't realize this later. I am thinking this might help my problem, but --would like some feedback. -- --- Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please Help ..working with MySql with a C compiler
Hi I am trying to compile a small C program that suppose to connect,create Database,tables. It compiles fine with no errors but at execution the function mysql_init(NULL) wich is suppose to return the pointer returns nothing at all ..so i cannot connect to the server.(I also added the library libmysqlclient ) I tried the same code but with a C++ compiler and it worked fine ...anyone has any idea what is the problem between MySQL and C ??? Thanks a lot PLEASE HELP ! __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2013:Lost connection to MySQL server
Hi folks: I have the following problem, when I try to connect to my DB servicios I get connected succesfully, but when I try to access certain tables I get the error ERROR 2013: Lost connection to MySQL server during query but only with those certain tables, to be more specific there's only 2 tables that i can't access, I get that error, the other ones works fine. Any ideas or suggestions. Thanxs in advanced. Best regards _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013:Lost connection to MySQL server
Hi, On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote: I have the following problem, when I try to connect to my DB servicios I get connected succesfully, but when I try to access certain tables I get the error ERROR 2013: Lost connection to MySQL server during query but only with those certain tables, to be more specific there's only 2 tables that i can't access, I get that error, the other ones works fine. Which version, which OS? Any ideas or suggestions. Maybe mysqld crashes? It restarts automatically, on unices at least. Check the mysql error log to find out if it crashed. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Delete from InnoDB
Hi all. I did a delete query on an InnoDB table where items were older than a certain date. That worked fine, and it told me that some 30,000 objects had been deleted. i did a commit, and then decided to delete a few more by changing the date parameter. Now the query just hangs, and when I do a show table status, the number of rows constantly changes even after I killed off the query and did more commits. My question is what happened and what can I do to fix this? Right now I can't access any data from this table. Thanks, Taylor Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you *
Anyone running Windows 2000?
Is anyone out there running mysql with Apache and php on windows 2000? If you are out there, please respond and hopefully you may be able to help me. I see that most of the posts are geared towards unix/solaris. I am a newbie that needs help. Thanks
Re: Anyone running Windows 2000?
running mysql 3.23.56-nt and apache 1.23.-don't-know-exactly on windows 2000 professional sp3 (going to upgrade to sp4 soon) - no problems by now what's your question? :) ··· yves at unclassified.de -Ursprüngliche Nachricht- Von: Ola Ogunneye [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Dienstag, 1. Juli 2003 21:39 Betreff: Anyone running Windows 2000? Is anyone out there running mysql with Apache and php on windows 2000? If you are out there, please respond and hopefully you may be able to help me. I see that most of the posts are geared towards unix/solaris. I am a newbie that needs help. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Delete from InnoDB
Taylor, SHOW TABLE STATUS reports an estimate of the number of rows. What do you mean that you cannot access any data from the table? All SELECTs hang? What OS, what MySQL version? What does SHOW INNODB STATUS\G print? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Taylor Lewick [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 01, 2003 10:32 PM Subject: Delete from InnoDB --=_154B26A2.4A2A23E3 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi all. I did a delete query on an InnoDB table where items were older t= han a certain date. That worked fine, and it told me that some 30,000 objects had been delete= d. i did a commit, and then decided to delete a few more by changing the dat= e parameter. Now the query just hangs, and when I do a show table status, the number o= f rows constantly changes even after I killed off the query and did more = commits. =20 My question is what happened and what can I do to fix this? Right now I = can't access any data from this table. Thanks, Taylor =09 Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that=20 you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * --=_154B26A2.4A2A23E3-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Different order than groupping
Hello. I have this simple query: SELECT sum(a), b, c FROM table WHERE statement GROUP BY b, c HAVING sum(a) 0 The problem is that I was the results to be in descending order by sum(a). I know that GROUP BY works as an ORDER BY at the same time, but I cannot use the group function into the GROUP BY statement...! What can I do? Thanks in advance! Themis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Different order than groupping
[snip] SELECT sum(a), b, c FROM table WHERE statement GROUP BY b, c HAVING sum(a) 0 The problem is that I was the results to be in descending order by sum(a). I know that GROUP BY works as an ORDER BY at the same time, but I cannot use the group function into the GROUP BY statement...! What can I do? [/snip] SELECT sum(a) as a_total, b, c FROM table WHERE statement GROUP BY b, c ORDER BY a_total HAVING sum(a) 0 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication problem: Slave not starting
I've setup my my.cnf file on the slave as: [mysql.server] user=mysql basedir=/var/lib socket=/var/lib/mysql/mysql.sock server-id=2 master-host=206.xxx.xxx.xxx master-user=replicateuser master-password=replicatepassword Master.info is: tux-bin.001 3109 206.xxx.xxx.xxx replicateuser replicatepassword 3306 60 Show slave status indicates NO under Slave_running, and I get: mysql slave start; ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO Server has been restarted. Version is 3.23.56 Any ideas? Andrew Instead of trying to build newer and bigger weapons of destruction, we should be thinking about getting more use out of the ones we already have. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Delete from InnoDB
Taylor, you are running a very old alpha version of MySQL. Lots of bugs have been fixed since. Please upgrade to 4.0.13, or if you use replication, then 4.0.12 is a safer choice. Regards, Heikki - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 11:04 PM Subject: Re: Delete from InnoDB Heikki, thanks for the quick response. I am on HP-UX 11.00 with MySQL version 4.0.1 Yes all selects hang. On other tables they work. When I used to do a select count(*) from this_table I would get about a 3 second response and 160,000 as the count. Now it just hangs. I tried to do show innodb status and I received a syntax error. Taylor Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with Mac OS X install
Hi all, I'm new to this list so forgive me if I tear open old wounds..;-) I installed MySQL 4.0.13 on my mac with OS X 10.2.6 I followed the instructions onthe mysql.com site. Everything seems to be in order until I have to do : /usr/local/mysql/bin/mysqladmin -u root password password I run this command as root user and substitute password for a password of my choice. I get my original prompt back without any errors or warnings. Now the docs say I have to do : /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password This command is run as root user. I replace password with the previously mentioned password of my choice. Now I get : /usr/local/mysql/bin/mysqladmin: connect to server at 'Warp-into-Chaos.local.' failed error: 'Host '192.168.1.4' is not allowed to connect to this MySQL server' Warp-into-Chaos.local. = my computer 192.168.1.4 = my computers IP address. I even tried to replace 'hostname' with localhost. And I get : /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Then I replaced localhost with 172.0.0.1 and I got : /usr/local/mysql/bin/mysqladmin: connect to server at '172.0.0.1' failed error: 'Can't connect to MySQL server on '172.0.0.1' (60)' Check that mysqld is running on 172.0.0.1 and that the port is 3306. You can check this by doing 'telnet 172.0.0.1 3306' I checked to see if mysqld was running and it was/is. Can somebody tell me what is going on here and how I can solve this? Kind Regards Werner van Mook
Re: Anyone running Windows 2000?
On Tuesday 01 July 2003 9:39 pm, Ola Ogunneye wrote: Is anyone out there running mysql with Apache and php on windows 2000? If you are out there, please respond and hopefully you may be able to help me. I see that most of the posts are geared towards unix/solaris. I am a newbie that needs help. Thanks yep apache 2 mysql 4 and php on 2000 server advanced edition. works fine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem with Mac OS X install
everything you need to know and do is here: http://www.entropy.ch/software/macosx/mysql/ On Tuesday, July 1, 2003, at 04:30 PM, Werner van Mook wrote: Hi all, I'm new to this list so forgive me if I tear open old wounds..;-) I installed MySQL 4.0.13 on my mac with OS X 10.2.6 I followed the instructions onthe mysql.com site. Everything seems to be in order until I have to do : /usr/local/mysql/bin/mysqladmin -u root password password I run this command as root user and substitute password for a password of my choice. I get my original prompt back without any errors or warnings. Now the docs say I have to do : /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password This command is run as root user. I replace password with the previously mentioned password of my choice. Now I get : /usr/local/mysql/bin/mysqladmin: connect to server at 'Warp-into-Chaos.local.' failed error: 'Host '192.168.1.4' is not allowed to connect to this MySQL server' Warp-into-Chaos.local. = my computer 192.168.1.4 = my computers IP address. I even tried to replace 'hostname' with localhost. And I get : /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Then I replaced localhost with 172.0.0.1 and I got : /usr/local/mysql/bin/mysqladmin: connect to server at '172.0.0.1' failed error: 'Can't connect to MySQL server on '172.0.0.1' (60)' Check that mysqld is running on 172.0.0.1 and that the port is 3306. You can check this by doing 'telnet 172.0.0.1 3306' I checked to see if mysqld was running and it was/is. Can somebody tell me what is going on here and how I can solve this? Kind Regards Werner van Mook -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013:Lost connection to MySQL server
The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access those tables but just after I rebooted my PC I couldn't access the 2 tables. The log files has the following: 030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file dict0load.c line 677 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. thd=0x8711eb8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80741ea 0x8286058 0x81193b5 0x8108df8 0x80cf9c9 0x80c9bf4 0x8096a76 0x809262b 0x8091ccf 0x8092989 0x80e1d18 0x807fdd6 0x8082638 0x807dd5d 0x8083b6e 0x807cf0f 0x828380c 0x82b6f1a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x87170a8 = show create table PEDIDOS thd-thread_id=1 I have 500MB in ram. Greetings From: Fred van Engen [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Tue, 1 Jul 2003 21:23:41 +0200 Hi, On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote: I have the following problem, when I try to connect to my DB servicios I get connected succesfully, but when I try to access certain tables I get the error ERROR 2013: Lost connection to MySQL server during query but only with those certain tables, to be more specific there's only 2 tables that i can't access, I get that error, the other ones works fine. Which version, which OS? Any ideas or suggestions. Maybe mysqld crashes? It restarts automatically, on unices at least. Check the mysql error log to find out if it crashed. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013:Lost connection to MySQL server
Miguel, what exact MySQL version you are running? Have you created FOREIGN KEY constraints to those tables? Have you downgraded to a lower MySQL version? Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:11 AM Subject: Re: ERROR 2013:Lost connection to MySQL server The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access those tables but just after I rebooted my PC I couldn't access the 2 tables. The log files has the following: 030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file dict0load.c line 677 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. thd=0x8711eb8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80741ea 0x8286058 0x81193b5 0x8108df8 0x80cf9c9 0x80c9bf4 0x8096a76 0x809262b 0x8091ccf 0x8092989 0x80e1d18 0x807fdd6 0x8082638 0x807dd5d 0x8083b6e 0x807cf0f 0x828380c 0x82b6f1a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x87170a8 = show create table PEDIDOS thd-thread_id=1 I have 500MB in ram. Greetings From: Fred van Engen [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Tue, 1 Jul 2003 21:23:41 +0200 Hi, On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote: I have the following problem, when I try to connect to my DB servicios I get connected succesfully, but when I try to access certain tables I get the error ERROR 2013: Lost connection to MySQL server during query but only with those certain tables, to be more specific there's only 2 tables that i can't access, I get that error, the other ones works fine. Which version, which OS? Any ideas or suggestions. Maybe mysqld crashes? It restarts automatically, on unices at least. Check the mysql error log to find out if it crashed. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands _ Charla con tus amigos en lnea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013:Lost connection to MySQL server
On Tue, Jul 01, 2003 at 04:09:26PM -0500, Miguel Perez wrote: The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access those tables but just after I rebooted my PC I couldn't access the 2 tables. The log files has the following: 030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file dict0load.c line 677 You don't write which exact version you use, but the changelist in the MySQL documentation mentions a fix for an assertion in dict0load.c in version MySQL/InnoDB-4.0.13. mysql select version(); If you use an earlier version than 4.0.13, you could try to upgrade. InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] Well, you did that now :) I don't use InnoDB currently, so maybe someone else will respond. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013:Lost connection to MySQL server
I am running the 4.0.12 version For those tables I don't have FOREIGN KEYS here is the table desc. CREATE TABLE CLIENTE ( FINGCIOID smallint(6) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FIOCUID smallint(6) NOT NULL default '0', FCCTENOMBRE char(18) NOT NULL default '', FCCTEAPATERNO char(18) NOT NULL default '', FCCTEAMATERNO char(18) NOT NULL default '', FCCTEDIRCALLE char(25) NOT NULL default '', FCCTEDIRNOEXT char(5) NOT NULL default '', FCCTEDIRNOINT char(5) NOT NULL default '', FCCTECP char(5) NOT NULL default '', FCCTECOLONIA char(65) NOT NULL default '', FCCTESEXO char(1) NOT NULL default '', FCCTETEL char(15) NOT NULL default '', FCCTERFC char(14) NOT NULL default '', FCCTEFISMOR char(2) NOT NULL default '', FITDAATIENDE smallint(6) NOT NULL default '0', FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00', FLCTEECO smallint(6) NOT NULL default '0', FIEDOCIVIL smallint(6) NOT NULL default '0', FNLINEACRED decimal(8,2) NOT NULL default '0.00', FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00', FCNOCOBRADOR char(6) NOT NULL default '', FITRANNO int(11) NOT NULL default '0', KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA) ) TYPE=InnoDB; CREATE TABLE PEDIDO ( FISUCURSAL int(11) NOT NULL default '0', FINOPEDIDO int(11) NOT NULL default '0', FINGCIOID smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FCEMPNO char(6) NOT NULL default '', FITIPOVENTA smallint(6) NOT NULL default '0', FDPEDFEC datetime NOT NULL default '-00-00 00:00:00', FNPEDTOTAL decimal(12,2) NOT NULL default '0.00', FIPEDFACT int(11) NOT NULL default '0', FDFECFACT datetime NOT NULL default '-00-00 00:00:00', FIPEDSTAT smallint(6) NOT NULL default '0', FCUSERID char(10) NOT NULL default '', FCWS char(10) NOT NULL default '', FDFECSURT datetime NOT NULL default '-00-00 00:00:00', FNPEDSALDO decimal(12,2) NOT NULL default '0.00', FCFOLIOPARAM int(11) NOT NULL default '0', FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00', FIDIASSERV smallint(6) NOT NULL default '0' ) TYPE=InnoDB; And I haven't tried to downgrade my version. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Wed, 2 Jul 2003 00:35:09 +0300 Miguel, what exact MySQL version you are running? Have you created FOREIGN KEY constraints to those tables? Have you downgraded to a lower MySQL version? Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:11 AM Subject: Re: ERROR 2013:Lost connection to MySQL server The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access those tables but just after I rebooted my PC I couldn't access the 2 tables. The log files has the following: 030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file dict0load.c line 677 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. thd=0x8711eb8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80741ea 0x8286058 0x81193b5 0x8108df8 0x80cf9c9 0x80c9bf4 0x8096a76 0x809262b 0x8091ccf 0x8092989 0x80e1d18 0x807fdd6 0x8082638 0x807dd5d 0x8083b6e 0x807cf0f 0x828380c 0x82b6f1a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x87170a8 = show create table PEDIDOS thd-thread_id=1 I have 500MB in ram. Greetings From: Fred van Engen [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Tue, 1 Jul 2003 21:23:41 +0200 Hi, On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote: I
Re: ERROR 2013:Lost connection to MySQL server
Miguel, the failing assertion is in dict_load_table(): ut_a(DB_SUCCESS == dict_load_foreigns(table-name)); Are you sure you do not have foreign keys which REFERENCE those tables? 4.0.13 has better diagnostics. Please upgrade to it if you are not using MySQL replication. Fixed a bug: if you dropped a table to which there was a FOREIGN KEY reference, and later created the same table with non-matching column types, InnoDB could assert in dict0load.c, in function dict_load_table. Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 12:47 AM Subject: Re: ERROR 2013:Lost connection to MySQL server I am running the 4.0.12 version For those tables I don't have FOREIGN KEYS here is the table desc. CREATE TABLE CLIENTE ( FINGCIOID smallint(6) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FIOCUID smallint(6) NOT NULL default '0', FCCTENOMBRE char(18) NOT NULL default '', FCCTEAPATERNO char(18) NOT NULL default '', FCCTEAMATERNO char(18) NOT NULL default '', FCCTEDIRCALLE char(25) NOT NULL default '', FCCTEDIRNOEXT char(5) NOT NULL default '', FCCTEDIRNOINT char(5) NOT NULL default '', FCCTECP char(5) NOT NULL default '', FCCTECOLONIA char(65) NOT NULL default '', FCCTESEXO char(1) NOT NULL default '', FCCTETEL char(15) NOT NULL default '', FCCTERFC char(14) NOT NULL default '', FCCTEFISMOR char(2) NOT NULL default '', FITDAATIENDE smallint(6) NOT NULL default '0', FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00', FLCTEECO smallint(6) NOT NULL default '0', FIEDOCIVIL smallint(6) NOT NULL default '0', FNLINEACRED decimal(8,2) NOT NULL default '0.00', FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00', FCNOCOBRADOR char(6) NOT NULL default '', FITRANNO int(11) NOT NULL default '0', KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA) ) TYPE=InnoDB; CREATE TABLE PEDIDO ( FISUCURSAL int(11) NOT NULL default '0', FINOPEDIDO int(11) NOT NULL default '0', FINGCIOID smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FCEMPNO char(6) NOT NULL default '', FITIPOVENTA smallint(6) NOT NULL default '0', FDPEDFEC datetime NOT NULL default '-00-00 00:00:00', FNPEDTOTAL decimal(12,2) NOT NULL default '0.00', FIPEDFACT int(11) NOT NULL default '0', FDFECFACT datetime NOT NULL default '-00-00 00:00:00', FIPEDSTAT smallint(6) NOT NULL default '0', FCUSERID char(10) NOT NULL default '', FCWS char(10) NOT NULL default '', FDFECSURT datetime NOT NULL default '-00-00 00:00:00', FNPEDSALDO decimal(12,2) NOT NULL default '0.00', FCFOLIOPARAM int(11) NOT NULL default '0', FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00', FIDIASSERV smallint(6) NOT NULL default '0' ) TYPE=InnoDB; And I haven't tried to downgrade my version. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Wed, 2 Jul 2003 00:35:09 +0300 Miguel, what exact MySQL version you are running? Have you created FOREIGN KEY constraints to those tables? Have you downgraded to a lower MySQL version? Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:11 AM Subject: Re: ERROR 2013:Lost connection to MySQL server The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access those tables but just after I rebooted my PC I couldn't access the 2 tables. The log files has the following: 030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file dict0load.c line 677 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. thd=0x8711eb8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80741ea 0x8286058 0x81193b5 0x8108df8
Re: ERROR 2013:Lost connection to MySQL server
Heikki: The only thing that I did with those tables is that I renamed both of them. And I didn't drop anything. Do you think that the renamed thing did affect my tables?.. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Wed, 2 Jul 2003 00:55:38 +0300 Miguel, the failing assertion is in dict_load_table(): ut_a(DB_SUCCESS == dict_load_foreigns(table-name)); Are you sure you do not have foreign keys which REFERENCE those tables? 4.0.13 has better diagnostics. Please upgrade to it if you are not using MySQL replication. Fixed a bug: if you dropped a table to which there was a FOREIGN KEY reference, and later created the same table with non-matching column types, InnoDB could assert in dict0load.c, in function dict_load_table. Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 12:47 AM Subject: Re: ERROR 2013:Lost connection to MySQL server I am running the 4.0.12 version For those tables I don't have FOREIGN KEYS here is the table desc. CREATE TABLE CLIENTE ( FINGCIOID smallint(6) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FIOCUID smallint(6) NOT NULL default '0', FCCTENOMBRE char(18) NOT NULL default '', FCCTEAPATERNO char(18) NOT NULL default '', FCCTEAMATERNO char(18) NOT NULL default '', FCCTEDIRCALLE char(25) NOT NULL default '', FCCTEDIRNOEXT char(5) NOT NULL default '', FCCTEDIRNOINT char(5) NOT NULL default '', FCCTECP char(5) NOT NULL default '', FCCTECOLONIA char(65) NOT NULL default '', FCCTESEXO char(1) NOT NULL default '', FCCTETEL char(15) NOT NULL default '', FCCTERFC char(14) NOT NULL default '', FCCTEFISMOR char(2) NOT NULL default '', FITDAATIENDE smallint(6) NOT NULL default '0', FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00', FLCTEECO smallint(6) NOT NULL default '0', FIEDOCIVIL smallint(6) NOT NULL default '0', FNLINEACRED decimal(8,2) NOT NULL default '0.00', FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00', FCNOCOBRADOR char(6) NOT NULL default '', FITRANNO int(11) NOT NULL default '0', KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA) ) TYPE=InnoDB; CREATE TABLE PEDIDO ( FISUCURSAL int(11) NOT NULL default '0', FINOPEDIDO int(11) NOT NULL default '0', FINGCIOID smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FCEMPNO char(6) NOT NULL default '', FITIPOVENTA smallint(6) NOT NULL default '0', FDPEDFEC datetime NOT NULL default '-00-00 00:00:00', FNPEDTOTAL decimal(12,2) NOT NULL default '0.00', FIPEDFACT int(11) NOT NULL default '0', FDFECFACT datetime NOT NULL default '-00-00 00:00:00', FIPEDSTAT smallint(6) NOT NULL default '0', FCUSERID char(10) NOT NULL default '', FCWS char(10) NOT NULL default '', FDFECSURT datetime NOT NULL default '-00-00 00:00:00', FNPEDSALDO decimal(12,2) NOT NULL default '0.00', FCFOLIOPARAM int(11) NOT NULL default '0', FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00', FIDIASSERV smallint(6) NOT NULL default '0' ) TYPE=InnoDB; And I haven't tried to downgrade my version. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Wed, 2 Jul 2003 00:35:09 +0300 Miguel, what exact MySQL version you are running? Have you created FOREIGN KEY constraints to those tables? Have you downgraded to a lower MySQL version? Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:11 AM Subject: Re: ERROR 2013:Lost connection to MySQL server The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access those tables but just after I rebooted my PC I couldn't access the 2 tables. The log files has the following: 030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file dict0load.c line 677 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may
Re: ERROR 2013:Lost connection to MySQL server
Miguel, best to upgrade to 4.0.13 because it has better diagnostics. Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 1:03 AM Subject: Re: ERROR 2013:Lost connection to MySQL server Heikki: The only thing that I did with those tables is that I renamed both of them. And I didn't drop anything. Do you think that the renamed thing did affect my tables?.. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Wed, 2 Jul 2003 00:55:38 +0300 Miguel, the failing assertion is in dict_load_table(): ut_a(DB_SUCCESS == dict_load_foreigns(table-name)); Are you sure you do not have foreign keys which REFERENCE those tables? 4.0.13 has better diagnostics. Please upgrade to it if you are not using MySQL replication. Fixed a bug: if you dropped a table to which there was a FOREIGN KEY reference, and later created the same table with non-matching column types, InnoDB could assert in dict0load.c, in function dict_load_table. Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 12:47 AM Subject: Re: ERROR 2013:Lost connection to MySQL server I am running the 4.0.12 version For those tables I don't have FOREIGN KEYS here is the table desc. CREATE TABLE CLIENTE ( FINGCIOID smallint(6) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FIOCUID smallint(6) NOT NULL default '0', FCCTENOMBRE char(18) NOT NULL default '', FCCTEAPATERNO char(18) NOT NULL default '', FCCTEAMATERNO char(18) NOT NULL default '', FCCTEDIRCALLE char(25) NOT NULL default '', FCCTEDIRNOEXT char(5) NOT NULL default '', FCCTEDIRNOINT char(5) NOT NULL default '', FCCTECP char(5) NOT NULL default '', FCCTECOLONIA char(65) NOT NULL default '', FCCTESEXO char(1) NOT NULL default '', FCCTETEL char(15) NOT NULL default '', FCCTERFC char(14) NOT NULL default '', FCCTEFISMOR char(2) NOT NULL default '', FITDAATIENDE smallint(6) NOT NULL default '0', FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00', FLCTEECO smallint(6) NOT NULL default '0', FIEDOCIVIL smallint(6) NOT NULL default '0', FNLINEACRED decimal(8,2) NOT NULL default '0.00', FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00', FCNOCOBRADOR char(6) NOT NULL default '', FITRANNO int(11) NOT NULL default '0', KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA) ) TYPE=InnoDB; CREATE TABLE PEDIDO ( FISUCURSAL int(11) NOT NULL default '0', FINOPEDIDO int(11) NOT NULL default '0', FINGCIOID smallint(6) NOT NULL default '0', FICTEID int(11) NOT NULL default '0', FINOTIENDA smallint(6) NOT NULL default '0', FIDIGITOVER smallint(6) NOT NULL default '0', FCEMPNO char(6) NOT NULL default '', FITIPOVENTA smallint(6) NOT NULL default '0', FDPEDFEC datetime NOT NULL default '-00-00 00:00:00', FNPEDTOTAL decimal(12,2) NOT NULL default '0.00', FIPEDFACT int(11) NOT NULL default '0', FDFECFACT datetime NOT NULL default '-00-00 00:00:00', FIPEDSTAT smallint(6) NOT NULL default '0', FCUSERID char(10) NOT NULL default '', FCWS char(10) NOT NULL default '', FDFECSURT datetime NOT NULL default '-00-00 00:00:00', FNPEDSALDO decimal(12,2) NOT NULL default '0.00', FCFOLIOPARAM int(11) NOT NULL default '0', FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00', FIDIASSERV smallint(6) NOT NULL default '0' ) TYPE=InnoDB; And I haven't tried to downgrade my version. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Wed, 2 Jul 2003 00:35:09 +0300 Miguel, what exact MySQL version you are running? Have you created FOREIGN KEY constraints to those tables? Have you downgraded to a lower MySQL version? Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:11 AM Subject: Re: ERROR 2013:Lost connection to MySQL server The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access those tables but just after I rebooted my PC I couldn't access the 2 tables. The log files has the following: 030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file dict0load.c line 677 InnoDB: We intentionally
Re: ERROR 2013:Lost connection to MySQL server
On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote: ... 4.0.13 has better diagnostics. Please upgrade to it if you are not using MySQL replication. Is there something wrong with 4.0.13's replication, or does it not replicate properly with 4.0.12? --Pete -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013:Lost connection to MySQL server
Pete, INSERT ... SELECT ... does not replicate properly with AUTO_INCREMENTs. Regards, Heikki - Original Message - From: Pete Harlan [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 1:10 AM Subject: Re: ERROR 2013:Lost connection to MySQL server On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote: ... 4.0.13 has better diagnostics. Please upgrade to it if you are not using MySQL replication. Is there something wrong with 4.0.13's replication, or does it not replicate properly with 4.0.12? --Pete -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone running Windows 2000?
The only Windows webserver that I never had security problems with was running apache, not iis. Curtis running mysql 3.23.56-nt and apache 1.23.-don't-know-exactly on windows 2000 professional sp3 (going to upgrade to sp4 soon) - no problems by now what's your question? :) ··· yves at unclassified.de -Ursprüngliche Nachricht- Von: Ola Ogunneye [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Dienstag, 1. Juli 2003 21:39 Betreff: Anyone running Windows 2000? Is anyone out there running mysql with Apache and php on windows 2000? If you are out there, please respond and hopefully you may be able to help me. I see that most of the posts are geared towards unix/solaris. I am a newbie that needs help. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone running Windows 2000?
Ola Ogunneye wrote: Is anyone out there running mysql with Apache and php on windows 2000? Yes: PHP 4.3.2 with Apache 2.0.46. What's your problem? Peter. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
defunct mysql threads
Hello, I am running the binary mysql 4.0.13 pclinux i686 with a linux 2.4.19 kernel. I have the problem that every time a client connects to the server and then exits, a defunct thread is left behind. Eventually the system prevents any further threads from being created. Even a simple command such as : bin/mysql mysql -e Select * from user will add the following to the log : 030701 13:11:28 16 Connect [EMAIL PROTECTED] on mysql 16 Query Select * from user 16 Quit and the error log remains unchanged, but there is another defunct mysqld process. The output of ps looks as follows UIDPID PPID C STIME TTY TIME CMD mysql 1650 1631 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1652 1650 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1653 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1654 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1655 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1656 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1657 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1658 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1659 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1660 1652 0 12:16 ttyp000:00:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cn mysql 1664 1652 0 12:16 ttyp000:00:00 [mysqld defunct] mysql 1666 1652 0 12:17 ttyp000:00:00 [mysqld defunct] mysql 1718 1652 0 12:24 ttyp000:00:00 [mysqld defunct] mysql 1994 1652 0 13:11 ttyp000:00:00 [mysqld defunct] mysql 2005 1652 0 13:20 ttyp000:00:00 [mysqld defunct] Any help would be greatly appreciated, Joshua Shapiro -- - - Service Observer * Canada-France-Hawaii Telescope - - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem with Mac OS X install
I think you have some slight errors in your connection line: Werner van Mook wrote: /usr/local/mysql/bin/mysqladmin -u root password password should be: /usr/local/mysql/bin/mysqladmin -u root --password=password /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password should be /usr/local/mysql/bin/mysqladmin -u root -h localhost --password=password Then I replaced localhost with 172.0.0.1 and I got : localhost's IP address is 127.0.0.1, so this should be: /usr/local/mysql/bin/mysqladmin -u root -h 127.0.0.1 --password=password Also, you're running mysqladmin with no commands, which will just output the help pages. Do you mean to be running the mysql command line client to interact with the mysqld server? If so replace mysqladmin in all of the above with mysql --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Possible solution to a simple newbie problem of JOINs
My newbie problem is solved and it may help other newbies if I share it. The idea is to take two or more tables and combine their data into one table that you can query. Each of the source tables may only have one or two columns of overlap. You want records (rows) that do not fill in data in unused fields, as JOINs do. (I tried JOINS and tried to get help on JOINS from these lists, but that's another story.*) What worked for me is: Create Table A and Table B, the source tables. Create Table C (Combination table) which will be used to collect the combined data. You can kill the records in this table regularly, as it is only a temporary storage area. Take Table A and INSERT SELECT it into the Combination table. Then take the Table B and INSERT SELECT it into the Combination table. In each of these passes, you can position the data into the columns that you decide, using the Select portion of the statement. The only requirement is that the data type be the same, so you must put an integer into an integer column, text into a text column, e.g. Also, I first use the TRUNCATE statement to kill all records in the Combination table before I load the data into it from Table A and Table B. That way, the Combination table is rebuilt with fresh data just before it is used. My problem was that I needed a database to keep track of a symposium's schedule, which includes about 21 Sessions, each of which has perhaps 10 Talks. It was necessary to make a separate table each for Sessions and Talks because I needed to provide my administrative client with the ability to change a Session title but not have it affect the Talks table, or vice versa. But, when all is said and done, the symposium's web page must deliver a schedule of a day's events that shows the Session title, then the Talks under it, then the next Session title, etc. First Table Name: Sessions ID int(6) autoincrement not null Session varchar(36) null SessionTitle varchar(255) null Sample rows: 1 Session I Dead Poets 2 Session II Live Poets 3 Session III Bad Poets Second Table Name: Talks ID int(6) autoincrement not null Session varchar(36) null StartTime time TalkTitle longtext null Sample rows: 1 Session I 07:00 Death of Smoochy 2 Session I 07:15 Byron's Secret 3 Session I 07:30 Kipling's Curse 4 Session II 10:00 Simon's Rhymes 5 Session II 10:15 AB Schemes Suppose you now want a table that we will call Combo, which gives you all the rows from Sessions and all the rows from Talks: Table Name: Combo ID int(6) autoincrement not null Session varchar(36) null SessionTitle varchar(255) null StartTime time TalkTitle longtext null Here is the SQL code to use: INSERT INTO Combo (Session, SessionTitle) SELECT Session, SessionTitle FROM Sessions (This loads from the table Sessions, into the appropriate columns of Combo) INSERT INTO Combo (Session, StartTime, TalkTitle) SELECT Session, StartTime, TalkTitle FROM Talks (This loads from the table Talks, into the appropriate columns of Combo) What we have assembled in Combo will look like this: 1 Session I Dead Poets nullnull 2 Session II Live Poets nullnull 3 Session III Bad Poets nullnull 4 Session I null07:00 Death of Smoochy 5 Session I null07:15 Byron's Secret 6 Session I null07:30 Kipling's Curse 7 Session II null10:00 Simon's Rhymes 8 Session II null10:15 AB Schemes (Notice that I always use an ID field as a primary key in every table, even though this data doesn't need to be passed into the Combo table. Whenever you rebuild Combo using TRUNCATE, you get new ID numbers for the rows.) I can now query the Combo table and use ORDER BY to sort the rows, getting exactly the results I need. (This is only a dummy set of data. The real symposium is completely different and the tables A, B and Combo all have a lot more fields.) This probably isn't a perfect solution. I will bet that there is a better way to do it and some smart guy can put it into one line of SQL code, but I had to get to the goal line like Clint Eastwood--any which way I could. --Dave Shugarts * If you're like me, you're not trying to be some expert in PHP or MySQL. You more or less have to work with PHP and MySQL because it came with your hosted server. So you read the documentation, which is really poor and has little sympathy for non-programmers. And you look for help on these two lists. People from each list tell you that you are asking the wrong question, whether it's a SQL question that has PHP code, or a PHP question that has SQL code. People on both lists tell you to RTFB. So you spend hours and hours figuring out what they could have just shown in a simple example. I think the really smartest guys know the line from Chaucer, Gladly would he learn and gladly teach. HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:
Re: License?
What does internal distribution mean? Is it another thing than copying? I've wondered that myself. See http://www.gnu.org or http://www.fsf.org to get more information on the GPL. Licensing, etc., is explained on their site, http://www.mysql.com/doc/en/Licensing_and_Support.html and they tend to be willing to answer questions if you send mail to their sales crew. Remember that publishing and distribution are two separate things. I think they used not to be very concerned about internal distribution, except in cases where the numbers were large, but I think their lawyers and business people having been pushing them to avoid ambiguities. Consider this example: A company has 2 database servers and want to install MySQL on both servers. Is MySQL free for the first server, but require a license for the second server? Or are MySQL free for both servers? Don't get me started. http://www.mysql.com/doc/en/Using_the_MySQL_software_under_a_commercial_license.html http://www.mysql.com/doc/en/Using_the_MySQL_software_for_free_under_GPL.html It looks to me as if distributing a modified version of MySQL appears to require either the use of the GPL on your modifications or the purchase of a license for each copy distributed. Modification includes linking an application to either MySQL or to one of the MySQL provided drivers. A GPL compatible license may also be used, I think, and if that path is chosen, it must be applied to all of your application source. Previously, the drivers were under the LGPL, which allowed linking an application that was not GPL compatibly licensed, and that was significantly easier to work with. Apparently (without further elucidation from MySQL) you can't distribute PHP linked with the new versions of the drivers (or even to libraries designed to work only with parts of the driver API that are uniquely MySQL's and therefore covered by MySQL's copyright). As a result, PHP 4 is distributed with libraries linked to the old drivers, and PHP 5 is distributed without the MySQL specific drivers directly linked. So the end user of an app written for PHP 5 must install MySQL and its drivers; separately install PHP and either compile the MySQL libraries in or, for MSWindows, set it up to use the MySQL shared libraries dll; and then install the app. You could provide an installer to install both PHP and the app, I think, but the installer for MySQL would have to be separate. (And if you built your own separate installer for MySQL, the installer would have to be under the GPL.) This would be because PHP is not under the GPL license, but under the PHP license, which does not require modifications to be published under a GPL compatible license in order to be distributed. If you use a generic driver, you may be able to avoid the GPL effects, but that's really beside the point. If it makes you money, and if you want it to continue to make you money, logic itself requires you to send some of the action back to the people that build it. In MySQL's case, the people who build it have set up a licensing program to make it easier to cooperate financially and technically. rant If you used, for instance, PostGreSQL, even though that license does not place any publishing or licensing requirements on linked code, the logic remains. Support the developers, or expect to find yourself stuck without support. Vote with your money, so to speak. (As I see it, the two specific advantages of open source and free software are, first, you can legally modify it to your own purposes, and, second, you can usually set up some way to get a good start without paying through the teeth just for the right to find out if your project is going to roll like a tank or roll in the tank. The concept of making money with no expenses at all is a mirage, and a dangerous one, and when you hear the suits talk about frictionless economy, tell them to take their manure generators elsewhere.) /rant -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Password
Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
privileges not updating
hi everybody, i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE should take effect immediately but they don't. i'm using command line also if i create a database, grant privileges on it and then delete the db if i check grants - it still appears... what might be wrong? where should i look? the mysql is 4.0.13 on a redhat 8.0 box... thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Hi there, Restart the mysql server with option --skip-grant-tables. You can then login without password. And then you reset your password with the update command like this: UPDATE user SET password='' WHERE user='root'; Restart the server again. Set a new password with mysqladmin like this: mysqladmin -u root password xxx mysqladmin -u root flush-privileges (xxx is your new password) That should be it. Mysql has a nice manual by the way where it is all described detailed, comes in very handy to have such a print close, just in case ;-) Best regards Nils Valentin Tokyo/Japan 2003 7 2 14:28harsh : You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]