one Database, 25 sites, different content

Hi everyone!

I’ve been building in WordPress for a while now and I’m fairly comfortable but am in no ways an expert.

I’ve got 25+ websites that are all currently on my dev server using their own subdomains (e.g. xyz1.devserver.com, xyz2.devserver.com, etc.). Currently they are all setup within their own cPanel and have their own databases. However, when I was discussing with the client about moving to their dev site, they threw a curve ball at me. They want to only use one database and just have different table prefixes for each site. Note that these sites have slightly different themes and different content.

Is there a step by step guide on how to migrate multiple WP installs from separate databases to new server utilizing one database? I’m afraid I’m a little out of my depth on this one.

Thanks in advance!