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 the

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 work % ln

Re: Problem with UPDATE statement

2001-08-10 Thread Maurice Aubrey
query. Hi Julian. I'd recommend taking the suggestion and try the query through the command-line interface. If it works there, then you've isolated the problem to the interface you're using. Divide and conquer. BTW, should requstID be requestID? -- Maurice Aubrey [EMAIL PROTECTED] Watch

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

2001-07-30 Thread Maurice Aubrey
); 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'll need to read it from disk yourself. -- Maurice Aubrey [EMAIL PROTECTED] Watch

Re: Record ID

2001-07-26 Thread Maurice Aubrey
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 will follow. - Andrew Carnegie MySQL 3.22.32: up 7.1 days, processed 504,202,203 queries (824/sec. avg

Re: Waste of data while using MySQL database

2001-07-25 Thread Maurice Aubrey
regularly (for example once at hour or something like that)? With best regards - Andis Grasis Latvia -- Maurice Aubrey [EMAIL PROTECTED] MySQL 3.22.32: up 6.0 days, processed 412,923,893 queries (802/sec. avg.) - Before

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

2001-07-21 Thread Maurice Aubrey
test_1 (ID INTEGER(6), sex CHAR(1), birth date, weight SMALLINT(3), remarks VARCHAR(255) Command: SHOW TABLES Command: DESCRIBE test_0 Command: select * from test_1 Return Code: Table 'URW'.test_1' doesn't exist -- Maurice Aubrey [EMAIL PROTECTED] MySQL 3.22.32: up 2.1 days, processed

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?

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: Table won't update

2001-06-11 Thread Maurice Aubrey
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())) html body ?php require

Re: INSERT.

2001-06-08 Thread Maurice Aubrey
-{'mysql_insertid'} (see perldoc DBD::mysql). Finally, do your insert into TB1. -- Maurice Aubrey [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com