/tmp/mysql.sock problem

Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it

MySQL Access 97 slow

Why do linked MySQl tables in Access 97 take longer to open thne linked Access 97 tables in Access 97? Is it MyODBC? Tom Worobec --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date:

release 4.0.2

Hello developers, What problem with release 4.0.2? Why you can't release it also as 'alpha' and continue work on next version like 4.0.3. You alredy fix many bugs and add many very nice features, such as query like 'MATCH ... AGAINST(... IN BOOLEAN MODE)'. Release it! We (users)

Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's included.

Michael, Stembridge, Michael wrote: Finally, I ran an EXPLAIN SELECT on my main query. (fyi, ticketid 1 has a noteid of 1) EXPLAIN SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start,

Re: Uninstalling MySQL

On Mon, 3 Jun 2002, Mysql Help Service wrote: I have built a MySQL binary from source and have installed it with no problem. However, when I go to make uninstall, make bombs on me. Any recommended way for uninstalling a MySQL distro? su -c 'make uninstall' Thomas

Re: /tmp/mysql.sock problem

Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which

Null Values in child table with no values in Parent Table

Hi All I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table Is it possible that i have no entries in parent table , and i am inserting null values for parentid in child table.. sql,query Regards,

mysql-4.0.1 installtion problem on redhat

From: ymalik To: [EMAIL PROTECTED] Subject: [Installation ] Description: precise description of the problem (multiple lines) mysql-4.0.1-alpha (Official MySQL RPM) installtion problem How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to

Re: WinZeos and Transactions

If WinZeos you've written about is the Zeos Database Objects (http://www.zeoslib.org), then I think I know the solution for your problem. First of all you don't have to BEGIN a transaction because when using an InnoDB connection, you always have an apened transaction, and when you close it by

upgrading php for mysql support

Could anyone help me please? I am currently using 4.0.6 which was installed before mysql and has no support. I have downloaded compiled and installed php 4.2.1, restarted Apache, but it continues to run the old 4.0.6. Is there a procedure I should follow or command line I dont know?

repair problem

hello, i have a broken table and mysql seems not to fix it: mysql repair table ksiegi; +--++--+--+ | Table| Op | Msg_type | Msg_text | +--++--+--+ | gbook.ksiegi | repair | status | OK |

RE: WinZeos and Transactions

Thanks for your help Daniel. I've tried transactions with ZeosDBO 5.3.0 beta6 and it worked well. The problem is that I want not to change zeos component 3.0.3 to 5.3.0 because it changes some things (first changes the names of the components) and I have to change the code of the application.

Re: innodb_flush_log_at_trx_commit

Jeremy, do we have the control as to WHEN to update the actual tables??? Thanx.. Ritu Singla --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu singla wrote: Hello, in InnoDB tables in MySQL, if innodb_flush_log_at_trx_commit is set to 1, then

can't start mysql.server

hi, my machine is compaq alphastation DS20E, and the mysql verision is mysql-3.23.49-dec-osf5.1-alphaev6(binary package) after executed scripts/mysql_install_db, I copy the mysql.server from /usr/local/mysql/support-files to /usr/local/mysql/bin, then executed mysql.server start and some error

Re: upgrading php for mysql support

Hi. This is a PHP and not a MySQL issue and therefore off-topic here. Please fine some appropriate PHP forum to ask. Bye, Benjamin. PS: The PHP READMEs contain the procedures to follow. On Tue 2002-06-04 at 02:56:25 -0700, [EMAIL PROTECTED] wrote: Could anyone help me

Re: can't start mysql.server

Have a look to mysql error log located in /usr/local/mysql/data David - Original Message - From: Paul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 12:15 PM Subject: can't start mysql.server hi, my machine is compaq alphastation DS20E, and the mysql verision

Where do i get 3.23.50 Max

Hi All MySQL Max doesnt support the feature of the column ,which is referred to be a foreign key , to be null But the Inno Db Site says We suppress the FOREIGN KEY check if any of the column values in the foreign key or referenced key to be checked is the SQL NULL.This is compatible with Oracle

How to get data from MySQL with perl

How do I query a database with Perl - retrieve a item and then have that as a var to use in another insert statement Currently I have : Use DBI I define: my vars : host,db,username,password etc I create my db object etc I used the script to do a insert to my db and it worked fine - but I

MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html

Hi! People on the mailing list are asking where they can download MySQL-(Max)-3.23.50. It is available from http://www.mysql.com/downloads/mysql-3.23-pre.html. The release .50 is a regular stable release for all the other platforms except Linux. In the Linux version there is a bug in the

Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html

Hi Heikki Tuuri I am not sure whether it's the Max version of MySql 3.23.50 Coz the URL differs for ordinary version and Max Version.In the Max version , i couldnt see anything beyond 3.23.49 -Arul - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Loading data from file

USING LOAD LOCAL INFILE Have a database file 15000± records however only approximately 8300 will load in from the file. I found some of the records that did not load in and they appear to be ok. So I emptied the loaded fields and tried to just load approximately 180 records that did not load

Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html

Arul, you find, for example, the following binaries from that page: Binary packages (tar.gz) MySQL 3.23.50 Linux (Intel libc6 systems) Download MySQL 3.23.50 Linux (Alpha) Download MySQL 3.23.50 Linux (IA64) Download MySQL 3.23.50 Linux (Sparc) Download MySQL-Max 3.23.50 Linux (Intel libc6

Replication not staying connected

Description: Replication has been running fine for the past few months. Last night after we did a couple of table rebuilds and a few hundred thousand sql updates, replication started falling behind due to the slave disconnecting every minute or so. Here's what

processlist

Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. regards tsa -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:04:29 This message was sent by ME!

Bug related to large tables and it's indexes on Win2k

Hi all, When large tables are being addressed, we seem to have encountered a bug related to having large indexes on the table. We have several tables in our system that have reached 4 gigs in size. We altered the table definition to allow it to get larger... this is our current table creation

Re: processlist

On Tuesday 04 June 2002 15:07, [EMAIL PROTECTED] wrote: Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. `mysqladmin -v proc` Or (in mysql client) mysql SHOW PROCESSLIST; regards tsa --

Re: processlist

Hi, Just connect to mysql and use this query : show processlit; http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html You can also use slow query logs. http://www.mysql.com/doc/S/l/Slow_query_log.html David - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday,

Problem in inserting date

create table dt (dt datetime); --- OK insert into dt values ( date_format('04/06/2002 13:48:38', '%d/%m/%Y %H:%i:%s')); --- Surprisingly it enters NULL insert into dt values ( date_format('2002/04/06 13:48:38', '%Y/%d/%m %H:%i:%s')); --- Surprisingly (not really) it enters correct date WHY is

Re: RE: InnoDB and Windows

Alexandre, Monday, June 03, 2002, 8:08:14 PM, you wrote: AZ Maybe this thread has already been solved. If so im sorry for the disturb. AZ Here is my problem: AZ I want to use InnoDB transactionnal table types with mysql on Windows 2000 . AZ I set my ini file correctly, start the console and

Re: Newbie - How 2 ODBC/JDBC to MySQL

Mary, Monday, June 03, 2002, 11:00:17 PM, you wrote: MDI just installed MySQL. Win 2000 Professional. MDI am logged in as none. MDNo User Id. No Password. MDI wonder how. :) Check the manual. By default on Windows all local users have full privileges on all databases. MDI

Re: files in /tmp

Don, Monday, June 03, 2002, 11:13:59 PM, you wrote: DV there are 2 files in my /tmp directory that look like mysql datafiles: DV #sql208_ecc_0.MYD DV #sql208_ecc_0.MYI DV They're on the same box as our development mysql instance but I don't see them on any of our other instances. Anyone have

Re: Null Values in child table with no values in Parent Table

Arul, Tuesday, June 04, 2002, 9:23:34 AM, you wrote: A I have created a table parent and also another table child where parentid A column in child is a foreign key to the id column in parent table A Is it possible that i have no entries in parent table , and i am inserting A null values

Re: changing the root password

Chris, Tuesday, June 04, 2002, 12:08:38 AM, you wrote: CS I can't remember my root password. I know that there is a way to set it by CS starting mysql with certain parameters, but I can't remember what those CS parameters are. Can you help me out? Thanks! You should start mysqld with

Re: processlist

thanks David, i have allready seen that but what is exactlly them command line to do so? EX: the select queries or the update ones in all databases or in just in one. regards tsa On 04-Jun-2002 David BORDAS wrote: Hi, Just connect to mysql and use this query : show processlit;

Re: Re: /tmp/mysql.sock problem

adam, Tuesday, June 04, 2002, 12:05:30 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D a Thanks. However, something's still wrong. a Restarted the daemon -

Re: processlist

thanks Sergey, but that command line only shows the total processlist, it doesn't show exactlly witch queries are happening on my tables besids my one that says 'show full processlist'.The others are sleep , but if they are really, why is my mysql server running severls processes with 11.5 Mgs

OT GUI front-end on Mac OS X?

Is anyone successfully accessing MySQL from Mac OS X via a GUI front-end? Any advice? Thanks, Andrew __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

JDBC Drivers

Hi Could anyone suggest me the JDBC Drivers available for MySql. Can the driver support Connection Pooling and RowSet -Arul - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: processlist

Think that even if mysql don't have connection, there are severals processes running ... For waiting connection for exemple. with 11.5 Mgs or so This memory is i think a buffer or a cache shared by each mysql process such as indexes for exemple ... David From: [EMAIL PROTECTED] To: Sergey S.

PLEASE SEE THE MYSQL.ERR FILE ATTACHED

Good Morning, Please see into file mysql.err look the InnoDB errors. We are working with 4.0.1-alpha-max-nt-log versión under operating system Windows 2000 advance Server. Our database have about 13GB of disk. Thank you for your help. We are waiting for your solutions or comments. Best

Re: processlist

Hi, If show processlist is not satisfied for you the try : show full processlist; On the right you can see the current query. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

Re: Problem in inserting date

Bad answer. If you 'guess', then don't answer. The idea behind the date_format is to format a date as per user's need and should not be forced to a particular format just because some countries follows some format. Still looking for serious answer? - Original Message - From: Harald

Full-Text Search Help!

I've implemented a full-text index on several of my database fields in a table, populated those fields with some very simple, yet distinct records, and have run recommended queries against that table. Alas, I still end up getting back empty query sets. I have read about having a minimum of 3

Re: Bug related to large tables and it's indexes on Win2k

Win2k (at least the version that we are on) does indeed support files much larger than 2 gigs. Another db we use has index files that are 6.8 gigs and 4.7 gigs. - Original Message - From: miguel solorzano [EMAIL PROTECTED] To: Jared Richardson [EMAIL PROTECTED]; [EMAIL PROTECTED];

RE: ON DELETE , ON UPDATE Operation

No, there are no STANDARD libraries that will do this for you. There are some good database abstraction layers that you can employ, my fav is ADODB (hit google to find it) but it only handles the basics. You will have to write PHP code that you call each time you delete a record to do additional

Re: OT GUI front-end on Mac OS X?

SQL4X Manager by InterServices has worked for me, it doesn't have much for meta edit guis though (alter tables and grant/revoke users) On Tuesday 04 June 2002 8:05, you wrote: Is anyone successfully accessing MySQL from Mac OS X via a GUI front-end? Any advice? Thanks, Andrew

Equivalent SELECT for SHOW command

Hello all, Are there any system_table which I can to do a pure SELECT command to get the same results that MySql SHOW command, in the same way that Oracle DB ? Thanks.. - Before posting, please check:

How to write output of sql stmt to file

Hi there, I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the

Frontend and report tool

Hi Can anyone tell me if they know about a good frontend for mysql with reporting facilities, or alternatively only a report generator? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Problem in inserting date

This date formatting is how mysql handles dates. If it cannot parse the date then is will store an invalid date. Please see http://www.mysql.com/doc/D/A/DATETIME.html as this will answer some of your datetime questions. Accept your rebuke. You should have read up on datetimes before posting.

query

alright, not sure if i can even do this or not, but i figured the list would know. here is the query i have: SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM wiseQuiz_questions WHERE test='$test' here is the table structure i have: CREATE TABLE `wiseQuiz_questions` ( `ID`

Re: GUI compiling on OSX

Luke Sather wrote: Greetings. I'd really enjoy having a SQL GUI for my Mac laptop, is it likely that one of BSD sources will compile under OSX? I haven't compiling anything yet, so I thought I'd should ask if it has been mentioned before. Here is a list of many GUI MySQL clients for OS

grant ALL on *.* to ... Error

Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try : grant ALL on *.* to admin@localhost identified by passwd i get the following errot: ERROR 1047: Unknown command Can some one felp me with that? Gregards Vlady

Re: Bug related to large tables and it's indexes on Win2k

The table type is the default, MYISAM - Original Message - From: Schneck Walter [EMAIL PROTECTED] To: 'Jared Richardson ' [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:11 AM Subject: AW: Bug related to large tables and it's indexes on Win2k |

RE: How to write output of sql stmt to file

[snip] I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the other

Re: Bug related to large tables and it's indexes on Win2k

Thanks Walter since their is no reason (that I am aware of) for the system not to handle the current problem, I want to try to solve it if possible. I have been using MySql for a number of years... if this is an actual bug, it will be the first one I've ever encountered! :) Also, we've

Installation of mysql failed on solaris 2.6

From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Installation of mysql on Solaris 2.6 using 3.23.49-sun-solaris2.7-sparc version content-length: 2557 Description: I'm trying to install mysql version 3.23.49-sun-solaris2.7-sparc on Sun Solaris 2.6 but kept on getting the

Re: mysql-4.0.1 installtion problem on redhat

Yogesh, Tuesday, June 04, 2002, 12:26:10 PM, you wrote: YM Description: YM precise description of the problem (multiple lines) YM mysql-4.0.1-alpha (Official MySQL RPM) installtion problem YM How-To-Repeat: YM code/input/activities to reproduce the problem (multiple lines) YM Fix: YM

Re: Mysl crashing

Steven, Tuesday, June 04, 2002, 5:29:06 AM, you wrote: Description: SW Our mysql server crashes relatively often. Most of the time after a crash, the error logs show a line like thd-query at 0x84aef98 = show processlist (although some have 0x50e64580 SW is invalid pointer and others

Re: repair problem

Terry, Tuesday, June 04, 2002, 12:46:44 PM, you wrote: T i have a broken table and mysql seems not to fix it: mysql repair table ksiegi; T +--++--+--+ T | Table| Op | Msg_type | Msg_text | T +--++--+--+ T |

RE: query

* Steve Katen alright, not sure if i can even do this or not, but i figured the list would know. here is the query i have: SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM wiseQuiz_questions WHERE test='$test' here is the table structure i have: CREATE TABLE

Re: How to write output of sql stmt to file

Did you check out the -w option to mysqldump? andy wrote: Hi there, I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I

Re: Problem in inserting date

On Tue, 4 Jun 2002, R.C.Nougain wrote: Bad answer. If you 'guess', then don't answer. The idea behind the date_format is to format a date as per user's need and should not be forced to a particular format just because some countries follows some format. Still looking for serious answer? RC,

Re: Record dependencies

Yes, the concepts he presents are in generic SQL. I've used them in 2 different systems (menus and security) and they work fine. (NOTE: You DO have to write your own code.) ;) Ok, I picked up the book yesterday. It has alot of really good information. However, with regards to the concepts

RE: grant ALL on *.* to ... Error

grant ALL PRIVILEGES on *.* to admin@localhost identified by passwd you may want to include with grant option -Original Message- From: vlady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:15 AM To: [EMAIL PROTECTED] Subject: grant ALL on *.* to ... Error Hi all, I

Re: Full-Text Search Help!

David, Tuesday, June 04, 2002, 5:43:16 PM, you wrote: DS I've implemented a full-text index on several of my database fields in a DS table, populated those fields with some very simple, yet distinct records, DS and have run recommended queries against that table. Alas, I still end up DS getting

Re: grant ALL on *.* to ... Error

vlady, Tuesday, June 04, 2002, 5:14:54 PM, you wrote: v I have a strange problem, v I am startirng my mysql-4.0.1 with option --skip-grant-tables. v I am using mysql and when I try : v grant ALL on *.* to admin@localhost identified by passwd v i get the following errot: v ERROR 1047: Unknown

Re: WinZeos and Transactions

It's easy to upgrade. I just did a search and replace in the .dfm files. Fredrick - Original Message - From: Informatica Handem [EMAIL PROTECTED] To: Kiss Dániel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 3:00 AM Subject: RE: WinZeos and Transactions Thanks for

Re: release 4.0.2

I agree, I would like to use multi table delete and other new features in win32... - Original Message - From: Artem V. Ryabov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 1:00 AM Subject: release 4.0.2 Hello developers, What problem with release 4.0.2?

Re: Bug related to large tables and it's indexes on Win2k

Hi Jared and Walter I don't suggest changing to InnoDB just to try solve a unknown problem! MyISAM tables are usually less problematic, being the default table type, and most tested in MySQL. And it seems Jared has benchmarked it as being more suited to his situation. InnoDb tables are usually

RE: grant ALL on *.* to ... Error

http://www.mysql.com/doc/G/R/GRANT.html It's in there...keep digging. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: vlady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 9:15 AM To: [EMAIL PROTECTED] Subject: grant

Full-Text update crash

I've read a couple posts about problems issuing updates to mysql on full-text key'd columns, unfortunately the only answer found is that its will be fixed in the upcoming 4.0.2 release. any idea when that will go beta? or should I trying using the cvs version? I could post a stack trace, but

RE: MySQL Access 97 slow

It's ODBC in general. One more layer of abstraction to deal with. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Tom Worobec [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:56 AM To: MySQl Lists Subject: MySQL

Re: How to write output of sql stmt to file

Jay Blanchard wrote: [snip] I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to

Re: Frontend and report tool

You might want to have a look at urSQL -- http://www.urbanresearch.com/ursql -- it has built in support for exporting query results in a variety of formats... On Tue, 4 Jun 2002, Petre Agenbag wrote: Hi Can anyone tell me if they know about a good frontend for mysql with reporting facilities,

Re: grant ALL on *.* to ... Error

- Original Message - From: vlady [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:14 PM Subject: grant ALL on *.* to ... Error Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try :

Re: grant ALL on *.* to ... Error

- Original Message - From: Mark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 6:19 PM Subject: Re: grant ALL on *.* to ... Error - Original Message - From: vlady [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:14 PM Subject:

how to make stress test , mysql

hi, I have finished an application about online exam using java servlet and tomcat and mysql. I am trying to write a testing script to simulate 180 students to take the exam during the period of one hour. so far i have no idea how to start. I didn't find anything talking about that. I just found

Re: /tmp/mysql.sock problem

Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which

Re: /tmp/mysql.sock problem

Egor Egorov wrote: adam, Tuesday, June 04, 2002, 12:05:30 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D a Thanks. However, something's still wrong. a Restarted the

Re: /tmp/mysql.sock problem

OK got this sorted in the end, by putting a soft link in to the /tmp folder pointing to the /var/lib - thanks one and all. Adam Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an

RE: MySQL Access 97 slow

-Original Message- From: Tom Worobec [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:56 AM To: MySQl Lists Subject: MySQL Access 97 slow Why do linked MySQl tables in Access 97 take longer to open thne linked Access 97 tables in Access 97? Is it MyODBC?

FW: Multiple Servers, mysqld_multi

sql,query Is there any option to do this on a windows version? All the documentation ( and from what I see of the installation of the = windows version ) leads me to believe there is not Luc - Before posting,

? Afer adding an Innodb file - .frm corruption ?

My objective is to create a clean new and installed system (with a clean database) from a developpement environment (where I do tests and developpement) where the database is full of things I clean. One solution would be to recreate from zero the database. But I have decided to use a cleaned

Re: Mysl crashing

Hi, It happened to me ...with Red Hat 7.2 and MySQL 3.23.47. Anyway if you want to see easily what's wrong you can do: Identify the PID of your process which make monitoring processes. In other task you can do : strace -d -p the_PID ...and let it open. When MySQL crash strace tell you with what

LOAD DATA LOCAL INFILE

Before I get started, let me say that I have looked at the manual, gone through a number of posts to the lists and read Paul's MySQL book. I've tried a lot of things over the course of the past three hours and am hoping that someone can shed some light on this one. When I do the load data

RE: LOAD DATA LOCAL INFILE

[snip] Texas AM University,College Station, TX,1999,Design, install, test and run blah, blah.,Whatever Industry LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\n'; [/snip] Have you tried this... LOAD

RE: LOAD DATA LOCAL INFILE

[snip] Texas AM University,College Station, TX,1999,Design, install, test and run blah, blah.,Whatever Industry LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\n'; Have you tried this... LOAD DATA

RE: WinZeos and Transactions

Yes, It's easy to upgrade, but this version of zeoslib is sufficient stable to use? Also what enhancements it has? Thanks for your help. Iago. -Mensaje original- De: Fredrick Bartlett [mailto:[EMAIL PROTECTED]] Enviado el: martes 4 de junio de 2002 17:02 Para: Informatica Handem; Kiss

Is it possible to have MySQL perform an action at a specifictime?

I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read the

RE: Is it possible to have MySQL perform an action at a specifictime?

[snip] I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read

Re: Is it possible to have MySQL perform an action at a specifictime?

Have you looked at cron on LINUX? - Original Message - From: Jamie Buck [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 11:37 AM Subject: Is it possible to have MySQL perform an action at a specifictime? I have a file containing commands to add and drop tables as

Making fulltext index is very slow!!

Hi I have a Huge amounts of data imported into mysql. My database has about 1,500,000 rows.each row has a text field with approx 70 words in it!.Size of my .MYD is 1013MB mysql has been starting to make fulltext index on text field since 55 hours ago!!! and now it dose not accomplish this job

Is it possible to have MySQL perform an action at a specifictime?

I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read the

a question

I downloaded mysql win 32 1.75-2 and downloaded the GUI for it. How do I tie the SDK to the gui? Pardon me if this sounds vague. AMeet - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Left join?

I have the following tables: Member_interests: Member_id Interest_id Interests: Name Interest_id I need a query that selects each interest name, and the # of members who have selected it...sample output: Boating 25 Hiking 10 .. Swimming0 Jumping 0 Talking 0 The following query works

Re: Bug related to large tables and it's indexes on Win2k

* Jared Richardson [...] CREATE TABLE IcAlias( IcAliasID BIGINT NOT NULL PRIMARY KEY, mID VARCHAR(255) NOT NULL, IcEntityID BIGINT NOT NULL, IcTypeID SMALLINT NOT NULL, IcDupSortID VARCHAR(255) NOT NULL, INDEX mIDIdx (mID), INDEX IcTypeIDIdx (IcTypeID), INDEX

Re: Making fulltext index is very slow!!

1) Add 1 or 2 gigs of ram 2) Adjust the my.ini (or my.cnf) settings to use it This will get your data into memory and off the disk. This will make it run an order of magnitude faster. Also, you can buy a P4 from Dell for $599. You might want to throw more hardware at the problem. -

Web Buttons and Command Line Instructions

Is there a way to develop buttons on a webpage that can send command line instructions to MySQL, such as to run a script in a file that already exists on the server? The command line instruction would be as follows: mysql database_name file_name Is it feasible to get this sent to MySQL through

Re: Bug related to large tables and it's indexes on Win2k

I replied below - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 3:24 PM Subject: Re: Bug related to large tables and it's indexes on Win2k | * Jared Richardson | [...] | CREATE TABLE IcAlias( | IcAliasID BIGINT NOT NULL

  1   2   >