Re: reset auto_increment

At 16:06 -0500 1/10/03, INVALID - TESTING ONLY. IF YOU GET EMAIL WITH THIS ACCOUNT P wrote: I need to reset the auto_increment in a table full of data. I had a problem recently where some script was putting InvoiceID numbers into an auto_increment CustID column...I since fixed the problem and

MySQL backend for mailing list

Hi there, I'm making a library website where users can store preferences about the types of books/cds/etc... they like (e.g. romance, rock, cooking, etc). Once a month the list of 'New Releases' is updated. Currently there is a New Release box which shows releases based on the users

reset auto_increment

I need to reset the auto_increment in a table full of data. I had a problem recently where some script was putting InvoiceID numbers into an auto_increment CustID column...I since fixed the problem and corrected the data but I now have a huge gap in my number sequence and I cant get

version 4 or 3

Hi, I would like to know what are the main differencies between the version 4 and and version 3 of mysql. I heard that sql changed in mysql 4. Is this true?? Must I change my existing programs to update the queries?? Thanking in advance, Nuno Lopes

Re: Blobs

At 16:36 -0600 1/10/03, Terry Cheryl Haimann wrote: Is there an easy way to see If and how much data I have written into a blob? LENGTH(blob_col_name) might be what you want. sql...tomakefilterhappy - Before

Re: cannot get foreign keys to work

At 18:45 +1100 1/10/03, Ben Mooney wrote: i have been using the following sql to try and get foreign keys working, the table creation works fine but when i try and delete data from the parent table it deletes as would normally happen in mysql, also the desired results do not happen if i use

Re: QUERY question (group by) - please help

At 14:41 +0100 1/10/03, Damir Dezeljin wrote: Hi. I want to calculate how many rows my query which uses 'GROUP BY' returns. The query: SELECT something FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; Is it posible to get number of rows with such a query

Re: Blobs

On Fri, Jan 10, 2003 at 04:36:07PM -0600, Terry Cheryl Haimann wrote: Is there an easy way to see If and how much data I have written into a blob? You can find the length of a blob in bytes using the LENGTH function: SELECT LENGTH(column) FROM table; You can also use BIT_LENGTH to

Re: host table in mysql database

At 15:15 +1100 1/10/03, Guy Waugh wrote: Hi there, I'm cleaning up MySQL permissions on one of my servers, and I see that in the mysql.host table, there are 8 rows. All 8 rows contain specific hosts in the 'Host' column (i.e. no wildcards) and specific databases in the 'Db' column. Further,

Re: Question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 George -- ...and then Gman said... % % How can I delete a database in MySQL so I recreate it? echo 'drop database dbname' | mysql -uuser -ppassword where dbname is the name of your database, user is your mysql user name, and pass is the password

Re: Question

At 14:51 -0800 1/10/03, Gman wrote: How can I delete a database in MySQL so I recreate it? George Flatman It's in the manual: http://www.mysql.com/doc/en/DROP_DATABASE.html - Before posting, please check:

Re: Hiding the password

Can you tell us what could be the security problem if Apache is set to run as each user's accounts? Is it a problem if you also allow SSH or Telnet access to users' accounts? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From:

mysql@lists.mysql.com

ÔÚÈ˵ÄÒ»ÉúÖУ¬Í¨³£Óкöà»ú»á...ÓÐÈËÒÔΪ»ú»á´ÓÀ´²»»á½µÁÙÓÚËûµÄÍ·ÉÏ£¬Òò´Ë£¬Ëû´í¹ýÁË...ÓеÄÈËÓöµ½ÕâÑùµÄ»ú»á²¢

RE: mysql monitoring

i think he was speaking more of graphical stats ..if i am not mistaken...mytop cant give you that or atleast i havent seen it..but it wouldnt be bad if it could have those stats in a graphical format. cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41

Re: file permissions problem on ALTER TABLE

Can the MySQL AB folks please tell me whether this bug really exists in 3.23.54a? And, if so, can we look forward to 3.23.54b soonish? I am not ready yet for the 4.x series, as I generally frown upon running such a major engine for my server in gamma/beta software. But a shiny new 3.23 version

Re: QUERY question (group by) - please help

SELECT something FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; Is it posible to get number of rows with such a query from MySQL v3.23.49? You want both a list of rows, and a count of the number of rows -- with a single query. That doesn't make

MySQL LOAD_FILE problems

Using MySQL, I have a problem where I am attempting to upload a 16.4MB file into a BLOB field, but the insert fails with a ERROR 1030: Got error 139 from table handler and after trying again I get ERROR 1062: Duplicate entry 'bla' for key 1 BUT the entry was never made. I need to repair the

Question about JOIN behaviour - I can't figure out how it works

Hi. I searched MySQL manual but I stil don't know how a JOIN works. I would like to avoid diging into sources so I'm posting this mail. I have two tables: - a HUGE table having a row ID_keywords - a SMALL table with keywords and columns ID_keywords and keyword_name I have to select some rows

Lock Tables Timeout value?

Hi, I have searched the docs but can't seem to find information on the time out value for Lock Tables (probably just me) When using Lock Tables how long does MySql wait before giving up if it can't get a lock? Is there any way of changing this time out value? Thanks Clyde England

Re: file permissions problem on ALTER TABLE

Hi there, I still have problems with this when using MySQL 4.0.8. When I try to DROP a DATABASE, it will go through and delete all the tables, except the last two, apparently because it can't delete the table.myi file. When I restart the server, I can DROP one of the tables, then I get the error

Re: Question

On Fri, Jan 10, 2003 at 11:50:28PM -0500, David T-G wrote: George -- ...and then Gman said... % % How can I delete a database in MySQL so I recreate it? echo 'drop database dbname' | mysql -uuser -ppassword where dbname is the name of your database, user is your mysql user name,

Re: Enabling Cache feature in MySQL 4

At 18:22 +0100 1/10/03, Blaster wrote: Happy as I was, I pulled out a test box, installed Linux Debian on it, downloaded MySQL 4 on it, everything worked smooth, now I wanted to enable the cache feature, but it didn't let me! I want the change to be permanent, so I looked up the doc pages at

Hungarian FONT problem in MySQLCC!

Hi All, Please help me. I can't use some hungarian characters (long accent mark and ) in the MySQL Control Center (version: 0.8.7-alpha, on op.sys.: Windows 2000 proffesional), because the application changes my fonts to ? (question mark) in the query, altough the MySQL server (ver.: 3.23.51)

Re: QUERY question (group by) - please help

Damir Dezeljin wrote: SELECT something FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; Is it posible to get number of rows with such a query from MySQL v3.23.49? You want both a list of rows, and a count of the number of rows -- with a single query. That

Re: MySQL on large server

How many connections do you need? 1000? As many as possible I guess. I'd like to maximise usage of the new server.. This is what I have in /etc/my.cnf on my current MySQL 3.23 server (dual AthlonMP,2GB RAM) [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking log-slow-queries =

Re: QUERY question (group by) - please help

Hi again ;) SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; This query returns: +--+ | COUNT(*) | +--+ |1 | |1 | |2 | |1 | |1 | |1 | +--+ 6 rows in set (0.03 sec) Inest of this I

Re: Lock Tables Timeout value?

Gee, I hope there is no such thing as a timeout value for Lock Tables. :) If two of my programs decide that one of them needs to wait for the other, however long that may take, then I hope MySQL honors that chosen symbiosis. I hope it behaves like a Perl flock(): it just waits, and waits, and

Beginners Running problems

Hi I have installed a downloaded version of mysql on my pc but am experiencing problems when I try to run the MySQL monitor. From the command line:- C:\mysql\bin when I type in mysql to activate the monitor, I get the error message: ERROR 2003: Can't connect to MySql server on

re: Cannot connect after upgrading to mysql-4.0.8

On Saturday 11 January 2003 04:35, Claus Olesen wrote: Description: The problem described on http://bugzilla.redhat.com/bugzilla/long_list.cgi?buglist=75128 with solution described on http://rhn.redhat.com/errata/RHSA-2002-197.html comes back after

re: version 4 or 3

On Friday 10 January 2003 23:11, Nuno Lopes wrote: I would like to know what are the main differencies between the version 4 and and version 3 of mysql. Check the manual: http://www.mysql.com/doc/en/News-4.0.x.html http://www.mysql.com/doc/en/Nutshell_Other_features.html

Re: MySQL LOAD_FILE problems

Herbert, Using MySQL, I have a problem where I am attempting to upload a 16.4MB file into a BLOB field, but the insert fails with a ERROR 1030: Got error 139 from table handler BLOB can store data up to 64 KB only. Use MEDIUMBLOB (up to 16 MB) or LONGBLOB (up to 4 GB). For MEDIUMBLOB, be

errno 144

My own MySQL-based news server (or, rather, its fetch-news aid) just gave me this horrible error: -- On Sat, 11 Jan 2003 13:42:00 GMT, (FETCH-NEWS) shutdown reason: 1016, Can't open file: 'my_table.MYD'. (errno: 144)

Re: QUERY question (group by) - please help

Damir Dezeljin wrote: Hi again ;) SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; This query returns: +--+ | COUNT(*) | +--+ |1 | |1 | |2 | |1 | |1 | |1 | +--+ 6 rows in

Ram Usage, and processes

Hello: I have a few questions about how MySQL uses Ram. I have a machine that I am using as a database server. The machine has close to 1G of ram. It is running Slackware Linux 8.1 With a 2.4.18 kernel. The main use of this server is a backend for Radius Authentication. I have read all

PHP4 Secure connection parameters

I'm trying to use SSL connections with MySQL 4.0.8-MAX and FreeBSD 4.6 using the online manual and have a question about section 4.3.9.2 Requirements Configure MySQL with --with-vio --with-openssl. Since I installed the MAX version isn't it already SSL ready? Where do I add the --with-vio

Re: Re: Re: UPDATE not working ...

On Friday 10 January 2003 21:43, you wrote: mysql UPDATE t SET d=UNIX_TIMESTAMP(DATE_ADD(c, interval (b) day)) / 1; ERROR 1105: Unknown error Thanks for bug report! This is a patch from Sinisa Milivojevic: = sql/item.cc 1.24 vs edited = *** /tmp/item.cc-1.24-3175 Tue Dec 3

Re: Lock Tables Timeout value?

*** REPLY SEPARATOR *** On 11/01/2003 at 1:29 PM Mark wrote: Gee, I hope there is no such thing as a timeout value for Lock Tables. :) If two of my programs decide that one of them needs to wait for the other, however long that may take, then I hope MySQL honors that chosen

Thanks and SQL Syntax help

First of, thanks to all who replied to my questions earlier! Now I have another problem. I have a table of Classes and Workshops. Each Class has a number of workshops. Each workshop has a date. I have a query that gives me the date range of a class - the min and max dates of its workshops.

synopsis of the problem (one line)

Description: 1 How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

install problem... (permissions?)

Hey guys, I'm having a little problem with my new mysql installation. I built from source, and everything built find and installed okay (I think). Here's the problem: when I start safe_mysqld it just ends. Here's the snippet from my error log: /usr/local/libexec/mysqld: File

Re: Lock Tables Timeout value?

At 17:12 +0800 1/11/03, Clyde wrote: Hi, I have searched the docs but can't seem to find information on the time out value for Lock Tables (probably just me) When using Lock Tables how long does MySql wait before giving up if it can't get a lock? Forever. For table-level locks such as you

Re: PHP4 Secure connection parameters

At 9:09 -0700 1/11/03, David Rock wrote: I'm trying to use SSL connections with MySQL 4.0.8-MAX and FreeBSD 4.6 using the online manual and have a question about section 4.3.9.2 Requirements Configure MySQL with --with-vio --with-openssl. Since I installed the MAX version isn't it already SSL

Re: SQL optimization problem

You might have to tweak the following a bit for syntax: SELECT a.name, COUNT(b.id) as votes FROM poll_options as a LEFT JOIN poll_votes as b ON a.id=b.oid WHERE b.pid='poll_id' GROUP BY b.oid Also, you can refer to: http://www.mysql.com/doc/en/JOIN.html Bhavin. - Original Message -

Re: file permissions problem on ALTER TABLE

At 10:17 11/01/2003 +0100, Dirkjan Ochtman wrote: Hi, cut server, I can DROP one of the tables, then I get the error again for the other table, so then I restart the server again and I can DROP the last table. The problem also persists on ALTERing TABLEs. cut Please if possible for you send

Nothing about logs in startup options but logs created

From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Nothing about logs in startup options but logs created Description: It's nothing in /etc/init.d/mysql.server and my.cnf files about logs. But if i start mysqld with '/etc/init.d/mysql.server start' or

Re: relations between tables

As far as I know and how I understand it, the relationships are basically all in your head... You just have to coordinate it in your queries and other functions This is not true. Fot type innodb tables, you can define REFERENCES using ON DELETE (CASCADE|RESTRICT) and/or ON UPDATE CASCADE

Re: SQL optimization problem

LEFT JOIN On Sat, 11 Jan 2003 18:35:44 +0100, Blaster used a few recycled electrons to form: | Hey, | | (this post is pretty long, a short version of the problem is listed at the | bottom if you don't like reading long emails :P) | | I'm currently going through all my SQL queries for my

Re: SQL optimization problem

Taking a blind stab, how about.. SELECT a.name, minimum(0,COUNT(b.id)) as votes FROM poll_options as a LEFT JOIN poll_votes as b on a.id=b.oid WHERE b.pid='poll_id' GROUP BY b.oid Ryan Fox - Original Message - From: Blaster [EMAIL PROTECTED] However! Here comes the problem, if no vote

Re: install problem... (permissions?)

Christopher, 030111 13:41:11 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) Did you run the install_db script? If not, MySQL can't find the grant tables. See http://www.mysql.com/doc/en/Post-installation.html for details. Regards, -- Stefan Hinz [EMAIL

How does the MySQL shutdown process works.

I'd like to know how MySQL shuts down. Where can I find more about the process, first with mysqladmin shutdown, and when it shuts down as a result of Windows shutting down, eirhter as a service or from the command line or a batch file? With InnoDb I always receive a message about recovering

Re: I need the full list of client options in my.cnf

Where can I find the full list of options which go under the [client] section? ignore this part it is the spam filter bypass (sql,query,queries,smallint) --- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To

Re: Ram Usage, and processes

James M. Luedke wrote: Hello: I have a few questions about how MySQL uses Ram. I have a machine that I am using as a database server. The machine has close to 1G of ram. It is running Slackware Linux 8.1 With a 2.4.18 kernel. The main use of this server is a backend for Radius

Re: Beginners Running problems

To paraphrase Yogi Berra: You can see an awful lot just by looking. http://www.mysql.com/doc/en/Can_not_connect_to_server.html Doug -- For Happy Filters, use SQL, query On Sat, 11 Jan 2003 12:50:29 -, alan.keith.simons wrote: Hi I have installed a downloaded version of mysql on my pc but

Problems installing additional instances of mysql 4.0.x as a service

I have been trying to install additional instances of mysqld 4.0.x as a service on Windows 2000, but it seems that only one set of parameters. eg. 'mysqld --install connectionname --port=3307 --datadir=c:\mysql\datadir2' does not work but mysqld --install connectionname --port=3307 and

PostgreSQL-OOo

From the Open Office . org list On 2003.01.10 12:09 Josh Berkus wrote: Ruben, Oh yes ... but it was in the short list of reasons to oppose using Mysql and it's what we call in Hebrew, Loshen Harah.. evil speach. Monty and Dave do not deserve this reputation. Say what you will about the

RE: PHP4 Secure connection parameters

At 16:52 -0700 1/11/03, David Rock wrote: Show variables says have_openssl = NO for the binary version. I compiled and installed the source version using --with-vio --with-openssl=/usr/bin Try --with-openssl without any argument and see if configure finds your OpenSSL installation location by

RE: PHP4 Secure connection parameters

Show variables says have_openssl = NO for the binary version. I compiled and installed the source version using --with-vio --with-openssl=/usr/bin and it still says have_openssl = NO. I'm not sure what path -with-openssl is expecting but other than that I'm not sure where to look next. FreeBSD

Has anyone managed to get 4.0.8 Win32 working properly?

Has anyone managed to get MySQL 4.0.8 Windows 2000 successfully? I am trying to run it as an additional service. It keeps crashing when I try to access data. sql, query __ Do You Yahoo!? Everything you'll ever need on one web page from News and

Replication bug?

I think I have found a replication bug. We are using Mysql-Max 3.23.53 in a master and multiple slave situation. That is working fine. We are using InnoDB We have found a workaround to the problem but I thought you should know about it. We have 2 databases on the system call them dba and dbb.

Problem with query cache and comments

Hi, I've been testing the query cache with mysql 4.0.8 and ran into a problem. the query select * from tablename where x=1; is cached correctly and generates nice hits when run more than once but if I add a comment like /* any comment */ select * from tablename where x=1; the query is cached,

Re: Question -Subselect

Please help! I already know that my query is wrong. I have identified it. But what is the solution to my query? --- gerald_clark [EMAIL PROTECTED] wrote: I answered this yesterday. Your FROM must precede your WHERE. Terence Ng wrote: How do I correct this SQL code: 2 tables there,

need help on ODBC

Hi, I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51. Any sugestion would be appriciated. - Before posting, please check:

Re: need help on ODBC

Hello Dolly, Kindly state and share with us the error encountered if there were any. Your source code would also be of help :-) Fred. dolly wrote: Hi, I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51.

Re: Replication bug?

Are the slaves doing the replication process? If not, you may try it that way. Slaves should do the updating and must request from the server and not the server to the slave. :-) Fred. Ross Davis - DataAnywhere.net wrote: I think I have found a replication bug. We are using Mysql-Max

Re: Has anyone managed to get 4.0.8 Win32 working properly?

I tried and is working perfectly. I am using MS2000server. Please share with us the error logs if there are any. thanks. Fred. My Deja wrote: Has anyone managed to get MySQL 4.0.8 Windows 2000 successfully? I am trying to run it as an additional service. It keeps crashing when I try to access

RE: Has anyone managed to get 4.0.8 Win32 working properly?

MY EXPERIENCE WITH MYSQL GAMMA 4.08 on win2000 professional SP 3 was not too bad: PREPARE A shutdown mysqlmax-nt (3.23.53) running as NT service, B downloaded mysql-4.0.8-gamma-win.zip to desktop C extracted zip to e:\mysql408 D installed to e:\mysql408\install E opened the html manual F skimmed