All geek questions in one place

Backing up a very large MySQL database

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

+3
source share
2 answers

mysqldump is usually the best and fastest way to back up a database, as it is a tool that comes with mysql live.

+1
source

Depending on the database engine, if you use MYISAM or ARCHIVE tables, you can use mysqlhotcopy, which allows you to back up tables without having to disable MySQL

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

0
source

Source: https://habr.com/ru/post/1755999/

More articles:


All Articles