Re: Mysql.log error - Please help

Hi, Or simply use perror 28 :) [EMAIL PROTECTED]:~$ perror 28 Error code 28: No space left on device Regards, Jocelyn - Original Message - From: "Brian Reichert" <[EMAIL PROTECTED]> To: "Minal Amle" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 04, 2003 9:06 AM Sub

RE: MySQL index fun

Create a compound index on either (time, source_ip) or (source_ip, time). Mysql cannot use two indexes on one table. woah what are you saying here , that it cant have multiple indexes within a table ? and what is a compound index ? say i have a table products: productID product storeID <-index

Re: Mysql.log error - Please help

On Fri, Apr 04, 2003 at 12:22:18PM +0530, Minal Amle wrote: > Hello, > > I am facing a problem while inserting data in one of the tables of my mysql database > as: > Error writing file '/var/log/mysql.log' (Errcode :28) I suspect this 'Errcode' corresponds to 'errno' under UNIX systems. On mine,

Mysql.log error - Please help

Hello, I am facing a problem while inserting data in one of the tables of my mysql database as: Error writing file '/var/log/mysql.log' (Errcode :28) While records are getting inserted in other tables. I am not getting why this is happening so. Can anybody please help me in this regard? Thanks

Re: my_raid_seek assertion failed in mysqld log

On Fri, Apr 04, 2003 at 01:22:39PM +0700, David Garamond wrote: > i found this on my server log: > > mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned > int, int, int): Assertion `pos != (~(my_off_t) 0)' failed. > > and then mysqld shuts down. i start it again but after a sh

my_raid_seek assertion failed in mysqld log

i found this on my server log: mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned int, int, int): Assertion `pos != (~(my_off_t) 0)' failed. and then mysqld shuts down. i start it again but after a short while the same error appears and mysqld stops again. what does this ind

Re: InnoDB disk file grows, never shrinks

I should add that my test continually inserted and deleted records from a set of tables. At no point did any table have more than 101 records, but the test ran 348 times, so there were 348 * 100 rows INSERTed and DELETEd. -ms -- Original Message -- From:

InnoDB disk file grows, never shrinks

My InnoDB file is set to 60MB, and is not set to autoexpand. When running stress tests against my server today, I got a message that the table was full and the test stopped. Sure enough, the InnoDB file was about 62MB. My question: I assume that the InnoDB file is the transaction log. Is there a

Re: MySQL index fun

In the last episode (Apr 03), Steve Phillips said: > I have a table for ip data that i need to index to suit the following > query > > SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time > > 1049108400 AND time < 1051786799) AND (source_ip > 3389268097 AND > source_ip < 3389268099) >

Blobbing data on MySQL

Hi All, Good day !!! I'm trying to setup up a mysql server that will store scanned documents (.doc, gif, jpeg, etc..) and will try to achieve this by blobbing data into the mysql server. I find this to be very useful for archiving old piles of paper and scanning them before they worn out. I a

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

[EMAIL PROTECTED] wrote: I need to know how to set it up and how to connect. How to setup what? There's is no setup that you have to do for DW. Just define your site as local and start coding. As for connecting, that's specific to what you're using. If you're using PHP, read its manual.

Re: external connection

Lecul, Fred wrote: Hmm... Yeah, its not connecting! Im getting: ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server Any idea's?? Fred Have a look at http://www.mysql.com/doc/en/Adding_users.html Note the example about a page down that says: mysql> GRANT ALL PRIVILE

Re: JDBC can't connect, but command line can...

OK. I'm an idiot. It suddenly hit me today that my code worked at home, but not at school. Then I remembered that we have a proxy server at school. I disabled the SOCKS proxy, and, sure enough, everything works now. There are disadvantages to just changing a Home/School setting, especially if y

RE: external connection

Hmm... Yeah, its not connecting! Im getting: ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server Any idea's?? Fred -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Friday, 4 April 2003 1:42 PM To: Lecul, Fred; [EMAIL PROTECTED] Subject: Re:

Re: external connection

Lecul, Fred wrote: Tried that and it didn't work Is it possible that the port 3306 is blocked? And if it is, how can I open this? Thanks Fred It's possible. Maybe post the grant commands you used (minus the password of course) to set up the user account. If possible try to connect with the m

Re: A question about using C API in mysql (linux platform)

Li: you have to link in the mysql library mysqlclient.a in your makefile Here is my makefile which you may use for reference # This assumes the MySQL software is installed in /usr/local/mysql inc := /cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/include lib := /cygdrive/g/mysql/mysql-

RE: external connection

Tried that and it didn't work Is it possible that the port 3306 is blocked? And if it is, how can I open this? Thanks Fred -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Friday, 4 April 2003 12:09 PM To: Lecul, Fred Cc: '[EMAIL PROTECTED]' Subject: Re: external c

MySQL index fun

Hey People :-) I have a table for ip data that i need to index to suit the following query SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time > 1049108400 AND time < 1051786799) AND (source_ip > 3389268097 AND source_ip < 3389268099) if i created an index on the time column and a

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

I need to know how to set it up and how to connect. MySQL is already installed but there is no database, no tables. - Original Message - From: Ashley M. Kirchner To: Marco Chaires Cc: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 PM Subject: Re: [MySQL] RE

A question about using C API in mysql (linux platform)

Hi, I'm a newbie to MySQL Now I am using C to connect mysql in Linux The heaser souce code like: #include #include #include and After I use "gcc test.c -L /usr/local/mysql/lib/ -shared " to compile it , and when I run the a.out ,it always say that "Segmentation Fault

Re: external connection

Lecul, Fred wrote: Hi Im new to mysql and am trying to connect externally. I have hashed out the skip-networking in the my.cnf, created a new user and gave permissions but it seems it just doent want to accept the connection. I am trying to connect using free-Mascon. Any idea's on what I can d

external connection

Hi Im new to mysql and am trying to connect externally. I have hashed out the skip-networking in the my.cnf, created a new user and gave permissions but it seems it just doent want to accept the connection. I am trying to connect using free-Mascon. Any idea's on what I can do? Frederic Lec

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

Quoting Marco Chaires <[EMAIL PROTECTED]>: > i dont really recommend that combination but its possible... good luck..! Why not? If you do it right, it works just fine. I develop mainly on my laptop before uploading to the main server. I have MySQL installed on the main server, and on my l

RE: table structure design

i cant seem to access the server times out :| http://www.research.att.com/sw/tools/graphviz/download.html -Original Message- From: Nicholas [mailto:[EMAIL PROTECTED] Behalf Of Nicholas Spagnoletti Sent: Friday, April 04, 2003 1:28 AM To: [EMAIL PROTECTED] Subject: Re: table structure desi

RE: self foreign keys and InnoDB is it possible ?

I don't have the answer to your question, but I find your question very interesting. One observation,and I could be wrong, is that "deleting 1 has to delete 1,2,4,5' doesn't seem to be legal as far as Foreign Key constraints go. As I read your table, 1/aa has no father (-1), 2/bb has father 1/aa

Re: How to prevent a user from dropping/creating a database

Jeremy Zawodny wrote: On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote: Hi all, I'm wondering if there is some way to setup privileges in the grant tables such that a user can create or drop any arbitrary table in databases that user is associated with, but be unable to create or

self foreign keys and InnoDB is it possible ?

hi all I'm creating a table like this CREATE TABLE test ( id integer not null primary key auto_increment, testchar(20), father integer key default ='-1' not null, FOREIGN KEY (id) RERERENCES test(padre) ON DELETE CASCADE ) Type=InnoDB; But I made some mi

Re: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

nah, i'll just test stuff off my website as usual thanks though - Original Message - From: Marco Chaires To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 8:59 PM Subject: RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000 Yeap.. i dont really

RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

Yeap.. i dont really recommend that combination but its possible... good luck..! Marco Chaires Depto. de Sistemas Miciudad.com [EMAIL PROTECTED] -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: Jueves,

Question: Connecting MySQL with DreamWeaver MX on Windows 2000

Question: can I install mySql on my computer and test php with dreamweaver mx? it's asking me to define a connection, which i've done in ultradev with asp/IIS, but there aren't really instructions on getting this working for me. the dwmx help file sent me to mysql.com, where i grabbed the app and

Re: How to prevent a user from dropping/creating a database

On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote: > Hi all, > > I'm wondering if there is some way to setup privileges in the grant > tables such that a user can create or drop any arbitrary table in > databases that user is associated with, but be unable to create or drop > t

RE: Question:

Kira, please correct your subject line and ask your question again. -ms -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 3:52 PM To: [EMAIL PROTECTED] Subject: Question: Question: can I install mySql on my computer and test php with

Question:

Question: can I install mySql on my computer and test php with dreamweaver mx? it's asking me to define a connection, which i've done in ultradev with asp/IIS, but there aren't really instructions on getting this working for me. i've got win2k. thanks for any help ~kira

RE: Can we make some C, Java based "Mysql App Server"

sorry i'm gonna learn java soon but i only develop in php right this minute thats my level :| , but the OO in java is similir to php so i an pick it up -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:15 AM To: Daniel Rossi; [EMAIL PROTECTED]

Re: Request: please use meaningful subject lines

On Wed, Apr 02, 2003 at 11:14:56AM -0800, Michael Shulman wrote: > > Please try to use more informative subject lines in your > queries. You'll be more likely to get good help quickly. Agreed. I simply delete messages with subject lines that don't say anything specific. I wish ISPs asked all th

RE: Problem with sum()

Thanks, I'll do that. -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:52 PM To: LeTortorec, Jean-Louis Cc: '[EMAIL PROTECTED]' Subject: Re: Problem with sum() Because neither 0.7 nor 0.1 have an exact binary floating point reprsentati

RE: Problem with sum()

Because you are using a float. There has been much discussion of this on the list, search the archives. Floats aren't so good if you need your math to be right. http://www.mysql.com/doc/en/Column_types.html > -Original Message- > From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED] >

Re: Problem with sum()

Because neither 0.7 nor 0.1 have an exact binary floating point reprsentation. Use Decimal type instead. LeTortorec, Jean-Louis wrote: Hello every one, I have a simple table, with a "float" field called quantity. In this table, there are 2 records: 1 with quantity=0.7, and 1 with quantity=0.1.

Problem with sum()

Hello every one, I have a simple table, with a "float" field called quantity. In this table, there are 2 records: 1 with quantity=0.7, and 1 with quantity=0.1. When I do a "select sum(quantity) from mytable", I got 0.798956919 instead of 0.8. Does any body know why? Thanks. Jean-Louis

Re: Migrate mysql from SunOS 5.8 to Windows 2000

Thank you Martin to give me good suggestion. As we know, windows 2000 is not as stable as unix. If other than operating system and hardware perspective, are there any other difference of mysql running on unix and mysql running on windows? Thank you, Jannie From: "Martin" <[EMAIL PROTECTED]> To:

Re: Migrate mysql from SunOS 5.8 to Windows 2000

On Thu, 03 Apr 2003 20:24:23 +, "Jannie Qu" <[EMAIL PROTECTED]> wrote: >We will migrate MySQL 3.47 from SunOS to Windows 2000. That's the dumbest thing I've heard for a long time. It sounds like a Pointy Haired Boss kind of decision. regards, -- Leif Biberg Kristensen http://solumslekt.org

Re: Migrate mysql from SunOS 5.8 to Windows 2000

Not if 0)strong processor (at least 2GHz) 1)you have enough RAM (1GB will do) 2)have enough SCSI or RAID Drives (with hopefully 1GB Free) 3)gets tricky with Process Management as Win2k process Management utilities are sparse (no cron or kill utilities) -Martin - Original Message - From: "Ja

Re: mysql equivalent for oracle.jdbc.pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 abjett wrote: | Does anyone know of a mysql equivalent for oracle.jdbc.pool? | | I am modifying code that uses OracleConnectionCacheImpl, | OracleConnectionPoolDataSource, classes I from oracle.jdbc.pool. | | Thanks for any help Use DBCP (http://jakarta

Re: Re: Help with 4.0.12 on WinXP

Mark, Your suggestion certainly sounds plausible. However, I have no control over the connections with Zeos Database Objects. Even though I open the actual database connection at the start of the program, it appears that each query forces a new connect/disconnect. In fact, in perusing through

Migrate mysql from SunOS 5.8 to Windows 2000

Hi, group, Greeting. We will migrate MySQL 3.47 from SunOS to Windows 2000. (I guess I have to use mysqldump). Well, I wonder any one of you who knows whether there is any forseeable problem of using production/busy mysql database on windows 2000 operating platform? Thank you, Jannie ___

mysql equivalent for oracle.jdbc.pool

Does anyone know of a mysql equivalent for oracle.jdbc.pool? I am modifying code that uses OracleConnectionCacheImpl, OracleConnectionPoolDataSource, classes I from oracle.jdbc.pool. Thanks for any help Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: Suggestions for choosing GUI Language that has a MySQL DB backend

The application will be run on windows2000. Or maybe Linux ... there is some choice ;-) >>Will this run on Windows or Linux? Thank you, Martin, Mitko, John Griffin, David Christensen, Michael T. Babcock, and sundisk for your replies. (Sorry for the delay...I work in several locations on Thurs

Re: date ranges

Bruce Feist wrote: Instead, if the four dates are s1, e1, s2, and e2 (s=start, e=end), we want: s1 <= e2 /* first range can't start after second range ends */ AND s2 <= e1 /* second range can't start after first range ends */ Bruce Feist also wrote: Your original suggestion works if

Re: Thoughts on MySQL training?

i attended this class back in September, it was MORE than worth the cost!! - hcir mysql sql On Wednesday, Apr 2, 2003, at 12:26 America/Anchorage, Rachel Rodriguez wrote: I should have been more specific: we're looking at the "Using and Managing MySQL" training. Opinions appreciated. ~RR ---

Re: date ranges

Matt Gostick wrote: Sarah Heffron wrote: I have a date range (start date and end date) supplied by the user and I also have information in a table that has start dates and end dates. I want to select everything in the table whose date range overlaps in any way with the date range given by the

new user needs help getting started

I have two machines that I have installed red hat 8.0 on and with it the mysql v 3.23.52. I have used admin and query tools to communicate with both from a local machine using both localhost via unix socket and via host name via tcp. When trying to communicate over the net from a different machine

Re: Conception - Tree - Recursivity -Address book - Query speed

On Wed, 02 Apr 2003 16:53:44 +0200, Grégoire Dubois <[EMAIL PROTECTED]> wrote: >Creating the tree doesn't give me problem. Where I ask me some >questions, is the speed to get the whole tree from the database in a >recursive way. I've made a PHP script doing genealogical descendancy charts that

RE: Conception - Tree - Recursivity -Address book - Query speed

I'm not sure Celko described all the queries in those articles (the url I sent plus the followups in April and May that year. You'll have to hunt down those follow-ups. But, for a much easier reference, look at Joe Celko's _SQL For Smarties_, where in one of the later chapters, he covers the nest

Saving the command buffer

Hello, I've been searching the manual and the web for information on saving the last command I just typed in at the mysql> prompt. If I create a complex command in SQLPLUS that I'd like to use in the future, I can then type "save greatcommand.sql", and the last command executed is saved to the cu

Re: Suggestions for choosing GUI Language that has a MySQL DB bac kend

I second that > :-) My offering would be to suggest developing in Delphi or Kylix, > depending on the platform. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Suggestions for choosing GUI Language that has a MySQL DB bac kend

:-) My offering would be to suggest developing in Delphi or Kylix, depending on the platform. David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Thursday

Mysql and POP3? Need help

Hi... Thanks to the great help on this list (including Juan), I was able to get postfix working with mysql. Now, of course, I need to be able to read the mail being forwarded. :) Due to restrictions beyond my control, it needs to be a pop3 server - I would prefer IMAP, but pop3 it is. And th

RE: Suggestions for choosing GUI Language that has a MySQL DB backend

Hi David, check out http://gtk.php.net/ It is a GUI toolkit with a PHP interface to allow you to build client applications. John Griffin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 11:25 AM To: [EMAIL PROTECTED] Subject: Suggestio

Re: Suggestions for choosing GUI Language that has a MySQL DB backend

I have been asked to write an interactive GUI program that allows for the display of results from related queries. For example, launching the application wil generate the first query, which will return a list of names of individuals. May I suggest Python with PyGtk+ and using Glade to build th

Re: Help with 4.0.12 on WinXP

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dan Cumpian wrote: | Hello, | | | | I am having the following problem that I've been able to consistently | replicate: | | | | I am using code written in Delphi with Zeos Database components and am | having a problem with a query returning "server conne

retry: Searching for values such as "10.2.4" via fulltext (more info)

Since no one responded to this message at all, I'm sending it again. I have a support system set up where people can search for various things using a fulltext index. The problem that I am having, though, is that I cannot seem to figure out how to get search results for values like "10.2.4" or

Storing queries

Hi, List, Just wondering... Anybody have a good method to store queries? I know MySQL doesn't support stored procedures at this time (will in 5.x, I guess). Obviously, I can just stash it in a varchar field in a table somewhere, then select it and execute it in a separate query, but is there

Re: Suggestions for choosing GUI Language that has a MySQL DB backend

If speed isnt a issue I would say develop with one of the interpreted languages (Perl/Python) My experience trying to get anything compiled under linux or windows because of missing headers or libraries will cause you and your project to experience insufferable delay. Regards, Martin - Original

MySQL 4.0.12 / UPDATE using 2 tables / ERROR 1114: The table is full

I've seen this on the mailing lists just a day ago ('*have a problem'*), and wow! I have a similar problem. None of the suggestions in the online documentation helped. I tried both MyISAM and InnoDB table formats. This obviously only works on MySQL >=4.0 (I'm running the 4.0.12 RPM on Linux). U

RE: Suggestions for choosing GUI Language that has a MySQL DB backend

I would use C + GTK+ (if the os is linux). MySQL has a very nice C API (which is well-documented, I think) and GTK+ is the most common and preferred GUI development kit for Linux. If the platform is Windows, the GUI will be something else but I would still use C for the MySQL stuff. HTH,

Re: 4.0.12 libmysqlclient.a

Allen- nm shows that the library libmysqlient.a contains the required my_close mysql_real_connect functions in Text section of libmysqlclient.a and yet I cannot resolve to it..*hmm* I have decided to attempt to compile libmysqlclient.c but am finding missing the header ctype-simple.h Cheers, Ma

Re: Thoughts on MySQL training?

Many thanks to all for responding to my query regarding MySQL training. Your honest opinions were greatly appreciated! BTW, the general consensus was that it was quality training and worth the price. Thank you, Rachel __ Do you Yahoo!? Yahoo! Tax

Suggestions for choosing GUI Language that has a MySQL DB backend

Hi MySQL Listers, I'm wondering if someone might provide some guidance about what programming language might best accomplish the following. I have been asked to write an interactive GUI program that allows for the display of results from related queries. For example, launching the application w

Re: 4.0.12 libmysqlclient.a

On Thursday 03 April 2003 15:37, Martin Gainty wrote: > The unfortunate consequence of those who think RTFM will actually help Hmph. > The test_libmysqld example is embedded in the online manual located at: > \MySQL\mysql-standard-4.0.12-pc-linux-i686\manual.html A path to a file that's not on

How do I tell which mysql process has a lock?

Greetings. How do I tell which mysql process has a lock on what tables? I'm using mysql 3.23.54-Max with MyISAM tables on Linux 2.4.9-34 (RedHat 7.2). We've got about 20 users and a myriad of automated scripts (Perl DBI, Java JDBC) connecting to the database on a regular basis. Thanks. -- M

re: How can i change charset in mysql ?

On Wednesday 02 April 2003 20:30, Pratchaya Chatuphian wrote: > I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir > How can i change charset sir ? > i want to use tis-620 .. sir > Any one can help me sir ... ? > > Just mean change the my.conf ? ( my-small.conf , my-medium.conf , ) You

re: loading data from a back up file

On Thursday 03 April 2003 09:28, Justin French wrote: > I have a 2.7meg dump of SQL created by phpMyAdmin [1], however when I try > to import this data back into mysql through phpMyAdmin, it times out > (understandably), so I guess I need to do this from the command line, but > have no idea how to

re: Schema definition fails when converted to InnoDB

On Thursday 03 April 2003 12:40, Ian Hartas wrote: > >Description: > > I have a database schema .sql file which is accepted when run with > MyISAM tables. If I change the tables to be type = InnoDB, then it fails > with the error message: > > mysql -u ts -p hbs ERROR 1005 at line 54: Can'

re: re: How come I can't use an "AS" field in other operations?

On Wednesday 02 April 2003 22:36, Daevid Vincent wrote: > so then the next obvious question to ask is... is this just not > implemented yet, or is it not even on the radar as a 'feature'? It'a behaviour. You can refer in the HAVING, ORDER BY and GROUP BY, but you can't in the select list and WHE

re: Can I enlarge user table's User field ?

On Thursday 03 April 2003 09:57, Heo Jungsu wrote: > mysql> show columns from user like 'User' ; > +---++--+-+-+---+ > > | Field | Type | Null | Key | Default | Extra | > > +---++--+-+-+---+ > > |

re: RE: password not working from command line

On Wednesday 02 April 2003 17:19, Eldon Ziegler wrote: > The contents of the user file are attached. The user name is testit and > there is no password. This is server version 3.23.52, the version that came > with the Red Hat 8 distribution. > > I entered mysql -utestit then USE mysql; and got > ER

Re: date ranges

> >>I have a date range (start date and end date) supplied by the user > >>and I also have information in a table that has start dates and > >>end dates. I want to select everything in the table whose date range > >>overlaps in any way with the date range given by the user. > >Well... if you

Re: table structure design

Hi About Entity Relationship Diagrams: I use Graphviz to generate ERD's on the fly, from the database. Graphviz is very cool: http://www.research.att.com/sw/tools/graphviz/ Graphviz draws graphs from files written in its language (called 'dot') Your PHP script (or language of choice) needs to get

Re: Schema definition fails when converted to InnoDB

You can't add constraints referencing indices that don't exist. Create your indecies first. Ian Hartas wrote: Description: I have a database schema .sql file which is accepted when run with MyISAM tables. If I change the tables to be type = InnoDB, then it fails with the error message

Re: 4.0.12 libmysqlclient.a

Allen- The unfortunate consequence of those who think RTFM will actually help The test_libmysqld example is embedded in the online manual located at: \MySQL\mysql-standard-4.0.12-pc-linux-i686\manual.html Cheers, Martin PostScript: I am still looking for library that will resolve MySQL *one = db_c

Re: Conception - Tree - Recursivity -Address book - Query speed

Thank you very much for your answer. I read the article. I've understood that this nested tree model (with the "worm", I liked the image), permits to retrive very easiely the path of a node, and some other things. But : I've understood that if we want to modify the tree, all left and right numb

RE: Please HELP!!! Re: Database Core Dumps

Hi Mark and Steffan, We solved this problem today and it was as Mark details below. We have installed the latest version available, and it now works fine :-) Phew! Thanks very much to everyone for their help, Best regards, Stewart -Original Message- From: Mark Matthews [mailto:[EMAI

Re: Can we make some C, Java based "Mysql App Server"

Daniel How about 1 working Java or C or C++ example which uses MySQL Personally every example I have used (both Linux and Windows) uses libraries which cannot resolve the simplest MySQL functions with no ability to recover. Very frustrating. Thank You, Martin - Original Message - From: "Dan

Re: table structure design

Lots of them. None cheap. What ever you do, steer clear of the one at www.thekompany.com. It's a piece of crap. I bought a version and then foolishly bought an upgrade thinking it would be better. it's not and the primary programmer for the project is very arrogant on the mailing list setup for

RE: Can we make some C, Java based "Mysql App Server"

Woah... scope creep.. hehehe Actually, I've done a little something along these lines with the MySQL C++ API (Unfortunately in VC++). I've found it useful for throwing together apps against the same db quickly. This, however, would be even better... If anyone decides to shoot forward on this, p

Re: BUG: NT service account and defaults file

At 17:04 02/04/2003 +0100, Simon Tyler wrote: Hi, Looking at the code (3.23, 4.0 and 4.1) it looks as if it is getting confused in the main (in mysqld.cpp) and just calls Service.Init without loading the default file. Doing the above without a service name works OK, doing it without over-riding

Re: Please HELP!!! Re: Database Core Dumps

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TRANTER,STEWART (HP-Germany,ex1) wrote: | Hello Everyone, | | Yesterday I posted the message listed below. I have some more information. | We have found the command that "pushes our database over the edge"! It is: | | SHOW VARIABLES; | | All other db c

Re: Please HELP!!! Re: Database Core Dumps

Stewart, > Yesterday I posted the message listed below. I have some more information. > We have found the command that "pushes our database over the edge"! It is: > SHOW VARIABLES; > All other db commands work (such as SHOW VARIABLES "%a";) except for: > SHOW VARIABLES "%" This should be "SH

AW: Schema definition fails when converted to InnoDB

> -Ursprüngliche Nachricht- > Von: Ian Hartas [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 3. April 2003 11:40 > An: [EMAIL PROTECTED] > Betreff: Schema definition fails when converted to InnoDB > > > >Description: > I have a database schema .sql file which is accepted > wh

Schema definition fails when converted to InnoDB

>Description: I have a database schema .sql file which is accepted when run with MyISAM tables. If I change the tables to be type = InnoDB, then it fails with the error message: mysql -u ts -p hbs How-To-Repeat: Save this text as schema_mysql.sql and run it as noted in the descript

Re: 4.0.12 libmysqlclient.a

On Wednesday 02 April 2003 19:32, Martin Gainty wrote: > Attempting to run the makefile for test_libmysqld.c Where does this file test_libmysqld.c come from? I'm working with the 4.0.12 distribution, there's nothing called that in the package I have. ... > /cygdrive/g/mysql/test_libmysqld/test

Please HELP!!! Re: Database Core Dumps

Hello Everyone, Yesterday I posted the message listed below. I have some more information. We have found the command that "pushes our database over the edge"! It is: SHOW VARIABLES; All other db commands work (such as SHOW VARIABLES "%a";) except for: SHOW VARIABLES "%" Does anyone have any

RE: Join Statement

Thanks for tip, I`ve been doing a bit of reading up and have solved the problem. Your advice will be stored for future reference, thanks. On Wed, 2003-04-02 at 21:31, Michael Shulman wrote: > You can't use a JOIN on an insert, only on a SELECT. > > The (simplest) syntax for INSERT is > > INS