Best way to clone a site within the same SQL DB

I have been looking around all day at the many cool plugins, but I haven’t found one that does what I need. My situation is that I have a very nice WP install that I would like to copy, byte for byte, and once that is accomplished I will just drop all the pages and other content, but I want to preserve my plugins and their settings as this is a highly configured site.

I know the basic WP files are a simple cut and past job followed by a tweak or two in wp-config but due to limitations at my host, I need to install multiple sites in a common SQL database. There are a lot of tables from site1, all have been prefixed with “site1_” so I can’t just dump the tables and import them without changing that to “site2_”.

What is the simplest, cleanest, and safest way to get this done? The table dumps I have been using have an extension of “.sql” and I am afraid of doing a global replace in notepad or something like that since the site names will have differing lengths (i.e. not really called site1 and site2).