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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
