- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, March 22, 2007 3:40 PM
Subject: Re: comparing storing engines
Assuming you have a database, let's call it DAT1 which contain all MyIS
Assuming you have a database, let's call it DAT1 which contain all MyISAM
tables,
you could make a copy of an entire database to DAT2
On create DAT2 using
CREATE DATABASE DAT2;
Then copy all data from DAT1 to DAT2 like this.
mysqldump -h -u... -p... --triggers --routines DAT1 | mysql -h
-u...
