How to auto repair db on hosting with quota

I am asking this question as a hosting PROVIDER, not as a hosting client. The sitation is like this (this is a simple example with small numbers): 1) a client has 100mb quota for site and db files (set on unix group) 2) 80mb is already taken by 75MB database in ONE TABLE and 5mb of files 3)

Re: How to auto repair db on hosting with quota

Using Quota on Unix, you can specify a different quota soft_limit for temporary space. You can set MySQL to use /tmp as the temporary space, then set a soft_limit of 10mb and a hard_limit of 300MB. This quota should be separate from the normal user space quota. With MySQL temp dir set to /tmp,

Re: MySql on Leopard

The easiest way to get mysql working on os x is with a fink build. The version is a little behind 5.0.38, but I can't imagine there would be any problems with a source build from the latest. Maybe you could give it a go, and report any problems, then I'll happily help out. Simon Elliston

Re: How to auto repair db on hosting with quota

Steven Buehler wrote: -Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Friday, December 07, 2007 4:35 AM To: mysql@lists.mysql.com Subject: How to auto repair db on hosting with quota I am asking this question as a hosting PROVIDER, not as a hosting client. The

RE: How to auto repair db on hosting with quota

-Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Friday, December 07, 2007 4:35 AM To: mysql@lists.mysql.com Subject: How to auto repair db on hosting with quota I am asking this question as a hosting PROVIDER, not as a hosting client. The sitation is like

Re: How to auto repair db on hosting with quota

I see topposting i popular in this mail list :) Well, thank you for the idea. It seems to be workable. I hope that while data is being repaired and it is located in tmp the rights are set correctly so noone else can read the files. I'll see it myself. Thank you very much. Any idea on how to

HELP: How to duplicate rows...

Hi! I have a table with several rows, some of which I need to duplicate. The fields of table1 are field1, field2, field3 and field4. Field1 is automatically incremented, field2 will serve as a filter condition. Normally to duplicate the rows that matched a certain condition I would do: INSERT

Re: How to auto repair db on hosting with quota

Artem set my.cnf in unix my.ini in windows set max_connections max_connections=100 M-- - Original Message - From: Steven Buehler [EMAIL PROTECTED] To: 'Artem Kuchin' [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, December 07, 2007 8:11 AM Subject: RE: How to auto repair db on

Re: HELP: How to duplicate rows...

At 09:39 AM 12/7/2007, rfeio wrote: INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, field4 WHERE field2=x Have you tried: INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, ABCD WHERE field2=x Mike -- MySQL General Mailing List For list archives:

Re: How to auto repair db on hosting with quota

Those of us who view our mail in threads also post in threads. ;-) Here is some info for your concerns. We assume the client is going to run their database under their client unix-system username. You specify the temp directory in the my.cnf file. The documentation (when I last read it) says

Re: ERROR 126 (HY000): Incorrect key file for table

Hi All, We fixed the error by creating a composite index on (user_id,billing_run) On 12/5/07, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I am getting below error when i am updating a table ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_5dc3_0.MYI'; try to r epair it Its a

Re: How to auto repair db on hosting with quota

Regards, Baron Yes it is. Even worse, people love to convert a top-posted thread to bottom-posted and verse vice-a! I see topposting i popular in this mail list :) And now for the bottom-posting part of this reply... Any idea on how to limit connection per user? (so one user cannot abuse

Re: HELP: How to duplicate rows...

u want something like this INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, 'abcd' from table_name WHERE field2=x On 12/7/07, rfeio [EMAIL PROTECTED] wrote: Hi! I have a table with several rows, some of which I need to duplicate. The fields of table1 are field1,

Re: How to auto repair db on hosting with quota

Baron Schwartz wrote: Regards, Baron Yes it is. Even worse, people love to convert a top-posted thread to bottom-posted and verse vice-a! I see topposting i popular in this mail list :) And now for the bottom-posting part of this reply... Any idea on how to limit connection per user? (so

Re: HELP: How to duplicate rows...

I knew it had to be something REAL simple! :-) Thanks guys, that worked perfectly! Ananda Kumar wrote: u want something like this INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, 'abcd' from table_name WHERE field2=x On 12/7/07, rfeio [EMAIL PROTECTED]