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: <

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 hav

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 compan

Re: Help with Update statement

--- rmck <[EMAIL PROTECTED]> wrote: > mysql> SELECT start,ID FROM table ORDER BY id DESC > LIMIT 1; > > ++---+ > | start | ID| > ++---+ > | 10726035

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. >>

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 somewh

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: 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

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 wh

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

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]> Se

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_

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-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 co

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 avai

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 ol

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 t

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

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 d

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

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

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

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

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 string

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 eve

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

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

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': > +---

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)),

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 t

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 I

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/libexe

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 | +---+--+

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

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: <[EM

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

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 recommen

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

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

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

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: pro

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 controll

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

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

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 war

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

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 co

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

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 b

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

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 uninst

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/

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: 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

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 MyOD

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!

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 bra