Duplicate and Re-prefix Tables in a MySQL Database with PHPMyAdmin
Posted on 2008-09-30
Hello, I have a (hopefully) simple but very specific question regarding database management.
I have a single MySQL database containing all of the relevant tables for a live Joomla installation.
I want to make another joomla installation using the same table data but with a different prefix so, using PHPMyAdmin, I want to duplicate the existing tables but I want the newly created duplicates to have a new prefix.
Let's say that there are currently 50+ tables (rows?? tables??) called things like:
I want to make exact copies of all tables prefixed with joom_ but I want all of the duplicates to be prefixed joom2_ so that you end up with
Is this possible with PHPMyAdmin?
How (exactly please) would I go about this?