Re: [tlug] Empty databases after moving MySQL data files

[Darren Cook <darren@example.com>]

>> In order to have consistent backups, I wanted to move all my MySQL data
>> from it's default directory to my home directory (which I keep on a
>> separate partition and backup regularly). ...

> $ mysqldump -u root [Name_of_Database] > backup.sql

This is a good point. Alternatively, while you can backup the files
directly, you must make sure mysqld is stopped before running your
backup process.

Darren

-- 
Darren Cook, Software Researcher/Developer

http://dcook.org/gobet/  (Shodan Go Bet - who will win?)
http://dcook.org/work/ (About me and my work)
http://dcook.org/blogs.html (My blogs and articles)