Recover deleted records

2002-12-18 Thread Alexis Antonakis
Hi, I posted this a few days ago, but haven't seen a reply as yet, and I'm getting quite desperate now!! I've managed to delete all the records in a table, well haven't we all done it sometime!, and was wondering whether it's possible to recover them. I notice that the .MYD and .MYI files still

Recover deleted records

2002-12-15 Thread Alexis Antonakis
Hi, I've managed to delete all the records in a table, well haven't we all done it sometime!, and was wondering whether it's possible to recover them. I notice that the .MYD and .MYI files still appear to be showing the original data. Thanks Alexis SQL

RE: storing PDF files in mysql ?????

2002-10-09 Thread Alexis Antonakis
Hi, The thing I was wondering is whether there is any advantage in saving IMAGES in a database? I have had a little play around with a 50k jpeg file and it appears that if I save it in Blob format, then the filesize of the database increases by 50K as well, and surely converting it from/to a data

Obtaining a count of the First and Last values

2002-09-27 Thread Alexis Antonakis
Hi, I have a table used for generating stats (In fact it is phpTracker) What I am trying to do is to generate the 1st page visited and the last paged visited, per session, but grouped together. i.e. request_timeSession referer_uri 21/09/2002 12:51:08

Obtaining a count of the First and Last values

2002-09-27 Thread Alexis Antonakis
Hi, I have a table used for generating stats (In fact it is phpTracker) What I am trying to do is to generate the 1st page visited and the last paged visited, per session, but grouped together. i.e. request_timeSession referer_uri 21/09/2002 12:51:08