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: <[EMAIL PROTECTED]> Sent: Monday, August 16, 2004 1:39 PM 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]