Q

Backing up databases without a GUI

MySQL expert Mike Hillyer recommends server volume-specific utilities for backing up a database on a Red Hat enterpise without using a GUI.

What is the best method of backing up MySQL databases on Red Hat Enterprise servers without using a GUI for this process?

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.

This was last published in April 2006

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close