Re: Auto-configuration of my.cnf?

Jeremy Zawodny wrote: >On Tue, Apr 23, 2002 at 08:26:23PM -0500, JW wrote: > >>-BEGIN PGP SIGNED MESSAGE- >>Hash: SHA1 >> >>Hello, >> >>Some time ago I set up a rather large mySQL server with InnoDB and >>had a hard time customising my.cnf. >> >>At the time there was some discussion of cr

FW: MySQL with Delphi 5.0

R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Roa, Rosel B. Sent: Wednesday, April 24, 2002 2:01 PM To: '[EMAIL PROTECTED]' Subject:RE: MySQL with Delphi 5.0 Use WinZEOZits free and friendly...I use it too...

Re: Circular replication

Hi! - Original Message - From: ""Madscientist"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, April 23, 2002 10:44 PM Subject: Circular replication > Hi, > > We're doing something weird (what else is new). We're hoping to use > MySQL as the base of a distributed

RE: MySQL with Delphi 5.0

Hi Jose, In the portal and contrib section of the MySQL website there is several direct API's to MySQL. I propose you use one of these, although dbExpress is a nice idea it is not dedicated and developed only for MySQL and thus works poorly. Our own components is also available at: http://ww

Re: Auto-configuration of my.cnf?

On Tue, Apr 23, 2002 at 08:26:23PM -0500, JW wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello, > > Some time ago I set up a rather large mySQL server with InnoDB and > had a hard time customising my.cnf. > > At the time there was some discussion of createing a tool that > some

New Setup

Using the commands you have offered... Egor> Your 'root' user doesn't have GRANT privilege ... Egor> Egor> You should change Grant_priv to 'Y' Egor> You can do this using UPDATE statement: Egor> UPDATE user SET Grant_priv='Y' WHERE user='root'; I get this response.. ERROR 1017: Can't

RE: MySQL 3.23.44 not using indexes

> >The corollary to the above quote is that MySQL can not use indexes with > >an OR clause at the base level. > > > MySQL *does* use the index on a different server, though, it just > doesn't use the index on that server. Compare the results of EXPLAIN > queries on the two servers (after ANALYZE

RE: mysqld

http://www.mysql.com/udmsearch/index.php?ps=10&q=safe_mysqld&ps=20&m=and 1. MySQL Manual | 4.7.2 safe_mysqld, the Wrapper Around mysqld MySQL Manual [2162694] MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts 4.7.2 safe_mysqld, the Wrapper Around mysqld

mysqld

I have run mysqld - and it tells me it is ready for connections - what syntax is it looking for? (is it the same as mysql ie commands and then a ';' to finish? Ian - Before posting, please check: http://www.mysql.com/manual.

Auto-configuration of my.cnf?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, Some time ago I set up a rather large mySQL server with InnoDB and had a hard time customising my.cnf. At the time there was some discussion of createing a tool that someone could enter their hardware info into and get a customised configur

RE: I thought MySQL Supported Relationships

http://www.google.com/search?hl=en&q=Views+Mysql ... MySQL Manual | 1.7.4.6 Views ... It is planned to implement views in MySQL Server around Version 4.1. Views are mostly useful for letting users access a set of relations as one table (in read ... www.m

Re: I thought MySQL Supported Relationships

Perhaps I fail to catch the humour in your response, or the flavour of this newsgroup, but I find your answer in no way helpful, and beyond that quite insulting to Access. 1. I have developed applications in Access comprising over 1000 tables, some of which contain millions of rows, with numerous

RE: alternative to intersect in mySQL

* Thomas Moore > The issue has to do with relating a PRODUCT table and ATTRIBUTE table so > that one product is related to multiple attributes. In the > shopping cart, I > want to show multiple select menus. After a user selects all of them, only > the parts related to those attributes will be dis

Re: MySQL 3.23.44 not using indexes

Steven Roussey wrote: >The corollary to the above quote is that MySQL can not use indexes with >an OR clause at the base level. > MySQL *does* use the index on a different server, though, it just doesn't use the index on that server. Compare the results of EXPLAIN queries on the two servers (a

Remove Mysql: New Setup

I seem to have done something that has crashed mysql on my server and I would really like to completely remove it and start again It's running on freebsd & is version 3.23.43 I think. Is there a safe procedure that will not crash my server? I can't seem to find any documentation on the msyql.or

Re: MySQLdb Exception Documentation

Yeah, the docs on that are a bit sparse. On 22 Apr 2002 at 12:05, Tim Johnson wrote: > Hello All: > I'm just learning to use Andy Dustman's MySQLdb for Python. > Very easy for this mysql-dummy to learn! > > It would be very helpful for me to find documentation > on the Exce

Re: LAST_INSERT_ID()

On Tuesday, April 23, 2002, at 03:10 PM, destr0 wrote: > SELECT LAST_INSERT_ID() as id FROM myTable; > > It returns the last inserted Id, but why does it return that value for > every > row in the table. > > for example. > if there are 5 total records in the table. and the last inserted Id is

Re: How to Install as non-root user in Unix system?

I think the general procedure is the same, just a couple things you have to consider. 1. The mysql daemon will have to run under your user name. 2. You might not be able to use port 3306, you'll have to check with the sys admin for this. 3. You'll have to install it into your home directory ( che

Erwin Vs Mysql ....

Has anyone got Erwin working with mysql. I guess all directly non-supported DBs by Erwin are suppose to work via ODBC but I have not been able to find ODBC driver (either generic or for mysql). thanks Vivek - Before posting,

RE: alternative to intersect in mySQL

The issue has to do with relating a PRODUCT table and ATTRIBUTE table so that one product is related to multiple attributes. In the shopping cart, I want to show multiple select menus. After a user selects all of them, only the parts related to those attributes will be displayed. Example: PRODUC

compile problem with 3.23.50

>Description: I get the following error: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr\"" - DDATADIR="\"/var/lib/mysql\"" -DSHAREDIR="\"/usr/share/mysql\" " -DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/inc

How to Install as non-root user in Unix system?

I have an account on our Dec Unix system and I can't find any directions on how to make MySQL work without root privileges. Can it be done? pj -- Paul E. Johnson email: [EMAIL PROTECTED] Dept. of Political Sciencehttp://lark.cc.ukans.edu/~pauljohn University of

Re: (Newbie) Apachie->PHP->MySql

You have to update your seession-path in your php.ini (usually located in %%systemroot%% eg windows) to a valid windows-path like c:\windows\temp Jan - Original Message - From: "r" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 11:19 AM Subject: (Newbie) Apac

MySQL datetime & GMT time handling

I have a question, or maybe it's a feature request. Or maybe it's a question and a feature request ;) We would very much like to be able to store time on the server in UTC. The TIMESTAMP type seems close, but has baggage due to its desire to update itself as a timestamp on updates. MySQL handlin

(Newbie) Apachie->PHP->MySql

Greetings all. A bit of history, I have a small.no actually...TINY website. :-) I am using PHP and mySql there without any problems. But uploading and testing each PHP page/program was a pain in the . so i installed Apache,MySql and PHP on my WINDOWS 2000 machine for testing before goi

3.23.50 client needs IP addresses

>Description: mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: ERROR 2005: Unknown MySQL Server Host 'xxx' (2) >Submitter-Id: >Originator:Rob Steele >Organization: FatKat, Inc. >MySQL support: none >Synopsis:

Re: insert for datatype of "set"

When I use this syntax, the first state gets inserted into the field and the others are ignored. Here is my exact SQL: mysql> insert into contr -> VALUES( -> "", 0, "Hammer Whackers", "Bob Hammer", -> "3390 Peachtree Rd.", "", "Atlanta", -> "GA", "30326", "", "404-326-0200",

SET row dynamic?

Short question: Is there a way to update SET-options without alter table? e.g. if one user is registered in table1 he is allowed(means registered in set-row options) to write his id into table2 ? Thanks, Jan P.S.: For the filter: I want to do a sql query which does something. -

Re: insert for datatype of "set"

insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2', 'TN,NC,AL') ; Jim Philips wrote: >Yes. I found that page earlier. I still don't see how it answers my question. >What is the proper syntax for an insert statement? > >On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:

Re: Intermittent 1049 error in MySQL 3.23.49

Hello again, I've now been on the list long enough to determine it's not an inactive list ... So, I'm hoping that means that someone (perhaps one of the MySQL team I've seen active on the list today) may be able to address this problem, as it is quite a serious one. Is there a reason that it's n

Re: insert for datatype of "set"

Yes. I found that page earlier. I still don't see how it answers my question. What is the proper syntax for an insert statement? On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote: > http://www.mysql.com/doc/S/E/SET.html > > On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote: > > I c

Re: insert for datatype of "set"

http://www.mysql.com/doc/S/E/SET.html On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote: > I couldn't find this in the documentation. What is the propoer sql to > insert into a field with a data type of set? My field has the following set > of acceptable values: > > GA, TN, SC, NC, AL > > Assum

insert for datatype of "set"

I couldn't find this in the documentation. What is the propoer sql to insert into a field with a data type of set? My field has the following set of acceptable values: GA, TN, SC, NC, AL Assume I am inserting multiple values, such GA, TN, SC. If I separate them with commas, mysql will assume

Re: LAST_INSERT_ID()

At 02:10 PM 4/23/2002, you wrote: >query, table > >When I run the query: > >SELECT LAST_INSERT_ID() as id FROM myTable; > >It returns the last inserted Id, but why does it return that value for every >row in the table. > >for example. >if there are 5 total records in the table. and the last insert

Circular replication

Hi, We're doing something weird (what else is new). We're hoping to use MySQL as the base of a distributed database with peer replication. Most of the peering and control mechanisms will be in the core application code, but we're counting on MySQL's ability to replicate for some of the lower-leve

Slow Shutdown with NET STOP MYSQL

I have version 3.23.41-max-debug running on Windows 2000 SP2. I have MySQL installed as a service and can use NET START MYSQL and NET STOP MYSQL to start and stop the server. One unusual item is that it takes about 30 seconds for the NET STOP to finish executing. The NET START is very fast as

Re: I thought MySQL Supported Relationships

On Tue, 2002-04-23 at 14:35, Andrew Kuebler wrote: > Hello Everyone. > > I'm still fairly a newbie to MySQL, but I could have sworn I read > somewhere that MySQL supported relationships just like Access. I've > searched the entire manual, and cannot find anything on the subject. > Does MySQL supp

Demande d'inscription à mysql-france

Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe

RE: I thought MySQL Supported Relationships

* Andrew Kuebler > I'm still fairly a newbie to MySQL, but I could have sworn I read > somewhere that MySQL supported relationships just like Access. I've > searched the entire manual, and cannot find anything on the subject. > Does MySQL support relationships, and if so does anyone know where I c

RE: I thought MySQL Supported Relationships

Actually, no. The addiction to MySQL has caused many relationship break-ups. There's probably even a database with that information out there somewhere. Probably a MySQL database, too. Meanwhile Access supports relationships because it blows so hard that people can't wait to get away from it and h

RE: mySQL "dump"

* On-Site > I'm very new to mySQL and have what is probably a simple question. I've > created my database using mySQL and it resides on my local PC. I want to > upload it to my hosting service's server. > > They tell me "You would dump the content of your mysql database on your > local machine an

I thought MySQL Supported Relationships

Hello Everyone. I'm still fairly a newbie to MySQL, but I could have sworn I read somewhere that MySQL supported relationships just like Access. I've searched the entire manual, and cannot find anything on the subject. Does MySQL support relationships, and if so does anyone know where I can find

mySQL "dump"

Hi, I'm very new to mySQL and have what is probably a simple question. I've created my database using mySQL and it resides on my local PC. I want to upload it to my hosting service's server. They tell me "You would dump the content of your mysql database on your local machine and then use the my

Re: MySQL start

Victoria Reznichenko > Samuel, > Tuesday, April 23, 2002, 4:04:20 PM, you wrote: > > SM> Can you help me in the following problem? > > SM> OS: Linux Slackware 8.0 > SM> Source: mysql-3.23.42.tar.gz > > SM> I can't start mysql after installing the source file. I did it step > by step SM> accord

Re: Prerelease of MySQL/InnoDB-3.23.50

Andrew, unfortunately it usually takes 7 days for the Windows binary to appear. Regards, Heikki - Original Message - From: "Andrew Chan" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 8:43 PM Subject: Re: Prerelease of MySQ

RE: alternative to intersect in mySQL

* Thomas Moore > > I know that intersect does not work yet with mySQL. I am selecting data > from > > two tables. Results of one select > > would be 1, 2, 3, 4 . Results of other select 1, 2. > > > Want to print 1, 2. > > > Are there any nice workarounds using PHP or SQL? [temporary table] > If

Re: Prerelease of MySQL/InnoDB-3.23.50

There is no download for Windows at the moment, isn't it? Andrew - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 1:12 PM Subject: Prerelease of MySQL/InnoDB-3.23.50 > Hi! > > InnoDB is a MySQL table type which adds tran

RE: table lock - which connection id own's it

Lopez David E-r9374c writes: > Monty > > BTW, it's a thrill to hear from the CTO. > > The procedure for locking a table is more complex but will > attempt to describe it further for you. Any of the 150 daemons > can insert to the hash tables. The data in the row can be used > by all 150 daemons.

Re: row id

Hi. Please start a new thread next time instead of replying to an existing one with a different topic. Mailers supporting threading will put your mail under the original thread. Thank you. On Tue, Apr 23, 2002 at 03:23:04PM +0800, [EMAIL PROTECTED] wrote: > Do anyone know how to select or get th

RE: table lock - which connection id own's it

Monty BTW, it's a thrill to hear from the CTO. The procedure for locking a table is more complex but will attempt to describe it further for you. Any of the 150 daemons can insert to the hash tables. The data in the row can be used by all 150 daemons. The primary key in hash table is the "id" f

Re: Strange behaviour with SQL vars and order by

I see no column named Site.nome showing that it is wrong. ds wrote: >Hi, > >I'm having a strange problem using SQL vars (@variable) and an order by >expression. > >I have a query that returns a record for each day. >Each record has a date (data), a column with the daily total value >(uv_views)

Re: LAST_INSERT_ID()

On Tuesday 23 April 2002 1:10 pm, destr0 wrote: > query, table > > When I run the query: > > SELECT LAST_INSERT_ID() as id FROM myTable; This query really makes no sense. It is almost the same as: SELECT LAST_INSERT_ID() as id; > It returns the last inserted Id, but why does it return that val

LAST_INSERT_ID()

query, table When I run the query: SELECT LAST_INSERT_ID() as id FROM myTable; It returns the last inserted Id, but why does it return that value for every row in the table. for example. if there are 5 total records in the table. and the last inserted Id is 9, if I run the above query I get:

Prerelease of MySQL/InnoDB-3.23.50

Hi! InnoDB is a MySQL table type which adds transactions, row level locking, hot backup capability, and foreign key constraints to MySQL. Version 3.23.50 of InnoDB features an auto-extending data file, better support for InnoDB Hot Backup, and better support of foreign key constraints, including

Re: MySQL with Delphi 5.0

I tryed to use Delphi 6.0 and dbExpress, but I didn't got. What component and what property I have to set for use correct?? Regards Alexander >-- Mensagem Original -- > >> Hi, Haroldo >> >> Is it first time to develop Database Application with Delphi? >> Do you know how to use DataAcces

Re: MySQL with Delphi 5.0

I tryed to use Delphi 6.0 and dbExpress, but I didn't got. What component and what property I have to set for use correct?? Regards Alexander -- Mensagem Original -- > Hi, Haroldo > > Is it first time to develop Database Application with Delphi? > Do you know how to use DataAccess Compo

Re: MySQL with Delphi 5.0

Several ways to do this, MyODBC, ZEOS, ASTA. dbExpress has issues, these can be confirmed in the Borland News groups. ZEOS works well and is free, MyODBC works but the BDE must be installed on the Client if the native database componets id D6 - D5 is used, ASTA is fast and excellent for Internet a

RE: Further Question with --> table lock - which connection id own's it

* Shaun Bramley > Depending on how many people are updating this db should ultimately > determine your decision to remove the table locks. If hte db is only > experiencing one person updating it then it is not necessary. However if > multiple people are updating it, then you will want to keep th

REPLACE() & wildcards

Hi, When using the REPLACE() function in a query, are there any wildcards allowed? If so what are they? Also are regular expressions only usable for matching or can one also do a regular expression substitute in some way? Thanks Gavin

UDF's Under Windows

Does MySQL 4 support udf's under Windows? Mike.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

RE: alternative to intersect in mySQL

If it is in a multi-user environment, this is undesirable. Any other thoughts? I was thinking of doing arrays in PHP and then using array_intersect PHP function, but would prefer a cleaner way. -Original Message- From: Aleksandar Bradaric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 2

Re: mysqldump

Dont worry. It worked. Yes i was supposed to create the database before using the restore command as it couldnt find the database. Thanks neways, Regards, Harpreet kaur >From: "Harpreet Kaur" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: mysqldump >Date: Tue, 23 Apr 2002 16:08:23 +0

Re: Update

I'd have to guess that MySQL is interpreting the "set" clause this way: Set events_ID = ( 512 AND ( term = 'changed' )) That is, a logical AND, so a zero result makes sense. Still, it seems a bit odd. - Original Message - From: "Salada, Duncan" <[EMAIL PROTECTED]> For one of two rea

Re: mysqldump

The mysql is working now and i can get into it. But when i type mysql databasename < /home/backup/backup_databasename.sql To restore a database do i need to have the database created first. i get an error message error 1044: access denied for user @localhost to database databasename If i log o

Re: problem with libmysqlclient_r.so

Andrey Kotrekhov writes: > > > my program crash in another plase > (gdb) bt > #0 _db_enter_ (_func_=0x280fe4dc "mysql_ping", > _file_=0x280fdd48 "libmysql.c", _line_=2248, _sfunc_=0xbfa87d3c, > _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48) > at dbug.c:712 > #1 0x28

Re: mysqldump

- Original Message - From: "Harpreet Kaur" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 5:44 PM Subject: mysqldump > Dear group members > > I did a mysqldump on my machine at home to backup a database. I saved the > file to the /home/backup folder at my work

mysqldump

Dear group members I did a mysqldump on my machine at home to backup a database. I saved the file to the /home/backup folder at my work and am trying to restore the database using mysql databasename < /home/backup/backup_databasename.sql I get the following error: Cannot connetc to local mysql

Re: Help needed on query

You should be able to just use something like this: Select uid, username From tablename Where '$externalstringvar' like query; That's PHP syntax. You'll have to use whatever makes sense for your scripting or programming language in place of the $externalstringvar variable. The single-quotes ar

RE: Update

For one of two reasons (probably) - and I think you found a bug: 1. The syntax in your "set" clause is wrong. It should be "set alternatepreference='C',AltContactID='1'" *Notice the use of a comma instead of "and"* 2. The row that matched the conditions in the "where" clause may already be s

Re: Checking if a table exists?

Hello, PHP has a function call that will return the table names within as an array. The function name is mysql_list_tables() Shaun - Original Message - From: "BD" <[EMAIL PROTECTED]> To: "Bo Mellberg" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 10:38 AM Subj

Update

mysql> update contact set alternatepreference='C' and AltContactID='1' where con tactid=2; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 any ideas why the UPDATE did not perform an update? Thanks Rich ---

Re: Checking if a table exists?

At 04:58 AM 4/23/2002, you wrote: >Hi! > >How do check if a certain table exists? I have to know if >the table exists and then make a query in that >table. I mean to use it in a function so the SHOW TABLES >is not an option... > >I have tried the "sysobjects" solution but it comes back with: > >ta

Re: Further Question with --> table lock - which connection id own's it

Hello, Depending on how many people are updating this db should ultimately determine your decision to remove the table locks. If hte db is only experiencing one person updating it then it is not necessary. However if multiple people are updating it, then you will want to keep the locks. Here i

Re: MySQL with Delphi 5.0

Hi, Haroldo Is it first time to develop Database Application with Delphi? Do you know how to use DataAccess Component(e.g., TDatabase) and BDE(or BDE Administrator)? I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which help you to develop Database Application very easil

Re: Pre-release of MySQL 3.23.50

Philip Molter <[EMAIL PROTECTED]> writes: > On Tue, Apr 23, 2002 at 10:26:04AM +0300, Michael Widenius wrote: > : > : Hi! > : > : 3.23.50 is basicly just a bug fix release compare do 3.23.49a > : > : There is however two things one should be aware of regarding 3.23.50 > : (both only affecting

Re: problem with libmysqlclient_r.so

äÏÂÒÙÊ ÄÅÎØ. > > program crash in my_fopen > > > > this is stack of program : > > (gdb) bt > > #0 0x180ef7f2 in my_fopen () from > > /usr/local/mysql/lib/libmysqlclient_r.so.10 > > #1 0x180f0b20 in search_default_file () > >from /usr/local/mysql/lib/libmysqlclient_r.so.10 > > [skip] > > Hi!

How to update/insert to a blob?

HI Gurus, I am very in need of dealing object serialization in / out a database, but I want to do it independent of any dbm such as ADO, ODBC etc, and I believe there is a sql statement to do it(though may not implemented in sql92), can you tell me? Thanks a lot! __

Re: trying to cpmpile mysql with hebrew

Afgin, Tuesday, April 23, 2002, 1:14:17 PM, you wrote: AS> I try to compile mysql with hebrew and did not success. AS> I compile it on solaris 5.6. AS> When I configure it with: AS> ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory AS> --with-extra-charsets=complex --with-charset=h

unable to build mysql-3.23.49 on Solaris2.6

>Description: I am unable to build mysql-3.23.49 on Solaris2.6 using gcc 2.95.3. Build fails with following error in mysql-3.23.49/sql. Rest of project builds successfully. . . . Making all in sql Making all in share make[3]: Nothing to be done for `all'. /bin/sh ../libtool --mode=link g

MySQL with Delphi 5.0

I've installed MyODBC and then I've set up ODBC and I saw the driver for MySQL DB, when I try to create a new alias wiht MySQL it does not apear to select the DB, acording a book wich is guiding it should has to appear. Can anybody help to set up the ALIAS with MySQL Thanks José Haroldo

Re: Further Question with --> table lock - which connection id own's it

*** REPLY SEPARATOR *** >Hi ... > >just wanted to added another question to this one... > >you suggested to use LAST_INSERT_ID() , but the >question is if there are concurrent access to the >database, how will you get the last id without locking >the table. Don't worry about c

Re: MySQL start

Samuel, Tuesday, April 23, 2002, 4:04:20 PM, you wrote: SM> Can you help me in the following problem? SM> OS: Linux Slackware 8.0 SM> Source: mysql-3.23.42.tar.gz SM> I can't start mysql after installing the source file. I did it step by step SM> according guidance from Install-Source file.

Re: ERROR 1045: Access denied for user: 'root@localhost'

Tewfic, Monday, April 22, 2002, 10:07:06 PM, you wrote: >> Hello, i'm having a problem accessing mysql database. I don't recall >> setting a password for root, but when i try to set that password. This is >> happening right after i run mysql_install_db >> >> [root@omsrh etc]# mysql -u root -p

Re: Mysql.sock missing

Charitha, Tuesday, April 23, 2002, 11:58:37 AM, you wrote: C> REALFROM: Charitha <[EMAIL PROTECTED]> C> HOUR: 2002042312 C> Hello all, C> I am facing very strange problem C> I am not having mysql.sock in /var/lib/mysql C> But it is showing its status to be running. C> How could it be? Chec

Re: New Setup

Ian, Tuesday, April 23, 2002, 12:41:40 AM, you wrote: Egor>> By default user 'root' has all privileges... Egor>> Show me the output of following: Egor>> SHOW GRANTS FOR 'root'@'localhost'; IP> mysql> show grants for 'root'@'localhost' IP> -> ; IP> +-

SUMMARY: Inserting a BLOB using MySQL++

All, First of all, thanks to everyone(Sinisa, Opus) who gave input into the resolution of my problem. What I ended up doing was escaping any character that would be interpreted as a special character in an STL string. These included ", \0, and '. So, basically I armored the binary data and ins

MySQL start

Can you help me in the following problem? OS: Linux Slackware 8.0 Source: mysql-3.23.42.tar.gz I can't start mysql after installing the source file. I did it step by step according guidance from Install-Source file. My OS is generating such messages: root@serwer:/TEMP# mysql ERROR 2002: C

Re: sub selects

Try the following: SELECT leads.* FROM leads LEFT JOIN blacklist ON leads.refnumberid = blacklist.leadid WHERE blacklist.leadid IS NULL AND ... The LEFT JOIN will give you a row for every row in leads; blacklist columns will be null if there's no matching blacklist, so the WHERE clause

Re: Mysql 4.0.x enough stable to be in production ?

What table types are you using? Anthony > I've been running 4.0.1-alpha on a development server for our new internet > bookstore. Holds around 1.3million books, 100k bookcovers and a lot of > other information. > > I haven't experienced any crash/problems except for one bug that brings > down My

Re: Pre-release of MySQL 3.23.50

Hi. I'm running on linux box 6.2 with glibc 2.1 and i compiled from src.rpm mysql. The compiler is gcc 2.95.2. So, the new version of mysql 3.23.50 can i complie with it (2.95.2) or i must upgrade to gcc 3.0.4 ??? Regards, irek. - Original Message - From: "Michael Widenius" <[EMAIL PRO

Re: Pre-release of MySQL 3.23.50

On Tue, Apr 23, 2002 at 10:26:04AM +0300, Michael Widenius wrote: : : Hi! : : 3.23.50 is basicly just a bug fix release compare do 3.23.49a : : There is however two things one should be aware of regarding 3.23.50 : (both only affecting our Linux x86 binaries (normal and RPM's): : : - We have s

Re: Mysql.sock missing

Don't worry if it's running then you can find that file else where on your system; try to look for in /tmp Hisseine - Original Message - From: "Charitha" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 4:58 AM Subject: Mysql.sock missing > > Hello all, > > I a

Re: Cant connect using socket ''(111) for Mysqlgui on linux

Verify if your MySQL server is running and the user and password when entering Mysqlgui1.7.5 I have the same on Linux and it's running fine. Hisseine - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 2

database design approval

i understand that this is a bit of an ask. but. I was wondering if someone could look over my database design. i've got a diagram. and text document of all my create table syntax. It's my first mysql database, and it's kind of important that i get the thing right. So if anyone could help

read only tables

Dear all, When I try to update or create a record to a table, there is an error saying the table is read-only. How can I change it to read-write? I have chmod 777 to all the tables in the mysql data directory. I have also restarted the mysql engine. This happened only after I copy the tables f

Further Question with --> table lock - which connection id own's it

Hi ... just wanted to added another question to this one... you suggested to use LAST_INSERT_ID() , but the question is if there are concurrent access to the database, how will you get the last id without locking the table. Because what I've been doing is also: 1. lock the table 2. get the id 3

Re: Cant connect using socket ''(111) for Mysqlgui on linux

Krishna Kumar Sundara Moorthy writes: > Hello All > > Is there any installation instructions for Mysqlgui1.7.5 on linux. > > Also i have installed it and while trying to connect it says couldnt connect > using Socket''(111) > and also can some one throw light on "sql command on connet or Socket"

Re: Question about mysql++ and g++

Mike Holmquist writes: > Ok, i downloaded the mysql++-1.7.8-1.i386.rpm > rpm > file from RpmFind.net. I have mysql installed already on my machine, o > ya and im running linux. I have gcc installed, version 2.96, i think > e

Re: Help needen on query

Hi all !! This is just great ! Sometimes things seem to be more complicated than they actually are. I needed (and still do) a similar solution to check if an IP adress exist in a table. And sometimes the argument in the query is a whole subnet like 192.168.0.% I guess this will do the job for m

RE: super-smack on FreeBSD

> Hi List > I know super-smack was writing for Linux but I am trying to get it to work > on FreeBSD. > Has any one done this or is there a another many threaded bench mark > software out there for MySQL ? > > Thanks > Simon - B

  1   2   >