Hi all,
Here's one of those damned annoying "what if" questions for everyone.
If I have a transaction that performs INSERTs or UPDATEs on a bunch of
tables, some InnoDB and some MyISAM, and after performing a bunch of
modifications on each I issue a ROLLBACK, does the fact that a MyISAM
table is
Hi all!
Currently, one of my clients has a MySQL+InnoDB database that they use for
storing "stuff". My question is, even though I know it will take more time
and will slow down operations for everyone, will mysqldump with the single
transaction option give a consistant snapshot of InnoDB tables if
Hi all,
I was wondering, does anyone know if there are any plans to add FULLTEXT
indexes to the almighty InnoDB such that it catches up with the funky
MyISAM in terms of things you can pass to ALTER TABLE?
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
best guess, you need some database maintence..
> optimize table blah1, blah2, etc..
On Mon, 18 Aug 2003, Vinod Bhaskar wrote:
>
> Hi Friends,
>
> In my linux server (LOCAL), accessing data through the PHP scripts from
> MySQL (3.23.41)tables, it is taking more time. Earlier it was very fast.
Hi Friends,
In my linux server (LOCAL), accessing data through the PHP scripts from
MySQL (3.23.41)tables, it is taking more time. Earlier it was very fast.
Now a days
some reports it is taking more than five minuits. Earlier it use to come with
in a minuit. What may the problem and what
At 16:29 +0300 8/17/03, Dmitry Kosoy wrote:
Hi,
Is there any possibility to check existing of autoextend option
for InnoDB ?
I mean by any sql command and not by searching in my.ini file ?
If you mean you want to find out the setting of the innodb_data_file_path
variable, you can use this statemen
On Thu, Aug 14, 2003 at 11:35:18AM -0700, Jennifer Goodie wrote:
> > Setting skip-name-resolve will avoid this code path and the bug. It
> > looks like some DNS funkyness...
> >
>
> I've implented this and so far I can't get the box to hang in authentication
> no matter how mean I am to it. I fe
The only and best careful way to use a global is not to use one at all!!
At 11:38 AM 8/18/03 +0900, Joel Rees wrote:
>> The only advantage of PHP is that
>> it runs faster than Perl which may be important if a lot of people are
>> accessing your web page.
>
>Using mod_perl vs. mod_php? or perl
> The only advantage of PHP is that
> it runs faster than Perl which may be important if a lot of people are
> accessing your web page.
Using mod_perl vs. mod_php? or perl with the CGI interface vs. mod_php?
(I understand that using mod_perl introduces persistence problems when
globals are not
> People tell me that PHP is THE way to do database work with mysql.
> The thing is, I'm familiar with Perl and it has all kinds of neat
> string manipulation stuff and LWP.
People have opinions. My personal opinion, but I think of PHP as Perl
with all the warts filed off, but I also think they fi
Hi Asif,
Just a guess, but how about
[mysqldump]
password = PASS
??
Best regards
Nils Valentin
Tokto/Japan
Asif Iqbal wrote:
Hi All
I have to run this to dump the database
mysqldump -u root -pPASS --opt database > database.tmp
Is there anyway I can hide the PASS is a file ? I was trying to
Hi Prem,
Which version are you curently using 3.23.xxx ??
Whats the XXX in your version ???
What do the change log files say at the www.mysql.com homepage ?
Best regards
Nils Valentin
Tokyo/Japan
Prem Soman wrote:
Thanks neils!
i have gone thru what u referred long before, i know
that th
Jackson Miller wrote:
> On Saturday 16 August 2003 4:41, Hans van Harten wrote:
>> Depending on your exact needs, consider brutal overwrites:
>> LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE
>> Replaces 1 rows within 3.5 s into Innodb running MySQL-max-4.10
>> and WinXP on Celeron /400MH
David Fair wrote:
i have working install of 3.23.46. on one server. by working, i mean
that i can
get this far
c:\mysql\bin>mysql
mysql>use mysql
and then run queries.
on my other server, i have reloaded 3.23.57 back from 4.04b when i was
having trouble with a php page not working, (failing
i have working install of 3.23.46. on one server. by working, i mean
that i can
get this far
c:\mysql\bin>mysql
mysql>use mysql
and then run queries.
on my other server, i have reloaded 3.23.57 back from 4.04b when i was
having trouble with a php page not working, (failing on the query even
Hello
I am no PHP expert but I find it quite easy to move from Perl to PHP.
PHP too has a huge standard library with lots of useful functions and it
has PEAR, something similar to CPAN.
but when I develop MySQL appliction (mainly for myself at the moment) I
use Python or Ruby. they are a
What is a dbf file?
-Martin
- Original Message -
From: "Bruce Bushby" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 17, 2003 1:40 PM
Subject: mysql and ESRI shape files
> hello
>
> Please excuse the 'baby' question :) I have a 'digital dataset' of the
> streets and
> su
hello
Please excuse the 'baby' question :) I have a 'digital dataset' of the
streets and
suburbs of my area (ESRI shape format). I used 'shp2mysql.pl' (from mapserv)
to import
the maps/layers into mysql, this worked fine EXCEPT for all the street
maps...perhaps
because they're vector "line" data a
Bennett Haselton wrote:
At 11:22 AM 8/17/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I had already run the command:
grant all on tracerlock.test to bhaselto identified by ""
and that didn't work when I did it, but I didn't restart mysql after
running the command. Probably it was the
At 17:35 17/8/2003 +0100, Debbie wrote:
Hi,
Hi,
I have just downloaded MySQLv4.0.14b for windows and 21% through the
installation, it displays the following error:
An error occurred during the move dataq process: -132
Component:
File Group:
File:
The above frequently happens because the installer
Hi,
Sun, 17 Aug 2003 20:08:43 +0300 tarihinde Ville Mattila
<[EMAIL PROTECTED]> soyle yazdi:
VM> I've already tried this
VM> SELECT DISTINCT mh.*, COUNT(mh2.id) AS albumsofartist FROM cd.mh,
VM> cd.mh2 WHERE mh.artist= mh2.artist GROUP BY mh2.artist
VM> But it dosen't give correct results.
Try
Done.
On Thu, 14 Aug 2003, Jack Dare wrote:
> Doh! You are so right. Thanks for the help. Got so used to not needing the
> INNER word that I forgot all about it.
>
> -Original Message-
> From: Kevin Fries [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 14, 2003 1:27 PM
> To: [EMAIL P
Thanks. Actually, my ISP helped me out and got this fixed. Here's what
they wrote in the support log:
>>>
Due to the method that the databases were copied over, I went into mysql
used the grant option on all the databases to allow root access and ability
to alter all the databases. Once this w
Hi there,
I have a table containing my CD collection information, the simplified
structure is following:
id artist album
1 A.R.T The best of A.R.T
2 ATB Big Hits Collection
3 A.R.T My Artistic Life
4 A.R.T You are the only one
How can I build up a query that will contain all
> >
> > I hope I don't start a relegious war here I just want some advice.
> >
> >
> > Mark Healey
> > [EMAIL PROTECTED]
I program with C, C++, python and rebol. My partner use perl.
We do lots of stuff with MySql. My hands-down favorite is rebol.
I find more code-efficient than any other language
Hi,
I have just downloaded MySQLv4.0.14b for windows and 21% through the
installation, it displays the following error:
An error occurred during the move dataq process: -132
Component:
File Group:
File:
The MD5 hash matches the one on your website and I have spent another 5
hours or so downloadi
Steve> select ENTITY from ATTRIBUTE where (NAME='FavoriteSport' and
Steve> VALUE='Soccer') and (NAME='FavoriteFood' and VALUE='CornDogs');
Steve> Empty set (0.00 sec)
Just analyze the query. You asked for a record in which
name = 'FavoriteSport' AND name = 'FavoriteFood' which is always false
bec
Checkout: http://php.dreamwerx.net/forums/viewtopic.php?t=6
It's got streaming code..
What I do is if the type is unknown I always send application/octet-stream
and the browser usually identifies it..
Or check the file extension for the file in the database, and apply
content type based on that.
Steve Cote wrote:
We are having problems with what we think is a simple select statement:
select ENTITY from ATTRIBUTE
where (NAME='FavoriteSport' and VALUE='Soccer')
and (NAME='FavoriteFood' and VALUE='CornDogs');
You are trying to find a row with a NAME value of 'FavoriteSport' and
'Favor
We are having problems with what we think is a simple select statement:
select ENTITY from ATTRIBUTE
where (NAME='FavoriteSport' and VALUE='Soccer')
and (NAME='FavoriteFood' and VALUE='CornDogs');
First, we are running an older version of MySQL:
mysql> select version();
+--+
* Karam Chand
[...]
> > > Is there any way wherein I can get data like
> > > .01,
> > > .02 etc.
* Roger Baklund
> > Maybe the FORMAT() function will do what you want:
* Karam Chand
> It formats the output to ##,###,##.## . I dont want
> the commas and also I dont know what maximum decima
Hi,
Is there any possibility to check existing of autoextend option
for InnoDB ?
I mean by any sql command and not by searching in my.ini file ?
Regards,
Dmitry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
Hi
> The most common problem in such cases is that the webserver doesn't know
> what MIME Type the file is and so it doesn't know how to send it.
> If you are using PHP to upload and later show that image on the web, i
> could give you the code for the scripts and the structure of the table
> cont
Hi
Where to start
For a pure web system, I would recommend PHP. It is smaller, faster and
interfaces better with apache. This was its design goal.
For a non web system, it has to be PERL.
For a mixed system, I would again favour Perl, due to its flexibilty and
power.
I am currently work
Thanks neils!
i have gone thru what u referred long before, i know
that this "set" method is not fully supported in 3.23
version, thats why i posed this question, i wanted to
know whether there is any other way to do it.
when i make changes to my.cnf file i am able to do it
but it is not immed
Hi there,
This is my first message to this mailing list.
I just upgraded Mysql from 3.23.54 to 4.0.14. Everything were fine after the upgrade,
but I experienced something strange:
- When I telnet to the localhost, the response says 3.23.54 is running.
- However, when I do a mysqladmin -V, it sh
Hi Bennett
I had a similar problem on my system a while back. With my particular
case, the problem was the the default priv's on the new server for it's
users did NOT include INSERT rights.
Basically what I'm saying is: these are the reasons for a table to be
(or appear to be) read-only:
1) Table
Hello
It formats the output to ##,###,##.## . I dont want
the commas and also I dont know what maximum decimal
value is there in the table. It may be .001 or it
maybe .001 . I just want them in simple expanded
form.
karam
--- Roger Baklund <[EMAIL PROTECTED]> wrote:
> * Karam Chand
> > I ha
The most common problem in such cases is that the webserver doesn't know
what MIME Type the file is and so it doesn't know how to send it.
If you are using PHP to upload and later show that image on the web, i
could give you the code for the scripts and the structure of the table
containg the binar
Hi All
I have to run this to dump the database
mysqldump -u root -pPASS --opt database > database.tmp
Is there anyway I can hide the PASS is a file ? I was trying to put it in
/root/.my.cnf as this
[client]
password = PASS
That seems to be not working. I am not sure if mysqldump even reads tha
40 matches
Mail list logo
