List:General Discussion« Previous MessageNext Message »
From:Istvan Hubay Cebrian Date:February 22 2007 6:07pm
Subject:Re: [Fwd: search issue] Duplicating contents of DB within same DB
with different prefix
View as plain text  


Istvan Hubay Cebrian wrote:
> 
> Hi everyone,
> 
> I revert to this mailing list to ask for help accomplishing a specific
> task. I'll try to explain as best I can.
> 
> Say I have a DB named... well... "database1", this db has the following
> tables:
> 
> pt_table1
> pt_table2
> pt_table3
> 
> 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:
> 
> pt_table1
> pt_table2
> pt_table3
> en_table1 (exact copy of pt_table1, including data PK, FK, etc..)
> en_table2 (exact copy of pt_table2, including data PK, FK, etc..)
> en_table3 (exact copy of pt_table3, including data PK, FK, etc..)
> 
> 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.
> 
> Any help or point in the right direction will be much apreciated!
> 
> Thanks,
> Istvan Cebrian
> 
> 


Well, i've managed. Ended up creating a little PHP script that takes care of
it. Don't know why I didnt think of this from the beginning. Anyway, thanks
Martijn & Chris.


-- 
View this message in context:
http://www.nabble.com/Duplicating-contents-of-DB-within-same-DB-with-different-prefix-tf3272642.html#a9105157
Sent from the MySQL - General mailing list archive at Nabble.com.

Thread
Duplicating contents of DB within same DB with different prefixIstvan Hubay Cebrian22 Feb
  • Re: Duplicating contents of DB within same DB with different prefixChris McKeever22 Feb
    • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb
  • Re: Duplicating contents of DB within same DB with different prefixMartijn Tonies22 Feb
    • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb
  • Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefixMartijn Tonies22 Feb
    • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb
  • Re: Duplicating contents of DB within same DB with different prefixMichael Dykman22 Feb
  • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb