CODEWITHSUNDEEP
mysqldatabase
Erik Sapir
Erik Sapir

Reputation: 24737

Backing up very large MySQL DB

What is the best way to backup very large MySQL database (Gigas of info)?

Upvotes: 3

Views: 255

Answers (2)

David Young
David Young

Reputation: 4743

Depending on the database engine if you are using MYISAM or ARCHIVE tables you can use mysqlhotcopy which allows for backing up the tables without having to shut down MySQL

http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy.html

Upvotes: 0

JochenJung
JochenJung

Reputation: 7213

mysqldump is generally the best and fastest way to backup a database, since it is a tool thats delivered with mysql rightaway.

Upvotes: 1

Related Questions