RE: Strange behaviour of mysqld after adding/dropping a column

Hello Sinisa, this has nothing to do with services. I have also tried this without creating a service and the result is the same. Normally the services are also stopped automatically when logging of, so I don't understand why I should stop it manually. Also I have tested this constantly by

Re: root password

Hi, I'm still stuck. If anyone has time, please take a look at this session I had and any pointers would be great. I just went to mysql.com to search the problem, but no site there..Weird. thanks all, Shawn [root /root]# mysql -u root -p Enter password: ERROR 1045: Access denied for user:

RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?

Hi again, I really think you should walk yourself through the InnoDB user manual at http://www.innodb.com/ibman.html There's a lot of usefull and explanory information in there. For your question: ib_arch and ib_logfileX are the logs that InnoDB uses to track committed transactions and

database permission

Hi all, I have a problem about the access permission of mysql. I found that the mysql client will be denied by the mysql server even I have granted the permission already. The mysql client has already run and can connect to the mysql server before... I am not sure what the problem is and so I

compiling 4.0.2

Anyone know what this syntax error is about? trying to compile the 4.0.2 on a freebsd server... Making all in sql gmake[2]: Entering directory `/usr/home/oblo/xfer/mysql-4.0.2/sql' byacc -d sql_yacc.yy mv y.tab.c sql_yacc.cc byacc: e - line 75 of sql_yacc.yy, syntax error %pure_parser

Re: mysql_real_query, insert floats as binary

* Dave Beck [...] charinsert_format[] = INSERT INTO %s VALUES (%hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd,%hhd%hhd%hhd%hhd); The values should be quoted... int build_real_insert(char *query, char *table, int frame, int atom, float x, float y, float

AW: AW: mysql wont start on SUSE

I noticed that my Server works with [mysql] user = root and than start with mysqld but when I tried to start with the runlevel editor it doesn't works. Perhaps a other Person in this list no the answer? The mysql_install_db create two folders in the var/lib/mysql pfad. The folder are mysql

RE: fulltext searching

I've never gotten the boolean features to work with version 4.0.1-alpha of MySQL. Also the database will crash with some queries where some of the search words are the same as words in the stopword list (myisam/ft_static.c in the sourcecode) Download the 4.0.2 source and compile it. Things

Re: compiling 4.0.2

ok it worked... had to that setenv and in addition do a ./configure --with-low-memory... running 4.0.2!!! :) thanks! m. Quoting Lenz Grimmer [EMAIL PROTECTED]: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 02 July 2002 10:35, Marko Djukic wrote: ok thanks. trying that

How do we make this query work in 3.23.51

Hi I had written a query which executes in MySql 4.0.1 But this is not working in 3.23.51 coz i had used Union function in the query which is not supported by 3.23.51 So any idea how this can be made to work on 3.23.51. I need to have only one Column in the result as TYPENAME SELECT

Re: looking for sql gui application

Hi, the latest version of mysql supports ssl connections. 'phpMyAdmin' is a browser based gui written in php. If your apache has mod_ssl then you could connect securely. http://www.phpwizard.net/projects/phpMyAdmin/ Alternatively, you could also use something like 'mysqlgui' and set up ssh

Re: fulltext searching

Is there a tutorial or step-by-step introduction to fulltext searches with MySQL somewhere? Regards, Eivind :-o sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: fulltext searching

section 6.8 in the manual i think... Quoting Eivind A. Sivertsen [EMAIL PROTECTED]: Is there a tutorial or step-by-step introduction to fulltext searches with MySQL somewhere? Regards, Eivind :-o sql, query

AW: How do we make this query work in 3.23.51

Hi Arul, maybe copying the columns into a temporary table might do the job. I don't know how big your tables are, if performance might be a problem. The following statements should create the query you wanted: /*creating temporary table*/ CREATE TABLE tmp_Information ( TYPENAME (any

RE: fulltext searching

Hi If anybody from mysql is listening / watching, www.mysql.com is down, and has been for a while. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED]

RE: mysql.com site down

I'm in the UK and I can get to it okay !!! Perhaps something has changed on your PC/Network ??? -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: 02 July 2002 10:45 To: [EMAIL PROTECTED] Subject: RE: fulltext searching Hi If anybody from mysql is listening /

Re: fulltext searching

section 6.8 in the manual i think... Hmm, no; that's about the access privilege system... I found it in section 24.2, but I feel this topic has gotten a bit scarce mention in the manual. Perhaps it deserves more than that...? I sure would appreciate something extra :-) Best regards,

Re: Re: fulltext searching

Eivind, Tuesday, July 02, 2002, 12:22:33 PM, you wrote: EAS Is there a tutorial or step-by-step introduction to fulltext searches with EAS MySQL somewhere? Sure. In the MySQL manual: http://www.mysql.com/doc/F/u/Fulltext_Search.html -- For technical support contracts, goto

Re: innodb @ windows xp

Hytham, Tuesday, July 02, 2002, 1:54:32 AM, you wrote: HS i have installed mysql v 3.23.44-nt on my XP using *Binary* HS distribution, how can i now develop an InnoDB tables? You must specify InnoDB startup options in the my.cnf/my.ini file:

Re: MySQL

Nigel, Monday, July 01, 2002, 6:32:53 PM, you wrote: NG I've tried to get MySQL to install and run from source. NG I configured and compiled without any errors. However when trying to start NG the service i get the following: NG ERROR 2002: Can't connect to local MySQL server through socket NG

Re: database permission

Kaming, Tuesday, July 02, 2002, 10:00:00 AM, you wrote: K I have a problem about the access permission of mysql. I found that the K mysql client will be denied by the mysql server even I have granted the K permission already. The mysql client has already run and can connect to K the mysql server

Re: Re: root password

Page, Tuesday, July 02, 2002, 9:23:16 AM, you wrote: PWWSI'm still stuck. If anyone has time, please take a look at this session PWWS I had and any pointers would be great. I just went to mysql.com to search PWWS the problem, but no site there..Weird.

RE: mysql.com site down

On Tue, 2 Jul 2002, Darley, Terry wrote: I'm in the UK and I can get to it okay !!! Perhaps something has changed on your PC/Network ??? I've had problems reaching the MySQL web site too. I think it's to do with the fact I'm connecting through a UK academic site which relies in ebone for

RE: Load problems with 3.23.51

Just an update: I installed a new fresh version of RedHat 7.3 (smp Athlon) and a new copy of MySQL 3.23.51, but the problem remains. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check:

Re: fulltext searching

there's not a huge lot more to cover than what is in the manual... what exactly are you looking for? m. Quoting Eivind A. Sivertsen [EMAIL PROTECTED]: section 6.8 in the manual i think... Hmm, no; that's about the access privilege system... I found it in section 24.2, but I feel this

Re: fulltext searching

plus are you sure you're reading the latest manual? it is chapter 6.8. try this (google cache of the mysql.com/doc since mysql.com seems to be down): http://www.google.com/search?q=cache:yvsB86pbs5cC:www.mysql.com/doc/F/u/Fulltext_Search.html+full+text+mysqlhl=enie=UTF-8 ciao, m. Quoting

Re: MySQL

Nigel, check that you are starting the mysqld properly. if you compiled it you may have selected different options with your ./configure, for example a different data directory location, so if you use the older start command it may be failing to start... that caught me out 30mins ago..

Author of windows binary distribution

Hello, can you send me a conntact (e-mail) to author of windows binary distribution of mySQL server, please? I have one question to him (about charset conversion in czech language, specially in windows distribution)... Thank you very much! Tom Planka

Re: How do we make this query work in 3.23.51

Yea Andreas I had that idea but i thought that would be a performance issue... So i thought of avoiding this temp table... I am looking into an option where i can do it in 1 single query... -Arul - Original Message - From: Oswald, Andreas [EMAIL PROTECTED] To: 'Arul' [EMAIL PROTECTED]

Re: blob versus file

Op maandag 1 juli 2002 14:18, schreef andy: Hi there, I am wondering if anybody has experiance in saving images to blob in mysql. I do save images with 1 K and 4 KB to blob fields while I used to save them to file. It seams to me that this is much slower accessing the files. The images

RE: fulltext searching / BUG report

On Tue, 2 Jul 2002, Erlend Hopsø Strømsvik wrote: Download the 4.0.2 source and compile it. Things seem to work a lot better with the 4.0.2. And it won't crash with special combinations of words :) Hi, Some things with BOOLEAN MODE seem still broken. Especially the '*' jokers. I have

Re: fulltext searching

plus are you sure you're reading the latest manual? it is chapter 6.8. The location was correct for the onlien manual. I first tried my stored PDf version, since I could not reach http://www.mysql.com There, it was section 24.2. Now I printed then online section 6.8 and will go through it. My

RE: Strange behaviour of mysqld after adding/dropping a column

Cams Ismael writes: Hello Sinisa, this has nothing to do with services. I have also tried this without creating a service and the result is the same. Normally the services are also stopped automatically when logging of, so I don't understand why I should stop it manually. Also I have

RE: blob versus file

There are several reasons why you should consider not storing binary data in your database: [snip] You probably have several reasons why you would want to store your images in your database, despite all the statements above. Others have, before you. And they have all returned to the

Re: redudancy / high availability

On Mon, 2002-07-01 at 22:23, Jeremy Zawodny wrote: On Mon, Jul 01, 2002 at 06:24:45PM +0200, Mathieu DESPRIEE - NO SPAM wrote: Hi all, I want to setup (on linux systems) a pair of redundant mysql servers, working this way : * one master and one backup * the master handles all the

InnoDB RAW devices under Solaris?

All: I am re-posting this in case someone may have an answer. RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support Has anyone had any specific experience implementing a RAW DEVICE InnoDB tablespace under Sparc Solaris? A specific few lines in my.cnf would be very helpful... As we are using

MySQL On Solaris

Hi All Can anyone refer me to any document which speaks about Installing MySQL 3.23.51 on Solaris 2.8 Sparc -Arul sql , query - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: MySQL On Solaris

The Document at www.mysql.com/manual is not clear for a Mysql beginner like me... Any Step by Step procedure... What should i do with the downloaded tar file .. I Had installed MySql in Windows.. But installing it in Solaris is not clear... -Arul - Original Message - From: Arul

Fiddling with myisam/ft_static.c

Hi, I am indexing texts in German, French or Italian language. I want to add words from these languages to the stopword list and need some more guidance: - case doesn't matter, right? - what should I do with words containing non ascii characters 'äöüéàè' ? Enter as is? - is there any

Re: fulltext searching / BUG report

Hi! On Jul 02, Thomas Spahni wrote: On Tue, 2 Jul 2002, Erlend Hops? Str?msvik wrote: Download the 4.0.2 source and compile it. Things seem to work a lot better with the 4.0.2. And it won't crash with special combinations of words :) Hi, Some things with BOOLEAN MODE seem still

Re: Left outer join

Arul, Monday, July 01, 2002, 3:58:48 PM, you wrote: A Can i use left outer join in MySQL. A Like i have one condition in Oracle A ex: A select * from user,company where u.companyid = c.companyid (+) A can i rephrase the query in mysql like this A select * from user left outer join company c

Re: MAX vs plain vanilla mysql

Petre, Monday, July 01, 2002, 9:26:49 AM, you wrote: PA Probably a stupid question, but which is best to have on ones server, PA the old mysql, or max. I.O.W, if you install MAX and never use innodb PA or berkeley tables, will it be equivalent to a normal mysql installation PA wrt performance

Re: procedure analyze()

Jason, Tuesday, July 02, 2002, 1:14:29 AM, you wrote: J I ran this on several of my tables... I expected it to give me reccomendations on how to improve my tables performance... J SELECT * FROM `5323` PROCEDURE ANALYSE() J It returned no results ever am I doing something wrong? Or, is

Re: Help?

Page, Monday, July 01, 2002, 7:48:00 PM, you wrote: PWWSanyone know why this error would come up. This is running on a Linux box PWWS [admin admin]$ scripts/mysql_install_db PWWS bash: scripts/mysql_install_db: No such file or directory Check where is your mysql_install_db located:

Re: MAX vs plain vanilla mysql

Hi! I have to correct: if you put [mysqld] skip-innodb skip-bdb to your my.cnf, then -Max uses only about 1.5 MB more memory than plain MySQL, because of a larger executable. MyISAM tables in -Max are as reliable as in plain MySQL. It is the same source code. Best regards, Heikki Innobase

laptop configuration/replication

Is it practical to use the builtin MySQL replication to have a MySQL server on a laptop that syncs to the LAN Database Master when it is connected? Are there any configuration issues that I should be aware of? - Before

cascading, referential integrity

does mysql 3.23 support cascading and referential integrity or is this only part of 4.01? if so, how do i take advantage of it and where in the documenation (link) can I read about it? thanks, blue - Before posting, please

selected records retrieve

Hi to all. I'm new in the list and in mysql as well, so excuse me for anything that sounds novice or in wrong place.I'm facing the following situation: For some reason, i had to use a backup of the database.Because of the difference in time between my backup and the instance i had to use it,i

Privileges

I would like to know what does mean the privilege References_priv on the table users?? Regards Alexander sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/

help me with this query

Hi All I have two tables User and Company User tables has userid , companyid and status Company table has companyid and companyname It's not necessary that all users should have company.There can be users without company also and for them the companyid is null. so i need all the users whose

Stumped on this Report - HELP

Dear All, I am stumped on this report. I just need an idea and help to do this in MySQL. To simplify my actual database, I am using an example. Database fields - salesperson,date,visited company industry type salespersons - a,b,c,d,e (can be 10 salesperson or 20 salesperson) visited company

Re: Privileges

At 11:54 -0300 7/2/02, Alexander Burbello wrote: I would like to know what does mean the privilege References_priv on the table users?? It's unused. Regards Alexander sql, query - Before posting, please check:

Re: cascading, referential integrity

Blue, Tuesday, July 02, 2002, 5:54:32 PM, you wrote: BP does mysql 3.23 support cascading and referential integrity or is this only BP part of 4.01? if so, how do i take advantage of it and where in the BP documenation (link) can I read about it? Yes, MySQL supports foreign key constraints for

Re: Privileges

Alexander, Tuesday, July 02, 2002, 5:54:48 PM, you wrote: AB I would like to know what does mean the privilege AB References_priv on the table users?? It's for future features... If you will grant references_priv, user can create foreign keys. -- For technical support contracts, goto

Re: help me with this query

select u.userid , c.companyname from users u left join company c on (u.companyid = c.companyid) where u.status = 'ACT' Best regards, Mikhail. - Original Message - From: Arul [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 5:15 PM Subject: help me with this

Multiple masters to 1 slave??

I'm trying to find a way to set up an off-site replication (slave 3). In house I have several MySQL 4.0 servers that are using replication. They consist of 1 master (master1) for all data, 1 slave (slave 1) for optimized web access and 1 slave (slave 2) for the internal database app. Both

RE: AW: mysql wont start on SUSE

In SuSE you should be able to start the MySQL server by: rcmysql start or rcmysql restart rcmysql is a symlink to the /etc/init.d directory -Original Message- From: John Macloy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 2:26 AM To: [EMAIL PROTECTED] Subject: AW: AW:

Re: Multiple masters to 1 slave??

On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote: In the my.cnf file on the off-site slave, can there be multiple masters specified where it will replicate all 3 in-house servers to different databases on itself? No. A slave can only have one master. Jeremy -- Jeremy D.

Debian (Woody/Testing) version of MySql

Hi We have just moved out test server from RedHat to Debian. We have used the backup tapes to recover the data, and all went well to until we tried to connect via a host name. For example mysql test -utest_user -ptest_passwd works fine, but mysql -hserver -utest_user -ptest_passwd reports

Re: cascading, referential integrity

okay, so my tables have to be of type InnoDB. Is there a configuration file somewhere where i can specify that all my tables be InnoDB so I don't have to keep manually specifying the type? blue - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday,

RE: RE: Multiple masters to 1 slave??

A slave can only have one master. You obviously don't work around here. :-) -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Subject: Re: Multiple masters to 1 slave?? On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote: In the my.cnf file on the off-site

Re: Debian (Woody/Testing) version of MySql

On Tue, Jul 02, 2002 at 05:56:37PM +0100, Simon Windsor wrote: Hi We have just moved out test server from RedHat to Debian. We have used the backup tapes to recover the data, and all went well to until we tried to connect via a host name. For example mysql test -utest_user

changing coulmn

in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 can someone please tell me the query for that. thanx anil - Before posting, please check:

Re: MAX vs plain vanilla mysql

Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of

Re: Fiddling with myisam/ft_static.c

Hi! On Jul 02, Thomas Spahni wrote: Hi, I am indexing texts in German, French or Italian language. I want to add words from these languages to the stopword list and need some more guidance: - case doesn't matter, right? yes. - what should I do with words containing non ascii

Re: cascading, referential integrity

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Blue Presley wrote: | okay, so my tables have to be of type InnoDB. Is there a configuration file | somewhere where i can specify that all my tables be InnoDB so I don't have | to keep manually specifying the type? | Add set-variable=

Re: Author of windows binary distribution

At 12:32 2/7/2002 +0200, =?iso-8859-2?Q?Planka_Tom=E1=B9?= wrote: Hi, Hello, can you send me a conntact (e-mail) to author of windows binary distribution of mySQL server, please? I have one question to him (about charset conversion in czech language, specially in windows distribution)... Thank

Recreating an MS-SQL database in MySQL: redux

No response from the first post, so here goes for one more try... My employer recently acquired an existing web site that uses a MicroSoft SQL database and I've been directed to get it running on an in-house server. As we don't have any Windows servers, I need to recreate the database in MySQL.

help on update

Hello, I am having some issues inserting and updating with mySQL. Database: asdf Table: test field: idfield (int, autoincrement) field: test (char) the query: insert into test set test = 'test' ; used in mascon or DBvisualizer correctly inserts the record. however, when

Re: configure won't configure

Thanks for the response. I set LDFLAGS and CCFLAGS for compiles and then it configured OK, I am out of practice porting compiled software. ./configure --prefix=/export/home/mysql --with-unix-socket-path=/var/tmp/mysql.sock --enable-thread-safe-client --with-berkeley-db --enable-local-infile

Re: help on update

Hi, Matthew, Have you tried: insert into test (test) values ('work') Or update test set test='test' I liked it when Matthew Hajda wrote this to me: Hello, I am having some issues inserting and updating with mySQL. Database: asdf Table: test field: idfield (int, autoincrement)

Re: changing coulmn

I wasn't entirely sure what you wanted - do you want to change the table's column names? If so, then do what the message below suggests. And yes, you can do it all in one query: alter table mytest change my_1 my_file_1 varchar(5), change my_2 my_file_2 varchar(5), ...and so on

Can't find file ./mysql/host.frm

Description: When starting safe_mysqld mysqld shutsdown immediately with no error message. However looking at /var/lib/mysql/matrix.err gives the following error messages:- mysqld started /usr/libexec/mysqld: can't find file: './mysql/host.frm' errno: 13 mysqld ended

Re: Can't find file ./mysql/host.frm

chown -R mysql /var/lib/mysql [EMAIL PROTECTED] wrote: Description: When starting safe_mysqld mysqld shutsdown immediately with no error message. However looking at /var/lib/mysql/matrix.err gives the following error messages:- mysqld started /usr/libexec/mysqld: can't find file:

Re: Recreating an MS-SQL database in MySQL: redux

There are commercial packages that do the conversion quickly and easily. The best one is obscenely expensive (the price isn't on the website, you have to write and request a quote, and a sales rep get back. I think it was around $3000. I don't remember the name of the software, because it was

installing 3.23.49 on solaris 5.8 fails

I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db /usr/local/gnu/bin/install: `copy-db' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db'

problems on solaris machine

We have mySQL running on a Sun Solaris machine and we are starting to have some problems. We just put a new 40GB drive into the machine which was expressly for mySQL. We then tar'd the whole mysql over to this new drive and then checked all the references.. everything looks good and it does

RE: problems on solaris machine

-Original Message- From: Kristen J. McFadden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 10:25 PM To: [EMAIL PROTECTED] Subject: problems on solaris machine [sql] However, the system keeps dying due to an OS error. problem with the size of this database. Any

Re: installing 3.23.49 on solaris 5.8 fails

It looks like you configured it to install in the source directory. Pushkar Pradhan wrote: I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db

innodb is disabled, how can i make it yes?

hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%;

Re: installing 3.23.49 on solaris 5.8 fails

That's right, I install all other stuff the same way. I also forgot to mention I am not an admin, so I install everything in my own disk space on the n/w. Isn't that okay? It looks like you configured it to install in the source directory. Pushkar Pradhan wrote: I used gnu's make as

Re: mysql_real_query, insert floats as binary

...and some bytes may represent an 'illegal' character, and thus must be escaped by a backslash... this goes for the quote character you use ( or '), the backslash character itself, and null bytes. Thanks, if I use mysql_real_query is this still the case? -- David A. C. Beck [EMAIL

Re: changing coulmn

mysql create table mytest ( - my_1 varchar(5) - ); Query OK, 0 rows affected (0.32 sec) mysql alter table mytest change my_1 my_file_1 varchar(5); Query OK, 0 rows affected (0.23 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show columns from mytest;

Re: MAX vs plain vanilla mysql

At 19:31 +0200 7/2/02, Petre Agenbag wrote: Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create

Re: innodb is disabled, how can i make it yes?

At 23:52 +0300 7/2/02, Hytham Shehab wrote: hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the

Re: installing 3.23.49 on solaris 5.8 fails

At 15:55 -0500 7/2/02, Pushkar Pradhan wrote: That's right, I install all other stuff the same way. I also forgot to mention I am not an admin, so I install everything in my own disk space on the n/w. Isn't that okay? From the error that you're getting, pretty clearly it's not okay the way

Re: help on update

At 18:54 + 7/2/02, Matthew Hajda wrote: Hello, I am having some issues inserting and updating with mySQL. You're not testing the result from mysql_query() to see whether not it succeeds. Do so, and they print the result from mysql_error() in the event of failure to see what it says.

Re: InnoDB RAW devices under Solaris?

Lou, I tested this on our SunOS-5.8 Sparc computer with 3.23.49: bash-2.03$ df / (/dev/dsk/c0t0d0s0 ): 7499474 blocks 2033414 files /proc (/proc ): 0 blocks 5861 files /dev/fd(fd): 0 blocks0 files

problems installing 3.23.51 on BSDI 4.0.1

Hi. I am trying to install MySQL on BSDI BSD/OS 4.0.1 Kernel #3. Processor: Cpu-1 = Pentium III (448 MHz) GenuineIntel mdl 7 step 2 type 0, feat 387fbff Ram: 128M I configured using: CC=gcc CXX=gcc CXXFLAGS=-O ./configure --prefix=/usr/local/mysql --with-extra- charsets=complex and ran

Re: mysql_real_query, insert floats as binary

* Dave Beck ...and some bytes may represent an 'illegal' character, and thus must be escaped by a backslash... this goes for the quote character you use ( or '), the backslash character itself, and null bytes. Thanks, if I use mysql_real_query is this still the case? The doc's only

two mysql questions

1. If all I want to do is use InnoDB tables for declarative referential integrity and nothing else, do I need mysql-max or can I just use the standard build of mysql 3.23.51? (Wondering about both Windows and Linus, though the answer should be the same in both places) 2. What's the best

Re: two mysql questions

As long as you need to create InnoDB table you have to use MAX binary... Check out phpmyadmin, it is totally free and operating system-independent since it runs from the server and can be used through the web browser.. Take a look at it at : http://www.phpmyadmin.net/ Gurhan - Original

Fw: innodb is disabled, how can i make it yes?

hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%;

Re: innodb is disabled, how can i make it yes?

hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus

Re: changing coulmn

thanx for ur mail, m sorry in dint mention that infact its a big table... Is there a way i can do it in all the columns using only one query ?? thanx anil - Original Message - From: nellA hciR [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 02,

Re: blob versus file

Yes, but, this advice does *not* go on to describe how you cope with the deletion problem. If you store data in records in the database a DELETE will delete *all* the data for the set of rows. If some of the data is lying around in disk files these obviously don't get deleted by DELETE. So

Re: innodb is disabled, how can i make it yes?

Hytham, start mysqld-max-nt from the MS-DOS prompt: yourpathtomysqlbindir mysqld-max-nt --console What does InnoDB print? Regards, Heikki - Original Message - From: Hytham Shehab [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 2:24 AM Subject: Re:

BUG: SHOW TABLE STATUS InnoDB Tables

Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables). I'm using MySQL 3.23.49Max on WIN2K. How to repeat the problem: Execute

Re: SHOW TABLE STATUS InnoDB Tables

Crecrio, - Original Message - From: Crercio O. Silva [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 3:49 AM Subject: BUG: SHOW TABLE STATUS InnoDB Tables Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each

MySql install on W2K server running Apache ver2.0.39

Hello all... I'm new to the list and to MySql and would like to get some advice on approaching my first mysql install. I've just installed Apache ver2.0.39 onto my W2K server and I'm currently attempting to get PHP4 going. Can anyone provide me with some ideas on how to approach the mysql

  1   2   >