RE: Bug with multi-table DELETE

Leeuw van der, Tim writes: Hello, Thank you very much for your reply! I was hoping that this was indeed fixed in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to 4.0.1; I will retest the query with 4.0.2 as soon as it's released. Apologies btw for not mentioning the

multithreading and libmysqlclient.so on solaris - need help

Does the library 'libmysqlclient.so' known to work in a multi-threaded environment on Solaris? I'm asking as in my C++ multithreaded program I get segmentation/bug error from time to time. Each of my threads is holding its own persistent connection. I'm using MyODBC. But even after I let each

Re: I need 50.000 inserts / second

At 07:07 PM 5/31/2002, you wrote: Hi Jeremy, I've done some tests grouping the INSERTs in groups of 1000 and 1, and it got very faster, in my Pentium III 700 from job I could get less than 3s. But I'm still doing concatenation to get the INSERT clause in the form values (x,x), (x,x) Is

installation question

Hi After i install mysql, there is a way that i can know on witch drive i installed it on? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

install MySql on drive other than C

Hi all, I read in the manual about building mysql not on c:\ and i found that i need to change the file my.ini my questions are: 1) can i build this file by my self and not with winmysqladmin.exe? 2) it is enough to change this file if i want to put mysql in drive d, or am i need to do another

need help with installation

Hi I am working with Windows NT. I want to install mysql on drive d. Now i need to change the file my.cnf. In the manual they write that i need to put this file in c:\ BUT what if i don't have drive C?? and if now i want to write some program that find out the drive that mysql installed on. how

Re: query problem with GROUP BY and ORDER BY

On Sat, 01 Jun 2002 11:58:38 +0200 Claire Forchheimer [EMAIL PROTECTED] wrote: I know the answer to the first part at least. I think you want to use two columns in the order by clause, and leave out the group by clause. As in: select * from tbl order by apt, name; I'm afraid its too late at

3.23.49 - documentation bug

version 3.23.49. when you have not compiled with --enable-local-infile, you will get $ mysql --help | grep local | wc -l 0 looks like undocumented feature. -- Petr Chloupek [EMAIL PROTECTED] All work and no play makes Jack a dull boy. -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS d-

can't re-start mysql server

Hi All, I've been trying to re-start the mysql server for a while now. A few days ago, I discovered that I couldn't connect to the database after entering my password. I got the usual can't connect via the /tmp/mysql.sock message. I tried to restart the daemon with ./bin/safe_mysqld , but that

Possible bug? MySQL table names

Hi, first of all: I'm currently not reading this mailing list, so if you answer I would be happy to receive a Cc: I'm currently trying to switch a web site on a complete new machine. The old machine was runnig MySQL 3.22.32, the new machine runs on 3.23.49 The application used Phorum for

mySQL Language

Hello everyone. I am trying to add non-Latin text to MySQL. Specifically speaking I need to use Persian fonts. I can add the text in the sql tables with no problem. I can also display them on the generated cgi pages which call those tables. The problem I have is when I go back to edit these

FULLTEXT relevance and phrase searching

The MATCH syntax will return a number indicating the relevance of a particular record to the specified criteria. I would like to generate similar numbers for phrase searches... please read on. I have written code which will generate an SQL query that allows phrase searching (without using IN

Re: I need 50.000 inserts / second

snip INSERT INTO my_table VALUES (foo, foo), (bar, bar), (z, z)... snip From my own experience, by using this method, that is doing one insert per 200 or more rows I can increase the insert speed from between 5x - 10x. A couple more performance improvements where made as well so that value

mysql_ping()

Hi, I've got a function/method in php, where socket communication is used, to determin if a host is live - however - there is drawback, because it's being registered as an invalid connection and the host gets blocked. Now - whether this is acceptable behavior (I can't turn the whole thing off,

RE: core dump, multithreading using MyODBC on Solaris

Hi, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 01, 2002 8:56 AM To: [EMAIL PROTECTED] Subject: core dump, multithreading using MyODBC on Solaris Hello, I'm using MyODBC 3.5 on Solaris. From time to time I get

Re: mysql_ping()

Hi, mysql_ping check connection to server. In documentation at 8.4.3.163 mysql_ping() you can find more details about that. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

Re: mysql_ping()

At 19:53 2-6-2002, Gelu Gogancea shared with all of us: mysql_ping check connection to server. In documentation at 8.4.3.163 mysql_ping() you can find more details about that. Yeah right. Did you actually take a look? Reading the source gives me more information. I know it returns an integer,

Re: can't re-start mysql server

Hi, If you wish to write an server application ...i think, you can be interested about how make settings for a socket (see man 7 setsockopt) But your problem it's so far from thati think, you changed some user access rights and for this reason you can't connect to MySQL server. Try mysql -u

Re: mysql_ping()

Hi, Indeed, mysql_simple_command (with COM_PING command like argument ) is used by C API mysql_ping, to check connection.MYSQL struct it's used like handler. For a connection you must use in order: mysql_init(),-initialise MYSQL struct mysql_options(),- option for

RE: MS Access Queries

well yeah, but the people who are going to be using the databse don;t know PHP and they want to edit the queries in Access, but still be able to access it online, and if they change the queries in Acces, then it won't be changed on the webpage (don't ask my why they want this, i'm just doing a

problems compiling mysql

I have tried this 3 times so far everytime i do a 'make', after a while, i get this message: make[2] *** [my_net.lo] Segmentation fault make[2] Leaving directory '/home/per0xide/mysql-3.23.49/libmysql' make[1] *** [all-recursive] Error 1 make[1] Leaving directory '

Help! (Transfer of table data gone wrong)

Hi, In haste to change some server hardware I copied the /var/lib/mysql directory directly assuming this would suffice in order to carry the data over. I'm pretty certain I stopped mysqld, but regardless I now seem to be missing nearly all the respective .ISM files for my databases. Now, I'm

Re: mysql_ping()

Hi Gelu, At 21:52 2-6-2002, Gelu Gogancea shared with all of us: Indeed, mysql_simple_command (with COM_PING command like argument ) is used by C API mysql_ping, to check connection.MYSQL struct it's used like handler. For a connection you must use in order: mysql_init(),

Re: problems compiling mysql

Hello, As I understood segmentation fault happens during compilation? Segmentation fault happens always at the same point? If not then it is a problem of your memory, try memtest86 to test your memory (not your but your computer :) ) If it always happens at the same point

Re: Help! (Transfer of table data gone wrong)

Hold the phone - I've just realised that those tables 'missing' .ISM files are actually supposed to be MyISAM - (I have complete MYD and MYI files) - not ISAM (ISM, ISD) - how do I tell MySQL this is the case? TIA (Again) /Phil On Sun, 02 Jun 2002 21:28:17 +0100 Phillip Baker [EMAIL

Re: mysql_ping()

Hi, Just now i read carefully your previous maili don't know if is possible to create a socket/used with PHP. In principle a client socket it's some like this: if ((sock=socket(AF_INET,SOCK_STREAM,0))0) --create socket file { .perror(Can't create socket: socket()); .exit(1);

Re: Will we ever get 3.23.50 for Linux????

Mark, - Original Message - From: Mark Hazen [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, June 02, 2002 8:21 PM Subject: Will we ever get 3.23.50 for Linux Monty said this on April 23, 5 1/2 weeks ago: If we don't get any fatal bug reports by the end of the

Re: mysql_ping()

Hi Melvyn, I'm sorry ... i didn't read carefully you mailPHP is great, if you can create socket that mean you can send and receive.data.In fact simple_command with COM_PING do the same thing.I suppose are some function in PHP for handling data.From your code i see the fsockopen returning the

Fw: fault tolerance

What if the MySQL server crashes during an Insert or delete or update statement, In what state would that leave the database, and would MySQL recover? If so how would it do that? If not what would happen, half of the statement would get executed before the crash while the rest is not? Would you

RE: RE: MS Access Queries

Hi !! uhh, this sounds really stupid to be honest :-) My first thought is, If they are so deep in MS junk why should they port to PHP/MySQL in the first place ?? I think it's definitely easier to give then a quick-course in PHP than writing these kind of workarounds... You could maybe write

Re: Fw: fault tolerance

Hi. With MyISAM the table will be marked crashed and you have to repair it (with myisamchk or REPAIR TABLE). In most cases this will simply disregard the last change. There is a low probability that the table is broken in a more serious way and you have to use your last backup (you surely do

Re: mysqldump -A dump.txt

Hi. Which version of mysqldump did you use and what error message do you get? I have never used mysqldump this way but from what I read in the help of mysqldump 3.23.31, mysqldump should insert the necessary SQL statements regarding changing and creating the databases (if they do not already

Re: mysql database quota solution for help!!

Hi. If you want someone to consider answering your problem, you should write in a manner that it is understandable what you want. I.e. give a detailed description of what your requirements are and what you have already considered and why it won't work. Also have a look at the mailing list

Re: INSTALLATION HELP, PLEASE!!

Hi. On Fri 2002-05-31 at 09:19:38 -0400, [EMAIL PROTECTED] wrote: im missing the mysql and mysqladmin binaries after my admin guy installed the most recent stable mysql rpm on a (linux) machine. are these included in the client rpm that he may have missed or is there something new that i

Re: mysql_ping()

- Original Message - From: Melvyn Sopacua [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: MySQL General [EMAIL PROTECTED] Sent: Sunday, June 02, 2002 10:27 PM Subject: Re: mysql_ping() So... you don't need mysql_ping ... unless if want to check periodical if the server is

Re: mysql_ping()

Hi Mark, At 02:04 3-6-2002, Mark shared with all of us: Yes and no. I do want that, but afterwards I want to connect. It still does not look to me like you really want to ping the server. What you seem to want is to check whether the server is alive; and if not, reconnect; right? Connect -

Re: mysql_ping()

Hi Gelu, At 23:10 2-6-2002, Gelu Gogancea shared with all of us: I'm sorry ... i didn't read carefully you mail No problem. Anyway, my opinion is that you should use(i don't know if is possible) the mysql_options to set time out. That works if only mysqld is down and the machine is

Re: mysqldump -A dump.txt

Hi, I didn't get that deeply into why exactly, but it seems that when I removed the mysql database from the file, that the rest went fine with mysql -u -p dumpfile I got an error about the column_prv field already existing I believe. Sorry, I should have been much more specific. I appreciate

Re: mysql_ping()

Melvyn Sopacua wrote: Hi Mark, At 02:04 3-6-2002, Mark shared with all of us: Yes and no. I do want that, but afterwards I want to connect. It still does not look to me like you really want to ping the server. What you seem to want is to check whether the server is alive; and if not,

ENCODE algorithm

What algorithm do ENCODE-DECODE functions use? sql,query -- Best regards, Evgeny mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual)

ANSI mode determination?

Is there any programmatic way (SQL, C-level API) way to determine whether or not a given mysql server is running in ANSI mode or not? If not, this would be most helpful, as otherwise it is impossible to know how to quote identifiers (` or ). -dave /*== www.urth.org we await

Re: ANSI mode determination?

Dave Rolsky wrote: Is there any programmatic way (SQL, C-level API) way to determine whether or not a given mysql server is running in ANSI mode or not? If not, this would be most helpful, as otherwise it is impossible to know how to quote identifiers (` or ). -dave /*==

Syntax dilemma

Hi, I'm having trouble trying to insert form data into a mysql db, the thing is my client wants table data to be splitted, I mean some data comes from the first form, and the rest from another form. This is a portion of the php script. // Add together proper fields to enter birth date

MySQL + cygwin

Anyone have any ideas on how to get MySQL to work under cygwin? I'm especially interested in getting a libmysqlclient which is compatible with cygwin so that I can use it to compile various other program which require the library... Currently, I run mysql 3.23.49-max for Win32 (NT 4.0) because

Re: ENCODE algorithm

At 08:58 PM 6/2/2002, you wrote: What algorithm do ENCODE-DECODE functions use? sql,query -- Best regards, Evgeny mailto:[EMAIL PROTECTED] Evgeny, Encode(),Decode() is for low level security. If you are trying to store passwords use something like MD5() to

innodb_flush_log_at_trx_commit

Hello, in InnoDB tables in MySQL, if innodb_flush_log_at_trx_commit is set to 1, then on COMMIT, the buffer log is flushed to disk log...or the changes are reflected in the disk copy of the database??? i mean what is flushed, the buffer-pool that contains data and indexes or the log-buffer??