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!!
Comments are stored in the cpg_comments table in the database.
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!? ^^
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
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
Look in mysql.sql with your text editor, that's the most likely candidate.