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).
