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


Martijn Tonies wrote:
> 
> 
>> >> 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).
> 
> Well, except for having to change the metadata for each additional
> language.
> 
> Sounds very easy ;)
> 
> Wouldn't it be a nice start to use the script that creates these tables
> and
> do
> a search/replace on them? If you need this multiple times (for more
> languages)
> in the future, why not create a script that has absolutely no errors in
> replacing, eg: %LANG% that will be replaced by es_ or whatever, to avoid
> errors.
> 

The script I use to create the tables and insert the data already allows for
the use of a prefix. Meaning that I could create the exact same tables
inside the same database with different prefixes. This, however, is not
ideal since when I develop a website, I initially develop it fully in one
language, then I simply duplicate the database and change the text, this
method saves me allot of time since all texts, stylesheets, templates, etc,
etc are copied. 

If I where to use the script again and create the initial tables with a new
prefix, I would have to go through the whole process of developing the site
(obviously easier than initial devl. but still time consuming). Therefore I
figured the easiest way would be to simply duplicate the tables and change
the prefixes.

I am now thinking that probably the best way to accomplish this is through a
PHP script. In any case i'd like to thank you for your prompt replies, this
little brainstorming has definitely given me some ideas.

Thanks,
Istvan H Cebrian

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