Re: database corruption ? how to fix ?

astien Pilon <[EMAIL 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,

database corruption ? how to fix ?

TABLES so i ran 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

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.

hen get a meaningful 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!

ow can I see the temp tables ? 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 ve

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! &g

mysql query and version problem .... Help!

FROM bids 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 Solu

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 > &

Re: problem with selecting my max bid ..

| 12 | 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: > >

problem with selecting my max bid ..

| | 3 | 13 | 7 | 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 [

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

ene.com/martijn/ > Database development questions? Check the forum! > http://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

rsive 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 Ma

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

Regex problem..

nt to remove the header include 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 Hosting Solu

Quotation marks in string causing repace to not work.

#x27; , ''); 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 Solutions Scalable Linux Solu

storing php pages with sql queries in a mysql database

from trying 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 M

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

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

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 [