Mailing List Archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

>> 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 Cook, Software Researcher/Developer  (Shodan Go Bet - who will win?) (About me and my work) (My blogs and articles)

Home | Main Index | Thread Index

Home Page Mailing List Linux and Japan TLUG Members Links