Link to home
Start Free TrialLog in
Avatar of thirsty4knowledge
thirsty4knowledge

asked on

Problem copying database

Afternoon, I am trying to copy a database to the same server and simply rename it.  I am trying to create a testing enviornment.  My credentials are not working with the wizard so that not an option.  I created a new database and imported to the newly created db but when i update db using a web app it updates the originating db not the newly created (testing db).  I've updated all refrences to the previous db.  So im not sure what I need to update to update the testing db and not production db or a better way of copying the production db.  
Avatar of gheist
gheist
Flag of Belgium image

What is your database? MySQL or PostgreSQL?
What SQL statement you used to copy database?
ASKER CERTIFIED SOLUTION
Avatar of thirsty4knowledge
thirsty4knowledge

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial