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
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
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
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
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
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,
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
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-----
>
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
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
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
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
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
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
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
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
-+--+
> | Marco | van Basten |
> | Max| van den Berg |
> | Chris | Brown|
> | Michelle | de Contes|
> | Alicia | Davidson |
> | Joe| McNeil |
> | Sylvia | du Sautoy|
> | Michael| Stass
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]
>
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
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]
&
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
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
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
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
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
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
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.
> >
> > ...
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
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
--
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
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.
>
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
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?
>
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
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
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
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
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
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
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?
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
$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
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
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.
> ---
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
>
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
>
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
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
48 matches
Mail list logo