Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Which file in the hierarchy stores cpg_comments table?  (Read 3656 times)

0 Members and 1 Guest are viewing this topic.

overdrivechao05

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Which file in the hierarchy stores cpg_comments table?
« on: October 08, 2005, 08:27:29 pm »

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!!
« Last Edit: October 09, 2005, 09:58:04 am by overdrivechao05 »
Logged

Nibbler

  • Guest
Re: How do i get comment info?? Newb help pls ><
« Reply #1 on: October 08, 2005, 08:42:30 pm »

Comments are stored in the cpg_comments table in the database.
Logged

overdrivechao05

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: How do i get comment info?? Newb help pls ><
« Reply #2 on: October 09, 2005, 08:41:51 am »

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!? ^^
Logged

overdrivechao05

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: How do i get comment info?? Newb help pls ><
« Reply #3 on: October 09, 2005, 09:01:20 am »

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
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Which file in the hierarchy stores cpg_comments table?
« Reply #4 on: October 09, 2005, 12:46:47 pm »

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

  • Guest
Re: Which file in the hierarchy stores cpg_comments table?
« Reply #5 on: October 10, 2005, 01:03:04 am »

Look in mysql.sql with your text editor, that's the most likely candidate.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.