/usr/local/mysql> mysqldump -d database1 | mysql database2
> -----Original Message-----
> From: Srini Bhamidipaty [mailto:sbhamidi@stripped]
> Sent: Friday, April 09, 1999 11:22 AM
> To: mysql@stripped
> Subject: Creating a SQL script to generate tables.
>
>
> Hi,
>
> I have a scenario:
>
> I have created a database and also created tables in that database. I have
> created another database for testing purposes. I want to create tables in
> test database similar to that which are in my first database.
>
> Is it possible to create a SQL script on one editor and run that script to
> generate tables in the database.
> If this is possible I can save a lot of time in creating my test database.
>
> Please let me know if such feature is available in MYSQL.
>
> Thanks in advance
>
> Srini Bhamidipaty.
>
