Re: bash powered MySQL Queries

2005-01-31 Thread andy thomas
On Sun, 30 Jan 2005, Andy wrote: > Hi all > > I just wanted to know what would be the easiest way to retrieve simple data > from a MySQL database from a bash script. I do this a lot - just construct the query and dump it into a file from within the script, eg: echo "select * from widgets

Re: spaces in table/column name

2004-12-10 Thread andy thomas
On Thu, 9 Dec 2004, sharif islam wrote: > How mysql deals with spaces in table / column name? I am also using > mysqlcc. If I try the following in the doesn't work. Creating table > name with spaces from mysqlcc didn't give any error. But the following > does: > > INSERT INTO 'tbl name with spaces

Re: Data loss problem with mysql

2004-11-23 Thread andy thomas
On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote: > > Dear all, > > We are running mysql 4.0.17 on linux environment. Our database resides > on external disk connected via FC cables. We recently noticed a loss > of data in the following scenario. > > Inserted a row in a table in a separate transacti

Re: Low-end SATA vs. SCSI

2004-11-13 Thread andy thomas
On Fri, 12 Nov 2004, Fagyal Csongor wrote: > Hi List, > > I am putting in a separate disk for our MySQL (4.1.7) server. I have > some MyISAM, some InnoDB tables. Lots of reads, lots of writes (mostly > atomic ones, insert/update one row), a few million rows per table, > approx. 100-400 queries per

Re: help with dbf and dbt

2004-11-08 Thread andy thomas
On Mon, 8 Nov 2004, José Antonio Viadas O. wrote: > Can someone help me, i have two files one dbf and one dbt thant i need to > import it in mysql, can someone help me telling me how can i do this. Have a look at dbf2mysql (http://dbf2mysql.soourceforge.net) - this will import .dbf files. I'm not

Re: MySQL and partitions

2004-11-03 Thread andy thomas
On Wed, 3 Nov 2004, Yves Arsenault wrote: > Hello all, > > I have MySQL installed on a Mandrake Linux system, it is installed on > the /usr partition. > > I was wondering, is it possible to store some databases on the /var > partition while MySQL is installed on the /usr partition? Yes. In fact,

Re: OT: Two more Gmail invites

2004-09-23 Thread andy thomas
On Thu, 23 Sep 2004, John Meyer wrote: > Just to let people know. And BTW, you have to say that you want the > account. Reply off list. > Onlist, I'd like to know how most people back up their Mysql dbs? XML > or direct SQL file? I prefer the latter, although I'd like to hear > from proponents

RE: Mysql and PHP

2004-09-15 Thread andy thomas
I originally said I compiled my apache with MySQL support! I tend to build my apache httpd with modules like php and mod_auth_mysql statically compiled into the binary (for speed and performance reasons) rather than loaded at run-time as a dynamic module. Andy > -Original Message----- >

Re: Mysql and PHP

2004-09-15 Thread andy thomas
On Wed, 15 Sep 2004, Greg Donald wrote: > On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]> wrote: > > Did you build both php and apache with MySQL support? > > I wasn't aware you could build Apache with MySQL support. How is that done? Apol

Re: Mysql and PHP

2004-09-15 Thread andy thomas
On Wed, 15 Sep 2004, nestor(earth) wrote: > People, > > This more of a php mysql question. I have installed PHP ( 5.01) with > Apache(1.31) and it runs. > I have install Mysql (the latest as of last night) and it runs. My > problem is that PHP does not see > Mysql. Now I have done this instal

Re: question about mysql start up again

2004-09-15 Thread andy thomas
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote: > Hi > > > I have installed some software on aix5.2 . > the list of software: > apache-1.3.29-1.aix4.3.ppc.rpm > php-4.0.6-5.aix4.3.ppc.rpm > MySQL-3.23.47-3.aix4.3.ppc.rpm > MySQL-client-3.23.47-3.aix4.3.ppc.rpm > > All of them was installed by using the

Re: question of mysql start up

2004-09-15 Thread andy thomas
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote: > Hi > > > I have installed some software on aix5.2 . > the list of software: > apache-1.3.29-1.aix4.3.ppc.rpm > php-4.0.6-5.aix4.3.ppc.rpm > MySQL-3.23.47-3.aix4.3.ppc.rpm > MySQL-client-3.23.47-3.aix4.3.ppc.rpm > > All of them was installed by using the

Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

2004-08-27 Thread andy thomas
On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote: > I am switching from a Windows computer to a Linux computer and when I > dump the data from Windows to Linux I have no problem except for the > fact that some of my characters have been converted to strange > characters and when the d

Re: No Response from Server

2004-07-13 Thread andy thomas
On Tue, 13 Jul 2004, s.ahmad wrote: > thankyou for your kind attention. > > there are 50+ Reservation stations in the country. Where multiple > operators are sitting and reserving seats. Indexes are being used in > the DB. as i am related to hosting company, i havent seen if they are > taking adva

Re: restore from mysqldump file

2004-07-02 Thread andy thomas
On Fri, 2 Jul 2004, Chuck Barnett wrote: > Hello, I have a huge problem that you guys may be able to help me with. > > I did a mysqldump all databases into a sql71.sql file. > > when I try and I get the following error when trying to restore > > ERROR 1050 at line 204528: Table 'columns_priv' al

Re: Federated servers

2004-06-29 Thread andy thomas
On Tue, 29 Jun 2004 [EMAIL PROTECTED] wrote: > > Hello! > > We are currently running with one big ms sql-server. > > Is it possible to do federated servers on mysql? > > What I want to do is to purchase one more server and split the work load on > the two servers. Yes, you can use master/slave re

Re: RE - Order By Problem

2004-06-11 Thread andy thomas
-+--+ > | Marco | van Basten | > | Max| van den Berg | > | Chris | Brown| > | Michelle | de Contes| > | Alicia | Davidson | > | Joe| McNeil | > | Sylvia | du Sautoy| > | Michael| Stass

RE: RE - Order By Problem

2004-06-11 Thread andy thomas
On Tue, 8 Jun 2004, Andy Eastham wrote: > Andy, > > Just: > > select substring_index(surname,' ',-1) as r from advisers order by r; Yes, that did the trick! Thanks, Andy > > -Original Message- > > From: andy thomas [mailto:[EMAIL PROTECTED] >

Re: AW: ORDER BY problem

2004-06-11 Thread andy thomas
ng this database, we are now about to redesign the table to allow individual people to decide where they want their surname to appear in the listing. Thanks for your suggestions, Andy > -Ursprüngliche Nachricht- > Von: andy thomas [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 8. J

Re: RES: ORDER BY problem

2004-06-11 Thread andy thomas
er chosen by the administrator, rather than trying to do this automatically by a SELECT statement. Thanks for your suggestion anyway. Andy > -Mensagem original- > De: andy thomas [mailto:[EMAIL PROTECTED] > Enviada em: terça-feira, 8 de junho de 2004 08:51 > Para: [EMAIL PROTECTED] &

RE: RE - Order By Problem

2004-06-08 Thread andy thomas
On Tue, 8 Jun 2004, Andy Eastham wrote: > Look at using the Reverse() function, then take the substring up to the > first space, then reverse the result. Well, 'select substring_index(surname,' ',-1) from advisers' does the trick as far as extracting the wanted parts of surnames at the end of the

Re: RE - Order By Problem

2004-06-08 Thread andy thomas
working. I now need to figure out how to use the IF syntax, etc (not done this before ;-) so that the result from thsi query can be used as an argument for the next. cheers, Andy > andy thomas wrote: > > >Yes, this is the approach I was thinking of using but: > > > > sel

Re: RE - Order By Problem

2004-06-08 Thread andy thomas
On Tue, 8 Jun 2004, Paul McNeil wrote: > I have never done anything like this but after looking at the spec's I have > a possible direction for you > > In String functions there is > > LOCATE(substr,str,pos) > The first syntax returns the position of the first occurrence of substring > substr

ORDER BY problem

2004-06-08 Thread andy thomas
In a table called 'advisers' I have a column called 'surname' which contains the surnames of a number of people. Using a query like: 'select * from advisers order by surname' lists the people in the correct order but some people have surnames like 'du Sautoy' and 'van den Berg' and these are listed

Re: Generating an automatic e-mail via MySQL

2003-02-12 Thread andy thomas
On Wed, 12 Feb 2003, Dan Tappin wrote: > Does any one have a suggestion on running a daily / weekly e-mail > notification based on results from a MySQL query? > > I have a table with date sensitive rows. The idea that as rows become > stale (they were created / updated more than a week or month a

Re: Serwer Hardware p4 or pIII ?

2002-12-04 Thread andy thomas
On Wed, 4 Dec 2002, Helmut Apfelholz wrote: > Hi, > I am assembling mysql only server. I am planning 2Gb > RAM, 4 x 15k SCSI disks. However I cannot decide if I > should get 2 p4 processors or 2 tuallatin pIII. > > I could not find any mysql specif?c benchmarks, that > would show which processors

Re: PHP bias

2002-11-09 Thread andy thomas
On Sat, 9 Nov 2002, R. Hannes Niedner wrote: > On 11/10/02 5:12 AM, "Robert Macwange" <[EMAIL PROTECTED]> wrote: > > > I am bothers me. > > It bothers me that that the MySQL people have a bias towards PHP. > > PHP is an inferior language. Deal with perl instead. > > > > ...

Re: mysql 4.x for debian?

2002-11-06 Thread andy thomas
On Wed, 6 Nov 2002, von Boehn, Gunnar wrote: > > Hello, > > what is the status of MySQL 4.x for debian? > > Does MySQL AB plan to release deb paketes or will > MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to a

Re: SELECT COUNT

2002-09-27 Thread andy thomas
On Fri, 27 Sep 2002, Michael J. Fuhrman wrote: > Hello All, > > I seem to be running into a very strange problem. > > In the mySQL command line interface I issue SELECT COUNT (*) FROM The correct syntax is SELCT COUNT(*) ie, there's no space between SELECT and the (*). Andy --

Re: Bug ?

2002-09-02 Thread andy thomas
On Mon, 2 Sep 2002, Marian wrote: > > Why mysql corrupt tables if filesystem if full ... ? > > On good database servers (eg. PROGRESS) process shutdown server > (protetcting data). > > sytem: > linux-2.2.19 > mysql-3.23-38 Good sys admins don't let filesystems become full Andy

Re: Moving a DB from one Server to another

2002-07-08 Thread andy thomas
On Mon, 8 Jul 2002 [EMAIL PROTECTED] wrote: > Todd Cary writes: > > > Is there a quick and simple way to move a MySQL DB from one server to another > > MySQL server? Can I just copy the tables? > > > > for as far i know, you can just copy the directory ( DB ) from one server to > the other. >

RE: mysql.com site down

2002-07-02 Thread andy thomas
On Tue, 2 Jul 2002, Darley, Terry wrote: > I'm in the UK and I can get to it okay !!! > > Perhaps something has changed on your PC/Network ??? I've had problems reaching the MySQL web site too. I think it's to do with the fact I'm connecting through a UK academic site which relies in ebone for

Re: Stored procedures

2002-06-27 Thread andy thomas
dy > - Original Message ----- > From: "andy thomas" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, June 27, 2002 7:01 AM > Subject: Stored procedures > > > > Does anyone know if stored procedures have been implemented in MySQL? >

Stored procedures

2002-06-27 Thread andy thomas
Does anyone know if stored procedures have been implemented in MySQL? Getting into the MySQL web site from the UK is almost impossible these days so I thought I'd ask here. Thanks in advance for any information, Andy - Befor

Re: MySQL for Digital UNIX V4.0F (Rev. 1229) binary?

2002-04-18 Thread andy thomas
On Thu, 18 Apr 2002, Atila Hajnal wrote: > We have Digital UNIX V4.0F (Rev. 1229) and we will to run MySQL but > only binary is for OSF 5.1 version. This isn't adecvate. > > Can anybody help us in compiling source or have anybody binary version > (just compiled)? I have a version 3.23.18 bina

Re: Do any of your applications work?

2002-04-06 Thread andy thomas
On Sat, 6 Apr 2002 [EMAIL PROTECTED] wrote: > I sense this could be a troll, but... > > /* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */ > . . > Frankly, the agreement your client should look at cancelling is the one > with your company. Your inability to install MySQL notwithstanding, > jump

Re: MySQL Power ?

2002-04-05 Thread andy thomas
On Fri, 5 Apr 2002, Steve Rapaport wrote: > On Friday 05 April 2002 06:37 pm, andy thomas wrote: > >On Fri, 5 Apr 2002, Steve Rapaport wrote: > >> With InnoDB, I'm sure this problem goes away, but as soon as we > >> go to InnoDB, we have to pay for backups

Re: MySQL Power ?

2002-04-05 Thread andy thomas
On Fri, 5 Apr 2002, Richard Spangenberg wrote: > > I don't mean to start an opinion war, but ... > > Can mySQL handle many processors, many servers (clustering), load > ballancing, etc as well as Oracle. Or should one use Oracle (some other > database) for large volume high response requiremen

Re: Table statistics

2002-04-04 Thread andy thomas
On Thu, 4 Apr 2002, Georg Richter wrote: > On Thursday, 4. April 2002 10:42, andy thomas wrote: > > > Yes but this is PHP code that can only be run through a suitable web > > server, browser, etc - I want a command line solution like mysqlshow ... > > or from within

Re: Table statistics

2002-04-04 Thread andy thomas
On Thu, 4 Apr 2002, denonymous wrote: > From: "andy thomas" <[EMAIL PROTECTED]> > > > Is there a command I can give in the mysql client to find the number of > > rows in a table or, better still, the number of rows in all the tables in > > a database?

RE: Table statistics

2002-04-04 Thread andy thomas
On Wed, 3 Apr 2002, Nick Arnett wrote: > > > > -Original Message- > > From: Doug Bishop [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, April 03, 2002 10:13 PM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: RE: Table statistics > > > > > > Try: > > > > > mysql_connect("local

RE: Table statistics

2002-04-04 Thread andy thomas
$query); > $row = mysql_fetch_array($result); > echo "Table " . $tableNames[$i] . " contains " . $row[0] . " rows.\n"; > } > ?> Yes but this is PHP code that can only be run through a suitable web server, browser, etc - I want a command line solution li

Table statistics

2002-04-03 Thread andy thomas
Is there a command I can give in the mysql client to find the number of rows in a table or, better still, the number of rows in all the tables in a database? Andy - Before posting, please check: http://www.mysql.com/manual.p

Re: ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)

2002-03-26 Thread andy thomas
On Tue, 26 Mar 2002, colin o wrote: > Same thing happens to me, > > i just use bin/safe_mysqld --user=root & > to start to server so that i can use mysql. > I don't know exactly why it happens though. > Possibly permissions?? It is better to run mysqld as a non-root user, such as mysql. > ---

RE: Coldfusion,Mysql,Myodbc

2002-03-26 Thread andy thomas
ed the full Internet address of teh MySQL server. Andy > -Message d'origine- > De : andy thomas [mailto:[EMAIL PROTECTED]] > Envoye : mardi 26 mars 2002 13:14 > A : [EMAIL PROTECTED] > Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED] > Objet : Re: Coldfusion,Mysql,Myodbc >

Re: Coldfusion,Mysql,Myodbc

2002-03-26 Thread andy thomas
On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote: > > > > Hi there . > I am new to Mysql.I have to access mysql from coldfusion..and we dont get > myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am > not able to compile the myODBC bit...its giving compilation problem..Any >

MS Access to MySQL conversion

2002-03-21 Thread andy thomas
We have a Unix server which in addition to running MySQL is also a fileserver for a group of MS Windows PCs (using samba) and it would be useful to be able to convert the Microsoft Access .mdb files put there by users directly to MySQL, or at least to .csv format. Does anyone know of such a utili

Re: High Availability questions

2002-03-20 Thread andy thomas
On Tue, 19 Mar 2002, Young Sul wrote: > Hi, > > I've got a website that uses a mysql backend database. Due to the way in > which > the database and development has been architected, I'm unable to > load-balance > the database between multiple DB servers, taking advantage of replication > inhere