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 [EMAIL PROTECTED]
