HOSTNAME not found error

I've seen this problem posted before but I can't find any replies. When I start the server I get the following ./mysql.server: @HOSTNAME@: command not found ./mysql.server: my_print_defaults: command not found Obviously I've setup something wrong. Running FreeBSD 4.3, Apache 1.3.X, MySQL 3.23.

Re: can't shutdown mysqld (nicely or not) on OS X 10.0.2

Tyler, Thanks for all the info... I'd love to help find the answer, but I don't know gdb (or even what it is, but I have heard those letters before :) So now I can start and "stop" the server... do any of the other issues you mention affect how mysql works for small databases? Thanks, Jim on 5

Re: can't shutdown mysqld (nicely or not) on OS X 10.0.2

Hi Jim, This is a known problem on OS X 10.0.x. I keep meaning to take a look at it, but haven't had the time ( I have to learn gdb and the mysql source first/at the same time). If you are already a familiar with gdb and can help the mysql programmers by finding out more info and/or even a f

Re: images and mysql

This topic has been discussed many times on the PHP General (archived at http://marc.theaimsgroup.com/?l=php-general) and PHP DB (archived at http://marc.theaimsgroup.com/?l=php-db) mailing lists. Search the archives for the terms 'MySQL images blob' and you will find a wealth of posts. Good Luc

images and mysql

Dear Sir/Madam, I use a mysql database on the web and use php to get information from it. Now I want to use pictures/images in the database. I've included a php script The information I get from the mysql database in a while statement. My question is, how do I get the picture available on the we

Re: Question

Krystian Miodynski wrote: > I am programer and testing MySQL. I have one question. > Where can I find the source code MySQL > of Windows version. The source for the Win version of MySQL can be downloaded from the mysql.com download page. --zak -

Question

Hi I am programer and testing MySQL. I have one question. Where can I find the source code MySQL of Windows version. Regards Krystian Miodynski [EMAIL PROTECTED]

Re: Performance Problems with Huge Table

I would suggest creating a new table to hold vendor information. Then remove the varchar vendor field in the parts table and replace it with an integer that represents the vendorid from the vendor table you just created. This should speed things up consideribly. You can do a left join any time you

Performance Problems with Huge Table

I am having performance problems with my server with larger tables. I Have a 512MB Pentium III Red Hat Linux 7 server running MySQL version 3.23.32 packaged by Red Hat This server's /etc/my.cnf is as follows : [mysqld] pid-file=/var/run/mysqld/mysqld.pid datadir=/var/lib/mysql port=3306 socket

Re: newbie needs help setting paswords

On Sat, 5 May 2001 14:11:24 -0700 "Daniel Goldin \(E-mail\)" <[EMAIL PROTECTED]> wrote: > I'bve been following SAM'S TEACH YOURSELF MYSQL and hit a glitch. Whenn I do > what I'm told to do create passwords here's what happens > > prompt> insert into user (host, user, password) values('localhost'

Re: newbie needs help setting paswords

On Sat, 5 May 2001, Daniel Goldin (E-mail) wrote: > I'bve been following SAM'S TEACH YOURSELF MYSQL and hit a glitch. Whenn I do > what I'm told to do create passwords here's what happens > > prompt> insert into user (host, user, password) values('localhost', 'myname' > password('testpass'); >

Re: Implementing Quota's on Databases

On Sat, 5 May 2001 13:47:57 -0600 "Zak Greant" <[EMAIL PROTECTED]> wrote: > chintanp wrote: > > I want to implement disk quota's for various MySQL databases. > > I checked out various books,but did not find the answere. > > Can you please help me in achieving my goal ? > > I am using Red Hat Linu

I'm new can someone help me?

I have a server hosting my site that offers MySql and they have activated a login and password for me. I use windows 98 and write websites with code not an editor. I want to learn database programming and heard MySql was the best. I downloaded mysql-3.23.37-win.zip from www.mysql.com After u

I'm NEW ! Can someone help me?

I have a server hosting my site that offers MySql and they have activated a login and password for me. I use windows 98 and write websites with code not an editor. I want to learn database programming and heard MySql was the best. I downloaded mysql-3.23.37-win.zip from www.mysql.com After u

RE: API or ADO??

Thanks for the feedback, I might opt for the MyVBQl because of the size of installation/ease of installation in comparison to hassling with ODBC stuff. However, this is not critical but certainly makes my life a little easier, with ADO I can set the datasource of a grid to the ado recordset and th

newbie needs help setting paswords

I'bve been following SAM'S TEACH YOURSELF MYSQL and hit a glitch. Whenn I do what I'm told to do create passwords here's what happens prompt> insert into user (host, user, password) values('localhost', 'myname' password('testpass'); I get the following error: "Syntax error near unexoecte

Re: API or ADO??

The application we develop here at icarz was written using MyODBC and ADO ... I wrote the MyVbQL API to replace the use of ADO in our application with minimal code changes ... The names and functionality of most of the methods and properties are modeled after ADO methods and properties ... Anyone

Re: Implementing Quota's on Databases

chintanp wrote: > I want to implement disk quota's for various MySQL databases. > I checked out various books,but did not find the answere. > Can you please help me in achieving my goal ? > I am using Red Hat Linux 7. Hello, I had to do this for an employer a few years ago. I wrote

Re: API or ADO??

I really like using ADO and I've had very good luck with it. I have used it extensively to connect to access, sybase, oracle, and mysql databases as well as other non relational data sources (using the correct provider). I believe that the flexibility is the best part about ADO. Therefore if

Re: API or ADO??

What API are you referring to ...MyVbQL.dll ? If not you should check it out ... http://www.icarz.com/mysql/index.html In my opinion, MyVbQL is the API that you should use ... but my opinion is a little biased since I am the one that wrote it ... Eric Warren van der Merwe wrote: > Hi again >

API or ADO??

Hi again database, sql Should one rather use ADO or the API for Windows programming? I am in a situation at the moment and don't know which one to move forward with. My program is currently developed with ADO, so that seems a slightly more 'easy' route to go, except that some ADO features don't

JDBC Connection

Hello: Could someone help me in giving me the JAVA syntax to connect to a datbase using MySQL. I have mm.msql.jdbc-1.2.c.tar as the jdbc connection. All I need is the detailed code in JAVA to connect to a database in regards to the try block statement. Thanks alot for all your help... Greg

can't shutdown mysqld (nicely or not) on OS X 10.0.2

From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: can't shutdown mysqld (nicely or not) on OS X 10.0.2 >Description: After starting mysqld with: safe_mysqld --user-mysql & I cannot shutdown the daemon. None of the mysqladmin commands work, kill -HUP does nothing and after using kil

myODBC

Hi there I have an ODBC connection to my database, but I want the ability to specify the username and password with my code when the connection is made. At the moment I just use the values entered when I setup the ODBC connection but this is most definatelly not what I want. Thanks Warren

Re: case insensitive regexp

Tom Svensson wrote: > > Hi! > > I'm using version 3.23.37 of MySQL (for Windows). Why does REGEXP > seems to be case insensitive? > Queries like > SELECT "tom" REGEXP "tOm"; > returns 1 Why? And how can I solve it (to return 0)? > > Regards, > Tom S. > > ---

Error 2002

Hi I have installed Mysql from the latest tar file and followed these steps. shell> groupadd mysql shell> useradd -g mysql mysql shell> gunzip < mysql-VERSION.tar.gz | tar -xvf - shell> cd mysql-VERSION shell> ./configure --prefix=/usr/local/mysql shell> make shell> make install shell> scripts/m

case insensitive regexp

Hi! I'm using version 3.23.37 of MySQL (for Windows). Why does REGEXP seems to be case insensitive? Queries like SELECT "tom" REGEXP "tOm"; returns 1 Why? And how can I solve it (to return 0)? Regards, Tom S. - Before pos

Re: Implementing Quota's on Databases

On Sat, 05 May 2001 16:27:05 +0530 chintanp <[EMAIL PROTECTED]> wrote: > Hello Everybody, > > I want to implement disk quota's for various MySQL databases. > > I checked out various books,but did not find the answere. > > Can you please help me in achieving my goal ? Some more serious this ti

Re: sorted select

So sprach [EMAIL PROTECTED] am Sat, May 05, 2001 at 12:30:27PM -: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query > > If you ju

sorted select

Hello, If I have a table like this MYID |time | some id creation time and the following query SELECT DISTINCT MYID from Table; How can I get the results ordered by time ? Any ideas ? Thank you ! -- Adi Tofan email : [EMAIL PROTECTED] ICQ#: 98771878

Re: Implementing Quota's on Databases

On Sat, 05 May 2001 16:27:05 +0530 chintanp <[EMAIL PROTECTED]> wrote: > Hello Everybody, > > I want to implement disk quota's for various MySQL databases. > > I checked out various books,but did not find the answere. > > Can you please help me in achieving my goal ? buy more diskspace > >

Implementing Quota's on Databases

Hello Everybody, I want to implement disk quota's for various MySQL databases. I checked out various books,but did not find the answere. Can you please help me in achieving my goal ? I am using Red Hat Linux 7. Regards Chintan

Re: Database size

RedHat 7.1 uses kernel 2.4, which *does not* have a file size limitation of 2Gb. I have a few tables bigger than 2Gb (3.23.37 / RedHat 7.1) It takes forever to index them, though... Vadim. Dhiin Data - Erik Dhiin wrote: > > Hi, > > I have a problem, my database has reached Linux Redhat 7.1