Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
backup database forum
Avatar
roberto splendorini
Member
Free Members
sp_UserOfflineSmall Offline
Feb 5, 2015 - 5:31 pm

Hi Which table I must select for backup database forum?
Thanks 

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Feb 5, 2015 - 5:42 pm

Hey Roberto,

To backup the forum specifically you want to select all tables which begin sf.  For example:

wp_sfauths, wp_sfbuddies, wp_sfcache etc.. Although your prefix might differ from 'wp'.

Depending on what you're doing though, you need to remember that all users being WP users, are stored in the wp_usermeta table. Without this table, posts will no longer be linked to anybody, and could cause more problems..

Hope this helps!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 5, 2015 - 5:44 pm

Don't forget the 'users' table. It is 'users' AND 'usermeta'.

andy-signature.png
YELLOW
SWORDFISH
Avatar
roberto splendorini
Member
Free Members
sp_UserOfflineSmall Offline
Feb 5, 2015 - 5:57 pm

ok thank you

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 5, 2015 - 9:10 pm

glad we could help...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626