mySQL q.

2003-02-12 Thread eliran
Hi, My name is Eliran and I'm working at Rimed company in Israel. We consider to use MySql as a database for our application. I installed MySql 3.23 on window XP. I want to know what I must do in order to be able to run the C++ example it give me the following error: "Error: Unknown database 'mysql

MySQL table locking?

2003-02-12 Thread H. Scott Brown
Hello, list, I'm having a weird issue with table locking. I'm running MySQL 3.23 on a Win2k server, used for eCommerce applications. All settings appear to be in order, that is, KeepAlive is 30, connection pooling is on, with a timeout of 30. The tables in any given database seem to remain loc

Re: Licence Free Import/Export for Access?

2003-02-12 Thread Daniel Kasak
Neil Williams wrote: Hi Is there a licence free way to Import (and Export) Access databases (mdb files) into (out from) mySQL? I've read the FAQs and looked at the converters available but it appears to me that all of these require the Access program to work. Is there any way of converting to/

RE: Licence Free Import/Export for Access?

2003-02-12 Thread Christensen, Dave
Yes, I think you misunderstood. You don't have to own MS Access or have it on your PC to use DBScripter. You DO have to set up an ODBC data source that points to the Access database though. That process can be accomplished without owning Access. -Original Message- From: David T-G [mailt

Re: Licence Free Import/Export for Access?

2003-02-12 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave & J, et al -- [re DBScripter and urSQL] Those are nice tools, but if I read you correctly they only work if one has MS Access. The original poster, if I read *him* correctly, wants a way to read Access DB files and turn them into MySQL files --

Re: Exporting Data

2003-02-12 Thread Greg Donald
> How would you export your data from the mysql tables to a tab or coma > delimiter. There are lots of ways, here are my favorite two: mysqldump: http://www.mysql.com/doc/en/mysqldump.html phpMyAdmin : http://phpmyadmin.sourceforge.net/ -- Greg Donald http://destiney.com/ -

Exporting Data

2003-02-12 Thread Stephen Lewis
How would you export your data from the mysql tables to a tab or coma delimiter. Thank you, Stephen A. Lewis [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

Dump from big table in MySQL

2003-02-12 Thread Grover Cussi N.
Hello!! when I do mysqldump of a big table, the process is killed, and it is not posible make the dump. I read in the list of somebody who did a dump of database with 4G size. Which variable it is necessary to modify for making a dump using mysqldump, or it is necessary to move a better machi

Bug with innodb multi-table delete and foreign keys.

2003-02-12 Thread Scott Wong
Version: Mysql 4.0.10-gamma Description: ERROR 1105: Unknown error after issuing a multi-table delete on parent/child table. if there's no foreign keys .. works ok. How to Repeat : drop table parent; drop table child; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id

A bug with innodb and non innodb multi-table delete.

2003-02-12 Thread Scott Wong
Version: Mysql 4.0.10-gamma Description: Mysql client loses connection when doing a multi-table delete if one table is innodb and the other is myISAM. How to Repeat : drop table parent; drop table child; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNOD

Re: Managing replication logs

2003-02-12 Thread walt
Danny Haworth wrote: > I too would be interested in a good way of clearing the binary log files > (preferably non disruptive to the server ;-) > The only thing thats saving me so far is that the systems capacity is 320Gb. > > danny > > Anirudha Kukreti wrote: > > >hi all > >i have established a tw

info-dir-section element missing in .texi (4.0.10)

2003-02-12 Thread ch
>Description: There is a missing element in the texi file. >How-To-Repeat: N/A >Fix: --- mysql-orig/Docs/manual.texi Wed Feb 27 23:45:07 2002 +++ mysql-patched/Docs/manual.texi Wed Feb 27 23:44:49 2002 @@ -56,6 +56,7 @@ @ifinfo @fo

Re: cannot compile 3.23, 4.0 or Redhat SRPMs

2003-02-12 Thread Dan Nelson
In the last episode (Feb 12), Nigel Wetters said: > whichever way I try, I'm having no luck compiling on redhat 8.0. I've > tried with the latest 3.23 and 4.0 tarballs, the latest pull from > bitkeeper, and the redhat SRPMs. > > some details here: > http://bugzilla.redhat.com/bugzilla/show_bug.c

[ANN] Beta version of Lasso Studio 6 for Dreamweaver MX

2003-02-12 Thread Bill Doerrfeld
Greetings: If you use Dreamweaver MX and are looking for a very easy way to Web-enable your MySQL databases, please check out today's announcement of the immediate availability of the first beta release of Lasso Studio 6 for Dreamweaver MX. Details at: http://www.blueworld.com/blueworld/news/

Re: [ Creating a new user ]

2003-02-12 Thread jtx
Here are some commands to add a new user. Do this from the MySQL prompt: mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP -> ON databasename.tablename -> TO username@localhost -> IDENTIFIED BY 'password'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ->

RE: Generating an automatic e-mail via MySQL

2003-02-12 Thread Andrew Braithwaite
I am interested as to why no one seems to be using the DBI/DBD-MySQL perl modules? Because it's twice as much code to do the same job. Why format your data when the -H option to mysql can do it too? Cheers, A -Original Message- From: Karl Dyson [mailto:[EMAIL PROTECTED]] Sent: 12

cannot compile 3.23, 4.0 or Redhat SRPMs

2003-02-12 Thread Nigel Wetters
whichever way I try, I'm having no luck compiling on redhat 8.0. I've tried with the latest 3.23 and 4.0 tarballs, the latest pull from bitkeeper, and the redhat SRPMs. some details here: http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=84137 Has anyone else had similar problems? The reaso

RE: [ Creating a new user ]

2003-02-12 Thread Bryan Lipscy
RTM: http://www.mysql.com/doc/en/GRANT.html Also see http://www.catb.org/~esr/faqs/smart-questions.html -Original Message- From: Elby Vaz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 10:39 AM To: [EMAIL PROTECTED] Subject: [ Creating a new user ] Hello friends! Ho

mysql-embedded throws errors during compile/linking

2003-02-12 Thread Nigel Wetters
I'm running Redhat 8.0, and can't seem to get mysql-embedded to work. After installing the current 4.0 RPMs, I get a lot of errors when trying to compile the sample program as described here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld_example [root@gw nwetter

RE: Recursion

2003-02-12 Thread Andy Eastham
Amer, It's still worth storing the parentId, because you can easily recreate the fullpath if (when!) your code screws up a set of full paths. You can also write a reliable sanity checker that checks the full path of all the nodes in the table based on the parentids. Also, to locate multiple chil

[ Creating a new user ]

2003-02-12 Thread Elby Vaz
Hello friends! How do I create a new user on MySQL? I want to create the respective password too. Thanks, e. _ MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com --

load data infile command not allowed problem

2003-02-12 Thread chip . wiegand
I access a msyql server (apache/mysql/php) from my w2k workstation using phpMyAdmin. I do not have command line access. When I use the link to load a local data file it responds that it is not allowed. I read the mysql docs and see it is now disabled by default. In 4.2.4 one paragraph says "If y

RE: Licence Free Import/Export for Access?

2003-02-12 Thread j.urban
I've used urSQL (http://www.urbanresearch.com/ursql) to accomplish this for quite some time. You can click on an MS Access table and select "Build Script as MySQL" to get a MySQL-like CREATE TABLE script... On Wed, 12 Feb 2003, Christensen, Dave wrote: > There's a relatively low-cost ODBC utili

RE: Recursion

2003-02-12 Thread Amer Neely
> Subject: RE: Recursion >Date: Wed, 12 Feb 2003 09:36:11 - >From: "Andy Eastham" <[EMAIL PROTECTED]> > To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]> > > Rob, > > This is a common problem in document management, where I have a reasonable > amount of experience. > > Unfortuna

RE: Generating an automatic e-mail via MySQL

2003-02-12 Thread Karl Dyson
I am interested as to why no one seems to be using the DBI/DBD-MySQL perl modules? Something like: == #!/usr/bin/perl use strict; use warnings; use diagnostics; use DBI; my $dbname = 'DBI:$driver:database=database;host=dbserver.blah.com'; my $dbuser = 'dbusername'; my $

mysql control centre on freebsd

2003-02-12 Thread ravi
has anyone managed to compile mysql control centre for freebsd (4.5 or lower)? i am on the verge of giving up: my attempt to compile qt3 is failing since qt seems to require the threads libraries even if i configure with -no-thread, and without qt3 i cannot compile control centre. of course if yo

re: Create table, wrong datatype

2003-02-12 Thread Victoria Reznichenko
On Wednesday 12 February 2003 10:21, Ulla Wensman wrote: > When I run this script the char-fields is converted to > varchar. Row-format is dynamic. I think it is because i have a text-field > in the > script. When I change the text field to somthing else I got the datatype > char in the char-colum

re: two questions in mysql

2003-02-12 Thread Victoria Reznichenko
On Wednesday 12 February 2003 11:30, Inbal Ovadia wrote: > I have mysql 3.23.41 on windows 2000 > I have two questions I need to ask. > > 1) I want bigger value for the max_connections variable. >can I define the value in my.ini file? Yes. > how can I define this variable? set-variable=max_

re: Change default CHARACTER SET value

2003-02-12 Thread Egor Egorov
On Wednesday 12 February 2003 13:49, Mirko wrote: > To perform correct ORDER BY I need to use win1251 charset. > I know that this can be set from my.cfg or in the my.ini: > > [mysqld] > default-character-set=win1251 > > The problem is that I cant use this because I have limited account on > my hos

RE: Licence Free Import/Export for Access?

2003-02-12 Thread Christensen, Dave
There's a relatively low-cost ODBC utility called DBScripter that does a pretty good job creating scripts for exporting ddl and data from ODBC datasources. It allows you to build dialects for server-based SQL variations. I don't think that there's a current MySQL dialect, but looks pretty simple

RE: Generating an automatic e-mail via MySQL

2003-02-12 Thread Sherzod Ruzmetov
: Does any one have a suggestion on running a daily / weekly e-mail : notification based on results from a MySQL query? In your cron file do something like: echo "select * from table" | mysql [options] db | mail [EMAIL PROTECTED] If it's a more complex query: cat ~/quer

RE: Generating an automatic e-mail via MySQL

2003-02-12 Thread Andrew Braithwaite
I use perl for this. Something like this: -- #!/usr/bin/perl use MIME::Base64; use Mail::Sendmail 0.77; $email = '[EMAIL PROTECTED]'; $subject = 'some stuff here'; $entire_msg = `/usr/local/mysql/bin/mysql -H -e 'some query here' somedatabase`; $ma

Size limitation on Text field

2003-02-12 Thread Gord Muir
Thanks to all that responded to my questions about Full Text Searching. Being caught up in that paradigm I overlooked the simpler answer :) I am now experiencing a problem with pulling data from a Text (longvarchar) field in MySql. The data is entered into a TEXTAREA field on a web page and f

Re: Counting null values

2003-02-12 Thread Paul DuBois
At 9:41 +0200 2/12/03, Octavian Rasnita wrote: It won't work because MySQL doesn't count null values. It depends. count(FieldName) will not count NULL values count(*) will, because it counts rows, not values. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Origina

RE: mysql privs table level security

2003-02-12 Thread Andrew Braithwaite
It seems like you are getting privileges systems mixed up. No, I understand and have extensively read the below docs & more. Going down to the filesystem level is a nasty work-around to the problem. I want to know if there is any way to set certain tables to have SELECT only privileges witho

Re: How to modify ft_min_word_len?

2003-02-12 Thread Octavian Rasnita
Can I create my own my.cnf file if I am not the administrator of MySQL but I just have a database? Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:

Re: Counting null values

2003-02-12 Thread Octavian Rasnita
It won't work because MySQL doesn't count null values. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 8:18 AM Subject: Re: Counting null values Hi

Re: Generating an automatic e-mail via MySQL

2003-02-12 Thread andy thomas
On Wed, 12 Feb 2003, Dan Tappin wrote: > Does any one have a suggestion on running a daily / weekly e-mail > notification based on results from a MySQL query? > > I have a table with date sensitive rows. The idea that as rows become > stale (they were created / updated more than a week or month a

Re: Generating an automatic e-mail via MySQL

2003-02-12 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dan -- ...and then Dan Tappin said... % % Does any one have a suggestion on running a daily / weekly e-mail % notification based on results from a MySQL query? ... % % I have a feeling that I will get a few 'buy a PERL book' suggestions % which is

Re: Licence Free Import/Export for Access?

2003-02-12 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil -- ...and then Neil Williams said... % % Hi Hi! % % Is there a licence free way to Import (and Export) Access databases (mdb % files) into (out from) mySQL? I haven't seen one yet. It's quite possible that nobody has written a file convert

RE: mysql privs table level security

2003-02-12 Thread Salada, Duncan
It seems like you are getting privileges systems mixed up. The MySQL server has its own privileges system that is separate (sort of) from the filesystem privileges system. All queries within MySQL will be handled by the MySQL server privilege system. Within that system, you are able to control a

Generating an automatic e-mail via MySQL

2003-02-12 Thread Dan Tappin
Does any one have a suggestion on running a daily / weekly e-mail notification based on results from a MySQL query? I have a table with date sensitive rows. The idea that as rows become stale (they were created / updated more than a week or month ago) the owner of the row is sent an e-mail wit

Re: mysql privs table level security

2003-02-12 Thread Jerry
Write a script that generates all the GRANT SQL ? Then pipe it into mysql. I'd write a function that would go and get all the table name and a list of the relevant users then generate the sql from there. Jerry - Jeremy Hutchings Apps R&D Cable and Wireless --

MySQL 4.05a slave crashes using load data on the master

2003-02-12 Thread Mechain Marc
I have a configuration under MySQL 4.0.5a using many slaves and one master under Linux 2.4.18. The slaves always crash when using the command "load data infile" to populate a table on the master (the table exists on the slaves). Maybe this could help: - The master and the slaves are bind on a spe

Has somebody got an example of Foreign Keys

2003-02-12 Thread Ben Clewett
I am using 4.0.10-gamma-max-nt, with 100% innodb, and cannot get Foreign Keys to create. The help files give this example: CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE SET NULL ) TYPE=INNODB

Re: Is there anything equivalent to Oracle9i's list partitioning?

2003-02-12 Thread Alec . Cawley
> I've recently learned that Oracle has the ability to partition table > data, Oracle9i's list partitioning feature. > http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html > I'm trying to find out if MySQL or any open source database has > something equivalent to this. See the My

RE: mysql privs table level security

2003-02-12 Thread Andrew Braithwaite
Any idea at all, anyone? Cheers, Andrew -Original Message- From: Andrew Braithwaite Sent: 11 February 2003 17:52 To: [EMAIL PROTECTED] Subject: mysql privs table level security Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certa

RE: Licence Free Import/Export for Access?

2003-02-12 Thread Steve Sapovits
> Is there a licence free way to Import (and Export) Access > databases (mdb files) into (out from) mySQL? > > I've read the FAQs and looked at the converters available > but it appears to me that all of these require the Access > program to work. Is there any way of converting to/from MDB > f

Re: mysql 4.1 clustering/hign avaliability

2003-02-12 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kissandrakis -- ...and then Kissandrakis Giorgos said... % % Hello, Hi! % ... % Does mysql 4.1 have any extra culstering capabilities? I don't know about mysql directly, but I'm sure it would work just fine as an application under an OS cluster.

./support-files/mysql.server bug

2003-02-12 Thread Greg_Cope
Hi All, Downloaded mysql-standard-4mysql-standard-4.0.10-gamma-sun-solaris2.8-sparc.tar.gz. If this is NOT installed in /usr/local/mysql and you try and start it using support-files/mysql.server it fails with error: $ ./support-files/mysql.server start ./support-files/mysql.server: /usr/local/my

mysql 4.1 clustering/hign avaliability

2003-02-12 Thread Kissandrakis Giorgos
Hello, I have two servers each one has mysql 4.1 running with seperate disks Is there a way that the 2 mysqld have exactly the same data (besides replication) ? Is there a way that if one server crashes mysql will be avaliable? Does mysql 4.1 have any extra culstering capabilities? Thank you

Re: Very slow select query with IN(...)

2003-02-12 Thread Artem Koutchine
> On Wed, 12 Feb 2003 15:50:29 +0300 > Artem Koutchine <[EMAIL PROTECTED]> wrote: > > > Hi! > > > > I have posted this message yerstaday, but apperantly > > did not give enough information for reader to figure out > > what's going on. So, i am reposting it with more information. > > > > I have the

Re: error 2013 on rh8.0

2003-02-12 Thread Markus Reger
Heinz great hint - poor success actually installed is 2.2.93 if i force it in maybe mysql functions - other thing will fail in bulk. kr mr >>> Stefan Hinz <[EMAIL PROTECTED]> 02/12/03 15:41 PM >>> Markus, If you're lucky, you might be able to use this RPM: ftp://ftp.suse.com/pub/suse/i386/u

Re: Licence Free Import/Export for Access?

2003-02-12 Thread Neil Williams
Hi Is there a licence free way to Import (and Export) Access databases (mdb files) into (out from) mySQL? I've read the FAQs and looked at the converters available but it appears to me that all of these require the Access program to work. Is there any way of converting to/from MDB files without

Re: Is there anything equivalent to Oracle9i's list partitioning?

2003-02-12 Thread Dan Nelson
In the last episode (Feb 12), Jeff Bearer said: > I've recently learned that Oracle has the ability to partition table > data, Oracle9i's list partitioning feature. > > http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html > > I'm trying to find out if MySQL or any open source databa

Re: Very slow select query with IN(...)

2003-02-12 Thread Artem Koutchine
No, I do not believe that MHZ is the bottle neck. Basically, we can ignore that this is a dual box, because it is a FREEBSD and only one CPU runs a whole process. 650Mhz is enough for doing a little web search engine and I have seen a lot of applications which use the same technology (vocabulary t

Is there anything equivalent to Oracle9i's list partitioning?

2003-02-12 Thread Jeff Bearer
I've recently learned that Oracle has the ability to partition table data, Oracle9i's list partitioning feature. http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html I'm trying to find out if MySQL or any open source database has something equivalent to this. ---

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Roger Baklund
* Ahmed S K Anis [...] > String filepath = "sys:\\restore\\data1.txt"; > String query = "load data local infile \'" + filepath + "\' into table > x > > it takes as estoredata1.txt as file name not clear why ? A double backslash will in many environments be reduced to a single backslash. Your

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Yes Mark it worked from the command line. The Archived resides at the server side. I ran Load data local infile 'sys:\\mail\\dump.txt" into table X it worked. The from a different machine i ran this java program. The Arch

Cannot create table either now...

2003-02-12 Thread Ben Clewett
MySql, magor problems! Ver 3.23.52-max-nt I find I cannot create a table (in my db 'rr'), which probably caused my previous posted problem. Works perfectly with MyISAM, but not with InnoDB. No SQL differnce. When executing I get: MySql Error: Could not execute command [create table if not exi

Re: Strange sorting in table

2003-02-12 Thread Stefan Hinz
Viktor, > I have a couple of tables in a MySQL database. In one of the tables, > PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and > ID 22. Any idea why? Have a look at the table structure. You will find 'ID' is an AUTO_INCREMENT column. When entries are deleted, they leave "gaps

Re: Create table, wrong datatype

2003-02-12 Thread Stefan Hinz
Ulla, > When I run this script the char-fields is converted to > varchar. Row-format is dynamic. I think it is because i have a text-field in > the script. This MySQL feature (silent column type change) is documented here: http://www.mysql.com/doc/en/Silent_column_changes.html Regards, -- Ste

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Ahmed S K Anis
Yes Mark it worked from the command line. The Archived resides at the server side. I ran Load data local infile 'sys:\\mail\\dump.txt" into table X it worked. The from a different machine i ran this java program. The Archived file still exists at the DB server side. So i guess local option

新站开张,休闲好去处,请您点评一下.

2003-02-12 Thread 风光无限网站
mysql:ÄúºÃ! ÐÂÕ¾¿ªÕÅ,ÐÝÏкÃÈ¥´¦,ÇëÄúµãÆÀÒ»ÏÂ. Ö÷Á¦Õ¾£º¡¡http://fenggwx.126.com Á÷ÐиèÇúÒôÀÖÕ¾£º http://yinyuewx.126.com FlashÕ¾£º http://flashwz.126.com ¼«Æ·Ð´ÕæÍ¼Æ¬Õ¾£º http://jpxzw.126.com ÍøÖ·Õ¾£º http://webwz.126.com Ö Àñ! ¡¡¡

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti

Re: Migrating Microsoft Access to MySQL

2003-02-12 Thread Crercio O. Silva
Hi Edward, Use DBTools Manager 2.0.1 (http://www.dbtools.com.br). It imports structure, data, indexes, queries and relationships from MSAccess and it's totally free. []s Crercio - Original Message - From: "Edward Kim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 1

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Ahmed S K Anis
Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti on: ** BEGIN NESTED EXCEPTION ** java.io.FileNotFoundException esto

Re: Very slow select query with IN(...)

2003-02-12 Thread Brent Baisley
But you're not using the word search engine, which would be the full text index. I'm not sure what you mean by "morphology". MySQL 4 full text searches support a lot of things, including using * as the truncation operator. Aside from that, perhaps it's the speed of your processor that bottlene

Cannot drop a table.

2003-02-12 Thread Ben Clewett
MySql, Version 3.23.52-max-nt I cannot drop a table. My syntax is: drop table if exists cust I get: MySql Error: Count not execute command [drop table if exists cust] on server because: Unknown table 'cust' This is true, it does not exist, although I still have a cust.frm file for some reaso

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is not allowedwith this MySQL version

2003-02-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12, 2003 3:48:16 PM >>> Hello, I'm using this command into a Java se

error 2013 on rh8.0

2003-02-12 Thread Markus Reger
this is probably an issue already solved or at least treated on this list - so please forgive. nevertheless I encountered the error 2013 when i tried to connect from another machine to the machine holding the mysqlserver running with the standard mysql package resp. the updated mysql package

Re: Create table, wrong datatype

2003-02-12 Thread Doug Thompson
Hello: Because you have a variable length column type (text) in the row, mysql changes char() types to varchar. This behavior is discussed in the manual in Silent Column Change Specifications under CREATE TABLE. If the stored length of these columns is an issue, you can move the variable length

Re: Very slow select query with IN(...)

2003-02-12 Thread Rafal Jank
On Wed, 12 Feb 2003 15:50:29 +0300 Artem Koutchine <[EMAIL PROTECTED]> wrote: > Hi! > > I have posted this message yerstaday, but apperantly > did not give enough information for reader to figure out > what's going on. So, i am reposting it with more information. > > I have the following table:

Re: Managing replication logs

2003-02-12 Thread Danny Haworth
I too would be interested in a good way of clearing the binary log files (preferably non disruptive to the server ;-) The only thing thats saving me so far is that the systems capacity is 320Gb. danny Anirudha Kukreti wrote: hi all i have established a two way replication setup my problem is th

Re: mysql overhead

2003-02-12 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz said... % % MyISAM tables (the default table type in MySQL) become fragmented ... % % If you don't optimize fragmented MyISAM tables, they will become slow % to scan because the operating system will need mor

Very slow select query with IN(...)

2003-02-12 Thread Artem Koutchine
Hi! I have posted this message yerstaday, but apperantly did not give enough information for reader to figure out what's going on. So, i am reposting it with more information. I have the following table: create table law_words ( l_id int unsigned not null, w_id int unsigned not null,

Managing replication logs

2003-02-12 Thread Anirudha Kukreti
hi all i have established a two way replication setup my problem is that my hard disk gets occupied by the log files; i tried purging the files but after some time again my hard disk gets filled with the log files could any one please tell me how to manage the log files. thanks anirudh mysql, q

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version

2003-02-12 Thread Ahmed S K Anis
Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis >>> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12, >2003 3:48:16 PM >>> Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INT

Change default CHARACTER SET value

2003-02-12 Thread Mirko
To perform correct ORDER BY I need to use win1251 charset. I know that this can be set from my.cfg or in the my.ini: [mysqld] default-character-set=win1251 The problem is that I cant use this because I have limited account on my hosting provider's server (I can't restart the server and I even do

Re: Table name 'con' ignored.

2003-02-12 Thread Roger Baklund
* Ben Clewett > I was trying to create a table named 'con' on version 3.23.52-max-nt and > found my request was ignored: > > mysql> >create table if not exists con ( > code integer unsigned not null auto_increment primary key, > ... > ... >) type=innodb; > Query OK, 0 rows af

Table name 'con' ignored.

2003-02-12 Thread Ben Clewett
MySql, I was trying to create a table named 'con' on version 3.23.52-max-nt and found my request was ignored: mysql> create table if not exists con ( code integer unsigned not null auto_increment primary key, ... ... ) type=innodb; Query OK, 0 rows affected (0.00 sec) A 'show ta

Re: MySQL & MacOS9

2003-02-12 Thread Shamit Verma
Hi, The approach I am suggesting is the one that you might use as a last resort. I do not know much about C/C++ programming in OS9. If you could find some ODBC Driver ( or any other API that can be used from C++ on OS9 ) that could talk to JDBC drivers, then you may connect to MySQL from JDBC, and

MySQL & MacOS9

2003-02-12 Thread Stowasser Harald
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello List, I am realy stucked. My Application (C++,OS9) needs to connect to a MySQL-Database. But I can't find any informations how I can do that. Maybe you can give me a hint? Thats what i tried: 1. I found http://www.openlinksw.com/ (ODBC). Bu

JDBC and LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version

2003-02-12 Thread [EMAIL PROTECTED]
Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INTO TABLE news"; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allo

Re: bug with MERGE tables and MAX

2003-02-12 Thread Sergei Golubchik
Hi! On Feb 11, [EMAIL PROTECTED] wrote: > >Description: > MAX fails to return the correct value in some MERGE table situations. Fixed, thanks. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / //

RE: Recursion

2003-02-12 Thread Rob
Thanks. Awesome idea. We'll probably use that :-) --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -Original Message- From: Andy Eastham [mailto:[EM

Re: socket error

2003-02-12 Thread J. A. Tovey
I really am running it all again ! Obviously though I am going wrong somewhere... I have killed it all and run it again 3 times now and getting the same errors, I think it is because I have done it so many times now... I have copied and pasted everything that i have typed (sorry that it is quite al

RE: Recursion

2003-02-12 Thread Andy Eastham
Rob, This is a common problem in document management, where I have a reasonable amount of experience. Unfortunately, the short answer is, that to be completely generic, efficient and elegant, it's a bit of an impossible problem. What we have always done in this situation is to maintain an additi

two questions in mysql

2003-02-12 Thread Inbal Ovadia
Hi All, I have mysql 3.23.41 on windows 2000 I have two questions I need to ask. 1) I want bigger value for the max_connections variable. can I define the value in my.ini file? how can I define this variable? 2) I tried to insert into table a string with the char ' and mysql failed to do thi

MySQL SELECT and INSERT not following (my) logic

2003-02-12 Thread Andrew
I have the follow MySQL queries for pulling out ans then inserting a >record from >a record set. Unfortunately I think I have missed something (vital) as the >record being inserted is the value and not the name, for example 1 instead of >blue... can someone kindly have a look and spot where I hav

Re: Query Help

2003-02-12 Thread Mirko
I think you can't If you want this why is this table structure? Details shold be as columns nos as records in separate table - just to lose time ? On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell <[EMAIL PROTECTED]> wrote: Hi, How can I write a MySQL query to grab single lines of the form: C

MySQL not logging from my LINUX machine to windows

2003-02-12 Thread mike Hughes
Hi.. Ok i have snort working and logging on my LINUX machine192.168.0.1. They are alerts in /var/log/snort/alerts and portscan. I have it setup soo it is suppose to log to my windows machine192.168.0.69 running MYSQL. I have been using this as my reference: http://www.sans.org/rr/intrusion/pra

Create table, wrong datatype

2003-02-12 Thread Ulla Wensman
Hello! When I run this script the char-fields is converted to varchar. Row-format is dynamic. I think it is because i have a text-field in the script. When I change the text field to somthing else I got the datatype char in the char-columns. I have tried to alter the colums to char but it doesn't

³Ì·sø¹Ï³nÅ餤¤åª©¤W¥«Åo

2003-02-12 Thread cvxbcvbbn
(7¤ù¸Ë)¡Aµ´¹ï¶W­È!(Á`ª÷ÃB: 1000¤¸) Windows XP PRO SP-1 ¤¤¤å"±M·~"¥úºÐ¥¿¦¡ª© Windows XP Service Pack 1¥]§t¤F±qWindows XP¥h¦~10¤ë30¤é¤W¥«¥H¨Óªº©Ò¦³­×¥¿¡A ³o¨Ç­×¥¿µ{¦¡¥]§t¤F¦b¦w¥þ©Êªº´£°ª¡A©Ê¯àªº¥[±j¤Î¿ù»~ªº­×¥¿¡A ·íµM§ó¥[¤J¤F¥þ·sªºµwÅé³W®æ¤ä´©¡A¤×¨ä¬O USB 2.0ªº¤ä´©¡A ¦Ó¥þ·sªºWINDOWS XP°£¤F§ó·s¤F¨t²Î