/var/log/mysql is taking up a lot of diskspace

)? Many Thanks, Will -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: /var/log/mysql is taking up a lot of diskspace

ok, cool. I was not sure if I could use logrotate with the mysql logs. Is it safe to delete what I have there at the moment? I need to free up some disk space. On Sat, Jan 31, 2009 at 5:07 PM, Bazooka Joe wrote: > On Fri, Jan 30, 2009 at 7:54 PM, will wrote: >> Hi, >> >&g

Re: /var/log/mysql is taking up a lot of diskspace

> this is what logrotate run before and after > > [ -e /var/lock/subsys/mysqld ] && /bin/kill -HUP `cat > /var/run/mysqld/mysqld.pid 2> /dev/null ` || /bin/true > > Assuming paths are the same I would run the above commands. Short of > that I would take down mysql, delete log, then bring mysql bac

Query join issues

labels of db3 e.g user2.user_name. I have tried printing out mysql_fetch_assoc($result) and from what I can see the user db doesn't get joined on again but wipes all results of the other user join. Thanks for any help offered. Will

php - MySQL 3.23.37 problem

rface MySQL-3.23.37 MySQL: a very fast and reliable SQL database engine I cannot find any other packages to install for 3.23.37. I am running red hat 7. Any help would be greatly appreciated, in your response it would help me if you put Will: in the subject line. Thank you

Re: Check out this Free software I found to document your IT infrastruct

Rob Munsch, I am a member of the Nabble project. This is regarding a bad post by user "itguy321". Just want to explain a few things. Nabble is a free mailing list archive/gateway that works like Gmane. Users can browse, search, and post via Nabble's web interface and t

RE: 4.1.x with php-4.3.x

been using 2.3.2 for several months on several machines and have had no problems at all. HTH, -- Will > -Original Message- > From: Daniel Kasak [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 26, 2005 6:25 PM > To: mysql@lists.mysql.com > Subject: 4.1.x with php-4.3.x >

Re: String Manipulation

',-1) | +--+ | string2 | +------+ 1 row in set (0.00 sec) mysql> Will. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT all except ... ?

th 29 column names that i want to get? If you're using MySQL 5.0 an up you could achieve similar functionality using views. http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-views.html Will. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

query kills mysqld

MySQL Ver 8.41 Distrib 5.0.27 Intel Xeon 3.60 GHz 2.0 G of RAM Windows Server 2003 Service Pack 1 The following query will sometimes work and sometimes fail. When it fails it kills the mysqld service and requires it to be restarted. Sometimes if I add additional id'

How to Version Control a database

that changes are not lost or stepped on. Right now, we use mysqldump to dump the database and version the dump file, but this still has problems. Is there a better way? -- Will -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

mysqlhotcopy as a replication scheme

the table. Other than "you should really use mysql native replication", does anyone have any comments on whether this is likely to be reliable, or why it's a bad idea? I'm using 3.23.49 (Debian stable); Is FLUSH TABLE likely to change in future versions in a way that wil

Re: Query syntax.

nstalled 3.x does not support subselects ("select x from (select y from ...)"). You'll need to upgrade to 4.1. -- thanks, Will -- MySQL General Mailing List For list archives: http://

Re: 100,000,000 row limit?

+---+ 1 row in set (0.00 sec) -- thanks, Will -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.1 alpha and mysql_install_db grant tables issue

*without* --user=mysql. mysql_install_db already takes a --user argument but doesn't use it; perhaps it should be added to line 208? -- thanks, Will -- MySQL General Mailing List For list archives:

Re: Time series

is going to be very slow. The query planner doesn't seem to be smart enough to read the index in reverse for ORDER BY DESC clauses. -- thanks, Will -- MySQL General Mailing List For

Re: Slackware10 & mysql

Hey - It's been awhile since I set up mysql on a box (it's one of those things where I teach myself, do it once, then forget it, heh) - but I seem to remember you need to do some things to initialize the databases and set initial privileges before it will work - su to the "mysq

Cygwin Mysql No Response

Hello All, Thank you for reading this email. I have the following Configuration Windows 2000 Server MySQL Win32 Binaries Installed Current Release of Cygwin installed I am trying to access mysql from the bash shell rather than the command line. It was working fine until now, but for some reason I

getting started on a SQL project

uld get started with this? Thanks, Will Johnston wsj3.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

trying to figure out error in PHP/MySQL

ing password: YES) in c:\phpdev\www\development\phpflash\init.php If anyone can advise me about what I need to change on my system to get this to work I would really appreciate it. Thanks, Will Johnston wsj3.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

follow-up

I'm having this error and am not sure what's causing it. I'm using PHP/MySQL and Apache on Windows XP. I've looked at my server, user, password settings and they seem to be accurate, but the error seems to indicate this is the problem. Any help would be appreciated.

mysqlimport 'can't get stat of [file]' error

ng or how to get around this would be really appreciated. Thanks, Will Tyburczy ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Why change in CONCAT_WS

I noticed in the changelog for the upcoming 4.1.1 alpha release that CONCAT_WS is being changed to NOT skip empty strings. I am sure that this must have been done in response to feedback but I wonder if there are others who like me have relied on the skipping of empty strings. Among other things,

retrieve ignored records from LOAD DATA INFILE IGNORE

hanks, Will -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Weird problem with displaying and retrieving varchar

state_id, countycode it displays just fine. I am thinking that maybe the city is unicode but i can't figure this one out. Has anyone else run into this problem or does anyone have any ideas to help me debug this? I have tried versions 4.0.15 and 5 but the same thing happens in each version.

Cant Explain Error Message

7;not null )' at line 11 I have tried a few different ways of rewriting the id line, like this for instance: id int not null primary key auto_increment, But it still keeps giving the error message. It's odd it's not working because this is a textbook example.

Re: Cant Explain Error Message

Thanks... syslexia ducks... Wil --- Hello. I am trying to create a table in one of my databases using textbook code, but it is giving me an error message. Here is how it reads: mysql> create TABLE messages -> ( -> id INT UNSIGNED NOT NULL AUTO_INCREMENT PR

Re: Some Basic Questions I can't Find Answers to

Hello Linda, You said ---> The MySQL database I want to run will be on my web host. Since I don't have the server physically in my possession, is the working method to install MySQL to my machine, develop the routines there, then upload them to my server? You may not need to do this

How to tell MySQL where to store db files ??

1 - When I create a new db using MySQL... Can I tell MySQL where (what path & directory) to store the new db files? And... 2 - To back up the db... can I just copy the files in that directory to a backup device like a CD or floppy? Thanks,

What are basic db files MySQL creates?

didn't see them... or at lease I did not recognize them.) Thanks, Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

RE: What are basic db files MySQL creates?

Roger, Are the files that you mentioned stored in the directory for the db ? thanks for the help, Will -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 6:31 AM To: [EMAIL PROTECTED] Cc: Will Standley Subject: Re: What are basic db files

How to delete MySQL db ?

I have a couple of "test" MySQL data bases on my Linux/Apache box and want to delete them for a clean start... How do I delete all the files associated with the two db's ? Thanks, Will - Before posting, please

How is DBTools Software?

ore stuff... like Excel to MySQL. All comments encouraged. Thanks, Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Compiling a list of MySQL tools - Please contribute.

Excel & more Please contribute to the list. Thanks, Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this threa

How to get MySQL to list current db's ?

I have two sample MySQL db's running on a local Linux box w/Apache... Once I enter "mysql" from the Linux command line... Is there a way to ask MySQL to list the db's that are currently created? Thanks, Will

RE: Accessing last_insert_id problem.

om test; ++--+ | id | d| ++--+ | 1 | 2 | | 2 |2 | | 3 |2 | ++--+ 3 rows in set (0.00 sec) mysql> = end clip = -- Will Will Merrell Virtual Assistant [EMAIL PROTECTED] Moreland Business Solutions - Your partner in business. h

--- How to query results of a query?

results of a query?) Is there a better and faster way to do this with minimum burden on the web server with the db on it? Thanks for any help. Will - Before posting, please check: http://www.mysql.com/manual.php (the

Will PhpMyAdmin do more than just create a MySQL db ???

Will PhpMyAdmin do more than simply create a MySQL db ? Please cc me directly on any post at [EMAIL PROTECTED] Thanks for any help. Will - Before posting, please check: http://www.mysql.com/manual.php (the manual

Will PhpMyAdmin run on Linux-Apache-MySQL box ?

I installed PhpMyAdmin on a Windows box using EasyPhp... Will PhpMyAdmin run on a Linux/Apache/MySQL server? (I've got one on my desk up & running) If so which version should I download? (.php files) - Download phpMyAdmin-2.3.3pl1-php.tar.bz2 - Download phpMyAdmin-2.3.3pl1-p

--- Best ISP for MySQL & PHP ???

Gang, I'm looking for an ISP to host a couple of MySQL db's... Will be using PHP as the scripting language... Want to use PhpMyAdmin to administer the db. Are there certain ISP's who specialize in hosting such sites? Thanks for

Designing Categories

ard system for different types of discussions, or art galleries for different types of galleries... ? I am wondering how the backend logic structures looks to that tablewise... I can handle SQL for relational databasing, but I am trying to understand this more from a design point of view... Tha

Uploading to MySQL?

just FTP-ed a bunch of files to a directory on my server, and then I wanted to catalog all the links in a MySQL database table... Is there a way to get all those links into the database without having to manually insert them one at a time? Thanks,

RE: Paul DuBois Book

My vote is have the 'mySQL Cookbook' get out the door first, give Paul a quick respite, and then put his nose to the grind stone for 'mySQL version 4'. 8-) -Original Message- From: Anthony W. Marino [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 7:30 AM To: Simon Green; [EMAIL

SSI's and Databases?

Greets Folks, Does anyone know if it is possible to get an SSI to work in conjunction with a database, like MySQL? I'd like to have a script that will insert a new text file each day along with a timestamp, and I was wondering if it would be possible to use an SSI to draw the info o

Select most recent files

Greets Folks, Quick question here... Is there a command I can use to select the most recent files inserted into a MySQL table? Thanks, =) Will _ Chat with friends online, try MSN Messenger: http://messenger.msn.com

Scanning Directory/Inserting Image Links to DB

Greets Folks, Can someone recommend a Perl script/technique that will scan a Unix directory of image/text files, and then insert the links into a MySQL database? I used to have a good one, but it got misplaced... Doh! Thanks, Will

Seeking Freelancer

Greets Folks, I need help with some too-involved-for-me CGI stuff, and I'd like to work with a freelance programmer/consultant. The consulting will be for a mature themed site, and I am running on a limited budget, so open minds only please. The project is for a paid membership site

Connection Problem

ermissions. The only other thing I can think of might be that the line DBI:mysql:host=localhost might be different on the actual system than in the book. Do any of these things sound possible? If so, how can I correct them or get the right info? Thanks, Will

Design: General DB Question

Greets Folks, Are there any good online tutorials for DB design in MySQL? I'm not necessarily interested just in the programming per se, but in DB design theory in general. Thanks! =) Will _ Get your FREE download o

Unsigned Int / Signed Int issue when using MyODBC2.5

roduction server. Does anyone have any idea why this would be failing, or know a better way to select the code and drop it into a recordset (or array) in asp? Thanks for any help. Will Lotto Systems Administrator - Before posting,

RE: Unsigned Int / Signed Int issue when using MyODBC2.5

ck hitting myself over the head with a plank of hardwood. Will Lotto Systems Administrator > -Original Message- > From: Will Lotto [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 2 July 2002 12:42 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Unsigned Int /

3 Questions

e web pages, but I dont know if there might be other ways. 2.) This question is more out of curiosity. Suppose I buy a database that has been prepopulated. Then how do I get that info into my existing database? 3.) Where would I look to buy prepopulated databases? Thanks! =)

Learning Data Types

Hi, I am learning about MySQL and how to use the CREATE TABLE command, and I was wondering where I could learn more about MySQL datatypes (cause they seem to be a big part of this command). Will _ Send and receive Hotmail on

NULL ?

hello, Please dont tell me to RTFM on this one (cause I am already doing that), but for clarity's sake... can someone tell me what it means when you use NULL and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I use them? W

Info on 4.0.x release date

When will 4.0.x finally be released to beta? The facts as I understand them: - 4.0 went alpha in Nov or Dec of '01 - At the time, Monty and his gang projected stabilization by Jan or Feb - More than 6 months have passed since and the product is not yet stabilized - No meaningful informatio

RE: Info on 4.0.x release date

o you about it? I will assume that your interest in mysql and participation in this list indicates that you are somehow involved in the process of software development. What is less clear is whether this may be a hobby or your profession. If it is the latter, I would love to know where it is t

RE: Info on 4.0.x release date

incredibly good tool. I explored MySQL because I like the open source model and I am interested in offering my clients a choice. While I know that many in this group will consider this blastphamous, at this stage, SQL Server is a vastly superior product in many ways. A discussion of why I

Re: Info on 4.0.x release date

I wrote >> Ironically, the fact that I pay no license fees to MySQL AB is based upon... Dean Ellis wrote >> Ahhh, I see. So, you are _completely irrelevant_. My relevance stems from the fact that I am a very good prospect to a company that has a stated interest in growing their community of sa

how does one successfully use mysql_store_result()?

If I understand you correctly, then you are trying to figure out how to distinguish between an empty result set vs. no result set (i.e. an error if statement was a SELECT). In the case of an error (or a not result set returning statement like INSERT), mysql_store_result will return null. In the

Re: Info on 4.0x release date

#x27;t more information available about the cause of the delay. In the absence of being able to say "the product will absolutely positively ship on such and such day," most people are comforted by knowing more about the variables which affect when it will ship. If you've ever been ma

RE: editor

unto the MSDOS window. Change the '\' to '/' in the command line. Put the semicolon at the end, press ENTER, and Voila' you have the command executed. Example: source C:/usr/bin/mysql/sql/updateALL.sql; HTH Will -Original Message- From: Stefan Hinz [mailto:[EM

RE: Use of the MySQL logo - licensing agreement

Unfortunately if they don't have something in place like this, then a company can come along and hijack the 'mySQL' name/logo for their own ends. A company has to make a sincere effort to protect its trademarks else it will fall into the public domain. Then a NuSpherish company

Record locking problems

IRIX v6.5.9 MyODBC v2.50.36 MS Windows 95 MS Access 97MS Windows 95 Grateful for any help you can offer. Thanks. -- Paul Will Daewoo Worthing Technical Centre Tel:01903 227132 Fax:01903 2

Re: Monitoring Database

ck: >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 <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/p

RE: How to count the number of ,br>'s in multiple records

something like this (assuming vbscript): Dim pos = 1 Dim cnt = 0 Do pos = InStr(field, "", pos) If pos > 0 Then cnt = cnt + 1 pos = pos + 3 'get past the current one Else break End If Loop 'at this point, cnt holds y

RE: Question about converting

Try this: SELECT * INTO OUTFILE 'mytable.txt' FIELDS DELIMITED BY '\t' LINES DELIMITED BY '\r\n' FROM mytable; Then, in Access, use the Import wizard and specify tabs as your field delimiter and set your field qualifier to (defaults to double-quote). Optionally, you could prepend the text file

From clause not allowed in update, delete

DELETE statement has a FROM clause but you can't, as I understand, JOIN tables there). This will pose significant design challenges for me as my app relies heavily on this functionality. So far, I have conceived 2 ways to work around this limitation. 1. Use CREATE TEMPORARY TABLE (...) S

RE: Simple SELECT query (or so I thought)

uery (or so I thought) I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- usernamevarchar(255) curDate da

RE: Simple SELECT query (or so I thought)

your order by in that in that scenario, the records will be sorted alphabetically by username. If you want to group by username, then you must determine in what order usernames will print. The solution I have outlined will order the usernames according to who has the highest (max) wucount and

RE: replication bug

I assume that you have already scanned the MySQL manual section 4.10.4 "Replication Features and Known Problems" to see if anything listed there as a problem is relevant to your situation. I found a couple of gotchas there that caused me some problems. -Original Message- From: Gabe E. Ny

RE: 123box.co.uk mail delivery system (from:MAILER-DAEMON@123box.co.uk)

database, sql, query, table > Sorry about that. Here's the answer: > > [EMAIL PROTECTED] > And this means what? A little less criptic, please, for use simpletons. - Before posting, please check: http://www.mysql.com/ma

RE: HELP PLEASE - C API code help: UPDATE query using result from SELECT

ql_errno(&my_connection), mysql_error(&my_connection)); > } > } > > return EXIT_SUCCESS; > } > > void display_row() { > unsigned int field_count; > > field_count = 0; >

RE: Load_File

See MySQL Manual section 6.4.1 SELECT INTO OUTFILE database <- to satisfy mailer-daemon > -Original Message- > From: Jason Kwok [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 19, 2001 10:21 PM > To: [EMAIL PROTECTED] > Subject: Load_File > > > Load_File is used to read a pic

RE: Basic details...

I looked but could not find any reference in the docs regarding limits on the number of columns a table may have. I can say for certain that at 50 you are at no risk (I have tables with 140+). The only db that I know the limit on is MS Sql Server and it allows 255. > -Original Message-

RE: UDF

What platform are you running on? Must... Have... Details... database > -Original Message- > From: Pavel Popov [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 20, 2001 6:57 AM > To: [EMAIL PROTECTED] > Subject: UDF > > > Hi, All. > > I have tried to add UDF, but has received a

RE: C API problems

> Can someone give me a quick *complete* example code of setting up a > connection, performing a small query, and reading back the result? > In windows install, there is an examples directory which contains mytest.c. I can't say if this exists for Linux but I bet it does in some form. Why don't

RE: C API problems

Sorry, I hit send before I was done... > examples, sadly, just aren't very good. And there is no example for > mysql_use_result(). (the example code uses mysql_store_result()) The syntax and proceedure for mysql_use_result is very very similar. My advice: get it working with *store* and then

Create Index - memory leak?

hole table. Why doesn't it just extract the columns it needs along with something like a unique record or page pointer and sort that? Any light that can be shed will be much appreciated - even if it just points me to some reference material that is relevant. Thank

RE: Semi colons in text fields in update statement

I'll be damned if I can find it documented. Until someone else enlightens us both, hopefully the above solution will see you through. > -Original Message- > From: johnlucas-Arluna [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 20, 2001 1:45 PM > To: [EMAIL P

RE: Semi colons in text fields in update statement

perly account for its being embeded in a literal string. > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 20, 2001 2:15 PM > To: [EMAIL PROTECTED]; johnlucas-Arluna; [EMAIL PROTECTED] > Subject: RE: Semi colons in text fields in update s

RE: synchronization of database between two mysql servers

Ok, an accidental double posting I can understand... but this is the 4th time in an hour that you have posted the same message... Chill out! > -Original Message- > From: phani krishna [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 20, 2001 2:42 PM > To: [EMAIL PROTECTED] > Subjec

RE: Select dates from Table 1 not in Table 2

Try this: CREATE TEMPORARY TABLE tmp_avldate (date datetime, nadate datetime); INSERT INTO tmp_avldate (date, nadate) SELECT DISTINCT schedule.date, nonavailable.date FROMschedule LEFT JOIN nonavailable ON schedule.date = nonavailable.date; SELECT dat

RE: MySQL Update Logging ???

Actually yes (if I read the documentation correctly - I have not tried this). In MySql Manual section "4.10.5 Replication Options in my.cnf", I find: binlog-do-db=database_name Tells the master it should log updates for the specified database, and exclude al

RE: Mysql as backend for email ?!?

e/have the bandwidth for it. Let me know, Will -Original Message- From: Rich Duzenbury [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 1:35 PM To: Christopher Bergeron; [EMAIL PROTECTED] Subject: Re: Mysql as backend for email ?!? I'm a little fuzzy on this, but I seem

RE: Backup Data

od is generally quicker but has a couple of downsides: - It will not create your table definition for you! You will have to either: 1. pre-define your table and then import into it 2. define your table through the import-text wizard (see the advanced button) 3. import it and t

RE: Backup Data

anges online and then replicate these changes back to the > local copy e.g two way replication > > Thanks > Neil > > - Original Message - > From: "Will French" <[EMAIL PROTECTED]> > To: "Neil Tompkins" <[EMAIL PROTECTED]>; <[EMAIL PROT

RE: Not working mysql in win2000 Prof.

The message you are getting indicates that it cannot find the executable file. You are getting this because you are not putting a space between the executable name "mysqld" and your command-line option "--standalone". Unless you have some reason to not want to run mysql as a service, I reccommend

RE: Newbie - PWS & SQL. Some VSQs (Very Silly Questions)

, for instance, download Apache and PHP and take a different road altogether. One advantage to this would be that you will certainly find more examples of people using these technologies with mysql than you will ado/asp. In either event, you should definitely look for a less restrictive ho

RE: Creating Databases

rtfm. Excerpt from mySQL manual. = 6.5.1 CREATE DATABASE Syntax CREATE DATABASE [IF NOT EXISTS] db_name CREATE DATABASE creates a database with the given name. Rules for allowable database names are given in Section 6.1.2 [Legal

RE: Update problem

In answer to your question - your statement does not work becuase mysql does not allow joins in update statements. imho, the fact that mysql does not support joins in UPDATE and DELETE statements is by far its greatest weakness. I have posted a couple of messages to this group to see what creati

RE: Update problem

me not-so-simple design challenges. In closing, I offer a couple rhetorical questions: 1. Who is the bigger idiot... The person who asks a naive question or the person who, upon hearing a question he knows the answer to, assumes the asker is an idiot? 2. Does your condescending attitude win you a

RE: Inserting Numeric Data with the C API

I searched pretty thoroughly for a way to access mysql data in their native field types (e.g. an int field I wouldn't have to use atoi()/itoa() on) and came up with nothing. If you are processing large amounts of data you may want to do what I did which was to make my program build a load file (a

Disk-bound joins

tables, I had to kill it after 100 minutes and it had not even begun writing to the result table yet. Anyone have any ideas... anyone? Thanks in advance for your help Will French - Before posting, please check: http

RE: Disk-bound joins

Thanks for responding. That's interesting. I will definitely give your sugestion a try. I thought the two syntaxs had the same effect. What does the optimizer do differently? > -Original Message- > From: Andrew Murphy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, Septem

RE: ms SQL server 7.0 -- > mysql?

ty (with the "/t" option which creates tab-delimited output) and the "load data infile" command to load it into mysql. It is possible that someone has created a more automated way of doing this and if so that would be worth checking out. Will French > -Original Messa

RE: ms SQL server 7.0 -- > mysql?

nes do not seem to be networkable, I am assuming that you have some means (cd-burner, etc.) of moving data from your windows machine to your linux machine at home. Both the "generate sql scripts" function and bcp create text files which can be copied to the medium of your choice. Will

RE: why would LOWER

r the index. If the character set you are using is case sensitive (and I assume it is or you wouldn't need the LOWER), then the hashing algorithm would also be case sensitive. Will French > -Original Message- > From: Joe Kaiping [mailto:[EMAIL PROTECTED]] > Sent: Sunday, Septemb

RE: last_insert_id() bug ?? using INSERT IGNORE

design feature... call it what ever... it doesn't change the fact that the behavior is counter-intuitive and could cause problems with some designs (at the very least, having gaps in the sequence could result in minor performance degradation due to uneven key distribution). Will French >

RE: --How to dump only table structure with MySQLDump?

check the command line option -d (or --no-data) > -Original Message- > From: Barry McClure [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 1:45 AM > To: [EMAIL PROTECTED] > Subject: --How to dump only table structure with MySQLDump? > > > I would like to extract the DDL f

RE: Is it possible to Rename Database

ravi:> Or, use mysqldump to dump the entire database, edit the CREATE ravi:> DATABASE line ravi:> at the top to the new name and pipe it all back into mysql, then drop the ravi:> old one? That's sort of taking the long way around the barn, isn't it? Will > -Ori

  1   2   >