Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
public-topic
Data importer, how does it work?
Avatar
Pixelloop
Guest
Guests
Oct 3, 2014 - 10:51 pm
sp_QuotePost Quote

You see I personally still think this would be useful or at least a guide on how to export the necessary data via phpmyadmin and how to then inject it into another database.

 

Take my scenario for instance. I have a live site and a staging site, now there are parts I need to keep seperate and most of the final work is on the staging site, now all I have left is to import the updated forum data that has changed since the clone of the live site was taken at the beginning of the development, so I just need to import all the data from the live forum to my staging forum and then once done I will push my staging site live and this means my staging site will completely overwrite my live site. 

 

Any advice for that?

 

Thanks in advance. 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 4, 2014 - 12:48 am
sp_QuotePost Quote

you can export any of the tables that have wp_sfxxxxx in the names....  your wp db prefix might be other than wp_ and of course, the xxxxx is the rest of the db name..

of course,  the wp users must remain constant as any forum posts will be tied to the wp users... as well as wp admin capabilities in the wp usermeta table... 

but if its just empty forum configuration, just grab the tables...

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