This depends on server activity and other needs. For servers with small tables and low activity the mysqldump utility should work fine.
Users with larger tables may want to look at the mysqlhotcopy utility
Users with very active servers may want to look at solutions such as LVM snapshots or configuring a replication slave for backup purposes.
Dig Deeper on Open source databases
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.