Thank you On Thu, Apr 15, 2010 at 8:49 PM, Jorge Godoy <jgo...@gmail.com> wrote:
> create database db_1 template db_2; > > This will create a new DB_1 using DB_2 as template. Otherwise, you'll > change your code to connect to DB_2 instead of connecting to DB_1. > > -- > Jorge Godoy <jgo...@gmail.com> > > > > On Thu, Apr 15, 2010 at 14:49, akp geek <akpg...@gmail.com> wrote: > >> dear all - >> >> I am not supposed to ask this. But, the question is I have 2 >> databases DB_1 and DB_2. I have a script that loads few tables in DB_1. The >> 2 databases are identical. In case , if database DB_1 is dropped, Is there >> any command that I can issue to use the DB_2? >> >> >> Regards >> >> >
