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

[Darren Cook <darren@example.com>]

> datadir        = /var/lib/mysql
> 
> With:
> 
> datadir        = /home/dave/Dropbox/MySQL

Does:
 du -s /home/dave/Dropbox/MySQL

Give the same sizes (at least roughly) as
 du -s /var/lib/mysql

If so, my guess would be that the "mysql" user cannot see the files
under your home directory. Add mysql to the dave group and make sure
/home/dave/ /home/dave/Dropbox/ and /home/dave/Dropbox/MySQL are all
group read-writable.

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)