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 /usr/local/lib/perl5/site_perl/local/Calendar.pm line 1667. The really annoying thing is that the error message keeps getting written to to the error log until it fills up the disk. We are looking into the source of the error message but I was wondering if anyone has any ideas as to why the error message goes into a loop and if there is anything we can do to stop it. Thanks for any information. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 | 5 | | 6 | pen | 7 | +-++--+ ..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. With one query... Appreciate any suggestions, really. Tibby
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, please refer to http://www.mysql.com/doc/en/Resetting_permissions.html -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. With one query... select `desc`, max(value) from mytable group by `desc` -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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| 7 | | 6 | pen | 7 | +-++--+ select key, desc, value from your_table t1 where value = (select max(value) from your_table where desc = t1.desc) Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 choice. However, I have a couple of reservations... I realise innodb does not have fulltext support built in - is the only way round this to have any data that needs to be fulltext-searched in a myISAM table? I've read that a ROLLBACK after a transaction will not rollback the myISAM tables - so I guess some app logic is required for these special cases. Is my thinking right on this issue? And secondly, I'm a bit worried about backing up innodb tables - more specifically a live backup. I've seen a product innodb sell specifically to do this but I can't really justify the licensing costs. Are there any other options for a live backup? The only others means of backup would be to shutdown the server and copy the data manually I assume? Any pointers to the above two queries greatly appreciated! Russ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 version then it's not possible to do it with a single query :( Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. Yes. If you use older MySQL version then it's not possible to do it with a single query :( Yes, it is. :) URL: http://www.mysql.com/doc/en/example-Maximum-column-group-row.html See the MAX-CONCAT trick. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 CREATE permission, they get to create databases that match x_n where _ is any character. Yet when I remove CREATE permission, they cannot create tables. How do I disable CREATE DATABASE without disabling CREATE TABLE? Here is an example: mysql show grants for 'netto_4'; +--+ | Grants for [EMAIL PROTECTED] | +--+ | GRANT USAGE ON *.* TO 'netto_4'@'%' IDENTIFIED BY PASSWORD '446a37200c856ce9' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `netto_4`.* TO 'netto_4'@'%' | +--+ 2 rows in set (0.00 sec) Cheers Niklas Saers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 current user has (for example) the rights to write on table xxx, because if not, I don't want to let him try and fail, I want to disable the updates in advance. Take a look at SHOW GRANTS command: http://www.mysql.com/doc/en/SHOW_GRANTS.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: 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 CREATE DATABASE. When I give the CREATE permission, they get to create databases that match x_n where _ is any character. Yet when I remove CREATE permission, they cannot create tables. How do I disable CREATE DATABASE without disabling CREATE TABLE? If you want to use '_' character in the database name, you should specify it as '\_' in the GRANT command. For example: GRANT ... ON `netto\_4`.* TO .. Here is an example: mysql show grants for 'netto_4'; +--+ | Grants for [EMAIL PROTECTED] | +--+ | GRANT USAGE ON *.* TO 'netto_4'@'%' IDENTIFIED BY PASSWORD '446a37200c856ce9' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `netto_4`.* TO 'netto_4'@'%' | +--+ 2 rows in set (0.00 sec) -- 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]
% 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 works, when I set it to % it doesn't. I thought % matched anything, and so should match localhost. In case I've missed something in the docs, please direct me to the correct page. I ran this, and it worked -- mysql -u root mysql EOF delete from user where user = 'foo'; insert into user (host, user, password) values('localhost', 'foo', password('bar')); flush privileges; EOF mysql -u foo -pbar EOF quit EOF -- So then I tried the same thing, just changing localhost to %, and the second mysql, where I try to log in as user foo, password bar (I know it's unsafe to put the password on the command line, this is just for testing) says ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -- mysql -u root mysql EOF delete from user where user = 'foo'; insert into user (host, user, password) values('%', 'foo', password('bar')); flush privileges; EOF mysql -u foo -pbar EOF quit EOF -- So I tried adding this line to after the insert select host, user, password from user where user = 'foo'; in case maybe I had botched the insert, or there were other entries in the user table that messed things up. Here's what I got (looks OK to me): hostuserpassword localhost foo 7c9e0a41222752fa hostuserpassword % foo 7c9e0a41222752fa
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 connect to MYSQL as root. [EMAIL PROTECTED] init.d]# mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Check that you type password correctly. If it doesn't help you can reset root password as described at: http://www.mysql.com/doc/en/Resetting_permissions.html [EMAIL PROTECTED] init.d]# mysql -h localhost -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED] init.d]# -- 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: 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 each table and InnoDB uses a single file for data and log. My question is, once Ive converted the tables from MyISAM to InnoDB, can I delete the .MYI and .MYD files for the tables ? Thanks Those files should be deleted automatically by MySQL, but if you still got them, you can delete them, but make sure you really moved to InnoDB type before deleting them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 production software that pulls data from DB01_rep1 and I need to set up DB01_rep2 to do some development work. When I copy the DB01 snapshot into a new database (DB01_rep2) on System02 and then log into that database and do a Show slave status it shows me the slave status information that was set up for DB01_rep1. Is replication System dependant or database dependant? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: Sunday, December 21, 2003 11:00 AM To: [EMAIL PROTECTED] Subject: Convert MS Access to MySql I need to convert an MS Access database to MySql. I would like to know the best way to do this. I was going to write an asp or php script that would read the MS Access db row by row and insert into the MySql db row by row. Is that the only way to move the data from the one db to the other? Many thanks Arthur --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 across a corruption after a crash of the DB or the operating system (linux). Richard On Mon, 2003-12-22 at 09:48, MySQL Support wrote: 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 -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. signature.asc Description: This is a digitally signed message part
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 running. So, I go into the mysql shell and start setting things up again, which is when I start getting some interesting problems. Firstly, 'SHOW DATABASES' doesn't work - -- mysql SHOW DATABASES; ERROR: No query specified -- The same thing happens for 'SHOW TABLES' when you have selected a database - this is for the 'root' user. Secondly, if I try and connect to the server from a PHP script, it looks in /Private/tmp for mysql.sock, rather than /tmp. This was all going so nicely until a couple of weeks ago... now I have a contract looming over my head, it all goes to pot. -Jon --- http://www.jonpearse.net[EMAIL PROTECTED] Some people come into our lives and quickly go. Some stay for a while and leave footprints on our hearts. And we are never, ever the same. --- -- 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: 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 need to do this to have a development copy of DB01 on System02. I have production software that pulls data from DB01_rep1 and I need to set up DB01_rep2 to do some development work. When I copy the DB01 snapshot into a new database (DB01_rep2) on System02 and then log into that database and do a Show slave status it shows me the slave status information that was set up for DB01_rep1. Just make sure that you're not running against the same logfiles/data, so you can have different relay-logs and master.info files. Is replication System dependant or database dependant? Neither, it's server instance dependant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 any kernel or filesystem changes they made. In my particular, case single-threaded tests (sql-bench) compare similar for the sunfire against dual proc 2.4 xeon systems (redhat 9) but under site load the sunfire slows to a crawl. Happy Holidays, Trevor
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 -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 An: [EMAIL PROTECTED] Betreff: Convert MS Access to MySql I need to convert an MS Access database to MySql. I would like to know the best way to do this. I was going to write an asp or php script that would read the MS Access db row by row and insert into the MySql db row by row. Is that the only way to move the data from the one db to the other? Many thanks Arthur -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Categories. These categories are maintained in a hierarchical fashion in the database. There is no restriction on the number of levels that this categories can go to. The requirements are to help an admin user manage product categories and also to be able to bifurcate a category. To cite an example, let us take a category of Toys which has 100 products beneath it. The admin user wants to split the Toys category based on age group. he can split the category into any sub categories ( 3 Yrs - 8 Yrs, 9 Yrs - 15 Yrs, 16+). The admin user will now have to split the 100 products into these categories. He cannot leave any products in the Toys category. There are two risks associated with this: a.. The user doesn't finish the multistep process. (handled by the use of session variables) b.. The admin user needs to test the application (data changes) on a staging environment before he can confirm the changes to production. c.. The admin user needs to be able to roll back changes if he is not satisfied with the changes made. I was planning to use replication. This is described in detail at the url document(http://www.aspiresys.com/karthik/procs.pdf). The process works fine as long as the data is correct. given the approach I would like to know how I can roll the old transaction back. Also I want to know the best method to achieve this. This is pretty important and any help would be highly appreciated. Thanks Karthikeyan B -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 : 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 An: [EMAIL PROTECTED] Betreff: Convert MS Access to MySql I need to convert an MS Access database to MySql. I would like to know the best way to do this. I was going to write an asp or php script that would read the MS Access db row by row and insert into the MySql db row by row. Is that the only way to move the data from the one db to the other? Many thanks Arthur -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Mann Library Cornell University [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Wilson | 1200 State Street The second table (Devices) looks like this |Device_Account | Device_Name| Installaton_Date |X10010100240 | Ultra 5| 19981010 |X10010100240 | HP1055CM | 20010528 |X10010100240 | LEXMARK | 20010529 |X10010100110 | HP1055CM | 20010528 |X10010100211 | HP LJET 4M | 20010528 There is a one to many relationship between users and devices and not all users have devices. I'd like to select a list of User accounts with certain devices. 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 get an error code Error Code:1064 You have an error in your SQL Syntax near 'Select DISTINCT'. I'm running 3.23.49 which I know is not the most current..it was installed with another package. Thanks for any advice. I know my SQL skills are limited! TIA, DB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 subselects (select x from (select y from ...)). You'll need to upgrade to 4.1. -- thanks, Will -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 need to do this to have a development copy of DB01 on System02. I have production software that pulls data from DB01_rep1 and I need to set up DB01_rep2 to do some development work. When I copy the DB01 snapshot into a new database (DB01_rep2) on System02 and then log into that database and do a Show slave status it shows me the slave status information that was set up for DB01_rep1. Just make sure that you're not running against the same logfiles/data, so you can have different relay-logs and master.info files. So I have to do something on the master then to add this second slave on the same system as the first slave? I'm not sure how to set up a separate logfile/data for the second slave... Is this done on the master or slave? Is replication System dependant or database dependant? Neither, it's server instance dependant You mean mysql server as in the software correct? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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? Thanks again Arthur -Original Message- From: Thomas Trutt [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:40 PM To: [EMAIL PROTECTED] Subject: 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 : 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 An: [EMAIL PROTECTED] Betreff: Convert MS Access to MySql I need to convert an MS Access database to MySql. I would like to know the best way to do this. I was going to write an asp or php script that would read the MS Access db row by row and insert into the MySql db row by row. Is that the only way to move the data from the one db to the other? Many thanks Arthur -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Mann Library Cornell University [EMAIL PROTECTED] -- 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: 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 support subselects (select x from (select y from ...)). You'll need to upgrade to 4.1. But 4.1 is alpha, so he may not want to do that (though it would be a good idea to upgrade to 3.23.58 or 4.0.17). In that case, the solution is to replace the subselect with a join, which may even be more efficient. Try: SELECT User_Account FROM Users AS a, Device_Name from Devices AS b WHERE a.User_Account = b.Device_Account AND b.Device_Name LIKE 'HP%' See http://www.mysql.com/doc/en/Rewriting_subqueries.html for more. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 performance to into the weeds for no aparent reason. I did an myisamchk --recovery on the v7_oe-invoice.MYI file, but did not help. I noticed it has a NULL on all of the cardinality fields in the show index command. Does this mead anything? SELECT v7_oe_invoice1.`cust-num`, v7_oe_invoice1.`cust-site`, v7_oe_invoice1.`whs-num`, v7_oe_invoice1.`tax-code`, v7_oe_invoice1.`post-date`, v7_oe_invoice1.`inv-merch`, v7_cust1.`cust-job-num`, v7_cust1.`cust-name`, v7_cust1.`cust-transfer`, v7_tax1.`tax-desc` FROM `v7_oe-invoice` v7_oe_invoice1, `v7_cust` v7_cust1, `v7_tax` v7_tax1 WHERE v7_oe_invoice1.`cust-num` = v7_cust1.`cust-num` AND v7_oe_invoice1.`tax-code` = v7_tax1.`tax-code` AND v7_cust1.`cust-transfer` = 0 AND v7_cust1.`cust-job-num` = 0 AND v7_oe_invoice1.`post-date` = {ts '2003-12-01 00:00:00.00'} AND v7_oe_invoice1.`post-date` {ts '2003-12-22 00:00:01.00'} AND v7_oe_invoice1.`whs-num` = '8' ORDER BY v7_oe_invoice1.`tax-code` ASC, v7_oe_invoice1.`cust-num` ASC | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | | v7_oe-invoice | 1 | idx-oei-oet |1 | oe-tran-num | A |NULL | NULL | NULL | | | v7_oe-invoice | 1 | idx-oei-csn |1 | cust-num | A |NULL | NULL | NULL | | | v7_oe-invoice | 1 | idx-oei-slc |1 | slm-code | A |NULL | NULL | NULL | | | v7_oe-invoice | 1 | idx-oei-cjn |1 | cust-job-num | A |NULL | NULL | NULL | | | v7_oe-invoice | 1 | idx-oei-csi |1 | cust-site| A |NULL | NULL | NULL | | | v7_oe-invoice | 1 | idx-oei-pod |1 | post-date| A |NULL | NULL | NULL | | | v7_oe-invoice | 1 | idx-oei-whn |1 | whs-num | A |NULL | NULL | NULL | | +---++-+--+--+-- -+-+--++-+ and the Explain + | v7_cust1 | ref | idx-cus-csn,idx-cus-cjn,idx-cus-cut | idx-cus-cjn | 5 | const | 14818 | where used; Using temporary; Using filesort | | v7_oe_invoice1 | ref | idx-oei-csn,idx-oei-pod,idx-oei-whn | idx-oei-csn | 9 | v7_cust1.cust-num |10 | where used | | v7_tax1| ALL | NULL| NULL| NULL | NULL | 258 | where used | ++--+-+-+--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: karthikeyan.balasubramanian [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 22, 2003 7:37 PM Subject: 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 Categories. These categories are maintained in a hierarchical fashion in the database. There is no restriction on the number of levels that this categories can go to. The requirements are to help an admin user manage product categories and also to be able to bifurcate a category. To cite an example, let us take a category of Toys which has 100 products beneath it. The admin user wants to split the Toys category based on age group. he can split the category into any sub categories ( 3 Yrs - 8 Yrs, 9 Yrs - 15 Yrs, 16+). The admin user will now have to split the 100 products into these categories. He cannot leave any products in the Toys category. There are two risks associated with this: a.. The user doesn't finish the multistep process. (handled by the use of session variables) b.. The admin user needs to test the application (data changes) on a staging environment before he can confirm the changes to production. c.. The admin user needs to be able to roll back changes if he is not satisfied with the changes made. I was planning to use replication. This is described in detail at the url document(http://www.aspiresys.com/karthik/procs.pdf). The process works fine as long as the data is correct. given the approach I would like to know how I can roll the old transaction back. Also I want to know the best method to achieve this. This is pretty important and any help would be highly appreciated. Thanks Karthikeyan B -- 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: 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 Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Russ [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 22, 2003 1:22 PM Subject: 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 choice. However, I have a couple of reservations... I realise innodb does not have fulltext support built in - is the only way round this to have any data that needs to be fulltext-searched in a myISAM table? I've read that a ROLLBACK after a transaction will not rollback the myISAM tables - so I guess some app logic is required for these special cases. Is my thinking right on this issue? And secondly, I'm a bit worried about backing up innodb tables - more specifically a live backup. I've seen a product innodb sell specifically to do this but I can't really justify the licensing costs. Are there any other options for a live backup? The only others means of backup would be to shutdown the server and copy the data manually I assume? Any pointers to the above two queries greatly appreciated! Russ -- 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: 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 which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, December 19, 2003 6:30 PM Subject: Database rollback doesn't work Hi! I have a simple webapp that allows users to register. The user is inserted in the DB and a confirmation mail is sent to the user. If the mail fails I'd like the DB to rollback the transaction, but it doesn't do it. The new user entry is kept in the DB. I'm using Tomcat 4.1 and mySQL 2.3.2. I include the code, log and server.xml. Thanks for your help. Monica ***CODE: Connection dbCon = null; boolean isSuccess = false; try { //inser user in db dbCon = new DBUtil().getDBConnection(); dbCon.setAutoCommit(false); userDBPopulator.insertEntry(user, dbCon); //send mail to user [snip] isSuccess = true; } //rollback if fail catch (MailException e) { log.error(MailException + e.getMessage(), e); log.debug(trying to rollback and close); try { dbCon.rollback(); } catch (SQLException e1) { log.error(SQLException rollbacking + e1.getMessage(), e1); } try { dbCon.close(); } catch (SQLException e1) { log.error(SQLException closing connection to DB + e1.getMessage(), e1); } } catch (SQLException e) { log.error(SQLException + e.getMessage(), e); try { dbCon.rollback(); } catch (SQLException e1) { log.error(SQLException rollbacking + e1.getMessage(), e1); } try { dbCon.close(); } catch (SQLException e1) { log.error(SQLException closing connection to DB + e1.getMessage(), e1); } throw new ServletException(e); } //commit user entry if( isSuccess){ log.debug(commiting); try { dbCon.commit(); } catch (SQLException e1) { log.error(SQLException commiting + e1.getMessage(), e1); throw new ServletException(SQLException commiting + e1.getMessage(), e1); } try { dbCon.close(); } catch (SQLException e1) { log.error(SQLException closing connection to DB + e1.getMessage(), e1); } } LOG: 2003-12-19 15:44:12,546 DEBUG [Thread-3] (RegisterServlet.java:200) - handle register request 2003-12-19 15:44:12,562 INFO [Thread-3] (UserDBReader.java:202) - No user found with name monica 2003-12-19 15:44:12,578 DEBUG [Thread-3] (MailHelper.java:88) - Sending mail to m 2003-12-19 15:44:12,625 ERROR [Thread-3] (MailHelper.java:121) - Messaging Exception: Sending failed 2003-12-19 15:44:12,625 ERROR [Thread-3] (MailHelper.java:124) - Next Messaging Exception: Invalid Addresses; 2003-12-19 15:44:12,640 DEBUG [Thread-3] (RegisterServlet.java:282) - trying to rollback and close ***SERVER.XML Resource name=jdbc/allukmasterDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/allukmasterDB parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value30/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameusername/name value***/value /parameter parameter namepassword/name value/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter nameurl/name valuejdbc:mysql://myMachine.com/myDB?autoReconnect=true/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter parameter namelogAbandoned/name valuetrue/value /parameter /ResourceParams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
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 be to backup database before changes and restore it if the user is not satisfied with the changes he has made. One transaction in my application would affect 6-8 tables with at least 50 - 100 records getting inserted/updated or deleted. Please advice Karthikeyan B - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 12:36 AM Subject: 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 keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: karthikeyan.balasubramanian [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 22, 2003 7:37 PM Subject: 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 Categories. These categories are maintained in a hierarchical fashion in the database. There is no restriction on the number of levels that this categories can go to . The requirements are to help an admin user manage product categories and also to be able to bifurcate a category. To cite an example, let us take a category of Toys which has 100 products beneath it. The admin user wants to split the Toys category based on age group. he can split the category into any sub categories ( 3 Yrs - 8 Yrs, 9 Yrs - 15 Yrs, 16+). The admin user will now have to split the 100 products into these categories. He cannot leave any products in the Toys category. There are two risks associated with this: a.. The user doesn't finish the multistep process. (handled by the use of session variables) b.. The admin user needs to test the application (data changes) on a staging environment before he can confirm the changes to production. c.. The admin user needs to be able to roll back changes if he is not satisfied with the changes made. I was planning to use replication. This is described in detail at the url document(http://www.aspiresys.com/karthik/procs.pdf). The process works fine as long as the data is correct. given the approach I would like to know how I can roll the old transaction back. Also I want to know the best method to achieve this. This is pretty important and any help would be highly appreciated. Thanks Karthikeyan B -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 wildcarded hostnames in the user table, if a row with a more specific (that is: non-wildcard) hostname matches (too). For example, if your user table has a row with (host=localhost, user=), mysqld will prefer @localhost to [EMAIL PROTECTED] . Remember, that blank username values match ANY username. In case I've missed something in the docs, please direct me to the correct page. http://www.mysql.com/doc/en/Connection_access.html could be a good page to start reading at... If you still have problems with connection verification, please send me the output of 'select Host,User,Password from mysql.user;' . -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 would be greatly appreciated!) Since for the rest my application was standard SQL92... it's a pity bye Plinio On Mon, 22 Dec 2003 15:37:43 +0200 Egor Egorov [EMAIL PROTECTED] wrote: 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 current user has (for example) the rights to write on table xxx, because if not, I don't want to let him try and fail, I want to disable the updates in advance. Take a look at SHOW GRANTS command: http://www.mysql.com/doc/en/SHOW_GRANTS.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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 PROTECTED]; It works. Did you guess why? On Mon, 22 Dec 2003 15:37:43 +0200 Egor Egorov [EMAIL PROTECTED] wrote: 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 current user has (for example) the rights to write on table xxx, because if not, I don't want to let him try and fail, I want to disable the updates in advance. Take a look at SHOW GRANTS command: http://www.mysql.com/doc/en/SHOW_GRANTS.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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 remove mySQL 3.23 from RH9 installation and re-install mySQL 4.0.?? (tar) I have spent better part of today reading the archives but I still have not gotten any satisfactory answer. Please Help!!! Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Apache side and 4.3.x and 4.4.3-1 on the PHP side but it didn't work (for now I will asume that it is a well known fact that these don't work together -- if it's not, then I can provide details of how it didn't work for me). Emphasis is on RPM packages. I did not try to compile the sources, and I would like to avoid doing that if only possible. Nonetheless I would be grateful for any advice, even if it involves compiling. Thanks, Zsombor __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 2.0.40 and 2.0.48 on the Apache side and 4.3.x and 4.4.3-1 on the PHP side but it didn't work (for now I will asume that it is a well known fact that these don't work together -- if it's not, then I can provide details of how it didn't work for me). Emphasis is on RPM packages. I did not try to compile the sources, and I would like to avoid doing that if only possible. Nonetheless I would be grateful for any advice, even if it involves compiling. Thanks, Zsombor You also need to install the php-mysql-4.x rpm -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 directly into mysql.user. Why? The GRANT command is what you probably ought to be using. Anyway... 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. In case I've missed something in the docs, please direct me to the correct page. It's a little funky, but MySQL treads TCP connections differently than local unix socket connections. Using the % wildcard will match any host or IP address connecting via TCP, but not via the local socket. Because the local socket is local, localhost is really the only possibility. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Trevor Rhodes === Powered by Linux- Mandrake 9.2 Registered Linux user # 290542 at http://counter.li.org Registered Machine #'s 186951 Mandrake Club Silver Member Source : my 100 % Microsoft-free personal computer. === 10:13:58 up 17:21, 1 user, load average: 1.42, 1.39, 1.22 -- Never mud wrestle with a pig.. you get dirty and the pig enjoys it! Never try to teach a pig to dance. You waste your time and annoy the pig. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 dependency failures. However, if you actually have a system with MySQL 4.0.17, Apache, and PHP, would you mind to send me the output of 'rpm -qa'? Thanks, Zsombor --- John Nichel [EMAIL PROTECTED] wrote: 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 2.0.40 and 2.0.48 on the Apache side and 4.3.x and 4.4.3-1 on the PHP side but it didn't work (for now I will asume that it is a well known fact that these don't work together -- if it's not, then I can provide details of how it didn't work for me). Emphasis is on RPM packages. I did not try to compile the sources, and I would like to avoid doing that if only possible. Nonetheless I would be grateful for any advice, even if it involves compiling. Thanks, Zsombor You also need to install the php-mysql-4.x rpm -- By-Tor.com It's all about the Rush http://www.by-tor.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 versions of openssl to avoid dependency failures. However, if you actually have a system with MySQL 4.0.17, Apache, and PHP, would you mind to send me the output of 'rpm -qa'? Thanks, Zsombor I don't use RPM's for anything but what the system installs. I've installed Apache (1.3.29), MySQL (4.0.16), php (4.3.4), etc. from source. http://www.by-tor.com/phpinfo.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 looked like I would have to install two conflicting versions of openssl to avoid dependency failures. However, if you actually have a system with MySQL 4.0.17, Apache, and PHP, would you mind to send me the output of 'rpm -qa'? Thanks, Zsombor I don't use RPM's for anything but what the system installs. I've installed Apache (1.3.29), MySQL (4.0.16), php (4.3.4), etc. from source. Yeah, that's what I feared. :) Nevertheless, thanks for the info. I'll do the same unless I find someone who managed to use the RPMs. Thanks, Zsombor http://www.by-tor.com/phpinfo.php __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: fetch() without execute() at /usr/local/lib/perl5/site_perl/local/Calendar.pm line 1667. The really annoying thing is that the error message keeps getting written to to the error log until it fills up the disk. We are looking into the source of the error message but I was wondering if anyone has any ideas as to why the error message goes into a loop and if there is anything we can do to stop it. Thanks for any information. If I had to guess, I'd say there's a loop in your code that's not properly checking the condition(s) that would normally allow it to exit. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[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 throwing. This operation show me some problems. Connector/j throws SQLExeption with an SQLState value of 0S100 which is not used/declared in SQLError.java nor in sqlstate.h. Is this a correct SQLState or a typo ? It's first used for unicode support error, this may be correct but should anyway be declared somewhere: (Note that lines references are for connector/J 3.0.8-stable source code) In Connection.java near line 2049 function checkServerEncoding : // // Attempt to use the encoding, and bail out if it // can't be used // [snip] } catch (UnsupportedEncodingException UE) { throw new SQLException( The driver can not map the character encoding ' + this.encoding + ' that your server is using + to a character encoding your JVM understands. You + can specify this mapping manually by adding \useUnicode=true\ + as well as \characterEncoding=[an_encoding_your_jvm_understands]\ + to your JDBC URL., 0S100); } But it's used elsewhere with really different meaning : In Connection.java near line 2217 function InitializeDriverProperties. This fuction checks that URL parameters are valid if not i think it shoud use sqlqtate 01S00 as declared in SQLError.java line 45 : sqlStateMessages.put(01S00, Invalid connection string attribute); but it use 0S100 : throw new SQLException(socketTimeout can not + be 0, 0S100); this looks like a typo in SQLError.java or in Connection.java. In the same function for other parameters the same problem appears : lines 2224, 2236, 2248 and 2267. Error code 0S100 is used again for Unsupported encoding (same function) line 2296. And again line 1778 in ResultSet.java function getString(int) for unsupported encoding too. I think having identical error code for unsuported exception and bad parameter error is a bit confusing, for me at least ... Thanks for any help, Gilles. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: mysql-standard-4.0.17-pc-linux-i686.tar.gz Note: on RH9 group (mysql) user (mysql) are already there.. # gunzip mysql-standard-4.0.17-pc-linux-i686.tar.gz # tar -xvf mysql-standard-4.0.17-pc-linux-i686.tar # cd mysql-standard-4.0.17-pc-linux-i686 NOW THE PROBLEM = According to the instructions, my next step is: # ./configure --prefix=/usr/local/mysql But I get a message that ./configure is already done This is where I am struck-up for the whole day. Can someone help to direct me to the right direction. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 /usr/local/mysql/data 031222 21:48:50 mysql ended I cant find a log file or anything that can help me pinpoint the issue. Any help is appreciated. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 for certain hours. The select count(*) stattement displays 830 records. However when I execute select * it only displays 150 records. Thanks for any help, -Teresa This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Aleksei Wolff aleksei_wolff To: [EMAIL PROTECTED] @yahoo.com cc: Subject: Install Question : DB does not start. 12/22/2003 09:25 PM 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 /usr/local/mysql/data 031222 21:48:50 mysql ended I cant find a log file or anything that can help me pinpoint the issue. Any help is appreciated. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- 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]
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 to sync with B? The problem is that I can't find out what the bin log and position is from B since show master status is always empty. I guess B still thinks its a slave. Thanks! Winston -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 i'm really interested. then i've greped Connector/J source for SQLException throwing. This operation show me some problems. Connector/j throws SQLExeption with an SQLState value of 0S100 which is not used/declared in SQLError.java nor in sqlstate.h. Is this a correct SQLState or a typo ? It's first used for unicode support error, this may be correct but should anyway be declared somewhere: (Note that lines references are for connector/J 3.0.8-stable source code) In Connection.java near line 2049 function checkServerEncoding : // // Attempt to use the encoding, and bail out if it // can't be used // [snip] } catch (UnsupportedEncodingException UE) { throw new SQLException( The driver can not map the character encoding ' + this.encoding + ' that your server is using + to a character encoding your JVM understands. You + can specify this mapping manually by adding \useUnicode=true\ + as well as \characterEncoding=[an_encoding_your_jvm_understands]\ + to your JDBC URL., 0S100); } But it's used elsewhere with really different meaning : In Connection.java near line 2217 function InitializeDriverProperties. This fuction checks that URL parameters are valid if not i think it shoud use sqlqtate 01S00 as declared in SQLError.java line 45 : sqlStateMessages.put(01S00, Invalid connection string attribute); but it use 0S100 : throw new SQLException(socketTimeout can not + be 0, 0S100); this looks like a typo in SQLError.java or in Connection.java. In the same function for other parameters the same problem appears : lines 2224, 2236, 2248 and 2267. Error code 0S100 is used again for Unsupported encoding (same function) line 2296. And again line 1778 in ResultSet.java function getString(int) for unsupported encoding too. I think having identical error code for unsuported exception and bad parameter error is a bit confusing, for me at least ... Thanks for any help, These definitely look like typos. After the holidays, I will look into a fix for these using constants in SQLError so that typos will no longer be a problem. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/57eUtvXNTca6JD8RApJBAKCo5uV88ZhznDro25Qmm3JgczimNwCgjmXo QYP3EARQXWiQ3oPFUbQoSMM= =5boi -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 starting mysqld I get: --- 031222 22:05:51 mysqld started InnoDB: Error: log file group too small for innodb_thread_concurrency 031222 22:05:51 InnoDB: Assertion failure in thread 2684396012 in file log0log.c line 856 InnoDB: Failing assertion: log_calc_max_ages() InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 10; 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. - Reverting back to 4.0.14 works fine and I get no error messages. Best regards, --j __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 scripts we are runing gives the following error message: null: DBD::mysql::st fetch failed: fetch() without execute() at /usr/local/lib/perl5/site_perl/local/Calendar.pm line 1667. The really annoying thing is that the error message keeps getting written to to the error log until it fills up the disk. We are looking into the source of the error message but I was wondering if anyone has any ideas as to why the error message goes into a loop and if there is anything we can do to stop it. Thanks for any information. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 possible work around for this? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]