How to copy the files of a database to another?

[JoshLewis]

When using simple scripts I accedently over write a fresh joomla installation over my original, which worried me. I looked into my sql and found the database still there, and as well as the content inside of that. But because I reinstalled joomla over my site, it has it under database 32 when my site files are in database 07. Is it possible to delete the files in database 32 and paste in the data from database 07? (The numbers are the database numbers) Perhaps is this possible through the web server? Any help would be greatly apprecaited!

[wysiwyg]

You just need to point your installation at the database you want (I'm not sure if you mean those are table prefixes in the same database or separate databases, I'm assuming it's a separate database if you used simple scripts).

Whatever script you're using, in this case Joomla, stores the connection information in a configuration file. Joomla's configuration file happens to be called configuration.php.

Just open the file up and edit the relevant settings.

[dataman]

Additionally, you can do an extraction of the database via phpMyAdmin (found in your C-Panel). Joomla also has a number of extensions that support doing backups of databases within the Joomla Administrative area. Checkout the Joomla extensions for more details.

DataMan