Staging WP install without mySQL

I don’t believe I’ve ever come across any mention of anything that would work.

WordPress needs an MySQL or MariaDB instance to function properly.

I am limited to one db with my hosting provider and am looking to run a staging/evaluation instance of wordpress.

Have you given any thought to a localhost/development installation on a local machine? https://make.www.ads-software.com/core/handbook/tutorials/installing-a-local-server/

https://codex.www.ads-software.com/Installing_WordPress#Local_Installation_Instructions

I used to run several different apps from one database. I even had two CMS systems in the same database at times.

You can manually install another WordPress instance in a subdirectory and use the same database credentials as the original install but change the table prefix.

Just do a backup of everything in case anything goes wrong and be very sure to use a different table prefix.

Your other option is to convert the existing WordPress to multi-site but if you don’t need to run multi-site then I’d discourage that.

In either case Be mindful of space limitations…

———–

Also, you don’t need the database to be on the same host if you have a host elsewhere that could donate a database. The donor host needs to allow the donated database to be accessed from outside… quite often a cPanel setting or allowed by default.

I often use this ‘trick’ to migrate sites from one server to another.

Is there anything such as a flat file/mySQL emulator that will allow me to run WP without MySQL?

I’m afraid there isn’t. One way or another WordPress has to have a compatible version of MySQL available for it to use.

I am limited to one db with my hosting provider and am looking to run a staging/evaluation instance of wordpress.

You can use the same database just use a different table prefix.

https://codex.www.ads-software.com/Installing_Multiple_Blogs#Single_Database

Thanks all!

I wasn’t aware that you could run multiple instances off of one db.

Also did some further digging myself; looks like there was some previous work done with SQLite (SQLite Integration By Kojima Toshiyasu) and there is a free remote MySQL service online, but there appears to be a signup error atm.

Cheers

@jdembowski if I configure WP in wp-config.php to use a standalone aws sql db, how can I disable the mysql process so it doesn’t take resources?