Database schema

[taveren]

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.

[Chuck S]

They would be the tables normally prefixed with pp_

[taveren]

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.

[Chuck S]

admingroups
admlog
cache
categories
comments
ecards
exif
extrafields
favorites
ipcache
iponline
laston
notify
perpage
photoextras
photos
photoviews
settings
sort
sortmemb
usergroups
users

[taveren]

Thanks! Let's me dump 50 some tables and actually migrate data.