Which file in the hierarchy stores cpg_comments table?

[overdrivechao05]

Thanks for reading! My fiancee had a bunch of pictures and comments using coppermine on a friends site, and the server had to be shut down. so the friend sent us the .tar.gz backup of the site. all she needs is the comment info per picture, and since i dont have a server ive been looking at files in wordpad and stuff trying to find where the comments are saved.
does anyone know if i can get that info without coppermine installed or an easy windows based emulator i can use just to view the gallery so she can get the comment info off?

Thanks a million!!

[Nibbler]

Comments are stored in the cpg_comments table in the database.

[overdrivechao05]

ok i went into dos and converted all the *.php to *htm so windows could see inside all the files to find cpg_comments... but to no avail. what is the name of the file and the assumed location of the same file that hold comment table info!? ^^

[overdrivechao05]

10/08/2005  11:51 PM    <DIR>          cp
10/08/2005  11:51 PM    <DIR>          cron
10/08/2005  11:51 PM    <DIR>          fp
10/08/2005  11:52 PM    <DIR>          homedir
10/08/2005  11:51 PM    <DIR>          httpfiles
10/08/2005  11:51 PM    <DIR>          interchange
10/08/2005  11:51 PM    <DIR>          logs
10/08/2005  11:51 PM    <DIR>          mm
10/08/2005  11:51 PM    <DIR>          mma
10/08/2005  11:51 PM    <DIR>          mysql
09/05/2005  06:51 PM             1,115 mysql.sql
09/05/2005  06:55 PM            17,349 nobodyfiles
09/05/2005  06:55 PM                 0 pds
09/03/2005  11:54 AM               251 proftpdpasswd
10/08/2005  11:51 PM    <DIR>          psql
09/05/2005  06:55 PM                 3 quota
10/08/2005  11:51 PM    <DIR>          resellerconfig
09/05/2005  06:55 PM                89 sds
09/05/2005  06:55 PM                34 shadow
09/05/2005  06:55 PM                29 shell
10/08/2005  11:52 PM    <DIR>          sslcerts
10/08/2005  11:52 PM    <DIR>          sslkeys
10/08/2005  11:51 PM    <DIR>          va
10/08/2005  11:51 PM    <DIR>          vad
10/08/2005  11:51 PM    <DIR>          vf
               9 File(s)         18,870 bytes
              19 Dir(s)  30,719,365,120 bytes free

THAT IS THE ROOT OF THE SITE .TAR I GOT SENT

and this is the public_html dir

10/08/2005  11:52 PM    <DIR>          .
10/08/2005  11:52 PM    <DIR>          ..
07/24/2004  04:33 AM             2,646 addfav.php
07/24/2004  04:33 AM             2,968 addpic.php
07/24/2004  04:33 AM             2,162 admin.php
07/24/2004  04:33 AM            15,666 albmgr.php
10/08/2005  11:52 PM    <DIR>          albums
07/24/2004  04:33 AM             1,590 anycontent.php
07/24/2004  04:33 AM            14,288 banning.php
10/08/2005  11:52 PM    <DIR>          bridge
07/24/2004  04:33 AM            17,133 calendar.php
07/24/2004  04:33 AM            18,179 catmgr.php
10/08/2005  11:52 PM    <DIR>          cgi-bin
07/24/2004  04:33 AM            17,553 config.php
07/24/2004  04:33 AM            13,910 db_ecard.php
07/30/2004  06:40 PM            19,366 db_input.php
07/24/2004  04:33 AM            16,040 delete.php
07/24/2004  04:33 AM             2,748 displayecard.php
07/24/2004  04:33 AM            29,908 displayimage.php
10/08/2005  11:52 PM    <DIR>          docs
07/27/2004  09:25 PM            10,360 ecard.php
08/03/2004  07:28 PM            15,237 editOnePic.php
08/15/2004  10:59 PM            23,404 editpics.php
08/19/2004  01:11 AM                27 fantversion.php
07/24/2004  04:33 AM             3,097 faq.php
07/30/2004  06:40 PM             4,973 forgot_passwd.php
07/24/2004  04:33 AM             2,516 getlang.php
07/24/2004  04:33 AM            12,842 groupmgr.php
10/08/2005  11:52 PM    <DIR>          images
07/24/2004  04:33 AM            41,557 image_processor.php
10/08/2005  11:52 PM    <DIR>          include
07/29/2004  09:18 PM            35,754 index.php
07/31/2004  08:16 PM            25,817 install.php
06/11/2004  12:36 AM             2,242 installer.css
10/08/2005  11:52 PM    <DIR>          lang
07/24/2004  04:33 AM             5,558 login.php
07/24/2004  04:33 AM             2,073 logout.php
07/24/2004  04:33 AM            16,443 modifyalb.php
07/24/2004  04:33 AM             2,578 phpinfo.php
07/24/2004  04:33 AM            30,440 picEditor.php
07/24/2004  04:33 AM            17,356 profile.php
07/24/2004  04:33 AM             4,240 ratepic.php
10/15/2003  01:35 AM                80 readme
10/08/2005  11:52 PM    <DIR>          README_FILES
07/30/2004  06:40 PM            11,140 register.php
07/24/2004  04:33 AM             6,477 reviewcom.php
10/23/2003  07:45 PM             2,715 scripts.js
07/24/2004  04:33 AM             2,519 search.php

where do i look to find the comment file table? or comments at all in any archived form?

^^ thx already

[Stramm]

I don't know where your mysql install saves it's data. Usually it's in the mysql folder. The data dir. Here find a folder matching your db name... eg. cpg135. Inside are a lot of *.frm, *.myd, *.myi files. The ones with *_comments.* hold the comments table. Best is to move the folder over to a working mox and place it there in the mysql data dir. Then use a tool like phpmyadmin to export the necessary data

[Nibbler]

Look in mysql.sql with your text editor, that's the most likely candidate.