Edd:
The best way is likely dependent on some factors that involve your storage
engine(s) (e.g. MyISAM, Innodb, etc) and the nature of the media you plan
to use to move the file created.
The smallest file you can produce is via mysqldump. Your 4GB db includes
all of your indexes. When using my
I used to check, optimize and repair tables, tar the database directory and
copy it simply. :) For me this is the simpliest way.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
- Original Message -
From: "Edd Dawson" <[EMAIL PROTECTED]>
To