looping error message

We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql 3.23.49 on a Sun Solaris machine. Every now and then, one of the scripts we are runing gives the following error message: null: DBD::mysql::st fetch failed: fetch() without execute() at

Need help with a query..

Hi ppl, I have already tried the 'rtfm', but it just didn't help. I have a table: +-++--+ | key | desc| value | +-++--+ | 1 | book| 4 | | 2 | book| 7 | | 3 | book| 5 | | 4 | pen | 4 | | 5 | pen

Re: Deleted all users from MYSQL. What to do now?

* Mike S [EMAIL PROTECTED] [2003-12-21 23:13 +0100]: By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Restart mysqld with the --skip-grant-tables option. Then you can log in again and fix your user table. For details,

Re: Need help with a query..

Tibby wrote: ..and I want to get this with a single query: +-++--+ | key | desc| value | +-++--+ | 2 | book| 7 | | 6 | pen | 7 | +-++--+ I need to get only one row from col. DESC, the one with the highest VALUE.

Re: Need help with a query..

Hi, I have already tried the 'rtfm', but it just didn't help. But it's right there :) 3.5.2 The Row Holding the Maximum of a Certain Column ..and I want to get this with a single query: +-++--+ | key | desc| value | +-++--+ | 2 | book|

innodb questions (backup and transactions)

Hey Guys, I have just a couple of questions regarding the innodb database type that I'd appreciate any advice with. I'm currently developing a custom shopping cart / backend and, due to the nature of such a system, would like to take advantage of transactions - so innodb seems the logical

Re[2]: Need help with a query..

Hi, select key, desc, value from your_table t1 where value = (select max(value) from your_table where desc = t1.desc) Anyway, when i execute this query, i get an error near 'select max(value)'... :( It's because the subselects are supported from version 4.1. If you use older MySQL

Re: Need help with a query..

* Aleksandar Bradaric select key, desc, value from your_table t1 where value = (select max(value) from your_table where desc = t1.desc) Anyway, when i execute this query, i get an error near 'select max(value)'... :( It's because the subselects are supported from version 4.1.

GRANT CREATE/DROP

Hi all, I've got a number of users who have their username on the format 'x_n' where x is a string and n is a one-decimal number. I want them to have full access to one, and only one, database. That means, they should be able to do CREATE TABLE but not CREATE DATABASE. When I give the

Re: Quering user privileges

Plinio Conti [EMAIL PROTECTED] wrote: Is there a way to query the privileges of current user if he hasn't the rights to read the mysql system tables (user, db, hosts, etc..) I mean, I CAN'T give a standard user the chance of read system tables! But my client app wants to know if the

Re: GRANT CREATE/DROP

Niklas Saers [EMAIL PROTECTED] wrote: I've got a number of users who have their username on the format 'x_n' where x is a string and n is a one-decimal number. I want them to have full access to one, and only one, database. That means, they should be able to do CREATE TABLE but not

% vs localhost in user.host

I am running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) on RedHat 6.2 (so shoot me, I'm using an old scratch computer so I won't break anything on the real development machine) I tried to create a user by inserting directly into mysql.user. When I set user.host to localhost, it

Re: Cannot login as root to mysql

Mike S [EMAIL PROTECTED] wrote: I had an account mike to mysql. But somehow I change the password. So now I have just one access to the system as root. Trying to login to mysql as root with password and without password no success. Root password is: 123456. What I'm doing wrong? I cannot

Re: converting tables MyISAM to InnoDB

Unknown Sender [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I recently upgraded from MySQL v3.23 to MySQL 4, and converted my tables from MyISAM to InnoDB by using the ALTER TABLE command. I did this for 16 tables. I know that MyISAM creates seperate data/index files for

InnoDB size against MyISAM size

Hello, My HDD is running low and I MyISAM tables are keep crashing... I think that converting to InnoDB will be more stable, but what about the data files sizes? convertion to InnoDB will need more or less disk space than MyISAM? -thanks, Eli -- MySQL General Mailing List For list archives:

InnoDB file data size against MyISAM files data sizes

Hello, My HDD is running low and I MyISAM tables are keep crashing... I think that converting to InnoDB will be more stable, but what about the data files sizes? convertion to InnoDB will need more or less disk space than MyISAM? -thanks, Eli -- MySQL General Mailing List For list archives:

Replication Question

Is it possible to have 2 database on one server replicating from the same Master server? In other words. DB01 is the Master on System01, System02 has DB01_rep1 and DB01_rep2, each with their own replication from DB01. I need to do this to have a development copy of DB01 on System02. I have

RE: Convert MS Access to MySql

Hi Arthur, Dbtools is a free product and it will do the conversion for you. http://www.dbtools.com.br/EN/index.php We have had success converting from MSAccess to MySQL in the past with it. Regards, Matt -Original Message- From: Arthur Klimowicz [mailto:[EMAIL PROTECTED] Sent:

Re: InnoDB file data size against MyISAM files data sizes

In my experience, I see about a 2x increase in space required between MyISAM and InnoDB. I believe this may be documented btw, check the InnoDB section of the manual. I have been using InnoDB for a couple years now on databases up to 180GB. InnoDB has been very robust and I have only once come

Re: More OS X/mySQL problems

Have you run mysql_install_db? Does the mysql user have full permissions (read, write, execute) on the mysql data directory you created with mysql_install_db? - Gabriel On Dec 20, 2003, at 9:00 AM, Jon Pearse wrote: ... you can tell that this isn't going my way at all ... I've got mysqld

Re: Replication Question

On Mon, 22 Dec 2003, Jeff McKeon wrote: Is it possible to have 2 database on one server replicating from the same Master server? yes. In other words. DB01 is the Master on System01, System02 has DB01_rep1 and DB01_rep2, each with their own replication from DB01. Shouldn't be a problem. I

Mysql on Solaris 8/9 with ultrasparc

Mysqlians, Greetings .. I am at my wits end trying to find a performance problem with 4.0.16 on solaris 9 with 4 ultrasparc III process (sunfire v880). I would be much obliged if the Mame's and Sir's out their with this setup(or similar) would share with me their show variables or

reset auto_increment

Hi, can the auto_increment value be reset back to '1' withou recreate the entire table again ?? The table would be emptied first, but we would like to reset the auto_increment value back to '1' without having to drop and recreate the table, if possible. MySQL version 4.0.15 Linux TIA --

AW: Convert MS Access to MySql

Arthur Get DBManager Professional (for free) here : http://www.dbtools.com.br/EN/dbmanagerpro.php There is a wizard which can do this conversion for you Freddie -Ursprüngliche Nachricht- Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 21. Dezember 2003 19:00

Replication Rollback

Hello everybody. I have a clarification/solution to request. I am currently in the process of designing a web application with JBoss 3.2.2 and MySQL 4.0.16. The application is a data centric application with huge list of products (tens of thousands). Sets of products are grouped into

Re: AW: Convert MS Access to MySql

question... does anyone know how it sets up the indexes, security preferences , relationships..??? I mean does it do this or does it just create the tables and upload the data??? Thanks Tom T At 06:01 PM 12/22/2003 +0100, you wrote: Arthur Get DBManager Professional (for free) here :

Query syntax.

Hi, I'm having problems with the syntax of a select statement. I have two tables linked together by account number. The first table (Users) looks similar to this |User_Account | User_Name | User_Address |X10010100110 | Michael Smith | 1000 North Main St |X10010100240 | David

Re: Query syntax.

Select User_Account from Users as a, Devices as b WHERE a.User_Account = (Select DISTINCT(b.Device_Account) from b.Devices WHERE b.Device_Name LIKE 'HP%' ) I'm running 3.23.49 which I know is not the most current..it was installed 3.x does not support

RE: Replication Question

-Original Message- From: Tobias Asplund [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 11:21 AM To: Jeff McKeon Cc: [EMAIL PROTECTED] Subject: Re: Replication Question On Mon, 22 Dec 2003, Jeff McKeon wrote: Is it possible to have 2 database on one server

RE: AW: Convert MS Access to MySql

Thanks everyone for great advice! Tom's question below is also interesting. Also, are there data compatibility/integrity issues moving from Windows/MS Access to Linux/MySql? I know that Linux is case sensitive and MySql wants dates to be stored as -mm-dd. Does anyone know of other issues?

Re: Query syntax.

Will Lowe wrote: Select User_Account from Users as a, Devices as b WHERE a.User_Account = (Select DISTINCT(b.Device_Account) from b.Devices WHERE b.Device_Name LIKE 'HP%' ) I'm running 3.23.49 which I know is not the most current..it was installed 3.x does not

Query is running slow that was running fast last week.

This query below is running REALLY slow. The indexes and EXPLAIN result are below. Last week this query was running in 20 sec, now it takes so long (20 mins). No I reloaded all the data from the oe-invoice table over the weekend. as I do every weekend. I have noticed that sometimes the query

Re: Replication Rollback

Karthikeyan, replication poses no problem here. MySQL does not write to the binlog transactions which are rolled back. Thus, a replication slave will never perform the steps in a transaction which is rolled back in the master. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign

Re: innodb questions (backup and transactions)

Russ, you can also use mysqldump --single-transaction to back up InnoDB type tables. The advantage of InnoDB Hot Backup over that method is that InnoDB Hot Backup takes binary backups of the ibdata files. Restoring a binary backup is much faster than a table dump. Best regards, Heikki Tuuri

Re: Database rollback doesn't work

Monica, I think there was no transaction support in MySQL-2.3.2. You should use MySQL-4.0 and an InnoDB or BDB type table. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB

Re: Replication Rollback

Hi Heikki, The basic problem is that I have committed the transaction and then replicated to another DB. Now I want to rollback the committed transaction. Is there a way to rollback to a particular point. This requirement is very similar to rolling back using save points. I guess an option would

Re: % vs localhost in user.host

* Warren Burstein [EMAIL PROTECTED] [2003-12-22 15:43 +0100]: I tried to create a user by inserting directly into mysql.user. When I set user.host to localhost, it works, when I set it to % it doesn't. I thought % matched anything, and so should match localhost. mysqld will ignore rows with

Re: Quering user privileges

Thank you! That is what I was looking for! Unfortunatly that command is not SQL 92 or SQL 99 standard, isn't it? (at least I guess, after I quick search in my ANSI files, BTW I think if they had put in MySQL documentation a note for each SQL command where is specified standard compliance that

Re: Quering user privileges

The manual page at http://www.mysql.com/doc/en/SHOW_GRANTS.html says: To list grants for the current session one may use CURRENT_USER() function But if I run SELECT SHOW GRANTS FOR CURRENT_USER(); I get syntax error (Error 1064). While if I run directly SELECT SHOW GRANTS FOR [EMAIL

mySQL Installation!!

Hello List: This is my first post you can easily figure out that I am a complete newbie to mySQL. I have a fresh install of RH9 on a (test) server. It also has mySQL 3.23 installed (part of RH9). My question is: 1) Considering the above setup, do I upgrade (and How?) from 3.23 to 4.0.?? 2) or

MySQL 4.0.17, PHP, and RPMs

Hi, I would like to have MySQL 4.0.17, Apache, and PHP with access to MySQL, all this on a Linux server. So far I have RedHat 8.0 and MySQL 4.0.17 installed. I would like to know if there are any Apache and PHP RPM packages that I could install on top of this. I did try 2.0.40 and 2.0.48 on the

Re: MySQL 4.0.17, PHP, and RPMs

Zsombor Papp wrote: Hi, I would like to have MySQL 4.0.17, Apache, and PHP with access to MySQL, all this on a Linux server. So far I have RedHat 8.0 and MySQL 4.0.17 installed. I would like to know if there are any Apache and PHP RPM packages that I could install on top of this. I did try

Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH

On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote: Hi Mark, I'll tell you what I know. :-) First, AVG_ROW_LENGTH is only needed for dynamic row-length tables (it's ignored with fixed-length rows) -- more specifically, those with TEXT/BLOB columns. And VARCHAR/VARBINARY. Jeremy --

Re: % vs localhost in user.host

On Mon, Dec 22, 2003 at 04:43:07PM +0200, Warren Burstein wrote: I am running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) on RedHat 6.2 (so shoot me, I'm using an old scratch computer so I won't break anything on the real development machine) I tried to create a user by inserting

Re: reset auto_increment

Mike, set insert_id=1; can the auto_increment value be reset back to '1' withou recreate the entire table again ?? The table would be emptied first, but we would like to reset the auto_increment value back to '1' without having to drop and recreate the table, if possible. Regards

Re: MySQL 4.0.17, PHP, and RPMs

I did try to install php-mysql-4.3.4-1 (I just noticed that I mistyped the PHP version numbers below, I tried 4.2.x and 4.3.4-1), and everything else the RPM dependency checks were complaining about. I gave up when it looked like I would have to install two conflicting versions of openssl to avoid

Re: MySQL 4.0.17, PHP, and RPMs

Zsombor Papp wrote: I did try to install php-mysql-4.3.4-1 (I just noticed that I mistyped the PHP version numbers below, I tried 4.2.x and 4.3.4-1), and everything else the RPM dependency checks were complaining about. I gave up when it looked like I would have to install two conflicting

Re: MySQL 4.0.17, PHP, and RPMs

--- John Nichel [EMAIL PROTECTED] wrote: Zsombor Papp wrote: I did try to install php-mysql-4.3.4-1 (I just noticed that I mistyped the PHP version numbers below, I tried 4.2.x and 4.3.4-1), and everything else the RPM dependency checks were complaining about. I gave up when it

Re: looping error message

On Mon, Dec 22, 2003 at 11:05:23AM +0200, Malka Cymbalista wrote: We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql 3.23.49 on a Sun Solaris machine. Every now and then, one of the scripts we are runing gives the following error message: null: DBD::mysql::st fetch failed:

[LONG] Connector/J SQLState 0S100 usage/meaning

Hi, i'm trying to write a java application which handle SQLException correctly. To achieve that i use declarations found in sqlstate.h and SQLError.java. Note that if someone have a good URL about SQLState error codes i'm really interested. then i've greped Connector/J source for SQLException

What am I doing wrong????

Hello List: Please point to what am I doing wrong: I am trying to install MySQL on top of RH9. I am following steps outlined MySQL official documentation from Section 2.3.1 titled Quick Source Installation Overview. These are the steps I have performed: # cd /usr/local Download:

Install Question : DB does not start.

If there is a better place to post this question please advise. I am following the instructions from mysql.com. to start the server I type the following command as 'root' ./bin/safe_mysqld --user=mysql The following error displays: Starting mysqld daemon with databases from

MYSQL 3.22.30 data missing

Hello, We run MYSQL 3.22.30 on a TRU64 alpha server(4.0F). Our scripts found corruption on one of our tables. The script tried to automatically clear the corruption but failed. Then we cleared the corruption by manually running isamchk -r.Everything seemed okay until we tried to pull data

Re: Install Question : DB does not start.

You may find the location of the log files by executing: % mysqladmin variables | grep datadir Under this directory you will find a fle named hostname.err. That file will give some info on what's happenning. Hope this helps you, -Teresa

Replication failover question.

Hi, I have a question regarding failover in a master/slave replication enviroment. Any advice/comments/links to materials are very much appreciated! Setup: Server A is Master, B is Slave. Upon A's failure, all clients requests are routed to B. Question: Upon recovery of A, how do I configure it

Bind on Unix Socket: Permission Denied

I just installed the server and I am getting this message in the mysql.log when I execute: ./bin/safe_mysqld --user=mysql Thanks in Advance. Alex- __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree --

Re: Bind on Unix Socket: Permission Denied

On Mon, 22 Dec 2003, Aleksei Wolff wrote: I just installed the server and I am getting this message in the mysql.log when I execute: ./bin/safe_mysqld --user=mysql Hi Alex, You might want to check the permissions of your /tmp directory. Is it drwxrwxrwt? :) Regards, Tan Shao Yi -- MySQL

Re: [LONG] Connector/J SQLState 0S100 usage/meaning

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gilles Magnier wrote: Hi, i'm trying to write a java application which handle SQLException correctly. To achieve that i use declarations found in sqlstate.h and SQLError.java. Note that if someone have a good URL about SQLState error codes

BUG: Innodb, Assertion failure in file log0log.c with 4.0.!7

There is a MySQl/Innodb bug with Mysql-Max 4.0.17 on mac osx 10.3 panther. A google search showed a similar problem with another platform (I think it was windows). I am running 4.0.14 without any problems. After upgrading to 4.0.17, copying the data directory from 4.0.14 to 4.0.17 and then

Re: looping error message

Hi Malka, Kindly re-install the Calendar DBD-mysql Perl Packages, problem will be resolved. -Aman. ITSSG -Vetri Software, Lason Inc., Malka Cymbalista wrote: We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql 3.23.49 on a Sun Solaris machine. Every now and then, one of the

100,000,000 row limit?

I was informed that MySQL has a 100,000,000 row limit. Is this true? We were planning to use MySQL for an inventory system. However, our current data (rows) for 1 year for one area is already 8.8 million. We want to place data for 5 years for 7 areas. This would exceed 100,000,000. Is there a