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 appear to be showing the original data.

Thanks
Alexis


SQL




-
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]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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


-
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]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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 database just add time to the
loading of a page, albeit it very minimal, but as I am designing a site
which will host huge numbers of photos, this will make a big difference.

Any thoughts or advice on this topic will be most appreciated.

Regards
Alexis

-Original Message-
From: kayamboo [mailto:[EMAIL PROTECTED]]
Sent: 09 October 2002 01:20
To: toby z
Cc: list mysql
Subject: Re: storing PDF files in mysql ?


I think if you decide to store in the blob,
whatever it is, a pdf or jpeg or bmp, it is going to be in binary format.
While you need to display it back, just convert them back to whatever format
you like.

Else there is always the choice of just storing the path in your database.

By the way, which language you are using to write your applications.
If it is delphi, I can send you some sample code


regards

- Original Message -
From: "toby z" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 1:14 AM
Subject: Re: storing PDF files in mysql ?


 thnx rich

 but u see the problem iz my clients want their text IN pdf format to be

 displayed with all these colors on the page in other  words they want

 their sites layout to be maintained on the pages showing this pdf text

 as they are pretty concerned bout security


 so what do i do now 


 thnx a mill

 toby



 From: "R.Dobson" [EMAIL PROTECTED]
 To: toby gibbson [EMAIL PROTECTED]
 CC: [EMAIL PROTECTED]
 Subject: Re: storing PDF files in mysql ?
 Date: Tue, 08 Oct 2002 16:35:56 +0100
 
 
 hi,
 2 ways to do this:
 
 a) don't store the file actually in the db but store the path to it.
 
 b)use the function LOAD_FILE(filename) to get the contents of a file as a
 string value and store as a blob.
 
 decide which to use depending on how many pics you have
 
 cheers
 Rich
 
 toby gibbson wrote:
 
 ok guyz more trouble
 
 now im supposed to convert all the text (from ms word) to PDF and put
the
 pdf files in mysql db
 
 now i ve really got myslf stuck havent i
 
 can anyone plz hlp 
 
 thnx a million
 
 stuck az usual
 
 toby .
 
 
 
 _
 Chat with friends online, try MSN Messenger: http://messenger.msn.com
 
 
 -
 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]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
 
 --
 
 Richard Dobson
 Database Administrator
 MRC Bright Study
 Clinical Pharmacolgy
 St Bartholomew's and the Royal London
 School of Medicine and Dentistry
 Charterhouse Square
 London EC1M 6BQ
 Tel: 020-7882-5670
 Mob: 07711-522926
 Fax: 020-7882-5672
 [EMAIL PROTECTED]




 _
 Send and receive Hotmail on your mobile device: http://mobile.msn.com


 -
 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]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php
21/09/2002 12:51:51 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?search=1
21/09/2002 12:51:58 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?view=1
21/09/2002 12:52:28 7cf95b3162dac3b1ac6049b784f9c0f2
/bid/index.php?displayid=81

this would produce:
First Page  Count
/bid/index.php  1
Last Page
/bid/index.php?displayid=81 1

Now for multiple sessions

request_timeSession referer_uri
21/09/2002 12:51:08 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php
21/09/2002 12:51:51 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?search=1
21/09/2002 12:51:58 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?view=1
21/09/2002 12:52:28 7cf95b3162dac3b1ac6049b784f9c0f2
/bid/index.php?displayid=81
21/09/2002 17:24:19 cb0b6d40a0c9004ebbbf9312ca13ecc1/bid/index.php
21/09/2002 17:24:50 cb0b6d40a0c9004ebbbf9312ca13ecc1/bid/index.php?view=1
21/09/2002 17:25:10 cb0b6d40a0c9004ebbbf9312ca13ecc1/bid/index.php?view=1
21/09/2002 17:25:38 cb0b6d40a0c9004ebbbf9312ca13ecc1
/bid/index.php?displayid=1

this would produce:
First Page  Count
/bid/index.php  2
Last Page
/bid/index.php?displayid=81 1
/bid/index.php?displayid=1  1

To add to this, some of the referrers have extra criteria which I want to
ignore
i.e.
if the value of the referer_uri field is:
/bid/index.php?displayid=1nextpage=2, I want to ignore everything after,
and including, the '' symbol.

I can do this using PHP, but I was wondering whether there is a way of doing
some or all of the above in a MySQL Query?
The main place where I fall down is when trying to COUNT upon the SUM of a
set of values, especially when trying to GROUP BY it.

MTIA
Alexis


-
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]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php
21/09/2002 12:51:51 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?search=1
21/09/2002 12:51:58 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?view=1
21/09/2002 12:52:28 7cf95b3162dac3b1ac6049b784f9c0f2
/bid/index.php?displayid=81

this would produce:
First Page  Count
/bid/index.php  1
Last Page
/bid/index.php?displayid=81 1

Now for multiple sessions

request_timeSession referer_uri
21/09/2002 12:51:08 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php
21/09/2002 12:51:51 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?search=1
21/09/2002 12:51:58 7cf95b3162dac3b1ac6049b784f9c0f2/bid/index.php?view=1
21/09/2002 12:52:28 7cf95b3162dac3b1ac6049b784f9c0f2
/bid/index.php?displayid=81
21/09/2002 17:24:19 cb0b6d40a0c9004ebbbf9312ca13ecc1/bid/index.php
21/09/2002 17:24:50 cb0b6d40a0c9004ebbbf9312ca13ecc1/bid/index.php?view=1
21/09/2002 17:25:10 cb0b6d40a0c9004ebbbf9312ca13ecc1/bid/index.php?view=1
21/09/2002 17:25:38 cb0b6d40a0c9004ebbbf9312ca13ecc1
/bid/index.php?displayid=1

this would produce:
First Page  Count
/bid/index.php  2
Last Page
/bid/index.php?displayid=81 1
/bid/index.php?displayid=1  1

To add to this, some of the referrers have extra criteria which I want to
ignore
i.e.
if the value of the referer_uri field is:
/bid/index.php?displayid=1nextpage=2, I want to ignore everything after,
and including, the '' symbol.

I can do this using PHP, but I was wondering whether there is a way of doing
some or all of the above in a MySQL Query?
The main place where I fall down is when trying to COUNT upon the SUM of a
set of values, especially when trying to GROUP BY it.

MTIA
Alexis


-
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]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php