Hi Jay,
Is this command
/usr/local/mysql> mysqldump -d database1 | mysql database2
to be executed at shell prompt
I tried at shell prompt and the error is given below:
[sbhamidi@darkness /]$ /usr/local/mysql> mysqldump -d test1 | mysql data1
bash: mysqldump: Permission denied
bash: mysql: command not found
[sbhamidi@darkness /]$
Please explain me .
Thanks.
Srini.
-----Original Message-----
From: Jay Miller [mailto:jaymiller@stripped]
Sent: Friday, April 09, 1999 11:24 AM
To: mysql@stripped
Subject: RE: Creating a SQL script to generate tables.
/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.
>
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread1597@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
