I’m trying to perform a very complicated migration from my staging server to a live server for a client.
Normally, I’d just use a plugin or just replace all the files using FTP, but in this situation, the client wants to keep their database (all of the users, and some other tables). Naturally, this presents a problem when using GeneratePress as all the page data is stored in the DB.
My questions is: How do I migrate a GeneratePress site without nuking the database?
A related question that would probably help me solve the problem is: is there a list of database tables that Generatepress needs to run? If I can just move those over, and leave the rest, I believe this will solve the problem.
Ah, things like Sections are stored in the postmeta table in your DB. Each post ID has associated postmeta, so there’s no way to extract only the GP stuff – you would need to extract the entire post (from the posts table) and the associated postmeta for that post.