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 mysql or mysqlimport these will be rebuilt on the fly. Also, since it is a text file, you can compress it even further with TAR to very high efficiency. This would be the optimal way to do the job if you plan to use some bandwidth dependent transfer. It is likely that the dump file will fit on a CD. The other advantage this method is simplicity. Dump one file, move the file, run the file and you are done, regardless of your storage engine. If speed is of utmost concern, then consider following (closely) the directions for making binary copies. These directions and requirements are different per storage engine, so closely consult the documentation. (Note the repetition of "closely"). Given the size of your DB it should fit on a DVD if you have a burner available, otherwise you can likely rig a USB or Firewire drive to do the trick. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -----Original Message----- From: Edd Dawson [mailto:[EMAIL PROTECTED] Sent: Monday, August 16, 2004 4:39 AM To: [EMAIL PROTECTED] Subject: Database export I have a 4GB database which i need to move to another hosting company. The source and destination databases are mysql so there is no conversion issue. My question is has anyone any recomendations on which is the best method for doing this. I am aware of doing a database dump and then importing into the new server. But i want to know if there are any issues with the file size. i.e. will carrying out an import time out with the file size being so large. I have also come across mysqlhotcopy, will this do? Any thoughts on this will be much appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
