database corruption ? how to fix ?

mysqlcheck --all-databases --auto-repair -ucojjohealth -p and now i get the following error: File '../diaendomet/users.MYD' not found (Errcode: 2) what do i do next ? many thanks -- Gregory Machin [EMAIL PROTECTED] www.linuxpro.co.za -- MySQL General Mailing List For list archives: http

Re: database corruption ? how to fix ?

PROTECTED] wrote: - Stop you mysql server - change working directory to $MYSQL_DATA_DIR - run myisamchck with */*.MYD This will run a check on all your table files -Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 8:41 AM To: mysql

stored procedures and regex

Hi Can mysql's stored procedures do regex function -- Gregory Machin [EMAIL PROTECTED] www.linuxpro.co.za

mysql-workbench - not working on fc 5.

backtrace from your debugger if you break on the gdk_x_error() function.) -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za www.exponent.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support and admin) +27 72 524 8096

Re: mysql query and version problem .... Help!

, Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version problem Help! Hi. I have just found out that my hosting provider is using mysql 4

mysql query and version problem .... Help!

b2 WHERE b1.auto_id = b2.auto_id) AND auto_dealer_id = '3' AND Bid_Status = '1'; How do I get this to work on version 4 ? Many thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za www.exponent.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support

Re: mysql query and version problem .... Help!

On 3/21/06, Addison, Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version problem Help! Hi. I have just found out that my hosting provider

Re: problem with selecting my max bid ..

Thanks for the further input, It works perfectly ... If you wouldn't mind please explain, the use of the b1 and b2 are they intended as varaibles .. On 3/17/06, Michael Stassen [EMAIL PROTECTED] wrote: Gregory Machin wrote: Ok I tried the following SELECT dealer_id, auto_id, bid_amount

Re: problem with selecting my max bid ..

| 9 | +---+-++ 1 row in set (0.00 sec) wich is the max bid overall, what I want is the max bid for each auto_id ... How would I go about this ? On 3/17/06, Michael Stassen [EMAIL PROTECTED] wrote: Gregory Machin wrote: Hi. I have the following table

problem with selecting my max bid ..

| 6 | +---+-+++ But this output is wrong because if you refer to the soucrce table above the dealer_id should be 24 in both cases.. What have I missed ? Many Thanks Gregory Machin -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED

mysql workbench and download?

Hi where can I download mysql workbench ? The links on the mysql forum dont work ... and i cant seem to find another download ... probably not see the wood for the treats .. Thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za www.exponent.co.za Web Hosting Solutions

time stapstamp problem, when updating records.

Hi I have a problem I need to create recordes with a time stamp that is not updated when the record is updated. Is this posible or will I have to manualy create the timestamp using php and insert it when the record is created ? Thank you for your time. -- Gregory Machin [EMAIL PROTECTED] [EMAIL

Re: selecting records newer than say 20 min

://www.databasedevelopmentforum.com -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za www.exponent.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support and admin) +27 72 524 8096

installing mysql in a chroot jail.

(using different ports). But I havnt a clue how to create a chroot and install mysql into it ... Any idea how I would go about this ? -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za www.exponent.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support

Help need search database

search, through all the table's in a database .. Many Thanks .. -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support and admin) www.goeducation (support and admin) +27 72 524 8096 -- MySQL General Mailing List

search in all tables in the data base ..

Hi all. Please could you advise. I would like to know if one could do a recursive search through a data base and get a result of wich column and field is holding the string ? Many Thanks . -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting Solutions Scalable

Quotation marks in string causing repace to not work.

($_SERVER['DOCUMENT_ROOT']./scripts/define_access.php);?' , ''); but it didn't work, i think thing problem is that the string i need to replace / null has quotation marks .. how can i work around this Many Thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting

Regex problem..

to remove the header include ?php require(./include/header1);? i tried \?php[^][header1].*\? , and other attempts but no luck .. unfortunetly i can do a normal string replace because of varations,in the code ... Many Thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web

storing php pages with sql queries in a mysql database

to interperate this data and blindly store it ?? Many Thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support and admin) www.goeducation (support and admin) +27 72 524 8096 -- MySQL General Mailing List

Re search and replace in large text fields

do I 1 import all the pages in one directory into the column. 2 how do i do a search and replace the tags with the new correct ones ? Many thanks ... -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support

Saving a whole txt file in a database

Hi all How does one save a whole txt file in a largetext column ? Ihave found l lots on delimited filesbut non on saving a whole text file . Many thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info

need deb for msyslog ..

Hi all. Has anyone got a deb for woody for msyslog . I have looked on www.apt-get.org but didn't come up with anything .. Or if anyone could sugest an opensource replacement for syslogd that logs to mysql that is better then that would be grate .. Many thanks Gregory Machin 072 5248 096 [EMAIL