Re: error 29, file not found (errcode: 13)

I generally drop them into /tmp for easy access and cleanup after the data load, but you can put them any place that the mysql daemon process has access to read. Scott Helms Vice President of Technology ZCorum (678) 507-5000 http://twitter.com/kscotthelms

Re: Select w/ group by question

UP BY item; Pretty straight forward and does not require another join back to the same table with 30+ million rows. Thanks Scott On Wed, Jul 14, 2010 at 10:35 AM, Peter Brawley wrote: > Scott, > > > I would like to obtain the least cost of each product type and its >> associ

Select w/ group by question

ient. My real tables have somewhere around 30 million rows in them. Thanks Scott

Error 1064

I am receiving this error: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '16 varchar(255) NOT NULL default 'Not applicable', 17a varch I have version 4.0.16 and have a dump file that I'm trying

RE: Join Suddenly Failing

so that only the last table (i.e. teamperson) was used for your JOIN Scott Swaim I.T. Director Total Care / Joshua Family Medical Care (817) 297-4455 Website: www.totalcareclinic.com NOTICE: The information contained in this e-mail is privileged and confidential and is intended for the

Happy Christmas

Hope you are all having a Happy Christmas. Regards Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to Backup the Database using Script

quot; $location cd $location echo "Now in: `pwd`" echo "begin tarballing" tar cvfz $time.tgz *.sql # set permissions on the final file chown root:wheel $time.tgz chmod 0 $time.tgz echo "removing:" ls -la $location*.sql rm $location*.sql echo "All your MySql Database

Re: insert random number into table

I always maintain a timestamp in my random numbers. As long as my precision is higher than my requests per second, wouldn't I be safe from collisions? Assuming a time machine is not invented. -- Scott Iphone says hello. On Oct 16, 2009, at 11:29 AM, "Jerry Schwartz" >

Re: insert random number into table

e it shorter. It's also quite easy to create a dictionary of words and create a function that can make word1-xx-word2 and end up with red-56-car. -- Scott Iphone says hello. On Oct 16, 2009, at 11:25 AM, Gavin Towey wrote: Don't try to give them a random number, instead use a tabl

Performance tuning a group by with percentage

my case, launchd, unless someone has a better suggestion. Would you think that a simple 'SELECT (the above) INTO foo' would suffice? ( I will add a date stamp as well ) Thanks all. -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailin

mysql.socket location problem

y php scripts connect but I can't connect to mysql from the command line. I get the error can't connect through socket /var/run/mysql/mysql.sock. What do I have to change to make the konsole use /var/lib/mysql/mysql.sock? Thanks, Scott -- MySQL General Mailing List For list

RE: SELECT by day

Try this SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3; Scott Swaim I.T. Director Total Care / Joshua Family Medical Care (817) 297-4455 Website: www.totalcareclinic.com NOTICE: The information contained in this e-mail is privileged and confidential and is intended for the exclusive

Re: Getting mySQL to ignore case sensitivity of field names

methods seem prone to trouble. On Aug 27, 2009, at 3:04 PM, Scott Haneda wrote: http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html You need to set the field format to a non binary one, and case insensitive will be the default. On Aug 27, 2009, at 2:57 PM, Adrian Aitken wrote: Hi

Re: Getting mySQL to ignore case sensitivity of field names

ng case in select query values not field names. -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Logins, php, legacy, old password

consolidate. Yes, I can run a second server, but I would rather manage and maintain one, giving me the ability to retire a machine. -- Scott Iphone says hello. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Client deleted database, semi high priority master slave question

On Jul 8, 2009, at 12:49 PM, Daevid Vincent wrote: I know it comes a little too late, but as a preventive measure going forward, I offer up my daily crontab backup script: http://www.daevid.com/content/examples/daily_backup.php FYI, this link does not work in Safari. -- Scott * If you

Re: Client deleted database, semi high priority master slave question

be on a raid, and on a schedule, it would also do dumps, which could take as long as they want, since this machine was not being hit at all. This was not implemented for some reason. I will look at your scripts, thanks again. -- Scott * If you contact me off list replace talklists@ with

Client deleted database, semi high priority master slave question

ed by MySql via DLZ/named. Thanks for any suggestions. -- Scott Iphone says hello. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Can a MyISAM DB hold /everything/?

want to have a second database for replication, as a "hot backup", and then have other things in place for "cold backups". This all depends on a lot of factors about your end plans which have not yet been shared. -- Scott * If you contact me off list replace talklists@ with s

Re: Can a MyISAM DB hold /everything/?

op the old image and replace it with the new one; if what you store is a simple pointer to an image file, lots of this work goes away. -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Can a MyISAM DB hold /everything/?

2. I understand there are problems in storing photos in the db. Can one overcome these problems somehow? -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Stored Procedure Data Types

Hello, I would like to do a select on a table to get back the IDs of some of the records. Then take those IDs and do a single update using a WHERE clause like (recordID IN (2,44,21)) My question is: Can I build a string using a cursor that has all of the IDs and then issue an update using the s

Re: Upgrade Mysql

, test, make sure it works, and go from there. -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Diff Mysql and mysqli

&ie=UTF-8&oe=UTF-8 -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replication config

the master info file. Thanks Simon, I will test. Looks like if this is the case, literally, 99% of every tutorial out there is wrong, as they all do this in duplicate, along with the "CHANGE MASTER" SQL command. -- Scott * If you contact me off list replace talklists@

Re: Replication config

by clients. I suppose just not having a login and pass to the replicated database is more than enough? -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Replication config

On May 12, 2009, at 11:11 PM, Simon J Mudd wrote: talkli...@newgeo.com (Scott Haneda) writes: Hello, I am confused about repliction setup. Reading a config file, and the docs, leads me to believe this is an either code choice, pick #1 or #2. If that is the case, why would I want to use #1

Re: Replication config

Thanks, a few comments inline below... On May 12, 2009, at 11:11 PM, Simon J Mudd wrote: talkli...@newgeo.com (Scott Haneda) writes: Hello, I am confused about repliction setup. Reading a config file, and the docs, leads me to believe this is an either code choice, pick #1 or #2. If that

Replication config

mented) and instead use CHANGE MASTER TO (see above) -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Help with mysql query, multiple list

the "between" and "in" keywords. Perhaps your list of timestamps is not in a database, can you put then in? Either way unless I am reading you wrong you only need the greatest and lowest time in your comparison, not a huge list. -- Scott Iphone says hello. On May 8, 2009, at 9

Query log for just one database

I am trying to monitor a specific issue, and I know it is related to only one database. There is a lot of other noise in the logs if I enable query logging. Is there any way to limit query logging to just one database? -- Scott * If you contact me off list replace talklists@ with scott

Re: Now() : SQL syntax error. But why?

ught I couldn't have missed ','(comma) before. But today somehow it works... ;; I wasted hours figuring this out, but you saved me! Maybe I'm still a complete newbie! -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For lis

Re: Now() : SQL syntax error. But why?

O mailing SET Name='$Name', Revenue='$Revenue', Company_Size='$Company_Size', Ownership='$Ownership', Homepage='$Homepage', Job_Source='$Job_Source', Created=NOW()"; echo $sql; mysql_query ($sql)

Information Schema

ccount. I will certainly go read more in the docs about what this table is for. However, since it seems to be important, I would assume you do not want database users to be able to update, insert, or delete against it. Is the default set up in a way that database/tables are protected? -- Scot

Re: Now() : SQL syntax error. But why?

gives no error. It's very strange. 'Now()' works for some tables, and it doesn't for some. (All set in phpmyadmin...) What could have caused this? Any similar experience? -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List

Re: Auto increment?

If you use the LOW_PRIORITY keyword, execution of the UPDATE is delayed until no other clients are reading from the table. This affects only storage engines that use only table-level locking (MyISAM, MEMORY, MERGE). Maybe you can use the LOW_PRIORITY keyword in your update comm

Re: Auto increment?

al update/change happened the time-stamp is not going to get updated. * There is a version of mysql 4, that going forward, had a change to how `timestamp` was defined. If your old data is in version four, and you plan to move to a new version, look out for that issue. Thanks for "w

Auto increment without uniquness

to have an empty group_id, and use the id as what I search on, but it seems messy. Suggestions? Thank you all -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: Multiple batch files

by AT&T > > -Original Message- > From: David Scott > > Date: Thu, 19 Mar 2009 11:16:03 > To: > Cc: > Subject: Re: Multiple batch files > > > Thanks for responding Gary > I get: > > --- > Volume in drive D has

Re: Multiple batch files

> Dir *.sql > my.bat > > Edit batch file for each line to append "| mysql" > > Call batch file > > > Sent via BlackBerry by AT&T > > -Original Message- > From: David Scott > > Date: Thu, 19 Mar 2009 11:08:28 > To: > Subject: Mu

Multiple batch files

dows box. Thanks for any suggestions you may have. -- David Scott

Installing MySQL client into workstations using GPO

My objective is to have all Windows XP workstation (300+) report their activities using mysql client that exports in CSV format to our Active Directory's MySQL server. Is it possible to install just the MySQL client over GPO, is this possible? Thanks, Scott Hamm Technology Coordinato

Re: stuck commits

On Tuesday 13 January 2009 07:23:52 am Krishna Chandra Prajapati wrote: > Hi Scott, > > I believe something wrong with innodb parameters. It should be optimum. In > your case it might be too high or too low. Take a look at log file size. > Please send your show variables and show

stuck commits

doing that now. Thanks in advance, Scott Edwards --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Locking database when 'creating sort index'

Oh and we increased the key_buffer_size=1200M (30% of ram) no change. 2009/1/7 David Scott > 1) InnoDb2) 5.0.51 on Linux > 3) No, a Select with a bunch of Joins, a Where, group and order > 4) 37 seconds > 5) Yes > 6) Show Processlist does not show anything, just the user, what ar

Re: Locking database when 'creating sort index'

ther queries start to back up when the large >> one >> gets to the 'creating sort index' phase, this lock seems to affect the >> whole >> server, all databases... does anyone know what may be causing this? >> Thanks in advance >> -- >> David Scott &g

Locking database when 'creating sort index'

When we run a large query other queries start to back up when the large one gets to the 'creating sort index' phase, this lock seems to affect the whole server, all databases... does anyone know what may be causing this? Thanks in advance -- David Scott

Hypothetically looking for Kevin Bacon

o give me the best performance. Does anyone have suggestions, or perhaps examples of this in working use? Maybe there is a known algo of function that gets close to this already. Thank you -- Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: SELECT locking tables.... in other databases

t; 0 is invalid since already the value that you verify is > between unix_timestamp('2008-11-26') and unix_timestamp('2008-11-26') > > > gSL.starttime > unix_timestamp('2008-11-26') > AND gSL.startTime > 0 AND gSL.endTime > 0 > AND gSL.sta

Re: SELECT locking tables.... in other databases

serted 17853779, updated 10095603, deleted 18, read 948444635 13.99 inserts/s, 65.93 updates/s, 0.00 deletes/s, 98.90 reads/s END OF INNODB MONITOR OUTPUT ==== ' I hope that helps-- Dave 2008/11/27 Ananda Kumar <[EMAIL PROTECTED]> >

SELECT locking tables.... in other databases

Hi list.We have 2 tables, both have a few inserts, many updates and the occasional select. When running a select joining the 2 tables (which can take upto 20 seconds to complete, they are large tables) all updates are blocked and the maxconnections is quickly reached. We tried copying the data to

mysqlimport failed to import

I created a csv file entitled 'disposed.csv' and placed it in computer_inventory data folder with the following inside: 1087 1046 1086 1161 1049 1178 1029 1030 1224 1044 1106 Now I created the table 'disposed' as following: Create disposed ( Mot_id INT(4) UNIQUE NOT NULL ); Then I issued the c

Re: Anyone know what to do about OS X 10.5 PPC

10.5 for PPC, I am growing very tired of building that one out all the time, and Entropy seems to have fallen off the planet. Thanks -- Scott [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Anyone know what to do about OS X 10.5 PPC

fallen off the planet. Thanks -- Scott [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

improving random record selection

be very random, I am looking for a pretty flat response in distribution of returned records over time. -- Scott [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Age old order by rand() issue

I have seen nicer fast random row implement, but that will work. Do you happen to have a snip of it, the one I have seems to lean pretty heavy as far as I can tell, and on occasion, though rare, also sends me an empty result set. -- Scott [EMAIL PROTECTED] -- MySQL General Mailing List

Age old order by rand() issue

: Column 'id' in field list is ambiguous I can not seem to get past that error, and would like to call just the columns I want. Or, if someone has a better random record return select, I am all ears. Thanks so much. -- Scott [EMAIL PROTECTED] -- MySQL General Mailing List F

Re: A use for REGEXP, I think.

On 10/12/2007, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > On Dec 9, 2007 9:17 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > > > On Dec 9, 2007 10:53 AM, David Scott <[EMAIL PROTECTED]> > wrote: > > > I have a field in a DB that contains something like

A use for REGEXP, I think.

oint me in the right direction? -- Thanks David Scott

Re: Trigger problem

On Thu, 2007-11-08 at 17:56 -0800, Lucky Wijaya wrote: > Yes, the trigger code is works. Many thanks !! > Now I understand the use of delimiter command. Thanks again... =) > > My next question is, do we able to view the triggers that has been created ? > And how ? > > David Schneider-Joseph <[E

Re: SAN and ibdata files

our server would be getting. Regards, Scott On Mon, 2007-10-08 at 18:06 +0530, Ace wrote: > Yes Scott! Only thing that confused and still confusing me is the following > note on mysql site - > > "*Note* > It is not a good idea to configure InnoDB to use datafiles or logfiles on

Re: SAN and ibdata files

Rajan, In a SAN configuration, the lun/volume should appear just like a locally attached physical disk on your server. MySQL will not need any special configurations to access it, just poiint the datadir to the SAN disk. Regards, Scott Tanner On Mon, 2007-10-08 at 11:06 +0530, Ace wrote

single line inserts with on duplicate key

nsert id is for each of an arbitrary amount of single-line inserts. Defining what I am calling single line insets, I mean: INSERT INTO foo (a, b, c) VALUES ('x', 'y', 'x'), ('x', 'y', 'x'), ('x', 'y', 'x

Re: Design decision

> Scott Haneda wrote: >> I have an a table of objects, attached to those objects are keywords. >> Users submit the keywords to the objects. >> >> Currently, I chose to keep a hit count on the keywords, so if a duplicate >> keyword is supplied, a counter is increme

Design decision

suggestions? Thanks. -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Query to find less than 3 char string

t I'm wondering if anyone may have a link to what they think the best search algoritim out there may be for a shopping website that needs to search three columns (product name, brands and categories) with plurals and possessives added and removed (meaning es, 's, and s). Thanks

OS X binary installer

. -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Slave Misbehavin'

Maybe I missed this in the text below, but are you trying to daisy chain the slaves (master -> slave 1 -> slave 2) or have multiple slaves connecting to one master? Is slave 1 configured with log-slave-updates? Regards, Scott On Wed, 2007-09-19 at 12:31 -0500,

Hypothetical design question regarding keyword searching

uery. Are there other approaches? Which approach would yield the best performance for growth issue? -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -

User variables in update statement

not work. Suggestions? -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Import a text file

s the program Or write a script that adds a comma to the correct location. Does anyone have any suggestions or already have something that does this? Thanks in Advanced Scott Swaim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

How do you reference custom column names

*tax_rate+something-other)+.6) Where what I really want to do is: SELECT price*tax_rate+something-other as foo, (foo+.6) -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Nova

Re: MySql Host through Heartbeat

> \! cat /etc/hostnames; (debian) mysql> \! cat /etc/hosts; (CentOS/rhel) Regards, Scott On Wed, 2007-06-13 at 17:46 +0100, Ben Clewett wrote: > What I know is that: > > Heartbeat with MySQL uses two IP's. That of the server, and that of the > resource MySql. Th

Translation of sql into mysql

right syntax to use near 'from extract a inner join CreditCodes b on a.ConsumerNO = b.Cons Can anyone translate it into correct mysql syntax for me? Thanks David Scott _____ David Scott Department of Statistics, Tam

Add column from another table

CallNumber which I want to add to the phone call table. I have looked at documentation and in the book I have available without success. Can anyone suggest appropriate syntax for this? David Scot _ David Scott Department of

Re: Diff between restore from tar and recover from power outage

our servers, and we haven't had an issue yet (restoring daily to a testing environment). Regards, Scott Tanner On Mon, 2007-06-04 at 14:57 -0700, Wm Mussatto wrote: > On Mon, June 4, 2007 14:21, murthy gandikota said: > > Hi > > When restoring a DB from a tar file, I had t

Obtaining the first or second instance of an event

particular month. I am quite inexperienced with MySQL and SQL in general and would appreciate any help which you can offer. Thanks David Scott _ David Scott Department of Statistics, Tamaki Campus The University

Re: SAN backend for DB's

with external scsi arrays for each server. For us it was cost driven - 8 scsi disks (in raid 10 config) and the arrays were cheaper then 4 fiber disks. The extra heads and less latency made a noticeable difference - our database has a really high write rate. Regards, Scott On Thu, 2007-05-31 at

Data types and reading in data

the appropriate location in the documentation. David Scott _____ David Scott Department of Statistics, Tamaki Campus The University of Auckland, PB 92019 Auckland 1142,NEW ZEALAND Phone: +64 9 373

Re: mysql creating lots of processes (not threads, linux processes)

r/mysql/mysql.sock \ --with-client-ldflags=-all-static \ --enable-shared \ --enable-thread-safe-client \ --with-extra-charsets=none Scott On Wed, 2007-05-30 at 18:29 +0200, Quentin Gouedard wrote: > Oh and by the way mysql works just fine on that machine. You can run > quer

Re: mysql creating lots of processes (not threads, linux processes)

Sounds like your not using threaded libraries. Was mysql built differently, or are you using a different RPM on this server? Scott On Tue, 2007-05-29 at 22:49 +0200, Quentin Gouedard wrote: > No, I have just collectd+mrtg, but i don't even use them to monitor mysql. > I launch mys

Re: Replace, Substitute, Delete

g factor you want to toss in like : SELECT REPLACE(imgName,' ','') FROM staff WHERE imgName LIKE '%d' You get the idea, that would select all image names that end in 'd' -- - Scott Haneda

Re: Replace, Substitute, Delete

t store the image name in a field, and call the path out in your html. This in large part is my opinion, but I do tend to find most will agree with it. -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo

Re: Replace, Substitute, Delete

PLACE('De Long', ' ', '%20'); ++ | REPLACE('De Long', ' ', '%20') | ++ | De%20Long | +----+ 1 row in set (0.00 sec) Which wi

Re: NOT NULL = Not Working?

I knew it was an option somewhere... Perfect! Thanks JamesDR wrote: > JamesDR wrote: >> Scott Baker wrote: >>> If I create the following table, and then try and insert the following >>> data both inserts work. It looks like the second one works (it shouldn't >

NOT NULL = Not Working?

If I create the following table, and then try and insert the following data both inserts work. It looks like the second one works (it shouldn't because Last is NULL) because it assumes Last = ''. Is there a way I can make it NOT assume that? If Last is not specified it should reject that command. I

Re: Bin logs and mysql 4

l occur? No, if you disable the bin-logs, replication wont be happening. Regards, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL e-zine

p is doing well enough you should be around knowledgeable people already. For me at least, it would be more about internals, that the step by step of how to do a join. -- ----- Scott HanedaTel: 415.898.2602 <

Re: Bin logs and mysql 4

mysqldump, just add the --delete-master-logs option. If you want to turn the logs off, remove log-bin and log-bin-index from the conf file. Regards, Scott Tanner On Thu, 2007-04-26 at 09:47 -0700, Scott Haneda wrote: > > In the short term, see the manual page for PURGE MASTER L

Re: Bin logs and mysql 4

recovery, and the once every 12 hour dump I do across all databases is ok with me, I suppose I can just disable said feature? Heck, some of these boogers are a GB each :-) -- - Scott HanedaTel: 415.8

Re: Bin logs and mysql 4

ack I should keep? thanks -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Bin logs and mysql 4

Running mysql 4, just poked into data and see I have gigs and gigs of hostname-bin.xxx log files. How does one maintain these, can someone point me to relevant data on what to do about drive space being lost to these? thanks -- - Scott

Re: Database Replication Fallover

server. Hope this helps, Scott Tanner On Mon, Apr 02, 2007 at 08:43:35AM +0100, Ben Clewett wrote: > I forgot to mention that I am running Linux. > > If anybody has some idea of software which can do this, I'd be very > interested. > > Regards, > > Ben >

Possible in sql, or just move it to a language

match from table 1 Should I just run a loop in my language of choice, or is there a join I am not seeing here? -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S

Problem Installation

older would have been built in the installation of MySQL. Please advise. TIA, Scott No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. http://mobile.yahoo.com/mail

Problem Installation

it starts up and immediately dies. What log file would tell me what happened? Also, strangely, if I move the /usr/local/include/mysql folder and rebuild MySQL, it *doesn't* rebuild that folder! I would have assumed that folder would have been built in the installation of MySQL. Pl

mysqlimport problem with , inside fields

I've been trying to import fields that contains the comma character ',' inside double quotes '"', with the results following: mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n" --ignore-lines=1 --user=root --password shark "c:\documents and set

loading files onto MySQL

Newbie question here. Using Mac OSX Server 10.4.4. Do most MySQL tasks in terminal window. Recently purchased software that tells me to go to Control Panel (which I don't think I have--though I have MySQL tools) and load their file onto the MySQL database. I'm not sure what this means. If I

Re: Choose a random record from a list of duplicates

you want to pick a random record, you can do ORDER BY RANDOM LIMIT 1 > or so. (warning, untested) And I think you will want to group by surname and postcode in order to filter out the duplicates. -- ----- Scott Haneda

SQL syntax

countryid = , enabled = '1' and can't quite figure out what it means. Any help is greatly appreciated. Thanks, Scott _ Experience the magic of the holidays. Talk to Santa on Messenger. http://clk.atdmt.com

  1   2   3   4   5   6   7   8   9   10   >