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 first 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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close