Re: mysql_real_query.... probably asked a lot

Eric Smith wrote: OK, I'll bet you guys get a lot of this one, but I can't seem to find the answer in the archives. I have binary data that I want to store in a longblob. This is just byte data null bytes are possible. So, I use mysql_real_query. How do I format the char* query string?

Re: It's party time!

On 2/25/06, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > I'm sorry to say, there won't be any version for Linux. Not this > year, at least. > > You can, however, connect to MySQL running on a Linux host. > > Martijn Tonies Too bad. Do you provide the winbox so that I can connect? 'Cause I've noth

mysql_real_query.... probably asked a lot

OK, I'll bet you guys get a lot of this one, but I can't seem to find the answer in the archives. I have binary data that I want to store in a longblob. This is just byte data null bytes are possible. So, I use mysql_real_query. How do I format the char* query string? Here's the wa

Re: Debian and "localhost.localdomain"

On 26.02.2006 00:10 (+0100), Yves Goergen wrote: I've been trying to get MySQL to work on Debian 3.1 but it won't let my newly created users connect. I added users like "[EMAIL PROTECTED]" and when one tries to connect to the server, it says "[EMAIL PROTECTED]" is not allowed to connect. I supp

Re: Debian and "localhost.localdomain"

On 26.02.2006 00:24 (+0100), Sam Tran wrote: What do you have in your /etc/hosts file? 127.0.0.1 localhost debian31 (and some IPv6 stuff that all begins with "ip6-") There was a "localhost.localdomain" in that file, too, which I already removed, but that didn't help. -- Yves Go

Re: Debian and "localhost.localdomain"

On 2/25/06, Yves Goergen <[EMAIL PROTECTED]> wrote: > I've been trying to get MySQL to work on Debian 3.1 but it won't let my > newly created users connect. I added users like "[EMAIL PROTECTED]" > and when one tries to connect to the server, it says > "[EMAIL PROTECTED]" is not allowed to connect.

Debian and "localhost.localdomain"

I've been trying to get MySQL to work on Debian 3.1 but it won't let my newly created users connect. I added users like "[EMAIL PROTECTED]" and when one tries to connect to the server, it says "[EMAIL PROTECTED]" is not allowed to connect. I suppose it's a Debian 3.1 issue since it worked on De

Fw: Re[2]: using WHERE and OR in a query

I'm putting this discussion back in the mailing list where it belongs; that way other people can contribute suggestions and learn from the discussion, either now or in the future via the archives. -- Is there any possibility the Update is doing exactly what your SQL is telling it to do? You'r

using WHERE and OR in a query

Why does this query not work using mysql 3.23.58? The query is updating all records with no regards to the WHERE clauses. Do I need to do separate updates for each WHERE clause? $SQL = This is the end of the internet.

Re: using WHERE and OR in a query

Define "not work": do you mean you get a compile error? A runtime error? Or a result that differs from what you expected? If you got an error message, please state the full message text. If the result simply differed from what you wanted, please give us a small sample of data, your expectation

using WHERE and OR in a query

Why does this query not work using mysql 3.23.58? $SQL = This is the end of the internet. Please turn around and go back. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Problem installing mysql on Debian linux

Thanks for the reply Sam, :-) I'm using Debian 3.1 I thought that termcap libraries where into ndevel package, which i installed. Where can i find the termcap libraries. Do i have to do something special in the configure of termcap or mysql? I need a version of mysql < 4.1.0 because i need to in

Re: Problem installing mysql on Debian linux

On 2/25/06, Tselemegkos Grigorios <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to install mysql 4.0.25 from source on Debian linux without root > privileges. > The problem comes when i execute the configure command. > I typed: > configure --prefix /home/grtsel/mysql > > and the output error was

Problem installing mysql on Debian linux

Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix /home/grtsel/mysql and the output error was: checking for FIONREAD in sys/ioctl.h... yes checking for TIOCSTAT in sys/i

RE: error 1016 : cant open ibd file even though it exists

I do not use Innodb tables at the moment, so all this is pure speculation. Is/was the server connected to a UPS when the power failure happened? If so, did the UPS function properly and do you have any UPS logs to match against the mysql error log? Things to check for would be the time the

Re: It's party time!

> On Friday 24 February 2006 09:14, Martijn Tonies wrote: > > And we're handing out the presents... > > > > A 5-year celebration of our developer tool Database Workbench. > > > > The MySQL module was added recently, so are the MS SQL > > Server and Oracle modules. > > > > >From this Monday until

Re: error 1016 : cant open ibd file even though it exists

Rithish, ok, then the most probable explanation is that someone had edited my.cnf earlier, when mysqld was running. When mysqld was restarted, it read the new my.cnf, and got confused. Please ask your sysadmins to scan the file system of the computer if they can find another ibdata1 file or

RE: error 1016 : cant open ibd file even though it exists

Hello David. There was supposed to be a power outage in our office that day. So the server was shut down. Finally when the power was back, the machine was plugged on. That's all. No file system change. Nothing. Regards, Rithish. -Original Message- From: David Logan [mailto:[EMAIL PROT

Re: error 1016 : cant open ibd file even though it exists

Hi Rithish, After reading Heikkis points, I am inclined to agree. Did your sysadmins change a filesystem during the maintenance? Did they forget to restore a directory if they changed disks? What was the maintenance that was performed? Your InnoDB files disappeared at some point because the s

RE: error 1016 : cant open ibd file even though it exists

The mysql server was shut down for maintenance. However it was a graceful shutdown and restart. That's all. No files were touched or removed. How could this have happened, I fail to see. Regards, Rithish. -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Friday, Febru