Re: MySQL

[Gavin Scott <support@pokerpages.com>]

On Thursday 07 December 2000 04:58, Dominic Blythe wrote:
> any MySQL tool for dumping/loading schema?
>
> my ability in SQL is low, so I use phpMyAdmin to set up databases.
> It's difficult then to replicate them. On other (non-free!) dbs I
> use you can dump out an sql file of the schema and then just run it
> on the next machine to build the database.
>
> pls copy reply to me - list to big to handle.
>
>
> ______________________________________________________________________
> Dominic Blythe
> Programmer
> BCP Ltd

mysqldump is what you want.  See 
http://www.mysql.com/documentation/mysql/bychapter/manual_Tools.html#mysqldump.

To replicate db1 on host1 to db2 on host2 you can do:
mysqldump --opt -hhost1 -uuser -ppassword db1 | mysql -hhost2 -uuser 
-ppassword db2

-- 
Gavin Scott
support@pokerpages.com