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

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

/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

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'

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: 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:

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: 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 >

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

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

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

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.

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]

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

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: 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]

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://

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

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,

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]

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.

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

Re: Backing up all MySQL DBs

ir/db_$dbname.zip - >> $destdir/backup.log done WILL [EMAIL PROTECTED] - Original Message - > From: "Mike Hillyer" <[EMAIL PROTECTED]> > To: "René Mølsted" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, September 08, 2003 9:02 PM

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]

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

--- 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

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

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

--- 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

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 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

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 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

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

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

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

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,

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

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

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.

$$ Wanted: MySQL & PHP expert assistance

. Interested parties should reply directly to my email. Ideal candidate will be located in SE USA, but will consider all. Email [EMAIL PROTECTED] thanks. Will Standley NetPV, Inc. - Before posting, please check: http://

Sorta OT: Perl/MySQL Mail List Module?

Greetings, This may be a bit OT, but does anyone know of a good perl/cgi module that works with DBI (MySQL) to write a mailing list? PLMK, Thanks, Will _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http

newbie stuff: good mysql books?

le systems development, and I am just wondering what books might be good for this purpose? PLMK, Thanks, Will _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=feature

RE: Connecting to MySQL on Linux from a Windows machine. -- Resolved !!

e to start up a MySQL/PHP setup that worked. Now both the website development works and I can use MyCC on the windows machine to administer the database. Thank you to all that considered my problem. --Will - Before posti

RE: Connecting to MySQL on Linux from a Windows machine.

ebmin tip, I'll give it a try. Doesn't solve all of my problem, but it may help. Thanks, --Will > -Original Message- > From: STIBS [mailto:stibs-pi@;gmx.de] > Sent: Friday, October 18, 2002 1:35 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] &

RE: ERROR 2013: Lost connection to MySQL server during query

same problem or if Animesh has a different problem that generates a similar response. See the "Connecting to MySQL on Linux from a Windows machine." thread for more details on my situation. Thanks, --Will > -Original Message- > From: Animesh [mailto:an

RE: Connecting to MySQL on Linux from a Windows machine.

Thank you to both of you who responded to my question. I have checked both of these issues and found that neither solve my situation. 1) I have (and had) both a 'will@localhost' and a 'will@"%"' entry in the user table. Is there something else that has to

Connecting to MySQL on Linux from a Windows machine.

et to port 80 and get a connection although it doesn't do much there. 5) I cannot telnet to port 3306. When I try, I get an immediate "Host connection lost." error. Any ideas would be most appreciated. Thanks

Index Columns: Night of the Living Newbie

Hello, Without giving me the RTFM, and in 25 words or less... Can someone tell me what an index column is and does for a query? Thanks, Will _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com

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

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.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

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

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

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

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

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

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! =)

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 /

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,

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

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

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

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

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

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

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

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,

Data Validation

Greets Folks, Semi-newbie question here. Is there a way to perform data validation (in the SQL language for MySQL) for input I would have coming in off the web (i.e. via HTML/CGI)? I need some tuts, or even just the raw SQL code with some simple install directions. Thanks, =) Will

Seeking Database/Scripts

SQL database. Please let me know if you have any scripts, tutorials or off-the-shelf software you could recommend. Thanks! =) Will K. P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote "MySQL and Perl

Corrupted table

I wonder if anyone can assist me with this one. I appear to be getting sporadic corruption of a table that is then unrecoverable. The error I get is as follows: Incorrect information in file: 'user_admin_table.frm' This is a longshot but Has anyone seen this error before? -

RE: Can MySQL be run from a CD-ROM?

I went to the link provided to the list archive just to see if I could find anything. I couldn't find anything with "CD", "CD ROM", "CD-ROM", "running mySQL for a CD" and various permutations and combinations thereof. Also did a Google search for this and came up blanked. So, this is not as readil

RE: auto increment problems

to create a new table and use "insert into" to populate all fields but the auto_increment field by specifying a column list. Additionally, you may find that myisamchk may have some feature to deal with this sort of problem but I don't recall. Will > -Original Message- > F

RE: auto increment problems

to create a new table and use "insert into" to populate all fields but the auto_increment field by specifying a column list. Additionally, you may find that myisamchk may have some feature to deal with this sort of problem but I don't recall. Will > -Original Message- > F

RE: Migration to mysql from MS SQL Server

the entire thread costs some bandwidth and disk space, imho, not having to sift back through scores of old posts to find the original is well worth it. Will > -Original Message- > From: Carl Troein [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 04, 2001 11:59 AM > To: [EMA

RE: Migration to mysql from MS SQL Server

t editing chores were, for me, valuable in that they provided me with a chance to review my schema for opportunities to take advantage of some features in MySQL not available in MS SQL (date fieldtypes where MS has only datetime, enum and set types, etc). Will > -Original Message- >

RE: Migration to mysql from MS SQL Server

n the script to build them now. There are probably a million different ways to do this. This is the way I did it and it worked well for me. Since I have huge amounts of data, the fact that both BCP and "load data infile" are very quick was a deciding factor. Hope this helps. Will French

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

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: 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: 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: 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: 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: 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

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: 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

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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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

  1   2   >