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 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 MARTIN
> Naval Electronics & Surveillance Systems
> ----------------------------------------
> PH: (856) 722-3182
> PAG: (888) 886-4956
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php