Re: Killing Queries...

On Wed, Sep 03, 2003 at 03:46:45PM -0700, James Kelty wrote: I was wondering of there is a way to kill multiple processes in MySQL rather than one at a time? mytop has a currently undocumented super kill feature. By using the 'K' key, you can kill all connections owned by a given user. I

Connection and query on one line (newbie)

G'day all I'm trying to run a connection and query from one line (it will eventually be called as part of a 'do shell script' Applescript on Mac OSX) The connection works fine: /library/mysql/bin/mysql -uroot -ppassword mydatabase And then I want to load a file using: load data infile

AW: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT

-Ursprüngliche Nachricht- Von: Toro Hill [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 16. September 2003 03:36 An: Morten Gulbrandsen Cc: [EMAIL PROTECTED] Betreff: Re: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT I believe that your ON UPDATE CASCADE clause should be

Mysql 4, Solaris 9 and Perl 5.8

We are getting new Solaris machines on which I plan to install MySQL. We will be installing Solaris 9 on these machines. Offhand, does anyone know if there are problems with compiling and installing MySQL 4 on Solaris 9. I am also planning on installing Perl 5.8 on these new machines. The

Re: User privileges on a database ... really stuck!

Michael Handiboe [EMAIL PROTECTED] wrote: I have the MySQL Reference Manual (the brown book), 1st Edition, and it is a mighty fine book. On p256, I follow the examples, but for a user who's supposed to have access to a single database ('cabs') with the following privileges:

Repairing a large table takes weeks!

Hi, About two weeks ago I received The table Worklist is full error. Since then I have been struggling to update the table indexes beyond 32 bits as suggested by the MySQL documentation. I have tried the following methods (I have two identical MySQL databases on two identical computers): -

Re: Connection and query on one line (newbie)

Kim Kohen [EMAIL PROTECTED] wrote: I'm trying to run a connection and query from one line (it will eventually be called as part of a 'do shell script' Applescript on Mac OSX) The connection works fine: /library/mysql/bin/mysql -uroot -ppassword mydatabase And then I want to load a file

Re: Repairing a large table takes weeks!

About two weeks ago I received The table Worklist is full error. Since what type of table? MyISAM? how big is 'full'? If you don't specify any of the above options, the maximum size for a table will be 4G (or 2G if your operating systems only supports 2G tables). i dont know how big files can be

Re: Poblem with cyrillic language

Sbandy [EMAIL PROTECTED] wrote: Hi all. I am italian and i have to insert into a database a string with cyrillic character in a field varchar but mysql give me this error: ? query was empty Seems you just have two semicolons at the end of the query. -- For technical support contracts, goto

mysqldump optimization

Thanks for that tip about the -opts on mysqldump. my import speed went from 28 hours to about 11 minutes. Thanks again! dan

Re: MySQL ssl Q

Thanks. To make things easier, I have been testing everything on the same machine. Even though the mysql client program can take the --ssl-*** flages, the status reports ssl not in use in mysql moniter when I log in with the root account. Sherrill On Mon, 15 Sep 2003 [EMAIL

mysql 4.1.0-alpha and innodb

Excuse my dumbness, but how do I tell MySQL server that I need InnoDB tables, not MyISAM? I was running 4.0.14 and it was ok, but now when I create a new db in 4.1.0-alpha the tables are defaulting to MyISAM Am I missing some startup option? Thanks. -Wash -- Odhiambo Washington [EMAIL

select data from two tables without join

I have two tables that are similar, but not related. One is for meetings and the other for training. I'd like to run a query to select data from both based on the date so I can display the information on a web page. Is that possible? It seems unnecessary to run a separate query for each. I'd

RE: select data from two tables without join

it depends on how you want it if you want them consecutively, you probably want to UNION two queries together, but you need to make sure that the column types are identical... i.e. select meeting_name as event_name, meet_date as event_date from meetings where meet_date = curdate() union

Re: mysql 4.1.0-alpha and innodb

Odhiambo Washington [EMAIL PROTECTED] wrote: Excuse my dumbness, but how do I tell MySQL server that I need InnoDB tables, not MyISAM? I was running 4.0.14 and it was ok, but now when I create a new db in 4.1.0-alpha the tables are defaulting to MyISAM Am I missing some startup option? Use

Re: select data from two tables without join

If the tables are *identical* in structure ant are MyISAM, you can create a MERGE table from them. See http://www.mysql.com/doc/en/MERGE.html Alec - I have two tables that are similar, but not related. One is for meetings and the

Re: Bug #942 fix for 4.1.1?

Hi! On Sep 16, Christoph Leiter wrote: Hi, I reported bug #942 which you've fixed in 4.0.15. Will this be fixed in 4.1.1 as well? I'm not familiar with the MySQL development process, but http://www.mysql.com/doc/en/News-4.1.1.html doesn't mention this bug. Yes, it's already fixed in

How to join from a union-result

Hi! I would like to perform a join on two tables, where one table is a UNION. This is because I have two different tables with products which looks the same and can be UNION:ed without problems So I'ld like to perform something like Select * from table left join [the union] on table.id =

Re: select data from two tables without join

Tony Thomas [EMAIL PROTECTED] wrote: I have two tables that are similar, but not related. One is for meetings and the other for training. I'd like to run a query to select data from both based on the date so I can display the information on a web page. Is that possible? It seems unnecessary

Re: select data from two tables without join

If the tables are the same, then maybe you could use one table with a field that tells the application if its a meeting or training. Other then that, UNION is very cool. As long as you have the same field definitions in 2 or more queries they can be added togeather. Unfortunatly you can do sub

Re: select data from two tables without join

I'm using 3.23.56, so UNION is out. MERGE looks like it might do the trick. The tables are duplicate other than the field names. The structure is identical. On Tuesday, September 16, 2003, at 08:32 AM, Haydies wrote: If the tables are the same, then maybe you could use one table with a field

RE: Repairing a large table takes weeks!

Hi, About two weeks ago I received The table Worklist is full error. what type of table? MyISAM? how big is 'full'? Sorry I forgot to mention. The table is MyISAM with 32-bit file pointers. This makes its maximum size 4 GB. This is the limit I hit. Windows XP with NTFS has no file-size

Re Does NULL == ?

All this discussion about the definition of NULL and its use in database querying has been most interesting and enlightening. I hadn't realized I was asking such a deep question. Unfortunately, I'm still at the stage of designing tables where I KNOW I will be loading thousands of records that,

Commands out of sync

Hello the list, sorry for my english, i'm french :-p i've got a php script with a mysql database. everything works fine. but today, i've got this message : Commands out of sync; You can't run this command now i've done NOTHING. nothing on my php scripts. nothing on the database server. why

Re: select data from two tables without join

If you use merge you might not be able to tell which records came from which table. If that dosn't matter obviously its not a problem. - Original Message - From: Tony Thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 2:48 PM Subject: Re: select data from

Re: Commands out of sync

On 16 Sep 2003, VIVES Ariel wrote: i've got a php script with a mysql database. everything works fine. but today, i've got this message : Commands out of sync; You can't run this command now i've done NOTHING. nothing on my php scripts. nothing on the database server. why ??? help

Re: Re Does NULL == ?

On Tue, Sep 16, 2003 at 09:58:32AM -0400, Randy Chrismon wrote: All this discussion about the definition of NULL and its use in database querying has been most interesting and enlightening. I hadn't realized I was asking such a deep question. Unfortunately, I'm still at the stage of designing

Reading Date from a csv file

I am new to mySQL. I am trying to import data from a csv file, using the following code LOAD DATA LOCAL INFILE 'D:/foldername/file1.csv' INTO TABLE database_name.tbl_name FIELDS TERMINATED BY ',' ( field1, field6_date, field9

RE: Reading Date from a csv file

Try '-mm-dd'. -Original Message- From: Lakshmi Chennareddi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:18 AM To: [EMAIL PROTECTED] Subject: Reading Date from a csv file I am new to mySQL. I am trying to import data from a csv file, using the following code LOAD

Re: Commands out of sync

At 4:26 PM +0200 9/16/03, VIVES Ariel wrote: Hello the list, sorry for my english, i'm french :-p i've got a php script with a mysql database. everything works fine. but today, i've got this message : Commands out of sync; You can't run this command now i've done NOTHING. nothing on my php

Re: Reading Date from a csv file

try ISO standard dates MMDD - Original Message - From: Lakshmi Chennareddi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 4:17 PM Subject: Reading Date from a csv file : I am new to mySQL. : : I am trying to import data from a csv file, using the

Re: Truncate do not reset auto increment counter

Kim G. Pedersen [EMAIL PROTECTED] wrote: I once red that using truncate table xx instead of delete from xx should reset autoincrement , but it seem not to happend. but when I try to insert data with insert or load data in it remember the old autoincrement value. from manual : Truncate

Different users try to access different mysql.sock

Here is an interesting one! I have changed datadir in my.cnf to point to /data/mysql. I also have the socket file as /data/mysql/mysql.sock This is all fine and works. My server starts up with no complaints, /data/mysql/mysql.sock springs into existence and everyone is happy. Except my

Re: Different users try to access different mysql.sock

You need to add the new socket location to the paragraphs in my.cnf that start with [client] and [mysql] /etc/my.cnf needs to be world readable. Check for private .my.cnf files in the home directories of the users having the problem. michael watson (IAH-C) wrote: Here is an interesting one! I

Re: select data from two tables without join

My fields have unique names. For instance, the fields for the date in each table are meet_date and train_date for the meetings and trainings tables respectively. If I did a merge, would I still be able to separate them out with PHP? For instance: while ($row=mysql_fetch_array($result)) {

RE: Mysql 4, Solaris 9 and Perl 5.8

Don't compile mySQL for Solaris 9. The mySQL team has invested months of work to get a very fast and stable static link of up-to-date libraries from their downloadable binaries section. I find that they are more stable and faster then the ones compiled by hand. For Perl 5.8 goto sunfreeware.com

Re: LOAD Fails on Lost Connection

I read the MysQL documentation re the Server Gone Away error but nothing there applied to my situation. On a whim, I re-created the table I was trying to import into but without the foreign key constraint (I had only disabled the foreign key constraint in the previous failed efforts). This time it

MySQL 4.1 .vs. MySQL 4.0.13

Hi I have a user who needs to do the following [snip] I believe I will need sub-selects for the following type of query. Subqueries are not supported until MySQL 4.1. I will need to do longest-match lookups in the DB to mimic the way that IP routers do longest-match routing lookups. In the

RE: Does Null == ?

Even if I grant you that, the DB designer should have produced the documentation. I'm willing to place the blame on both people; either one could have avoided the problem. But, the DBD (data administrator, if you prefer) is more likely to have been *aware* of the problem in the

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

Hi I have a user who needs to do the following [snip] I believe I will need sub-selects for the following type of query. Subqueries are not supported until MySQL 4.1. I will need to do longest-match lookups in the DB to mimic the way that IP routers do longest-match routing lookups. In the

RE: Re Does NULL == ?

The performance benefit to be had with NOT NULL columns comes from the fact that a NOT NULL column can be of fixed length (allowing for fixed length records). Using NOT NULL probably wont offer any benefit on a VARCHAR column, since VARCHAR columns are not of fixed length to begin with. -JF

SEC_TO_TIME not working?

SELECT DailyLog.TimeOut, DailyLog.TimeIn, SEC_TO_TIME(UNIX_TIMESTAMP(DailyLog.TimeOut) - UNIX_TIMESTAMP(DailyLog.TimeIn)) as test FROM DailyLog keeps on giving me a result as a date. Not time in years, days, hours, min. For example 9/9/2007 12:51:26 PM - 9/9/2007 12:51:26 PM gives me 12:00 PM.

random access denied

Hello, I am having a frustrating problem with MySQL. I don't consider myself a newbie, nor am I a master, but either way I can't figure out this problem and I'm hoping someone here has an idea of what is going wrong. Every so often MySQL decides it doesn't want to authenticate a user, doesn't

RE: Does Null == ?

I didn't know that. What *does* it do if you specify a string literal that's smaller than the CHAR(20) field, then? Pad it with binary zeros? MySQL returns a properly trimmed string, although it will allocate a fixed amount of space for the storage. Other databases pad with blank spaces.

innodb and mysql 4.0.15

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have mysql 4.0.15 on a dual Pentium IV machine. It has been running well, though in my logs I get the following error: 030916 17:30:21 InnoDB: Error: page 120855 log sequence number 11 2122008369 InnoDB: is in the future! Current system log sequence

Re: Connection and query on one line (newbie)

G'day Victoria You can use mysql in a batch mode like: mysql -e LOAD_DATA_command_here That's perfect, thanks. Exactly what I was looking for and now up and running. Cheers and thanks again kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

mysqldump with innoDB

It looks like the dump works... however the way it is made, there is no way to use it to recreate the database because key constraints fail. The dump contains table creations in an order which does not respect key constraints. Is there any work around to rebuild a database with innodb tables ?

Re: mysqldump with innoDB

At 7:13 PM -0400 9/16/03, Irwin Boutboul wrote: It looks like the dump works... however the way it is made, there is no way to use it to recreate the database because key constraints fail. The dump contains table creations in an order which does not respect key constraints. If you have problems

Re: SEC_TO_TIME not working?

At 2:55 PM -0700 9/16/03, Grant Cooper wrote: SELECT DailyLog.TimeOut, DailyLog.TimeIn, SEC_TO_TIME(UNIX_TIMESTAMP(DailyLog.TimeOut) - UNIX_TIMESTAMP(DailyLog.TimeIn)) as test FROM DailyLog keeps on giving me a result as a date. Not time in years, days, hours, min. For example 9/9/2007 12:51:26

Selecting only the exact record from double

Hi Guys, Quick question... I need to be able to send a query like: select cd,fid,s_from,s_to from ima where '3355443200' between s_to and s_from Thats fine and all, but when I get my results I pull 2 records: MA smith 335544320 352321535 BS mango 3355443200 3355445247 I must only

Re: AW: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT

The first foreign key contraints in the following table definition mean this: Any record that is inserted into the product_order table must have values for product_category and product_id that exist in the category and id fields of a record in the product table. The second foreign key contraints

innodb tables key problem ?

I have created a new database with those tables. DROP TABLE IF EXISTS ACL_GROUPS; CREATE TABLE ACL_GROUPS ( groupid char(30) character set latin1 NOT NULL default '', creationtime datetime default '-00-00 00:00:00', active smallint(6) default '1', priority smallint(6) default '1',

URGENT: foreign/linked table keys

Hello - I've got a simple MySQL/PHP database set up with 3 tables plus a relationship table (using phpMyAdmin.) The end result is for students to be able to dynamically find out what books are required for their classes by selecting; term --- course --- instructor --- (results) The tables

Re: Does Null == ?

On Tue, Sep 16, 2003 at 05:39:35PM -0400, Bruce Feist wrote: 1) It is the responsibility of the DBD to document the meaning of NULL if NULLs are allowed. No, it's not. The meaning of NULL is documented in the SQL specification. It's the responsibility of people working with databases to know

Re: (4.0.14) Corrupt table on DELETE FROM ...

Yep, verified here with .15-nt on Win2k. :-/ I'm sending this to the Bugs and General lists because I'm assuming it affects all platforms; or is it only Windows? Matt - Original Message - From: Fredrick Bartlett Sent: Tuesday, September 16, 2003 7:40 PM Subject: Re: (4.0.14) Corrupt

Unique Key Violation - How to determine which key

I have a table w/ a primary key and 2 additional unique keys. How can I determine which key was in error when a key violation occurs (error=1062)? The call is issued from PHP (4.4.3). I can retrieve a message w/ mysql_error() which returns Duplicate entry '[EMAIL PROTECTED]' for key 3 I'd

Re: Unique Key Violation - How to determine which key

On Tue, Sep 16, 2003 at 08:25:39PM -0700, Scot Campbell wrote: I have a table w/ a primary key and 2 additional unique keys. How can I determine which key was in error when a key violation occurs (error=1062)? The call is issued from PHP (4.4.3). I can retrieve a message w/

URGENT: foreign/linked table keys

Hello - I've got a simple MySQL/PHP database set up with 3 tables plus a relationship table (using phpMyAdmin.) The end result is for students to be able to dynamically find out what books are required for their classes by selecting; term --- course --- instructor --- (results) The tables look

Re: Checksum over tables

On Tue, Sep 09, 2003 at 10:13:09AM +0200, Michael Otto wrote: Is there a way of getting one checksum for a structure of tables of a database. The problem we are facing is that we have 2 database servern with the same table structure and with the same data in the tables, it is NOT possible

Re: Innodb multiple tablespaces

On Mon, Sep 08, 2003 at 10:05:02PM -0600, Mike Hillyer wrote: And will you be making your deadline? ;) No, he's gonna be a bit late. At least that's what he said a couple days ago when I sent in an InnoDB bug report. But have faith. I'm sure it'll be worth the wait. :-) Jeremy -- Jeremy D.