redirect mysql output to file

Hi, How do i redirect a mysql output to a file from the command line? For example, I want to save DESCRIBE test_table test_table.file without doing a MYSQLDUMP. thanks, MT - Before posting, please check:

PHP / MYSQL Question

I'm trying to get it to display like this Topic1 Question1 Question2 Question3 Question4 Topic2 Question1 Question2 So each topic would be listed with its set of questions below it. Any help would be appreciated. Mike Walth CinoFusion

digest mode for mysql list

hi list, Is there a way i can subscribe to this list as a digest user's mode, Similar to mailman's digest feature. I was trying to get to the mailman user's preference page but cannot find it on mysql.com. Can anyone help me out here. thanks, MT

Join or Group By?

the links by Series to generate a result similar to: SeriesTitle(1) LinkTitle(1) LinkTitle(2) LinkTitle(3) SeriesTitle(2) LinkTitle(1) LinkTitle(2) LinkTitle(3) Links.Series holds the value of SeriesID that it is under. Thanks again for your help. Mike Walth CinoFusion

MySQL not logging from my LINUX machine to windows

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:

tricky regrex and case case query

Hi all, I think this can be done with a SQL query, but not have much luck getting it right. Was hoping to get some suggestions on the best way to do this. I need to extract the 'name' column in a mysql database table. split the name so we have a first and last name value, as the name was

Supposed memory leakage in libmysqlclient

Description: Application that uses MyODBC 3.51.05 + MySQL 4.0.10 constantly grow memory consumption. Such behavior is not observed if MyODBC 3.51.05 + MySQL 3.23.55 are used. I suppose that there is memory leakage in libmysqlclient. Application linked

Re: How to build Relay Replication system ?

Is your Server B using the --log-slave-updates flag? -Mike Hello! I have a following system. Server A : a master for server B. MySQL 4.0.9 Server B : a slave for server A, a master for server C. MySQL 4.0.10 Server C : a slave for server B. MySQL 4.0.10 and I wanna that if update

Assigning different hosts

Hello all, I want to change some of our database host settings to allow for other host connection other then the default 'localhost' setting. what is the proper way to assign a different host to connect to, like an IP address or something like mysql.somedomain.com,..etc.. thx's --

Assigning different hosts

Hello all, I want to change some of our database host settings to allow for other host connection other then the default 'localhost' setting. what is the proper way to assign a different host to connect to, like an IP address or something like mysql.somedomain.com,..etc.. thx's mysql

RE: What are the best MySQL and PHP resource books?

on the 13th of Feb, so maybe wait for the next edition which I assume will cover the latest versions of both. Mike Hillyer -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 1:30 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: What are the best

MySQL error

/usr/local/libexec/mysqld: Shutdown Complete 030201 16:32:59 mysqld ended I have removed and reinstalled Mysql, checked permissions, made sure nothing else is running on that port tried safe_mysqld and still got the same error. Any hints would be great! Mike Benzel [EMAIL PROTECTED] for NT

MySQL error

:59 /usr/local/libexec/mysqld: Shutdown Complete 030201 16:32:59 mysqld ended I have removed and reinstalled Mysql, checked permissions, made sure nothing else is running on that port tried safe_mysqld and still got the same error. Any hints would be great! SQL DATABASE Mike Benzel [EMAIL

Getting Images in and out of a Blob

is ColdFusion, but PHP/PERL would be helpful too. Thank you for your help. Mike Walth CinoFusion - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

setting auto increment start value

Hi all, I am creating a new table with an auto_increment primary key. How do i tell mysql to start incrementing at a certain value, let say 1000 instead of 1? Thanks, MT -- - Before posting, please check:

compiling issue

--with-mysqld-user=mysql --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-berkeley-db=/usr/local/BerkeleyDB.3.2 --with-innodb Any thoughts? Thanks, Mike - Before posting, please check: http://www.mysql.com

In eWeek: Rhode Island uses MySQL

working only two days a week to complete. Not a big user, but good to see a state government openly use MySQL. Mike Hillyer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: sql query using select and row functions

Why not just reverse your order by clause and use Limit 5? Mike Hillyer -Original Message- From: Christopher Lyon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 9:26 AM To: [EMAIL PROTECTED] Subject: sql query using select and row functions I am trying to do an sql query

undo last transaction

Hi all, How do i undo the last transaction in mysql? Thanks for any suggestions. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

order by birthday not year

Hi, I want to use the order by clause to list the birthday field by the birthday not year. How do i do this? example birthday=1972/02/14 How do i tell mysql to order by the day (14) only so that I can list same birthday in a month in acending order. Thanks -- Mike Doanh Tran Shuffle

help w join query

help, Mike sql,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

Connetion times out - OT

Hello all, sorry if this maybe a bit OT, but we've seem to be getting this error 110: Connection timed out.. from our Perl scripts connecting to our MySQL database... is this perl or the mysql server related issue ? thx's -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder

. cn

mysqlÄúºÃ: È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû£¡ ±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû. .CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£

help w/join condition

is not all units will have 9 items. Most units will have less than 9 items. Any help would be greatly appreciated, Thanks in advance, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Hostname error on install

OS - FreeBSD 4.7 Release MySQL 3.23.54 Have an odd error. When reinstalling MySQL, I needed to add something's, it says the hostname is wrong, I did a make clean and tried make reinstall --force and everything else I can find. Never had this error before! Nothings been changed since it was

MySQL backend for mailing list

will be) the emails to a browser, download the file, have a seperate program actually send the emails -- however I suspect this too might take up too much of PHPs time, and too much bandwidth. Has anyone tried to do something like this before, what did you end up using, etc...? Cheers, Mike

. cn

mysqlÄúºÃ: È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû £¡ ±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû. .CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£

RE: Binary Data and BLOB Problem

BEGIN SHAMELESS PLUG Hi Kevin; You may want to look at the online article I wrote at http://www.dynamergy.com/mike/articles/blobaccessvb.html which covers use of the stream object in detail. While written for VB, it should be easy enough to convert to ASP. Mike Hillyer END SHAMELESS PLUG

RE: Fulltext search of words 3 chars in 3.23

I would think that using the fulltext search IN BOOLEAN MODE would return results of any length, even 3 characters or less, check the bottom of http://www.mysql.com/doc/en/Fulltext_Search.html for examples on using boolean mode. Mike Hillyer -Original Message- From: Frank Peavy [mailto

RE: Fulltext search of words 3 chars in 3.23

He wants to execute a FULLTEXT search as opposed to a simple LIKE statement, so I think REGEXP is out of the question. Mike Hillyer -Original Message- From: JamesD [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 10:48 PM To: Frank Peavy; [EMAIL PROTECTED] Subject: RE

Re: SOLVED! (was: Re: What is wrong with this query?)

This is getting a little bit away from mysql but the easy way to do this is: use Proc::Daemon;# Available at a CPAN near you :-) ... Proc::Daemon::Init; which takes care of all the details of daemonizing your program. But this still doesn't explain (at least to me) the lost connection.

NPTL and MySQL

How will NPTL (http://people.redhat.com/drepper/nptl-design.pdf) effect MySQL? Will MySQL break when linked against glibc 2.3.1 which has NPTL built in? Will MySQL be able to take advantage of NPTL to allow more threads on Linux systems.

Re: How long is my piece of string?

Iain Lang wrote: . But that is my question! *When* do they provide a performance difference? Obviously my (fairly simple) question (...and beyond what number of records might indices provide faster extraction/presentation?... ) has not been understood. Can anyone else help, please? Its

Re: How long is my piece of string?

Sure. Indices increase the time it takes to add or update a record. They also take up disk space. Also when scanning a database, its quicker ot just read the data records directly than to use an index if most of the data records need to be read anyway. For example, if you had a table with 10,000

RE: Case sensitivity

You have two choices, you can use a binary datatype for the field, or force a binary comparison using the BINARY operator. http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html http://www.mysql.com/doc/en/Column_types.html query, sql Mike -Original Message- From: asp52 [mailto

RE: Case sensitivity

You can specify a varchar field as binary, for instance: field1 varchar(50) binary query, sql Mike -Original Message- From: asp52 [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:50 AM To: Mike Grabski; [EMAIL PROTECTED] Subject: Re: Case sensitivity Thanks, Just worked

Help w/ Join Query

from album , img_path from images, and caption from img_caption for any paticluar album row. Thanks in advance for the help, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Parser seems to have problems with '-' (dash).

if that works. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:52 AM To: [EMAIL PROTECTED] Subject: Parser seems to have problems with '-' (dash). Hello I have hade several problems with the character '-' (dash, minus, or whatever

RE: Re: SELECT and UPDATE at the same time?

it with the primary keys of the records you want to update by selecting into it from the main table, then iterate through those for processing, with the updates going to the main table. Mike Hillyer -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1

RE: Using MS Access as front end to mysql database

. It works very well. However, this perhaps is only a good solution where the servers/workstations involved are static and well defined. mysql query Mike Grabski -Original Message- From: Fernando Grijalba [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:17 AM To: MySQL Help Subject

RE: MySQL4 on Linux with Intel Hyperthreading CPUs?

performance. If the OS doesn't support hyperthreading, then it just won't use it, obviously, so it's not an issue. But as far as MySQL's usage and performance in particular with hyperthreading procs, I don't have any experience :/ Mike -Original Message- From: John Dell [mailto:[EMAIL

Sorting Results

Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet

Re: Sorting Results

Cancel this! :) after reading it again, I realized a simple ORDER BY will do the trick nicely... Happy Holidays, Mike(mickako)Blezien wrote: Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like

Re: Can I get the matching expression from REGEXP

Thanks for the reply. I agree on the scripting languages. However it was a one time conversion problem. I managed with the substring_index sugestion. Regards, Mike On Wednesday 11 December 2002 02:05, Robert Citek wrote: Hello Mike, The short answer: use Perl, Python, Ruby, etc. You

Can I get the matching expression from REGEXP

column. I can select the rows with WHERE colX REGEXP . .{1,2}$ This wil return the first two rows only. But I cannot figure out how to get the query to return the matching result (being ef and i). Any help appreciated Mike

custom2.cc

Hello, Iam compiling custom2.cc from 'examples' : g++ -I /usr/include/sqlplus custom2.cpp -I /usr/include/mysql -lsqlplus -lmysqlclient -Wno-deprecated Receive compile errors with stock datatype. Iam unable to find stock in any of the including libraries. Can someone put some light on this?

Re: Innodb row locking question

, Benjamin. Thanks for your reply and information. The problem is that I'm conservative as hell when it comes to coding and must be absolutely sure things will work the way they should. Otherwise, I'll choose the inefficient route just because I know it's safe. Mike

RE: mysql port number

Actually, I do google searches first before asking on any list - and it didn't turn up a darn thing. -Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 6:19 PM To: Mike At Spy Cc: [EMAIL PROTECTED] Subject: Re: mysql port

RE: mysql port number

That, of course, isn't even getting into the point that you didn't answer my question. I asked how I could tell, not what the default port was! Thank you to the others that did. :) -Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December

Innodb row locking question

for your help and very nice table handler. Mike... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

RE: Serwer Hardware p4 or pIII ?

different types of boxes based on their strongpoints. Mike -Original Message- From: Robert Adkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:22 AM To: andy thomas; [EMAIL PROTECTED]; Helmut Apfelholz Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? I

multiple hosts w/ GRANT

PROTECTED] identified by 'passwd'; Is it possible to combine them in some fashion such that there would be one entry in the mysql.user table with multiple hosts? -Mike - Before posting, please check: http://www.mysql.com/manual.php

RE: mysql breaking through a firewall

Opening TCP port 3306 for inbound requests on your firewall should be adequate. Mike Grabski -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: mysql breaking through a firewall I am trying to break

Re: Serwer Hardware p4 or pIII ?

Does anybody have any benchmarks of MySQL running on otherwise equivalent machines but with different CPUs? It would be interesting to compare Athlon vs Pentium III vs Pentium IV vs Pentium IV Xeon at various speeds. And yes, while a Pentium IV is generally slower than a Pentium III at the

Download MySql 4.05 for HP-UX

Folks I'm trying to download 4.05a-beta for HP-UX 11.00. However I select the file and go of to the sites to be told i'm trying to download binaries for HP-UX 10.20. Anyone know where I can get the correct binaries for 11.00 ? Rgds Mike E-mail: [EMAIL PROTECTED] /mysql sql

Slow performance using 3.23 on RH 8.0

something really stupid here... relatively new to Linux after a lot of years of windoze. Thanks in advance Mike ** my.cnf * [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock datadir = /db/mysql skip-locking set-variable= key_buffer=500M set

mysql port number

How can I tell what port number mysql is running on? I need it for a chat program. :) Thanks, -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: Slow performance using 3.23 on RH 8.0

, December 04, 2002 3:37 PM To: Ledet, Mike; [EMAIL PROTECTED] Subject: Re: Slow performance using 3.23 on RH 8.0 Hi Mike, i'm a newbie in optimizing the inner structure of a db - so i stick to the os-part where i might have a vague clue ;-) did you take a look at the memory / swap-space mysqld used

RE: Slow performance using 3.23 on RH 8.0

Good question... I have no idea. I'll change it to 4. -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 4:36 PM To: 'Ledet, Mike'; [EMAIL PROTECTED] Subject: RE: Slow performance using 3.23 on RH 8.0 Oh, and what's up

RE: Slow performance using 3.23 on RH 8.0

PROTECTED]] Sent: Wednesday, December 04, 2002 4:35 PM To: 'Ledet, Mike'; [EMAIL PROTECTED] Subject: RE: Slow performance using 3.23 on RH 8.0 The first thing I would do is toss the ultra ata drive and just use the scsi drives running raid1, raid0 just isn't safe and hardware raid1 is much faster than

RE: Slow performance using 3.23 on RH 8.0

. -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 5:18 PM To: 'Ledet, Mike'; [EMAIL PROTECTED] Subject: RE: Slow performance using 3.23 on RH 8.0 Don't let this list fool you. SQL Server is a very good product. It is far superior to Mysql

RE: Slow performance using 3.23 on RH 8.0

on licenses. -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 5:26 PM To: 'Ledet, Mike'; [EMAIL PROTECTED] Subject: RE: Slow performance using 3.23 on RH 8.0 Go for it. Whatever works works. Caveat, MSDN is not an actual license

RE: dividing

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 8:35 AM To: Fifield, Mike Subject: Re: dividing Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must

RE: SQL Select Idea

I believe that SELECT * FROM processo_arquivos ORDER BY date DESC LIMIT 10; Should do it. Mike Hillyer -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: SQL Select Idea Importance

RE: ado , blob reading problem

You cannot get a BLOB back in one piece. I wrote an article at www.dynamergy.com/mike/blobaccessvb.html that describes how to use the adodb.stream object to access MySQL BLOB data through VB. Mike Hillyer -Original Message- From: Lalit Chandwani [mailto:[EMAIL PROTECTED]] Sent

LIMIT in MySQL

I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 Thanks, -Mike - Before posting

RE: .NET and mysql

be interested in knowing of any other free providers if anyone else has other suggestions! Mike -Original Message- From: Natale Babbo [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 12:06 PM To: [EMAIL PROTECTED] Subject: .NET and mysql Hello All, Is it possible to connect to a MySQL

MySQLDump BLOB Columns

Hello All; I am setting up a backup system for a client and am thinking to use mysqldump on a daily cron job to back up my SQL database. Does anyone know if I will have any concerns using mysqldump with a table that contains BLOB columns? (No larger than 15 megs for any given file) Mike Hillyer

RE: 'Persistant' temporary tables

that. That way you never have to worry about duplicate tables from multiple users. Also, make sure you have a mechanism in place to periodically destroy the old tables in case your PHP stops working before it does, otherwise you could get a very bloated database. Mike Hillyer -Original Message

RE: Mysql Encryption

A windows versionof Stunnel is available from the stunnel website (www.stunnel.org), I would reccomend using it for your needs. Mike Hillyer -Original Message- From: Alexandre Aguiar [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 6:09 AM To: Fraser Stuart Cc: [EMAIL

RE: Mysql Encryption

As far as I know you have to have a shell account to use ssh tunnels, am I right? If so this may be a concern for some. Mike -Original Message- From: Muir, Michael (OTS-EDH) [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 11:01 AM To: 'Andy Eastham'; Mysql@Lists. Mysql. Com

Sequence of SQL actions gives wrong query result for 10 seconds!

to produce my test-script) affected the results.) Any info appreciated! Thanks, Mike. THE SCRIPT STARTS HERE. # SET UP THE STARTING POSITION. drop table application_role; drop table application_role_operation; drop table application_operation; CREATE TABLE application_role (aro_role_id integer

Column aliasing

| +-+--+--+-+--++ | id | int(11) | | PRI | NULL | auto_increment | Thanks in advance. Mike - Before posting, please check: http://www.mysql.com/manual.php

Re: replicate-do-table and related

=%.% none of these update the slave's tables. Thanks. -- == Mike Blazer [EMAIL PROTECTED] == - Before posting, please check: http://www.mysql.com/manual.php

Re: Hello all :-)

Also, make sure you're running FLUSH PRIVILEGES after your grants and revokes. (Did I spell that right?) -Mike Hi all. My name is Mike. I have a Linux RedHat 7.3 with Mysql ver 3.23.49. I want to grant access to databases and tables to users,but only to a certin databases and tables. I

replicate-do-table and related

! -- == Mike Blazer [EMAIL PROTECTED] == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

mysqld crashing

. Any ideas? I've just about run out of things to try. The other two mysql servers don't have this problem and they're installed with the same binaries. Thanks, Mike - Before posting, please check: http://www.mysql.com

MySQL - version to install?

I've got to do a fresh install of mysql on a webserver (a new server, so it isn't overwriting anything). Does anyone have any info as whether I should use just MySQL or MySQL-MAX? What is the difference? Thanks! :) -Mike

90.

mysql:ÄúºÃ! 90¿îÍøÉÏÓªÏúÈí¼þµÍ¼ÛתÈÃ. ±¾ÈËÒÔ400Ôª¹ºÈëȺ·¢Èí¼þ,ËÑË÷Èí¼þµÈ90¿îÍøÉÏÓªÏúÈí¼þ, ¼°1000Íò¸öEMAILµØÖ·,ÏÖÒò¹¤×÷±ä¶¯,ÒÔ50ÔªµÍ¼ÛתÈà QQ:8223613 0574-63133687 Ö Àñ! mike

Complicated (to me) query

) AS name, DATE_FORMAT(date_checked_out,'%b %D, %Y (%r)') AS date FROM file LEFT JOIN staff ON file.checked_out_by = staff.username WHERE staff.username = 'mike' AND staff.security_level file.required_security_level; Anyway, any help with this query would be greatly appreciated. Thank You, Mike

Maintaining #'s between 2 databases

the mysql install) A messy solution would be one big database and one big table that uses the same autoindex key. I appreciate ideas on a better solution (e.g. Cross inserts?, a 3rd index table)? Thanks, Mike - Before

mysqld segfault

Description: After upgrading mysql to 3.23.53, mysqld would segfault every time accessing a certain database. After running checks on the database and making sure everything was okay, I started mysqld up in gdb. Program received signal SIGSEGV, Segmentation fault. [Switching to Thread

BOM (Bill of Material)

Anybody know of a BOM processing system running on MySQL? Hosted on Linux or Windows? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

RE: Slow opening a recordset

Well, let's start with the simply, yet possibly overlooked solution: have you indexed the table appropriately? Mike Hillyer -Original Message- From: [EMAIL PROTECTED] [mailto:m.colurcio;softhor.com] Sent: Saturday, October 19, 2002 9:12 AM To: [EMAIL PROTECTED] Subject: Slow opening

re: High load with cleaning up status

At 02:56 PM 10/14/2002 +0300, you wrote: Hello Mike, Saturday, October 12, 2002, 5:41:11 AM, you wrote: MZ Recently our DB, which is running MySQL 3.23.52, started experiencing MZ intermittant load spikes, of the magnitude of 200+ load averages. Normally, MZ our high spike is about 0.90 load

Weird error when adding a fulltext index

| | +---+++--+--+---+-+--++--++-+ Fix: Submitter-Id: randy6839 Originator:Mike Wexler Organization: tias.com MySQL support: login support Synopsis: can't add a full text index

High load with cleaning up status

in as to what cleaning up means, and what the possible cause of this is? Thanks, Mike Zimmerman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Mysql problems

I am getting: ./bin/myisamchk: error: 'data/mckesson/tempbak.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair on a number of my tables. I have recently imported this data, from a box that is totally ruined. I have no other copy of the data.

RE: Problem with moving database using mysqldump

I have tried that with no success. A suggestion was made though of just tarring the data dir, I think I shall try that route. Mike -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 6:46 PM To: 'Mike Hillyer'; MySQL Mailing List

Problem with moving database using mysqldump

requests around the 90-100 query mark. Does anyone have any idea why this is happening? The file is about 40-50MB and the largest table in the database is only 110,000 rows, so this should not be straining the system. Thanks, Mike Hillyer

Re: Urgent!!

William R. Mussatto wrote: On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru

RE: MySQL BLOB Visual Basic

What does your VB code look like? Mike Hillyer -Original Message- From: Bruno Batarelo [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:42 PM To: [EMAIL PROTECTED] Subject: MySQL BLOB Visual Basic Greetings. I try to save 7MB large binary string to mysql blob field

RE: Index usage vs table scanning

MySQL performance query. I've got a puzzle which is as follows: I've got a new table which I'll be loading with approx 1 million rows per day. This is being loaded from a C program which seems to work fine. The table being loaded is as follows: | Field | Type| Null |

RE: MySQL as a desktop DB

Oh fiddle sticks! I just noticed mySQL-Front has been discontinued. I love that program :( Oh well, I'll check out this SQLyog. Thanks for the tip. Mike -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject

RE: Value

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:43 AM To: Fifield, Mike Subject: Re: Value Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must

Porting Mssql to MySQL

sort of tweek to the file would i need.? 3) Is there an ODBC connector so that i could get a reporting tool to access the MySQL database? (reporting tool is crystal reports). I am sure there will be plenty more questions to bug you all with but this is enough to start with. Thank all mike

russian language

I am working on a multilingual site and trying to figure out how to store Cyclic (Russian) and text in other languages in a mysql database. When I try to enter the text what I enter looks like it is getting converted to its ASCII equivalent. Dose anyone know if there is a way to set up mysql so

INDEX not getting used

| +--+--+---+--+-+--+--+-- --+ Anyone have any suggestions as to where I could look to fix this up? -- Mike Miller -- Happy 20'th Birthday, Mr. Smiley :-) http://research.microsoft.com/~mbj/Smiley/Smiley.html

Slow results return through ODBC

is reported at 0.02 seconds, and returns 5 rows very quickly (the appropriate index is in place), but when I run the query through ODBC on my VB client, it takes 10 seconds. Any ideas on what is causeing the discrepancy? Mike

RE: MySQL 2.23 DELETE ORDER BY bug

While I have no solution for you, I am curious: why would you need to specify the order rows are deleted in? Mike -Original Message- From: Peter M. Flor [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 4:03 PM To: [EMAIL PROTECTED] Subject: MySQL 2.23 DELETE ORDER BY bug

<    4   5   6   7   8   9   10   11   12   13   >