PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro How Do I...?

Photopost Pro How Do I...? Wondering how to do things in PhotoPost?

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old June 13th, 2006, 09:59 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Dec 2001
Posts: 94
Database schema

I'm working on a site migration to a new data centre. Using mysqldump to move the databases. Over the years, I've migrated software a couple of times, so I have some tables in my database that are no longer used and I would like to get rid of them. Does someone have a quick list of tables owned by photopost? I'm using phpBB integration, but that's contained in another database.

Thanks.
taveren is offline   Reply With Quote
Old June 13th, 2006, 10:20 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,788
They would be the tables normally prefixed with pp_
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old June 13th, 2006, 10:28 AM   #3 (permalink)
Member
Verified Customer
 
Join Date: Dec 2001
Posts: 94
Quote:
Originally Posted by Chuck S
They would be the tables normally prefixed with pp_

Sadly, my predecessor opted to not use a prefix and to also combine all databases into one. I have since taken a different approach, but still have a mess to clean up.
taveren is offline   Reply With Quote
Old June 13th, 2006, 11:39 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,788
admingroups
admlog
cache
categories
comments
ecards
exif
extrafields
favorites
ipcache
iponline
laston
notify
perpage
photoextras
photos
photoviews
settings
sort
sortmemb
usergroups
users
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old June 13th, 2006, 03:13 PM   #5 (permalink)
Member
Verified Customer
 
Join Date: Dec 2001
Posts: 94
Thanks! Let's me dump 50 some tables and actually migrate data.
taveren is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use "forums" database or "photopost" database thephonemall Photopost Pro Installation & Upgrades 1 August 11th, 2005 03:18 PM
database garybrun Photopost Pro How Do I...? 2 May 25th, 2005 06:59 PM
Database error izan Classifieds Bug Reports 7 October 23rd, 2004 12:40 PM
User database name? nf71 Before You Buy 2 October 2nd, 2004 12:21 AM
Database Error... maikj Photopost Pro Installation & Upgrades 8 July 14th, 2004 04:01 PM


All times are GMT -5. The time now is 08:48 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0