I am going to update site to a new custom theme and it will take a few days to get all the work done. Can I duplicate a wp database in phpMYadmin, so i have wp-db1 and wp-db2. Then I can change wp-config to use db2 while i am updating the site theme but when I run out of time for the day, i can change wp-config to use the original db1 and switch back and forth between the two. Is that possible or just a pipe dream on my end? All theme settings are saved in the DB so why wouldn't it work?
I am going to update site to a new custom theme and it will take a few days to get all the work done. Can I duplicate a wp database in phpMYadmin, so i have wp-db1 and wp-db2. Then I can change wp-config to use db2 while i am updating the site theme but when I run out of time for the day, i can change wp-config to use the original db1 and switch back and forth between the two. Is that possible or just a pipe dream on my end? All theme settings are saved in the DB so why wouldn't it work?
Share Improve this question asked Oct 18, 2018 at 16:55 Joe BarrettJoe Barrett 236 bronze badges1 Answer
Reset to default 0That will work - as long as you're the only user. If other users have access to the site you'd also have to port over their work to the other database. If that's the case, you may want to copy your entire website to a staging site, make the changes there, and once changes are complete push everything (database and files, assuming files are also necessary) to the live site.