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


Martijn Tonies wrote:
> 
> Hi,
> 
>> 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!
> 
> It seems you're trying to create something multi-lingual, would that
> be correct?
> 
> If so, why not design proper metadata so you don't have to copy
> tables AND modify your queries.
> 
---

Correct this is for a multilingual website using an extremely simplified
"CMS". 

The reason I am not designing proper metadata is due to the fact I am using
a CMS not programmed by myself, therefore I would rather not have to alter
its inner core, also, i gathered this would probably be the simplest way of
accomplishing what I want without having to use a db for each language
(which is what I am doing right now).




-- 
View this message in context:
http://www.nabble.com/Duplicating-contents-of-DB-within-same-DB-with-different-prefix-tf3272642.html#a9100707
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