Re: [linux-lvm] System Suggestions

2002-03-06 Thread Maurice Aubrey
On Wed, Mar 06, 2002 at 07:40:09PM -0800, Petro wrote: [snip] > We have 10 of the 3ware cards, and while the drive is GPLd and in > the kernel, we have not been satisfied with the stability of the > system What were the stability problems? > We haven't had a chance yet to qual t

Re: How to add mysql to my startup

2001-09-25 Thread Maurice Aubrey
On Tue, Sep 25, 2001 at 01:16:05AM -0700, Rodney Broom wrote: > From: Bertrand TACHAGO <[EMAIL PROTECTED]> > > > > % cp /usr/local/mysql/support-files/mysql.server \ > > > /etc/rc.d/init.d/mysql.server > > > % chmod 544 /etc/rc.d/init.d/mysql.server > > > > I had done it but it doesn't w

Re: Problem with UPDATE statement

2001-08-09 Thread Maurice Aubrey
10708 where requstID = 2' at line 1 > >> I can't see any reason for the error. > > > >Your web based interface is mangling your query. Hi Julian. I'd recommend taking the suggestion and try the query through the command-line interface. If it works there

Re: Antwort: Re: howto insert an image as blob?

2001-07-30 Thread Maurice Aubrey
;c: > \temp\testpicture.gif"); > > picturename is defined as char(50) - picturedatea is defined as blob No, you're just inserting the string "c:\temp\testpicture.gif" into the blob column. MySQL won't go out to the disk and fetch the image for you. You'

Re: Record ID

2001-07-26 Thread Maurice Aubrey
ed > "AUTO_INCREMENT problem in table" Huh? You had a problem with an auto_increment column because you mistakenly inserted too large a value. As long as you're careful not to do that, it works fine. -- Maurice Aubrey <[EMAIL PROTECTED]> "Watch the costs and the profits wil

Re: Waste of data while using MySQL database

2001-07-25 Thread Maurice Aubrey
c immediatly, but after some time. > > What can I do for saving data regularly (for example once at hour or something like >that)? > > > With best regards - > > Andis Grasis > > Latvia -- Maurice Aubrey <[

Re: How to create table in msql DB through cgi script

2001-07-21 Thread Maurice Aubrey
---- > > Returned message in Netscape > > Attempting to connect to the database... > Successful connection to database: DBI:mysql:URW > Command: CREATE TABLE test_0 (ID INTEGER(6), name VARCHAR(20), address1 > VARCHAR(40), address2

Re: transactions support in mysql

2001-07-18 Thread Maurice Aubrey
The various table types are discussed here: http://www.mysql.com/doc/T/a/Table_types.html Maurice On Wed, Jul 18, 2001 at 02:12:37PM +0530, Chandrashekhar wrote: > Thanks for your prompt reply. > I would like to know which version of mysql does supports transactions. and > is it stable? > T

Re: Table won't update

2001-06-11 Thread Maurice Aubrey
. Verify again that the update worked. Finally, one by one, add the variables back in. Maurice Aubrey On Mon, Jun 11, 2001 at 05:39:43PM -0700, Vladimir Kravtsov wrote: > The table sitesats won't update and shows no errors! (even though there > are two instances of echo(mysql_error(

Re: query to display per page

2001-06-11 Thread Maurice Aubrey
Hi Sommai. On Mon, Jun 11, 2001 at 04:52:01PM +0700, Sommai Fongnamthip wrote: > Dear, > I am preparing my web page to display search result. How could I use SQL > command to handle display specific row per page and next button at the > bottom page (like most search engine display result

Re: INSERT.

2001-06-08 Thread Maurice Aubrey
value of ID_tb2. If you're using the perl DBI, I believe it's in $sth->{'mysql_insertid'} (see perldoc DBD::mysql). Finally, do your insert into TB1. -- Maurice Aubrey <[EMAIL PROTECTED]> ---