One Slave Many Master
I know someone already ask this, and the answer generally 'NO YOU CANT' :b but, is there any work around so i can make a backup server (slave), from many other server (master) through replication? well, it's not just a backup server actually.. it really is the headquarter's db server, and the branch offices can not directly post their transaction.. because the line is teriblyy sllw :D so, im thinking of adding extra server on branches and replicate what ever happens there to the main server perhaps, if i can run multiple mysql server on different port on the main server, with it's own database, that act as a slave one to one to other server, and add one more that handle all of the DB .. Main ServerBranch ----- DB1, 3306 DB1, 3306, BranchServer1 DB2, 3307 DB2, 3307, BranchServer2 DB3, 3308 DB3, 3308, BranchServer3 DB4, 3309 DB4, 3309, BranchServer4 and so on... MASTER DB(DB1,DB2...DBn) on port 33xx is this possible??? or maybe there are other solution.. pleasseee.. i really appreciate it oh, one more thing, can the replication run both way? what ever happened on machine A, replicated on machine B and vice versa.. thanks... -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com
Please. i need help compiling mysql under CYGWIN
Can you send me the configure file + makefile configured for cygwin ? Version 3.23.58 please thanks alot!
Re: Forms Reports like I use in MS Access
Me I use VB for the front end development and MySQL for the database. I use ADO to connect to the database through MyODBC. When you use VB to connect to a MySQL database, there are two things that will change: * the connection string * the cursor location will be set to adUseClient. Read the MyODBC manual and you will get enough information about how you can use VB with MySQL. Also, consider joining the MyODBC mailing list. Thanks Emery - Original Message - From: Ed Leafe [EMAIL PROTECTED] To: Adam Jones [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, December 28, 2003 16:07 Subject: Re: Forms Reports like I use in MS Access On Dec 28, 2003, at 4:49 AM, Adam Jones wrote: When building Access DBs, I write VB code, SQL, develop DBs using 3rd N.F. and build lovely forms for data entry, print outs, reports etc, etc. After examing MySQL's material, I don't see any forms like I use in Access. So what GUI should I use and how do I link the SQL to things like command buttons, check boxes, drop-down list etc? You could use Access. ;-) MySQL is a database; Access is a database with a form and report designer. With MySQL you can use any front end you like that can 'talk' to the database engine. In my case, I used Visual FoxPro for many years, because of its pure object-oriented design tools, but I got tired of being limited by the file-based data access of products like VFP and Access and the limited security of those products. I now use VFP as the front end and MySQL as the back end exclusively, and my apps are better than they ever were. I have a powerful object-oriented design tool that allows me to create not only the GUI for my apps, but also has the power to create a strong middle tier of business objects that contain the logic that governs the data. I'd recommend VFP, but if you are already fluent in Access, you would probably be better off using that for your GUI. You connect to the data via ODBC or OleDB, and then use the data normally. And if you ever move away from the world of Windows development, there are several choices on Linux and OS X that I'm sure others will chime in with. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- 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: newbie question about calculations
Why do you want to store the results of a calculation? Don't store the results of a calculation, instead do the calculation when you are retreiving data. For example SELECT field1, field2, field1 + field2 AS sum_of_the_two_fields FROM your_table Also, it is a good idea to give good names to your fields. Not Field1, Field2, Your names are very confusing. It is like giving birth to three boys and you name them Boy1, Boy2, Boy3 Would you do that? The last question will be why you defined the fields as VARCHAR while it seems they will be holding numeric values. If the will be holding INTEGERs or FLOATs, define them accordingly. The manual will easily teach you about the data and field types. Hope this will help you Thanks Emery - Original Message - From: daryl hansen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 27, 2003 10:59 Subject: newbie question about calculations Please excuse me if I do not use the correct terminology for what I am trying to descibe. I am new to mySQL and am using FileMaker and Lass to export Filemaker data for use with mySQL. How do you make a field that is the sum of two other fields in the same record? I have riffled through the mySQL manual, but I still have no clue on how to make calculation fields. Right now I have FileMaker talking to mySQL 4.0.15 using the JDBC driver and a SQL plug-in for Filemaker. And it is working very well, for static data, But Anyway, this is a sample of my current code to create my Table called, cart: CREATE TABLE Cart ( ID bigint(20) NOT NULL auto_increment , Field1 varchar (5) , Field2 varchar (5) , Field3 varchar (5) , KEY `ID` (`ID`) ) And code to input data into the table: INSERT INTO cart ( Field1, Field2, Field3 ) VALUES ( '1', '1', '2') How do I make Field3 a calculation, which equals 2 if fields 1 2 where values set to 1? Any pointers in the right direction would be sincerely appreciated. Aloha, Daryl Hansen -- 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]
extending a database over several servers
Hi, Is it possible to extend a MySQL database over several servers in such a way that when space is exhausted on one server, a second machine can be added and used? Cordially, Daniel Page
Re: MySQL 5.0.0 has been released
Hi, is there any change in data format for MySQL 5.0.0? Is it safe (for a user of stable 4.0.17) to test 5.0.0 on existing data and then go back to 4.0.17 for production? Thanks, Thomas On Wed, 24 Dec 2003, Michael Widenius wrote: Hi, MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reinstall error
I reinstalled my entire system and then reinstalled mysql again. Making sure I went through the correct set-up this time. I have set a root password and now when I go to /usr/local/mysql and type in mysql -u root -p it says that mysql is not a found command. What do I do, can I completely uninstall it or reset the password for the database, or run through the installation again without issues? Please help Very frustrated user!! Rob Snow -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Reinstall error
Rob Snow wrote: I reinstalled my entire system and then reinstalled mysql again. Making sure I went through the correct set-up this time. I have set a root password and now when I go to /usr/local/mysql and type in mysql -u root -p it says that mysql is not a found command. Your shell can't find mysql file under your PATH env var. echo $PATH; This var could be updated throught your profile file. Good luck. Ruslan. You also can use full path to mysql, like: /usr/local/mysql/bin/mysql -u root -p What do I do, can I completely uninstall it or reset the password for the database, or run through the installation again without issues? Please help Very frustrated user!! Rob Snow -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem trying to connect to MySQL server
I'm having a problem with one of our MySQL servers. Setup VPN with Firewall at main office (iptables), remote office currently has 2 MySQL servers and their port numbers are 3306 (server1) and 3309 (server2) Programmer accesses server1 okay from his location, but cannot access server2. He will be moving data from server1 to the new server2. Error msg: error no. Can't conect to mysql server at '192.168.0.15' (10061). Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: One Slave Many Master
On Mon, 29 Dec 2003, Leo wrote: I know someone already ask this, and the answer generally 'NO YOU CANT' :b but, is there any work around so i can make a backup server (slave), from many other server (master) through replication? You could run a server instance per database replicated and use the same data-dir (be careful of conflicting writes, however, you probably want to enable-external-locking, especially if they share any data). oh, one more thing, can the replication run both way? what ever happened on machine A, replicated on machine B and vice versa.. That works fine, just be aware of the problems that can arise if this is not taken into consideration since the replication is asynchronous read the Q: What issues should I be aware of when setting up two-way replication? part at http://www.mysql.com/doc/en/Replication_FAQ.html thanks... -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld-max startup unusual error
David W. Brown [EMAIL PROTECTED] wrote: Hello mysql list, I have recently incurred an unusual error. Attempts to startup mysqld-max fail with the following error: 031226 17:02:08 Error message file 'e:\mysql\share\english\errmsg.sys' had only 192 error messages, but it should contain at least 237 error messages. Check that the above file is the right version for this program! 031226 17:02:08 Aborting The error makes sense because the daemon is looking a errmsg.sys file in an unexpected directory location. Set correct path to the error message file with --language option of mysqld. -- 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: Core Certification
Hi Arjun, I have taken both exams (July and August 2002). The best advice I can give you is to get your hands on the Mysql Certificate study guide coming out in 2 months (from Paul Dubois). I had the chance to preview bits of it and I believe that it will be a VERY good help. Just read through it carefully and playaround with the system at the same time to practice the read things. The exam which I was taking was beta at that time. It was hard but fair I felt. Take your time when reading the guide question the details mentioned (or not) in the book to get a really good grasp of the subject. Thats the best you can do, do get into the exam relaxed and without any unneccesary pressure. Best regards Nils Valentin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 28, 2003 4:51 AM Subject: Core Certification Hello everybody ! I have question regarding the MySQL core certification. Does anybody have any general insights on taking the exam ? I am studying from the manual, but I am pretty nervous about the exam as I don't know how much in depth the questions will be or even if studying from the manual alone will be sufficient. I would appreciate any thoughts or comments from anyone about the exam.Thanks ! -- 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]
Not able to connect to mysql by mysql_connect()
Hi, I am trying to connect mysql through .php script. Following is the php code. ### MYSQL_CONNECT(localhost, x, xxx ) OR DIE(Unable to connect to database); @mysql_select_db(xxx) or die(Unable to select database); ### I get following warning : Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /usr/local/apache2/htdocs/Display_squiddata.php on line 99 Unable to connect to database. I then tried mysql_real_connec() as per documentation as follows : ## MYSQL mysql;mysql_init(mysql);mysql_options(mysql,MYSQL_OPT_COMPRESS,0);mysql_options(mysql,MYSQL_READ_DEFAULT_GROUP,odbc);if (!mysql_real_connect(mysql,host,user,passwd,database,0,NULL,0)){ fprintf(stderr, Failed to connect to database: Error: %s\n, mysql_error(mysql));} The above requests the client to use the ## 1) I want to use mysql_connect() to connect to database whcih I am using all these days. 2) If there is any problem due to new version of mysql. Please guide how to use function mysql_real_connect(). Please guide me to URL which will give values for using mysql_real_function. I am have installed mysql as follows : MySQL-client-4.1.1-0.i386.rpm MySQL-server-4.1.1-1.i386.rpm Help appreciated. I don't know what should be values - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square
Re: MySQL 5.0.0 has been released
Hi, First of all, thanks a lot. I have installed MySQL 5.0.0 on my test machine (Suse Linux 8.2 kernel 2.4.20 i586) and have populated data (~40 InnoDB tables with max. 50 000 000 rows) So far it works stable and I didn't have any big problem, but I have found that speed of inserting data is ~3-5 times slower in comparison with version 4.0.14 (the same my.cnf config-file and the same PC). Is it because binary distribution of 5.0 version is not optimized? Thank you in advance, Mikhail. On Wed, 24 Dec 2003, Michael Widenius wrote: Hi, MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Not able to connect to mysql by mysql_connect()
If you are the one controlling the MySQL server, do one of the following: 1. Shorten the Password Column of the mysql.User table 2. Change your password to use the old passwords (you may use SET password=OLD_PASSWORD('your_password'); 3. Put the option --OLD-PASSWORDS in your options file 4. Update the User table using the OLD_PASSWORD() function [for example UPDATE mysql.User SET password=OLD_PASSWORD('your_password') WHERE User='your_username' AND Host='your_host'] Just do one of the above and your problem will be solved until PHP releases a version that supports the new authentication protocol used by 4.1 Also, reading the manual will give you more hints. Thanks Emery - Original Message - From: ads mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 29, 2003 15:42 Subject: Not able to connect to mysql by mysql_connect() Hi, I am trying to connect mysql through .php script. Following is the php code. ### MYSQL_CONNECT(localhost, x, xxx ) OR DIE(Unable to connect to database); @mysql_select_db(xxx) or die(Unable to select database); ### I get following warning : Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /usr/local/apache2/htdocs/Display_squiddata.php on line 99 Unable to connect to database. I then tried mysql_real_connec() as per documentation as follows : ## MYSQL mysql;mysql_init(mysql);mysql_options(mysql,MYSQL_OPT_COMPRESS,0);mysql_op tions(mysql,MYSQL_READ_DEFAULT_GROUP,odbc);if (!mysql_real_connect(mysql,host,user,passwd,database,0,NULL,0)){ fprintf(stderr, Failed to connect to database: Error: %s\n, mysql_error(mysql));} The above requests the client to use the ## 1) I want to use mysql_connect() to connect to database whcih I am using all these days. 2) If there is any problem due to new version of mysql. Please guide how to use function mysql_real_connect(). Please guide me to URL which will give values for using mysql_real_function. I am have installed mysql as follows : MySQL-client-4.1.1-0.i386.rpm MySQL-server-4.1.1-1.i386.rpm Help appreciated. I don't know what should be values - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: extending a database over several servers
Yes and no.. mySQL itself cannot do this.. If you need to keep growing in size (on 1 server) you may want to look at some kind of LVM disk array/SAN you can keep plugging in disks and extending the volume.. I do kinda of what you are looking for with 1 application, but it is all software controlled, mysql has no knowledge it's happening. There is 1 controller sql server that controls all the storage, it knows of multiple other sql servers and decides where to store data and where all the data is for retrevial. You need more storage, plug in another server, tell the controller it exists and it will start filling up with data and serving requests for that data. On Mon, 29 Dec 2003, Daniel Page wrote: Hi, Is it possible to extend a MySQL database over several servers in such a way that when space is exhausted on one server, a second machine can be added and used? Cordially, Daniel Page -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem trying to connect to MySQL server
Maybe port 3309 is not open on the firewall or there is no rule set for it or it is blocked. I am not a network expert though!!! Thanks Emery - Original Message - From: Jon Miller [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Monday, December 29, 2003 13:44 Subject: problem trying to connect to MySQL server I'm having a problem with one of our MySQL servers. Setup VPN with Firewall at main office (iptables), remote office currently has 2 MySQL servers and their port numbers are 3306 (server1) and 3309 (server2) Programmer accesses server1 okay from his location, but cannot access server2. He will be moving data from server1 to the new server2. Error msg: error no. Can't conect to mysql server at '192.168.0.15' (10061). Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd -- 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]
Cannot connect on the internet...Do I need to open a port on my router?
Hello all, This might not be a mysql problem, but I just need clarity. My Mysql is sitting on port 3306. I have a router that sits in front of my server. Do I need to open the port number on my router for my suystem to work well? Right now, the only port opened on my router is 80 for Apache. The following are pertinent information for my system Router -WAN IP 216.49.74.183 LAN IP 192.168.1.1 Server LAN IP 192.168.1.22 Sever DNS entry 192.168.1.22 - Microsoft recommended Windows 2000 Advanced Server with Active Directory and Local DNS Apache 2.0.47 PHP 4.3.2 Mysql 4.0.13 Geeklog 1.3.8 Gallery 1.4 Is there any entry in mysql configuration that I need to edit to move from my localhost to my website on the internet. I can only see my site locally on the webserver but not on the internet. Since my initial installation was done before I had access to the internet via DSL, do I need to edit anything now that I have the DSL installed? Am I supposed to share any of my directories to make my site work? Please I am desperate.. Ola -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie Question - can I collapse these two queries into one line?
MySQL Gurus, Hello, I am new to this list. I have looked through the archives and online, but the particulars of my situation still leave me perplexed as to how to solve this. It may be more of a lack of ability to logically sort my query than it is an issue of syntax. I have three tables. One records members and information about them, such as their email addresses. Another table keeps track of classes that the members attend, and in that table is the date of the classes. The third table records when a member is attending a class. What I want to be able to do is select all the email addresses of all the students who attend a class on a particular date. If I do it as a two step process in PHP, it works: $wsQuery = SELECT improvwsid FROM improvws WHERE wsdate ' . $today . ' AND wsdate ' . $sevenDays . ' AND cancelled = 0; $wsResult = mysql_query($wsQuery); $wsid = mysql_result($wsResult, 0, improvwsid); $emailQuery = SELECT members.email AS email, members.firstname AS firstname, members.lastname AS lastname FROM members, improvwsattend WHERE members.id = attend.attendeeid AND attend.improvwsid = . $wsid; $emailResult = mysql_query($emailQuery); While this is getting the job done, it doesn't sit right because it feels like I'm being inefficient. There must be a way to get the results I want in one query. But not only can I not figure out how to do that, I'm at a loss as to how to describe where my thinking is going wrong. Any help would be much appreciated. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot connect on the internet...Do I need to open a port on my router?
If remote clients will connect directly to your MySQL server then you will need to open port 3306. If you are only going to access MySQL via server side scripts (PHP) then you will not need to open this port as the scripts will connect to the localhost. If you cannot see your web site then it sounds like a configuration problem with Apache. You might check your Apache config file. You might also check your firewall and router settings to make certain that port 80 is open. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.0 has been released
Hi! On Dec 29, Thomas Spahni wrote: Hi, is there any change in data format for MySQL 5.0.0? Is it safe (for a user of stable 4.0.17) to test 5.0.0 on existing data and then go back to 4.0.17 for production? As far as I know it should be safe. But, of course, a backup is always recommended :) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!
Hi! On Dec 28, Derek J wrote: Hello Every Body , I have been facing a strange problem, that i assume its a mysql bug of some sort. In my datadabase there are 2 tables, if i tried to add any index to them ,any INSERT INTO request status will be - in show processlist- update and will freeze like this forever , and consequently all inserts ot this table stays in the que, untill mysql stops responding. If i drop the INDEX on those tables INSERTS works fine, once i create ANY index except PRIMARY index, INSERTS fails. ALL kind of tricks, like myisamchk, drop table and creating a new one, even moving it to a new machine seems to cause the same problem. Running Mysqld 4.0.16 / 4.0.17 ( tried both) on AMD opteron 2 gig ram using MySQL Binaries on REDHAT AS3. one of The table structures: CREATE TABLE `keywordlog` ( `username` char(40) default NULL, `country` enum('Unknown','Unknown','AD','Andorra','AE',**removed rest of enumerate due to restricton on email size**,'ZW','Zimbabwe') NOT NULL default 'Unknown', `ip` char(15) NOT NULL default '', `time_date` datetime NOT NULL default '-00-00 00:00:00', `keyword` char(50) NOT NULL default '', `refer_url` char(70) default NULL, `request_url` char(70) default NULL, `xmlstatus` enum('HTML','XML') NOT NULL default 'HTML', `bid` char(6) NOT NULL default '', `toolbar` int(1) default '0' ) TYPE=MyISAM; What columns are you trying to index ? What is the index definition ? What does SHOW PROCESSLIST show when there are freezed inserts ? How big is your table ? Can you create a repeatable test case ? Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: One Slave Many Master
Hi Leo, a quick search for multiple daemons at www.mysql.com/doc reveals: http://www.mysql.com/doc/en/Multiple_servers.html This should give you all your answers and make it possible to do what you want. Hope this helps, Ken - Original Message - From: Leo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 29, 2003 2:28 AM Subject: One Slave Many Master I know someone already ask this, and the answer generally 'NO YOU CANT' :b but, is there any work around so i can make a backup server (slave), from many other server (master) through replication? well, it's not just a backup server actually.. it really is the headquarter's db server, and the branch offices can not directly post their transaction.. because the line is teriblyy sllw :D so, im thinking of adding extra server on branches and replicate what ever happens there to the main server perhaps, if i can run multiple mysql server on different port on the main server, with it's own database, that act as a slave one to one to other server, and add one more that handle all of the DB .. Main ServerBranch ----- DB1, 3306 DB1, 3306, BranchServer1 DB2, 3307 DB2, 3307, BranchServer2 DB3, 3308 DB3, 3308, BranchServer3 DB4, 3309 DB4, 3309, BranchServer4 and so on... MASTER DB(DB1,DB2...DBn) on port 33xx is this possible??? or maybe there are other solution.. pleasseee.. i really appreciate it oh, one more thing, can the replication run both way? what ever happened on machine A, replicated on machine B and vice versa.. thanks... -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!
Hello, First, Yes I can create repeatable test case, I still have live server with the same problem. and another Dual opteron server, which i created the same database there as a test to make sure there are no hardware faliures casuing this probles, but i still had the same problem there too. I can give full access to any of MySQL team to check this problem. I had aleaddy 2 DBA's fail to Identify the problem in there. About the kind of index. any index except primary creates this problem. I have tried with index on column only , and on multiple, one index instead of the the multiple i had on the table ( shown below ) . but still same problem. The indexes i have there : mysql show index from keywordlog; +++-+--+-+---+-+--++--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +++-+--+-+---+-+--++--++-+ | keywordlog | 1 | time_date_index |1 | time_date | A |NULL | NULL | NULL | | BTREE | | | keywordlog | 1 | time_date_index |2 | username | A |NULL | NULL | NULL | YES | BTREE | | | keywordlog | 1 | time_date_index |3 | keyword | A |NULL | NULL | NULL | | BTREE | | | keywordlog | 1 | keyword_index |1 | keyword | A |NULL | 10 | NULL | | BTREE | | | keywordlog | 1 | keyword_index |2 | time_date | A |NULL | NULL | NULL | | BTREE | | | keywordlog | 1 | ip_index|1 | ip | A |NULL | NULL | NULL | | BTREE | | | keywordlog | 1 | ip_index|2 | username | A |NULL | NULL | NULL | YES | BTREE | | | keywordlog | 1 | username|1 | username | A |NULL | NULL | NULL | YES | BTREE | | | keywordlog | 1 | username|2 | bid | A |NULL | NULL | NULL | | BTREE | | | keywordlog | 1 | username|3 | time_date | A |NULL | NULL | NULL | | BTREE | | | keywordlog | 1 | bid |1 | bid | A |NULL | NULL | NULL | | BTREE | | | keywordlog | 1 | bid |2 | time_date | A |NULL | NULL | NULL | | BTREE | | +++-+--+-+---+-+--++--++-+ 12 rows in set (0.00 sec) Here is the result of show processlist on the second server where i created the test case: mysql show processlist; ++--+---+--+-+--++--+ | Id | User | Host | db | Command | Time | State | Info| ++--+---+--+-+--++--+ | 2 | root | localhost | donds87_smartppc | Query | 263 | update | INSERT INTO keywordlog (keyword, username, ip, time_date, country, refer_url, request_url, xmlstatus | | 3 | root | localhost | donds87_smartppc | Query | 0| NULL | show processlist| | 4 | root | localhost | donds87_smartppc | Query | 191 | Locked | INSERT INTO keywordlog (keyword, username, ip, time_date, country, refer_url, request_url, xmlstatus | | 5 | root | localhost | donds87_smartppc | Query | 184 | Locked | INSERT INTO keywordlog (keyword, username, ip, time_date, country, refer_url, request_url, xmlstatus | | 6 | root | localhost | donds87_smartppc | Query | 182 | Locked | INSERT INTO keywordlog (keyword, username, ip, time_date, country, refer_url, request_url, xmlstatus | | 7 | root | localhost | donds87_smartppc | Query | 180 | Locked | INSERT INTO keywordlog (keyword, username, ip, time_date, country, refer_url, request_url, xmlstatus | | 8 | root | localhost | donds87_smartppc | Query | 180 | Locked | INSERT INTO keywordlog (keyword, username, ip, time_date, country, refer_url, request_url, xmlstatus | | 9 | root | localhost | donds87_smartppc | Query | 179 | Locked | INSERT INTO keywordlog (keyword, username, ip, time_date,
Help on Select/Join
Hello I work on this problem for three days now and could not find any tip in any manual, book, tutorial or search engine. I have the following problem: Table1 'pl': +---+---+ | p | o | +---+---+ | 1 | 1 | | 2 | 1 | | 3 | 2 | +---+---+ Table2 'ln': +---+--+---+ | p | l | v | +---+--+---+ | 1 | 'de' | 9 | | 1 | 'en' | 8 | | 1 | null | 7 | | 2 | 'en' | 6 | | 2 | null | 5 | | 3 | null | 4 | +---+--+---+ Now my problem: how to write a statement to select all 'p' and 'v' from 'pl' and 'ln' where 'o=1' and 'l=de' or 'l=null if l=de is unavailable'. The result is shown below: +---+---+ | p | v | +---+---+ | 1 | 9 | | 2 | 5 | +---+---+ Because I will do this on quite huge tables, an analysis on client side would be possible but would result in megabytes of data transferred while the database server is quite big and bored :) Thanks for you help. Ah, before I forget: I use MySQL server v4.0 and being not able to use 4.1 or 5.0 -- +++ GMX - die erste Adresse für Mail, Message, More +++ Neu: Preissenkung für MMS und FreeMMS! http://www.gmx.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INNOB error and mysql won't start
Hello, I have a problem that started. I am getting this error in /var/log/messages 31229 12:44:47 Can't init databases 031229 12:44:47 Aborting 031229 12:44:47 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete 031229 12:44:47 mysqld ended in the /etc/my.cnf I have all the innodb statement remmed out. I accidently deleted the ibdata and iblogfile files. How can I fix this. ? Thanks Mark the newbie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INNOB error and mysql won't start
Hi! What version of MySQL you are running? Is the output below ALL you get into the .err log? In = 4.0 you can disbale InnoDB by putting the line skip-innodb to my.cnf. 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: M.D. DeWar [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 29, 2003 7:36 PM Subject: INNOB error and mysql won't start Hello, I have a problem that started. I am getting this error in /var/log/messages 31229 12:44:47 Can't init databases 031229 12:44:47 Aborting 031229 12:44:47 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete 031229 12:44:47 mysqld ended in the /etc/my.cnf I have all the innodb statement remmed out. I accidently deleted the ibdata and iblogfile files. How can I fix this. ? Thanks Mark the newbie -- 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: MySQL 5.0.0 has been released
Hi! It is NOT safe to upgrade to 5.0 and then downgrade to 4.0 again. http://www.innodb.com/ibman.php IMPORTANT NOTE: if you upgrade to InnoDB-4.1.1, you cannot downgrade any more! That is because earlier versions of InnoDB are not aware of multiple tablespaces. InnoDB-5.0.0 is essentially the same as InnoDB-4.1.1. 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: Sergei Golubchik [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 29, 2003 5:13 PM Subject: Re: MySQL 5.0.0 has been released Hi! On Dec 29, Thomas Spahni wrote: Hi, is there any change in data format for MySQL 5.0.0? Is it safe (for a user of stable 4.0.17) to test 5.0.0 on existing data and then go back to 4.0.17 for production? As far as I know it should be safe. But, of course, a backup is always recommended :) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ 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: Problem with mysql_close() API
hi, i had same problem. But after I put mysql_free_result(MYSQL_RES *pResult) after fetching rows from query (or generaly after calling all queries), it was OK without this message. I think there is a problem when you allocate memory for result of a query (with mysql_store_result(MYSQL *myData)), and you dont call mysql_free_result() to free this allocated memory, than memory leaks are detected, and Access Violation Error proceed. - Original Message - From: Leo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 29, 2003 7:24 AM Subject: Problem with mysql_close() API Hi All, i have a problem everytime i call the function mysql_close(), it result in Access Violation Error in module libmysql.dll fyi, im migrating from 3.23.52 to 4.0.x server runs under linux, im accesing the server through windows based application built with delphi, using Object Pascal translation from C API (by Jorge del Conde) with the library i took from mysql directory the flow is similiar like this: mysql_init(@myconnection); mysql_real_connect(@myconnection,...); ... some proccess ... mysql_close(@myconnection); -- this is where the error raised i slip in mysql_init before mysql_close, and the problem disappear.. mysql_init(@myconnection); mysql_real_connect(@myconnection,...); ... some proccess ... mysql_init(@myconnection); mysql_close(@myconnection); -- this is where the error raised is this normal?? is this how it should be? i've red the manual, and there is none mentioning that i have to do init before cloaing one. thanks for any comment -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help on Select/Join
* Bjoern Wuest I work on this problem for three days now and could not find any tip in any manual, book, tutorial or search engine. I have the following problem: Table1 'pl': +---+---+ | p | o | +---+---+ | 1 | 1 | | 2 | 1 | | 3 | 2 | +---+---+ Table2 'ln': +---+--+---+ | p | l | v | +---+--+---+ | 1 | 'de' | 9 | | 1 | 'en' | 8 | | 1 | null | 7 | | 2 | 'en' | 6 | | 2 | null | 5 | | 3 | null | 4 | +---+--+---+ Now my problem: how to write a statement to select all 'p' and 'v' from 'pl' and 'ln' where 'o=1' and 'l=de' or 'l=null if l=de is unavailable'. Maybe something like this could work: SELECT pl.p,IF(ISNULL(de.v),nu.v,de.v) AS v FROM pl LEFT JOIN ln AS de ON de.p=pl.id AND de.l = 'de' LEFT JOIN ln AS nu ON nu.p=pl.id AND nu.l IS NULL WHERE o = 1 -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Use of Parameters
I need to use this sentence with parameter but I couln't have which is the symbol that is equal to parameter. For instance: SELECT * FROM EMPLOYEES WHERE last_name LIKE ? + % ? means parameter This sentence is right in SQL and also you can use in Access or SQL SERVER but MySql say there is a mistake near to LIKE. What can I do? Mario. Lic. en Cs. de la Computacion Mario Lucero San Luis - Argentina Sucre 692. Depto D3 TE: 54-2652-421219 - Do You Yahoo!? Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo. Visíta Yahoo! Noticias.
Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!
Hi! On Dec 29, Derek J wrote: Hello, First, Yes I can create repeatable test case, I still have live server with the same problem. and another Dual opteron server, which i created the same database there as a test to make sure there are no hardware faliures casuing this probles, but i still had the same problem there too. I can give full access to any of MySQL team to check this problem. I had aleaddy 2 DBA's fail to Identify the problem in there. mysql show table status like 'keywordlog'; +-+-++-+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | ++++--++--- | keywordlog | MyISAM | Fixed | 518 |267 | 138306 | 1146756268031 |77824 | 0 | NULL | 2003-12-27 19:21:28 | 2003-12-28 02:40:00 | 2003-12-27 21:40:36 Great, table is 138306 bytes only - relatively small, that is. Then, the fastest way to get this fixed is to create a bugreport at http://bugs.mysql.com (just copy-paste your first mail and information from the your last reply) and to attach a (compressed) table dump to a bugreport using [Files] tab (mark it private if you want it to be visible to MySQL AB staff only). As far as I understand, the table in the dump should be created without indexes (this is your point, isn't it?), and if one adds to the end of the dump ALTER TABLE keywordlog ADD INDEX ...; INSERT keywordlog ... then mysql keywordlog.dump will hang. Did I understand you correctly ? Then, as I advised above, just create a bugreport and attach a dump (that ends with ALTER TABLE ... ; INSERT ...) to it - with a repeatable test case the bug will be fixed very quickly. No need to waste the time sending emails back and forth and speculating, when your test case is small enough :) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
View Users in MySQL 4
Hello! Got a database I'd like to know what user/s have access to this database. I am able to login to MySQL and can do SHOW DATABASES, Now, I know there's a user supposedly called kong using an specific database. How can I tell if that is so? I am new to MySQL, being this the 1st time I ever use SQL commands. Thanks! __ 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: Use of Parameters
In the last episode (Dec 29), Mario Lucero said: I need to use this sentence with parameter but I couln't have which is the symbol that is equal to parameter. For instance: SELECT * FROM EMPLOYEES WHERE last_name LIKE ? + % ? means parameter Are you sure you want to add two strings together? That's a math operation, and you'll just get zero. You probably want WHERE last_name LIKE concat(?, %) or WHERE last_name LIKE ? , and make sure the string you're passing in has a % at the end. Note that only MySQL 4.1 and above truly support parameters (aka bind variables); if you're using mysql 3.23 or 4.0, your language's database API will have to expand them before sending the query to mySQL. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL/InnoDB-5.0.0 is released
Hi! Due to Christmas, this release note comes late. For MySQL users release 5.0.0 is a milestone: you can now write stored procedures in MySQL. InnoDB in this MySQL release is essentially the same as in 4.1.1, with the bug fixes of 4.0.17 included. Later 5.0.x versions will probably include new space saving table formats for InnoDB. IMPORTANT NOTE: if you upgrade to InnoDB-4.1.1 or higher (like to 5.0.0), you cannot downgrade to a version lower than 4.1.1 any more! That is because earlier versions of InnoDB are not aware of multiple tablespaces. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INNOB error and mysql won't start
yes. InnoDB: Error: log file ./ib_logfile0 is of different size InnoDB: than specified in the .cnf file! 031229 8:54:37 Can't init databases 031229 8:54:37 Aborting 031229 8:54:37 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 8:54:37 /usr/local/libexec/mysqld: Shutdown Complete 031229 08:54:37 mysqld ended 031229 12:44:45 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size InnoDB: than specified in the .cnf file! 031229 12:44:47 Can't init databases 031229 12:44:47 Aborting 031229 12:44:47 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete 031229 12:44:47 mysqld ended Thanks mark - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 29, 2003 12:41 PM Subject: Re: INNOB error and mysql won't start Hi! What version of MySQL you are running? Is the output below ALL you get into the .err log? In = 4.0 you can disbale InnoDB by putting the line skip-innodb to my.cnf. 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: M.D. DeWar [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 29, 2003 7:36 PM Subject: INNOB error and mysql won't start Hello, I have a problem that started. I am getting this error in /var/log/messages 31229 12:44:47 Can't init databases 031229 12:44:47 Aborting 031229 12:44:47 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete 031229 12:44:47 mysqld ended in the /etc/my.cnf I have all the innodb statement remmed out. I accidently deleted the ibdata and iblogfile files. How can I fix this. ? Thanks Mark the newbie -- 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: INNOB error and mysql won't start
Hi! I accidently deleted the ibdata and iblogfile files. InnoDB: Error: log file ./ib_logfile0 is of different size InnoDB: than specified in the .cnf file! You really have not deleted the ib_logfiles from the MySQL datadir. And probably not the ibdata1 file either. If you have already valuable data inserted, best to edit my.cnf so that it agrees with the real ib_logfile size. Or, if you can start from scratch: http://www.innodb.com/ibman.php#Wrong_creation If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all data files, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding .frm files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening. 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: M.D. DeWar [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, December 29, 2003 10:33 PM Subject: Re: INNOB error and mysql won't start yes. InnoDB: Error: log file ./ib_logfile0 is of different size InnoDB: than specified in the .cnf file! 031229 8:54:37 Can't init databases 031229 8:54:37 Aborting 031229 8:54:37 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 8:54:37 /usr/local/libexec/mysqld: Shutdown Complete 031229 08:54:37 mysqld ended 031229 12:44:45 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size InnoDB: than specified in the .cnf file! 031229 12:44:47 Can't init databases 031229 12:44:47 Aborting 031229 12:44:47 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete 031229 12:44:47 mysqld ended Thanks mark - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 29, 2003 12:41 PM Subject: Re: INNOB error and mysql won't start Hi! What version of MySQL you are running? Is the output below ALL you get into the .err log? In = 4.0 you can disbale InnoDB by putting the line skip-innodb to my.cnf. 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: M.D. DeWar [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 29, 2003 7:36 PM Subject: INNOB error and mysql won't start Hello, I have a problem that started. I am getting this error in /var/log/messages 31229 12:44:47 Can't init databases 031229 12:44:47 Aborting 031229 12:44:47 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 12:44:47 /usr/local/libexec/mysqld: Shutdown Complete 031229 12:44:47 mysqld ended in the /etc/my.cnf I have all the innodb statement remmed out. I accidently deleted the ibdata and iblogfile files. How can I fix this. ? Thanks Mark the newbie -- 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: Redhat crash - help needed
Hi again, sorry for replying to my own message, but I found the [obscure] problem. turns out mysql doesn't like getting its gid information from an LDAP server. There is no mention of this in any of the docs I found, but I will do more looking this morning. The solution was to change my nsswitch.conf file from group: files ldap to group: files and this solved things. I think this is dumb and should be fixed/changed in mysql. I now have to have my group definitions on every system, even though the information for users is taken from LDAP. (and yes, I've tried simply creating a local group/user for mysql, but to no avail - so long as the group line contains ldap in nsswitch.conf, mysql falls over). -Dan On Mon, 29 Dec 2003, Dan Goodes wrote: Hi folks, just compiled up mysql-4.0.17.tar.gz on a (stock, basic install) RHEL3 system, and get similar symptoms to something I experienced a while ago with RH9. that is... it compiles fine, but wont start. The ./configure options are: ./configure '--prefix=/opt/local/stow/mysql-4.0.17' '--without-innodb' \ '--without-debug' '--with-extra-charsets=none' '--enable-assembler' \ '--localstatedir=/data/mysql' '--with-mysqld-ldflags=-all-static' The output i get in my error log file is: 031229 13:04:33 mysqld started mysqld got signal 11; 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. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x82a8378 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfff62c8, stack_bottom=0x6a696867, thread_stack=196608, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x66656463 is invalid pointer thd-thread_id=137005528 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 031229 13:04:33 mysqld ended If anybody has any ideas please help. -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Regards, Dan Goodes : Systems Programmer : [EMAIL PROTECTED] Help support PlanetMirror - Australia's largest Internet archive by signing up for PlanetMirror Premium : http://planetmirror.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Foreign Keys in CREATE TABLEs produced by mysqldump
Heikki Tuuri [EMAIL PROTECTED] wrote on 12/24/2003 01:53:07 PM: Michael, this is the question where the valid answer is: upgrade! In which version was this corrected? I'm hesitant to upgrade to the latest and greatest without it being banged on by the masses first.. I have half a dozen or so business applications running w/ this mysql data store, regression testing them would involve an amount of time I can not afford to spend. The 3.23 branch works well for us right now and I have no real need to use 4.0 (feature-wise.) So until 3.23.x is no longer supported or there is a dire need to use 4.x functionality... I can't make a business case justifying the regression test work. MySQL/InnoDB-3.23.57, June 20, 2003 Changed the default value of innodb_flush_log_at_trx_commit from 0 to 1. If you have not specified it explicitly in your my.cnf, and your application runs much slower with this new release, it is because the value 1 causes a log flush to disk at each transaction commit. Thats it! Thanks. -mike
three highest and lowest column values
Hello, from the following Product-table ProductId MarketId CustomerId Type Price ... i would like to get the three highest and lowest prices for each group of ProductId,MarketId Type. How could i do that ??? Many thanks in advance roland
Help with Update statement
Hello, I have a db that a script failed to run against, and becasue of that a column did not get updated. I have a varchar col that has unixtime timstamp in it. That column gets converted to be readable. My problem is I have many rows that need to be updated, but I dont want to re-convert the times that have already been converted. I know from about 61500 and up that the records are partially updated. mysql select start from table where ID =61500; +-+ | start | +-+ | 2003-12-28 00:45:16 | +-+ 1 row in set (0.00 sec) mysql mysql SELECT start,ID FROM table ORDER BY id DESC LIMIT 1; ++---+ | start | ID| ++---+ | 1072603517 | 617168732 | ++---+ 1 row in set (0.01 sec) mysql So now I want to run my update statment, how do I not update the times that have been converted??? Help my current update statement: from script: OID=`echo select ID from $TBLE order by ID desc limit 1; | $MSQL -u$UI -p$PD -h$HT $DB|grep -v ID` echo update $TBLE set start = from_unixtime(start) where ID '$OID';| $MSQL -u$UI -p$PD -h$HT $DB Thanks for your help up front Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
left join-ing for two values
hi how do u create a query to select two diff values of the same column from another table using a left join? i know i'd retrieve them with aliases but where do i set which alias is for which value? here's a simplified version of the tables table1: colours id colour table2: choices id old new old and new are both ids in the 'colours' table. what i wanna do is something like: select id, colours.colour as old1, colours.colour as new1 from choices left join colours on colours.id = old... now here, can an and clause be used so it reads on as... and colours.id = new or do i put another left join? either ways, how do i specify which join / equality is which alias or whateva? i don't wanna use two queries...as far as possible. ty abs ps: i wouldn't be going through all this just for colours ;-) also (unrelated to mysql) ;-) i didn't know that pink's song feel good time is from charlie's angels 2. just saw the video on mtv and realised. my question: the rythym guitar, bass and to some extent, the lead guitar are playing this tune throughout the song, any idea which song it's from? i don't think it's original to that song, anyone know where...? Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
5.0 binary question
I downloaded the 5.0 preview alpha binary for Win32 and installed it - so far, so good. But I don't see anything in the doc on the stored procedure capability (how-to/syntax) and I can't create one within 5.0 (using SQL99 syntax - at least I think/hope so). Is stored procedure capability not available in the provided binaries (maybe it's only in the source tree?)? Just want to make sure I'm not missing something. Thanks, Rick
Re: left join-ing for two values
i wrote: hi how do u create a query to select two diff values of the same column from another table using a left join? i know i'd retrieve them with aliases but where do i set which alias is for which value? here's a simplified version of the tables table1: colours id colour table2: choices id old new old and new are both ids in the 'colours' table. what i wanna do is something like: select id, colours.colour as old1, colours.colour as new1 from choices left join colours on colours.id = old... now here, can an and clause be used so it reads on as... and colours.id = new or do i put another left join? either ways, how do i specify which join / equality is which alias or whateva? i don't wanna use two queries...as far as possible. lol @ me. i decided to use my brains for a change. didn't realise it was staring me in the face. use aliases...for tables too! here's what i've come up with, and works... select choices.id, a.colour as new, b.colour as old from choices left join colours a on a.id = choices.new left join colours b on b.id = choices.old if i put choices.id as just id, i get id is ambiguous (after making all changes to real table and column names) ;-). if 'from' is 'choices', shouldn't mysql assume it's from that itself and not one of the joined tables? abs ps: anyone with an answer to that song question? :P Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
java APIs v.s. c APIs
Happy new year to all: Here is my question: does mysql connector/J has APIs for the same functions as in C api in addition to the java.sql.*? e.g. mysql_insert_id() and etc.? Thanks, chasee - Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: LEFT JOIN help (or come and slap the newbie)
Dan Hansen wrote: is essentially giving me what I need: CREATE TEMPORARY TABLE temptable SELECT state.name AS state , group.name AS group, group.zip AS zip, city.name AS city FROM city, group, zip LEFT JOIN state ON city.state_id = state.id WHERE group.zip = zip.zip AND zip.city_id = city.id; INSERT INTO temptable SELECT name, NULL, -1, NULL FROM state; SELECT state, group, zip, city FROM temptable ORDER BY state, zip, group ; (Once plugged into PHP code, I will replace temptable with a unique code-generated string). Should run in a single query too... SELECT state.name AS state , group.name AS group, group.zip AS zip, city.name AS city FROM city, group, zip LEFT JOIN state ON city.state_id = state.id WHERE group.zip = zip.zip AND zip.city_id = city.id UNION SELECT name, NULL, -1, NULL FROM state ORDER BY state, zip, group ; .. although untested. -do remove the semicolon twice- Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 5.0 binary question
Hi, I have found slides show http://mysql.progen.com.tr/events/uc2003/slides/stored-procedures.pdf and examples in mysql-5.0/mysql-test/t/ - sp.test - sp-error.test Best regards, Mikhail. - Original Message - From: Rick Robinson [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 12:14 AM Subject: 5.0 binary question I downloaded the 5.0 preview alpha binary for Win32 and installed it - so far, so good. But I don't see anything in the doc on the stored procedure capability (how-to/syntax) and I can't create one within 5.0 (using SQL99 syntax - at least I think/hope so). Is stored procedure capability not available in the provided binaries (maybe it's only in the source tree?)? Just want to make sure I'm not missing something. Thanks, Rick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: java APIs v.s. c APIs
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 chasee L. wrote: Happy new year to all: Here is my question: does mysql connector/J has APIs for the same functions as in C api in addition to the java.sql.*? e.g. mysql_insert_id() and etc.? Thanks, chasee Connector/J does not use the MySQL C-API, however it exposes most of the functionality in a JDBC-like way. Funtionality such as mysql_last_insert_id() _is_ exposed via the JDBC-3.0 Statement.getLastGenerated() keys method, or via a 'custom' method of com.mysql.jdbc.Statement.getLastInsertId(). Other MySQL-specfic functionality is exposed in a JDBC-compliant manner. You will have to specify _which_ functionality you're looking for to get any more specific answers (or look in the README for Connector/J). Regards, -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/8MgGtvXNTca6JD8RAuKzAJ99RhTZqDNqZcNy6adgq6OWnUawpQCdEftV tgKMdmd7xxJEcGSpCC+0qZ4= =bQ56 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Log Files in MySQL
I think I am confused. I have many bin index files, but I have not gotten rid of them. I read somewhere that I should not remove them...or I should not remove the entries in the index file. Since I am unsure of which one above is correct, I am posting to the list. Can someone let me know which of the above is correct, and what I should do? Thanks Eric eric wagar glxvr623 on AIM [EMAIL PROTECTED] on MSN
RE: 5.0 binary question
Hi Mikhail- Thanks for responding; the presentation is very helpful; However, I think I may not have been clear enough - I was asking whether the binary alpha 5.0 that is now available from the web site had stored procedure support. I don't think it does as I don't see a catalog table mysql.proc defined and I cannot create any procedures. It's a little odd that 5.0 would be made available as a binary without the primary feature to exercise built into it. Oh well. I still feel like I'm missing something because that just doesn't make sense. Regards, R -Original Message- From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED] Sent: Monday, December 29, 2003 7:18 PM To: [EMAIL PROTECTED]; Mysql Subject: Re: 5.0 binary question Hi, I have found slides show http://mysql.progen.com.tr/events/uc2003/slides/stored-procedures.pdf and examples in mysql-5.0/mysql-test/t/ - sp.test - sp-error.test Best regards, Mikhail. - Original Message - From: Rick Robinson [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 12:14 AM Subject: 5.0 binary question I downloaded the 5.0 preview alpha binary for Win32 and installed it - so far, so good. But I don't see anything in the doc on the stored procedure capability (how-to/syntax) and I can't create one within 5.0 (using SQL99 syntax - at least I think/hope so). Is stored procedure capability not available in the provided binaries (maybe it's only in the source tree?)? Just want to make sure I'm not missing something. Thanks, Rick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: One Slave Many Master
Thank You All for the response, I'll try to set up your recomendation.. I'll post the result back in a few days.. thanks :) -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com
RE: Log Files in MySQL
-Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoyé : Monday, December 29, 2003 8:12 PM À : [EMAIL PROTECTED] Objet : Log Files in MySQL I think I am confused. I have many bin index files, but I have not gotten rid of them. I read somewhere that I should not remove them...or I should not remove the entries in the index file. Since I am unsure of which one above is correct, I am posting to the list. Can someone let me know which of the above is correct, and what I should do? First, please let us know what you are trying to achieve (save space, optimize...). Ugo Thanks Eric eric wagar glxvr623 on AIM [EMAIL PROTECTED] on MSN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Log Files in MySQL
I think I am confused. I have many bin index files, but I have not gotten rid of them. I read somewhere that I should not remove them...or I should not remove the entries in the index file. Since I am unsure of which one above is correct, I am posting to the list. Can someone let me know which of the above is correct, and what I should do? First, please let us know what you are trying to achieve (save space, optimize...). I am trying to save space. I currently have about 70 files in the range of 10-30MB. I have a cron job that does a flush tables every morning at 0600. Thanks Eric
Re: Help with Update statement
--- rmck [EMAIL PROTECTED] wrote: mysql SELECT start,ID FROM table ORDER BY id DESC LIMIT 1; ++---+ | start | ID| ++---+ | 1072603517 | 617168732 | ++---+ 1 row in set (0.01 sec) mysql So now I want to run my update statment, how do I not update the times that have been converted??? Help my current update statement: from script: OID=`echo select ID from $TBLE order by ID desc limit 1; | $MSQL -u$UI -p$PD -h$HT $DB|grep -v ID` echo update $TBLE set start = from_unixtime(start) where ID '$OID';| $MSQL -u$UI -p$PD -h$HT $DB for starters, when u use desc to get ur 'oid', it's already the highest. so when u say where ID '$OID', it won't match any rows. '=' would've atleast matched that one row. unless BOTH the above command run repeatedly after changing the highest value (so then onto the next highest, etc.) in the manual, mysql SELECT FROM_UNIXTIME(875996580); - '1997-10-04 22:23:00' so that part is fine. 2 (low tech) solutions that would work *well* are: 1. check the length of the timestamps. atleast so far, i don't think the no. of seconds would've crossed 19 chars which is the size according the date format returned by FROM_UNIXTIME (when it's without +0). so u can use where length(start) 19 and u'd only need the second command. 2. to be y10k compliant :P do an instr search. since u using that style, there will always be a - or a : (search for : ... just in case some warped -ve values got in there). so use where instr(start, ':') i don't see the point about worrying about the ids. in case some rows were edited in between and the initial query wasn't run with an order by clause, there could be some in between that haven't been reformatted. those two solutions are pretty much foolproof. since some values have already been converted, i think u've made it a varchar(19) or something, i.e. it's length is fine. put semi-colons at the end of my 'where' segments. i guess they're required. of course, these queries will run slower coz u're doing text search stuff rather than a simple id comparison. abs Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binary Log replay utility?
Hi there, Is there a utility out there to do transaction-at-a-time view and/or replay with MySQL's binary log ? Primarily for audit / debug purposes. I'm only interested in using it with the proper database back-end, not ISAM. -- Sam Vilain, [EMAIL PROTECTED] In married life, three is company and two none. OSCAR WILDE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL user in Indonesia
Hi All, im sorry if this mail a bit out of topic =) im currently developing a new system based on MySQL for the company i work on. and i have to report how wide and famous is mysql had been used, especially in indonesia. i need the fact that i can show to my boss, why i choose mysql.. well i have a lot of it, but he demand some example, which company in indonesia had successfully implemented mysql in their core bussiness so please, let me know.. i already run a search at google, but i have trouble determining what kwyword should i use if there is among you that work in a company here in indonesia, please, would you kindly share your experience thanks in advance -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com
Re: MySQL user in Indonesia
My company use it :) PT. Tempo Inti Media Tbk For experience sharing, contact me in private. I believe there're alot of company here using MySQL. Just take a look around. Me fail English? That's unpossible ###___Archon___### - Original Message - From: Leo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 1:24 PM Subject: MySQL user in Indonesia Hi All, im sorry if this mail a bit out of topic =) im currently developing a new system based on MySQL for the company i work on. and i have to report how wide and famous is mysql had been used, especially in indonesia. i need the fact that i can show to my boss, why i choose mysql.. well i have a lot of it, but he demand some example, which company in indonesia had successfully implemented mysql in their core bussiness so please, let me know.. i already run a search at google, but i have trouble determining what kwyword should i use if there is among you that work in a company here in indonesia, please, would you kindly share your experience thanks in advance -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]