Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
tion 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:

Re: Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Michael Dykman
and change prefix to "es_" for example. Any help or point in the right direction will be much apreciated! Thanks, Istvan Cebrian -- View this message in context: http://www.nabble.com/Duplicating-contents-of-DB-within-same-DB-with-different-prefix-tf3272642.html#a9099573 Sent from th

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
h 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 acc

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Martijn Tonies
> >> 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 examp

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
ot 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
> MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Duplicating-contents-of-DB-within-same-DB-with-different-prefix-tf3272642.html#a9100674 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]

Re: Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Martijn Tonies
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 (exac

Re: Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Chris McKeever
On 2/22/07, Istvan Hubay Cebrian <[EMAIL PROTECTED]> wrote: Hi everyone, Say I have a DB named... well... "database1", this db has the following tables: 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 pr

Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
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 -- View this message in context: http://www.nabble.com/Duplicating-contents-of-DB-within-same-DB-with-different-prefix-tf