Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
as to how my efforts seem to return me to the same problem time and time again. I look forward to any further suggestions you may have; JP On Thu, 15 Mar 2007, Brent Baisley wrote: You probably did not change the max_rows setting when you created the table. If you read the manual under

Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
Addendum; On Thu, 22 Mar 2007, JP Hindin wrote: Zero improvement. I used the following CREATE: MAX_ROWS=10; At first I thought I had spotted the obvious in the above - the MAX_ROWS I used is smaller than the Max_data_length that resulted, presumably MySQL being smarter than I am

Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
, mea culpa, mea maxima culpa. I slink to my corner with Google in hand and apologise for wasting your time. Here's hoping, of course, in four days I don't find out I'm wrong about the 4.2b rows part. - JP On Thu, 22 Mar 2007, JP Hindin wrote: Addendum; On Thu, 22 Mar 2007, JP Hindin wrote

Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
On 03/22/2007 01:02 PM, JP Hindin wrote: Addendum; On Thu, 22 Mar 2007, JP Hindin wrote: Zero improvement. I used the following CREATE: MAX_ROWS=10; At first I thought I had spotted the obvious in the above - the MAX_ROWS I used is smaller than the Max_data_length

max_rows query + SegFaulting at inopportune times

2007-03-15 Thread JP Hindin
going to release me from my hovering 4GB table limit? Has anyone seen this blasted SegFault issue before? I appreciate any help I can get with this one, I'm obviously missing something, flame away. Many thanks. - JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: max_rows query + SegFaulting at inopportune times

2007-03-15 Thread JP Hindin
On Thu, 15 Mar 2007, Michael Dykman wrote: What host OS are you running? And which file system? MySQL is always limited by the file size that the host file system can handle. Deb Sarge is a Linux distribution, the large file support I mentioned allows files up to 2 TB in size. On 3/15/07, JP

Invitación: Webinar MySQL 5.0 - Nuevas funcionalidades para la Empresa

2006-01-26 Thread JP Files
Amigos me llegó este mail, quiza les sea de ayuda. Jorge Paiva Lima - Peru MySQL 5.0 - Nuevas funcionalidades para la Empresa Miércoles 1 de Febrero de 2006 MySQL les invita a participar en el primer webinar en castellano para España y

oledb provider with transaction support?

2003-07-07 Thread jp
i downloaded oledb provider from mysql.com, i use Delphi's ADO. but i found that this oledb provider does not support transaction. is there any oledb provider that does support transaction? thanks

RE: having trouble killing mysqld to restart and change root

2002-02-11 Thread JP Audette
that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to. JP Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect

RE: having trouble killing mysqld to restart and change root

2002-02-11 Thread JP Audette
started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing

having trouble killing mysqld to restart and change root password

2002-02-06 Thread JP Audette
. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: having trouble killing mysqld to restart and change root pass word

2002-02-06 Thread JP Audette
started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing

RE: having trouble killing mysqld to restart and change root pass word

2002-02-06 Thread JP Audette
that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to. JP Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect

monitor will not start

2002-02-06 Thread JP Audette
that's not the problem (unless the monitor has different disk space needs than the tables). Are there any other reasons why the monitor won't start? I can't get mysqladmin to function properly either (same problem - hung cursor after entering the password). Thanks, JP

need developer to help transfer our site

2002-01-17 Thread JP Audette
for this project. The site is not very big, and our new host is already in place, so it should be mostly a matter of transferring files. If anyone on this list is interested in our meager project please reply to me directly at [EMAIL PROTECTED] Thanks, JP

Grant problems

2001-05-18 Thread jp
I have successfully installed MySQL 3.23.38. I can start the server and log in as root. When I try to grant new users using: grant insert to test.* for testuser identified by 'testpassword'; It comes back saying 0 rows affected. I can go the the MySQL db and look at the grant table and

Configuring PHP for MySQL

2001-05-17 Thread jp
Thanks for the responses. Unfortunately they didn't work. I tried /usr/local /usr/local/mysql /usr/lib /usr/lib/mysql /usr/var /usr/var/mysql and /usr/bin for the --with-mysql=/. command to configure PHP4. It still says Header files not found at ..Does anyone know what

Re: Configuring PHP for MySQL

2001-05-17 Thread jp
Sorry Jorge. I thought that the individuals on this list would be more qualified to answer a question regarding where a specific installation (3.23.38 RPM) of MySQL placed specific files ( header files? ) than would PHP users. Justin Pease On 17 May 2001, at 9:53, Jorge del Conde wrote:

Re: Configuring PHP for MySQL

2001-05-17 Thread jp
. Like I said I'm a newbie. JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED