InnoDB problems with 4.0.18-max

2004-04-01 Thread Rick Ellis
Hi Guys, We are currently using MySQL as the backend to the RT Request Tracker Ticketing system. The problem is that we are seeing total data loss from the InnoDB after a proper shutdown of the database using mysqladmin shutdown. We have observed this once on a Sparc Enterprise 420R with 4 CPU's

Problems replicating

2004-04-01 Thread Jonas Lindén
Hello, I still trying to get my replication working witout success. I included show processlist and show slave status. Can anyone make out from them what I am lacking? I am running mysql 5.0.0 on a linux master trying to replicate them on a windows slave Best regards /Jonas

Using Access as client all fields are marked #Deleted

2004-04-01 Thread Patrick Kirk
Hi all, My setup is windoes 2000, Access 2000 and Mysql built from source on Debian. Some tables can be seen but all new entries are marked #Deleted. If I close the table in Access and re-open it, its looks fine. Others have every field marked #Deleted and nothing I do makes those tables

Re: Problems replicating

2004-04-01 Thread Jonas Lindén
Hola, I figured it out myself, The problem was that I didnt specify any tables. I thought that if you replicated a database the tables would be included. That is not the case. I added this to make it work. Replicate_Wild_Do_Table: CellDB%.% Regards /Jonas - Original Message - From:

adding/changing passwords on mysql

2004-04-01 Thread Talk21
Hi all, I have noticed that when I change a password using sqlyog, the password table stores as plain text which surely can'y be right ? Can anyone tell me what I'm doing wrong here. All the passowrds originaly were added useing the command line client in Dos window. and when originally viewed

Re: adding/changing passwords on mysql

2004-04-01 Thread Jigal van Hemert
From: Talk21 [EMAIL PROTECTED] I have noticed that when I change a password using sqlyog, the password table stores as plain text which surely can'y be right ? Can anyone tell me what I'm doing wrong here. All the passowrds originaly were added useing the command line client in Dos

Re: INSERT INTO ... SELECT

2004-04-01 Thread Egor Egorov
Ricardo Lopes [EMAIL PROTECTED] wrote: I have to copy some records from one table into the same table is it posible? my sql is like this: INSERT INTO equipamento_componentes (cod_equipamento_componentes, cod_tipo, numero, data_colocacao, cod_componente) SELECT '', 'C', 65, NOW(),

Re: Is this possible?

2004-04-01 Thread Chris Boget
GROUP_CONCAT() is in 4.1. :-) Oh, so close yet so far. We're running 4.0.14 and my company has no plans on upgrading in the near future. *sigh* Thanks for the info, however!! Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

connection errors when making lot of connections continiously.

2004-04-01 Thread Grgory Starck
hi, I'm using mysql mysql 4.0.18-log, and I'm having trouble (i tried also with an older 3.23.49-log and give the same). It's running on debian 2.4.20. I explain the case : I've a multi-processes application, each of these process doing about that : while (1) { wait some client, while (1)

autonumber rows in SQL result, how to

2004-04-01 Thread Miroslav I.
- how to autonumber rows in SQL result I would like to put an auto numbering column in any SQL SELECT result, is it possibile? miroslav i.

MySQL Administrator don't connect

2004-04-01 Thread Renato Cramer
Hello, I use MySQL 4.1 in Windows 2000 and don't get connect with MySQL Administrator. The message what get is: Could not connect to the specified host. MySQL Error Nr.1115 Unknown character set: 'utf8' Details of the my connection: Username: root Password: not informed Hostname: localhost

RE: load data help

2004-04-01 Thread David McBride
Thanks so much, that did the trick. I really appreciate the mercy on a poor newbie. Thanks again, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 5:28 PM To: David McBride Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re:

Re: autonumber rows in SQL result, how to

2004-04-01 Thread Egor Egorov
Miroslav I. [EMAIL PROTECTED] wrote: - how to autonumber rows in SQL result I would like to put an auto numbering column in any SQL SELECT result, is it possibile? You can use variables, for example: mysql SELECT @id:=0; ++ | @id:=0 | ++ | 0 | ++ 1 row in set

RE: Using Access as client all fields are marked #Deleted

2004-04-01 Thread Osvaldo Sommer
What type of connection are you using? Linked table or you connect on demand? Osvaldo -Original Message- From: Patrick Kirk [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 7:32 AM To: Osvaldo Sommer Subject: Re: Using Access as client all fields are marked #Deleted Osvaldo

mysql 2 nics forward to bound ipaddress

2004-04-01 Thread Frank Singleton
Hi, If I start mysql bound to a particular address on our server, eg: mysqld --bind-address=MY_IP_ADDRESS and this server has 2 nics connected via 2 switches. If the first NIC or switch fails, can I use iptables to forward incoming mysql requests from the 2nd (alive) nic (IP address) so it

Re: starting mysql daemon

2004-04-01 Thread muhammad alqama
hi the error mentioned in the file is... fatal error : can not open privilege tables can not find file : './mysql/host.frm' (errno 13) what to do now... regards alqama - Original Message - From: Victor Pendleton [EMAIL PROTECTED] Date: Wed, 31 Mar 2004 16:03:43 -0600 To:

RE: starting mysql daemon

2004-04-01 Thread DChristensen
Errno 13 indicates a permissions error. Please check the ownership of the data directories you're using to make sure that the mysql user group. Dave -Original Message- From: muhammad alqama [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:46 AM To: [EMAIL PROTECTED]; [EMAIL

Re: starting mysql daemon

2004-04-01 Thread muhammad alqama
hi the error mentioned in the file is... fatal error : can not open privilege tables can not find file : './mysql/host.frm' (errno 13) but in the directory /var/lib/mysql/mysql the file host.frm exists...(/var/lib/mysql/ being the data dir) what to do now... regards alqama

4.1 timestamp errors

2004-04-01 Thread Arthur, John
Good morning, I just upgraded to MySQL 4.1 from 4.0. The upgrade went fine but now all of my timestamp fields are being cut off half way through the time. Example field: 2004-04-01 10:4 Can anyone provide some insight into why I have this issue and how I can resolve it? Thanks! - - - - - - -

Re: load data help

2004-04-01 Thread beacker
David McBride [EMAIL PROTECTED] writes: Thanks so much, that did the trick. I really appreciate the mercy on a poor newbie. David, You're quite welcome. Now if I could find an employer willing to pay me for utilizing the 23 years of knowledge I used to provide such a solution :)

RE: starting mysql daemon

2004-04-01 Thread muhammad alqama
hello the directory /var/lib/mysql/mysql (datadir) has read/write permissions for user mysql and for root group drwx-- 2 mysql root... but the file /var/lib/mysql/mysql/host.frm (as well as all the files in dir .../mysql/mysql) has permissions only for root -wr-wr- 1 root root

DB Connection

2004-04-01 Thread Shrikrishna Sathe
The following .asp code sinppet gives error. Dim rs Set rs = Server.CreateObject(ADODB.Recordset) rs.Open printjob,objConn, adOpenForwardOnly, adLockOptimistic , adCmdTable rs.AddNew rs(jobid) = Request.Form(jobno) rs(closesize) = Request.Form(closize)

Re: starting mysql daemon

2004-04-01 Thread Michael Stassen
All the files in the mysql directory should be owned by the mysql user, so yes, you should change all of them. Michael muhammad alqama wrote: hello the directory /var/lib/mysql/mysql (datadir) has read/write permissions for user mysql and for root group drwx-- 2 mysql root... but

Record Change Date

2004-04-01 Thread Jeff Cook
Is there any way to see what date a record was changed on? I am building a database of mostly imported CSV files. The files would be imported on the day they were created and would not have a date field in them. May hope would be to have a field in the database that would show the date the

Re: Record Change Date

2004-04-01 Thread Victor Pendleton
Can you add a timestamp field in your table? This field will be updated upon insertion and updates. On Thu, 01 Apr 2004, Jeff Cook wrote: Is there any way to see what date a record was changed on? I am building a database of mostly imported CSV files. The files would be imported on the day

Weird Error message

2004-04-01 Thread Jason Chuong
Hi All, has anyone seen this error message before 040331 0:26:00 ft_read_next: Got error 127 when reading table ./ 040331 0:26:38 ft_read_next: Got error 127 when reading table ./ 040401 0:23:10 ft_read_first: Got error 127 when reading table ./ 040401 0:23:19 ft_read_next: Got error

Re: starting mysql daemon

2004-04-01 Thread muhammad alqama
hello it is now running .. thank everyone who helped me ... many many thanks regards alqama - Original Message - From: Michael Stassen [EMAIL PROTECTED] Date: Thu, 01 Apr 2004 12:13:43 -0500 To: muhammad alqama [EMAIL PROTECTED] Subject: Re: starting mysql daemon

Create Table Syntax

2004-04-01 Thread Khashan
I am looking at the syntax for creating table( section 6.5.3 of the manual): CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] and: create_definition: part-1 (- inserted by me for reference) col_name type [NOT NULL | NULL]

Re: Weird Error message

2004-04-01 Thread Rhino
It would really help if you could tell us at least which version of MySQL you are using. It might also help to know which OS you are using and what command you issued to get this error message. Rhino - Original Message - From: Jason Chuong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Manual for MySQL control centre

2004-04-01 Thread Colin.Beeke
Dear Sir/Madam, I am looking for a manual for MySQL Control Centre, so that I may supply it to the students I teach. Do you have such an items or can offer any assistance. This I hope will assistance the students in their learning for a Module called Internet Programming, for which we use MySQL

Re: Create Table Syntax

2004-04-01 Thread Rhino
- Original Message - From: Khashan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 1:04 PM Subject: Create Table Syntax I am looking at the syntax for creating table( section 6.5.3 of the manual): CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

2004-04-01 Thread Pahlevanzadeh Mohsen
I didn't found hostname.pid file. SOS SOS --- J.R. Bullington [EMAIL PROTECTED] wrote: The next step is to shutdown mysqld, delete the mysql and temp tables from your /data/ folder, and then re-run the scripts/mysql_install_db. That will reinstall the mysql/hosts.frm, which will basically

Re: starting mysql daemon

2004-04-01 Thread Hadi Ariwibowo
- Original Message - From: muhammad alqama [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 10:49 PM Subject: Re: starting mysql daemon hi the error mentioned in the file is... fatal error : can not open privilege tables can not find file :

Calculation in a mysql column

2004-04-01 Thread Mike R
I am using mysql 4.0.16. Is it possible to put a calculation of two other columns as the default value for a third column? Like: time = decimal 3,2 rate = decimal 3,2 totals = default is time * rate Thanks, -Mike -- MySQL General Mailing List For list archives:

MySQL in vxWorks ?

2004-04-01 Thread Juan Romano
We are considering porting mySQL to vxWorks. Can anybody offer some advice or references ? May be somebody has done this already. The intention is to use a trimmed down version of mySQL with HEAP tables. Only a very basic set of features would be used. ODBC is a requirement. I'd appreciate

AW: DB Connection

2004-04-01 Thread Freddie Sorensen
What is the connection type ? ODBC ? -Ursprüngliche Nachricht- Von: Shrikrishna Sathe [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 31. März 2004 12:53 An: [EMAIL PROTECTED] Betreff: DB Connection The following .asp code sinppet gives error. Dim rs Set rs =

Fwd: failure notice

2004-04-01 Thread Tina Gross
Hi. This is the qmail-send program at lists.mysql.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: Sorry, no mailbox here by that name. (#5.1.1) --- Below this line is a copy

Re: group by order by rand() problem

2004-04-01 Thread Michael Stassen
Right. You're grouping by user_id and throwing in title, and you're hoping to influence which of the titles is chosen to go with user_id, but as title is neither part of your group nor part of an aggregate function, its value is undefined. See the manual for an explanation

Renaming an index

2004-04-01 Thread Chad Attermann
Hello, Through some strange quirk in my MySQL console application (an older version of PHPMyAdmin), 4 indexes that I created on different columns of a table all resulted in indexes with the same keyname, that of the first column that was indexed. The field of each index is correct, just the

Re: Create Table Syntax

2004-04-01 Thread Khashan
Thanks for the reply. It seems like the syntax for create_table/create_definition should have 2 part-2 modifiers 1- one part-2 'column' modifiers for the each column. and 2- another part-2 table modifiers for the table as a whole ? ( at the end of column definitions). two questions: -- Are

Handling threads

2004-04-01 Thread Mikel -
Hi list, I'm having the following problem when I tried to connect to MySQL server through terminal mysql client it displayed Can't create thread errno (11) , I worked around the variables thread_stack and thread_cache_size, its initial value was 64KB for thread_stack and 20 for

Re: Handling threads

2004-04-01 Thread Victor Pendleton
When this happens are you able to ping the MySQL server? The literal error message is Resource temporarily unavailable Have you looked in the hostname.err file to see if anything else is being logged? On Thu, 01 Apr 2004, Mikel - wrote: Hi list, I'm having the following problem when I tried

question on autoincrement

2004-04-01 Thread Amit Wadhwa
Hi All, I was wondering if there was a way in mySQL wherein I tell the autoincrement spec where to start from? Eg. Autoincrement startfrom 1 And the values go in as: 10001..10002 and so on,.. instead of 1..2..3.. ..like sequencing in oracle… Any help is appreciated, Thanks Amit Wadhwa Data

MYSQLOUTPUT

2004-04-01 Thread Seena Blace
Hi, I'm getting output like select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from host a,ipdet_temp1 b,makemodel c,software d,hsdet e - where a.hostid=b.hostname2 and a.makemodel=c.makemodelid and a.hostid=e.host_id and e.software_id=d.softwareid and

RE: question on autoincrement

2004-04-01 Thread joe collins
similar-ish to setting your sequence in oracle try this: The create table statement below will start the auto increment at 1 CREATE TABLE TableX ( X_primary_key INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, X_col1 VARCHAR(20) NOT NULL, X_col2 VARCHAR(40) NOT NULL, X_col3 VARCHAR(10) NOT

Re: InnoDB Deadlock cannot find free slot for undo

2004-04-01 Thread Bryan Heitman
No, we did not run out of disk space, we had 102GB free using reiserfs partition. We are running all the defaults for transactions, so we have REPEATABLE-READ as our tx_isolation. We should have allowed enough time for this transaction to finish, this is in a production environment that has run

Re: MYSQLOUTPUT

2004-04-01 Thread Victor Pendleton
Are you just wanting to remove the header information? If so, then try mysql --skip-column-names On Thu, 01 Apr 2004, Seena Blace wrote: Hi, I'm getting output like select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from host a,ipdet_temp1 b,makemodel c,software

Re: question on autoincrement

2004-04-01 Thread Victor Pendleton
Try this: When you add an AUTO_INCREMENT column, column values are filled in with sequence numbers for you automatically. For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table option. See section

FreeBSD stacksize problem, possibly?

2004-04-01 Thread Nick Gaugler
I am running mysql-standard-4.0.18-unknown-freebsd4.7-i386-linuxthreads and I am unable to achieve more than 440 connections. I receive the common Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug. Now, I have

[Fwd: Re: compiling with icc]

2004-04-01 Thread Yonah Russ
Hi all- Here is more info on compiling mysql with icc 8 from the mysql packagers list- As for my attempts, I compiled successfully a couple times and the first benchmark I did was faster than the gcc compiled server by about 10%- unfortunately, I can't say if this is a conculsive test since the

Re: [Fwd: Re: compiling with icc]

2004-04-01 Thread Yonah Russ
sorry- typo- the gcc binary was 4.0.18 yonah Yonah Russ wrote: Hi all- Here is more info on compiling mysql with icc 8 from the mysql packagers list- As for my attempts, I compiled successfully a couple times and the first benchmark I did was faster than the gcc compiled server by about 10%-

FileMaker Pro compared to MySQL

2004-04-01 Thread Justin Tulloss
I am currently using FileMaker Pro for a relatively large database and I am wondering how to speed it up. Would MySQL speed things up? Is FileMaker in some way inferior to MySQL? If so, how? Would it be easy to use a FileMaker plugin to access the MySQL database, or should I write a PHP front?

retrieve ignored records from LOAD DATA INFILE IGNORE

2004-04-01 Thread Will Lowe
Is there anyway to get mySQL to generate a warning or other info when it ignores a row via LOAD DATA INFILE IGNORE? I'm happy having the duplicates ignored but ideally would like to log which records were dupes in a place I can find them again. -- thanks,

5.0 InnoDB problem - ADD CONSTRAINT

2004-04-01 Thread Matt Chatterley
Hi folks. I have a problem creating a foreign key constraint which I just don't seem to be able to figure out. There are three tables, for which the 'show create' output is given below: CREATE TABLE `users` ( `UserID` int(11) unsigned NOT NULL auto_increment, `ContactID` int(10) unsigned NOT

MySQL upgrade tips

2004-04-01 Thread Mike Blezien
Hello, we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18 via the RPM's on a RH/Linux system,... can we retain all the user privileges and databases without loosing any data and our user privileges after the upgrade... we do have backups of all the databases. Is

Re: MYSQLOUTPUT

2004-04-01 Thread Seena Blace
Victor I want output like noname amt 1 10 20 instead of below noname amt 1 10 1 20 thx Victor Pendleton

MySql SQL Help

2004-04-01 Thread Ramesh
Hi, Need a SQL/Design help. I have a table as follows: ORDER_HISTORY -- ORDER_ID | ORDER_NAME | ORDER_AMOUNT | ORDER_DATE -- 10 | Order 1| 20.00| 10-Jan-2003 11 | Order 2| 200.00 |

Re: MYSQLOUTPUT

2004-04-01 Thread Rhino
Can MySQL actually produce result sets like the ones Seena wants? In DB2, which I know a lot better than MySQL, DB2 doesn't produce such a result set by itself; you use a program like QMF to suppress the duplicate information on the rows and replace them with blanks. Is there an equivalent

Re: MySql SQL Help

2004-04-01 Thread Rhino
I can't suggest a complete solution but I think the answer is going to start with the week() function. See http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1403. You're lucky; figuring out which week a date belongs to was something I had to do in DB2 a few years back. The user was on

What Is LIMIT? and How to Use LIMIT?

2004-04-01 Thread Caroline Jen
I saw somebody has MySQL statement this way: StringBuffer sql = new StringBuffer(512); sql.append(SELECT ThreadID, ForumID, MemberName, LastPostMemberName, ThreadTopic, ThreadBody); sql.append( FROM + TABLE_NAME); sql.append( ORDER BY + sort + + order);

Re: What Is LIMIT? and How to Use LIMIT?

2004-04-01 Thread Johan Hook
Hi, I guess this is for a java.sql.PreparedStatement as the '?' seem to indicate that. LIMIT limits ;-) the number of rows retrieved, i.e. LIMIT 10, 20 gives you 20 rows starting at row 20 in the resultset and LIMIT 10 gives you the first 10 rows. See: http://www.mysql.com/doc/en/SELECT.html

Re: MySQL upgrade tips

2004-04-01 Thread Egor Egorov
Mike Blezien [EMAIL PROTECTED] wrote: Hello, we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18 via the RPM's on a RH/Linux system,... can we retain all the user privileges and databases without loosing any data and our user privileges after the upgrade... we

Re: Re: Message

2004-04-01 Thread pbarakos
Here is the file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

query-cavhe questions revisited

2004-04-01 Thread Mark
I recently just upgraded to MySQL 4.0.18. I still have a few questions about the new query-cache. Since I am new to the query-cache, I really hope someone has some answers. The documentation says: The FLUSH TABLES statement also flushes the query cache. What does that mean exactly? Does it mean