CiviCRM Community Forums (archive)

My hosting only provides one database pr domain. I want to create a test environment with wordpress and CiviCRM using the same database as the live wordpress and CiviCRM are in.
It went fine to have two installations of wordpress (the tables are then named wp_ and test_wp0_). Then I installed CiviCRM as a plugin on the test_wp. All the CiviCRM tables are named civicrm_, so far so good.
Has anyone tried to do a second installation on the same database? (I am just concerned that I might crash the whole thing)

Do you have other advise on how to create a testing environment with only one database?

To echo Lobo's response, I'm pretty sure it wouldn't be possible.  There is no where in the configuration of Civi where you can define the table prefix, so it will always be civicrm_

Unfortunately (or I guess fortunately for me) I have never had a host that said I could only have one database so I have been able to create development versions of sites without a problem.  Backups are always a good idea though, just make sure that if you are doing them via database export that you disable Foreign Key Checks (this is a setting in phpMyAdmin).  CiviCRM uses a lot of Foreign Keys in the database and if you don't disable them it can make reimporting difficult.