Good day to all,

Heare iam taking mysqldump backup in my server and i can any one help me how to take mysql physical backup and is copying /var/lib/mysql a good alterntive to mysqldump?


Thanks,

Copy the resulting mysqldump files to another filesystem / another server / rsync to a cloud / copy to usb / ftp them home.

Only if you shutdown the MySQL server daemon while you do the copy, and even then my preference would be to use mysqldump.

There are at least two other recent threads on mysql backup:
http://www.linuxquestions.org/questi...command-934730
http://www.linuxquestions.org/questi...sqldump-914773

Hi,

I have stopped mysql service and i have taken backup /var/lib/mysql using tar and in another server i have installed mysql and i replcaed the backup to /var/lib/mysql and i started mysql service and i was not able to access the database,can u please assist me


Thanks,

Like he said, stick to mysqldump unless you are an advanced mysql dba

Hi !

I know how to take mysqldump backup and i like to learn how to take physical backup in mysql as i mention above.can any one assist me.

Thanks,

mysqldump or realtime replication and mysqldump are the best and most reliable methods of backup up databases, especially if they have multiple or mixed table engines such as innodb/myisam/memory. These are the prefered methods of backup up MySQL databases.

IF you have a database where you KNOW that the only storage engine is MyISAM then with shutting down the whole MySQL server process and copying the relevant folder then you can take the kind of backup you need.

If you simply shut down and copy the whole /var/lib/mysql "tree" and then drop it on to a different server then it may or may not work (as you've already discovered).

The databases I'm backup up with mysqldump consist of millions of rows and are used to transact millions of dollars of business each month, so I'm not playing with a database of some 100 post WordPress sites. I use this method because it works simply, is reliable, and gives consistent results without having to stop the database server. It's also highly suited to scripting backups for different databases (See the script examples in the other threads for details).

If you wish to go down the stop server/copy files route then good luck with that.

Hi TenTenths !

I agree with u and i will go with mysqldump backup Thank you one again