On 2/22/07, Istvan Hubay Cebrian <[EMAIL PROTECTED]> wrote:
Hi everyone,
Say I have a DB named... well... "database1", this db has the following tables:
What I want to do is copy each of the tables (exactly as they are, including primary keys, data, etc) but at the same time change the prefix to something else (ie: eng_) so that I would end up with: Anyway of accomplishing this? Ideally without having to state each of the tables names. And also that this would work so that you could only duplicate tables that have a certain prefix, so: duplicate only tables that start with "pt_" and change prefix to "es_" for example.
a suggestion - could you replicate to another server and not worry about the prefix? or is having a different prefix a requirement (as opposed to a separate server or even database)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
