mysqlhotcopy Backup Problem
I'm having a problem with the mysqlhotcopy script.
Code:
$ /usr/bin/mysqlhotcopy --user=root --password=pass --socket=/path/to/mysqld.sock db1 /root/backups/db-backup/ It seems that mysqlhotcopy is failing to copy the files over out of /var/lib/mysql/db1/ ? Has anyone else ever had this problem? Thanks for your time. |
Hello Schiz0
if a normal database dump is also good for you... i am using this to backup mysql DB's export database Code:
mysqldump -u root -p DB-NAME > /path/to/backup/filename Code:
mysql -u root -p DB_NAME < BACKUP_FILE_NAME bugtracker (MANTIS) DB's and mediawiki DB's Yaniv |
Well the reason I'm using mysqlhotcopy INSTEAD of mysqldump is because my database is way too big. mysqldump takes over an hour to run everything, while mysqlhotcopy is extremely quick (because it copies the raw files on the filesystem).
|
All times are GMT -5. The time now is 08:00 PM. |