Duplication Question

2001-02-15 Thread Joe Ferrara
I want to make an exact duplicate (differenet name) of my entire DB for test purposes. My DB is not too large 8 tables, about max 200 records in any table. What is the best way to do this? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED

Re: Duplication Question

2001-02-15 Thread Peter Skipworth
mysqladmin create newdatabasename mysqldump olddatabasename | mysql newdatabasename Of course you'll need the usual username/password parameters as well. On Thu, 15 Feb 2001, Joe Ferrara wrote: I want to make an exact duplicate (differenet name) of my entire DB for test purposes. My DB