From: Dan Nelson Date: January 14 2004 5:43am Subject: Re: why: mysqldump and mysqlimport? List-Archive: http://lists.mysql.com/mysql/157627 Message-Id: <20040114054323.GA46141@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii In the last episode (Jan 13), EP said: > I am wondering: > > I can see the MySQL data files for my various databases. > > What technically prevents me from simply copying those files and using > copies > - to move my database to another file structure or server > - to back-up my current db Absolutely nothing. As long as you ensure there are no active writes while you make the copy, this is the fastest way to back up a database. The mysqlhotcopy script automates the process. -- Dan Nelson dnelson@stripped