<div>
Both answers were correct but the basis of my problem wa that the phpmyadmin program i was using to copy to database was not making a good copy. After getting a good copy of the database and applying the information above my problem was solved.
</div>


<div>
<div class="content wysiwyg-content">
I have copied the production site to a folder called test.prod.com. I have made a bckup of the prod data base in phpmyadmin and restored it to a data base called prodtest.I have edited the settings.php file to point to the new data base and foint to the site test.prod .com.<br />
<br />
Without running the install.php file I get error &nbsp;table XXXXprodtest does not exist in the database. several of these errors.<br />
<br />
If i run the install PHP file I do not get the original web site to use for testing.<br />
<br />
How do I create the test site from the original production site?
</div>
</div>


I have copied the production site to a folder called test.prod.com. I have made a bckup of the prod data base in phpmyadmin and restored it to a data base called prodtest.I have edited the settings.php file to point to the new data base and foint to the site test.prod .com.

Without running the install.php file I get error  table XXXXprodtest does not exist in the database. several of these errors.

If i run the install PHP file I do not get the original web site to use for testing.

How do I create the test site from the original production site?

Drupal multi sit setup fails when changing database name, using mysql and apache2.2 on a windows install.

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.

Apache Web Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.