How can I backup a large database in mysql?
Folder size of Database is more than 5GB & contains 1.5 Lakh tables.
I have tried to backup server through phpmyadmin but no luck.
database-administrationdatabase-backupMySQLUbuntu
How can I backup a large database in mysql?
Folder size of Database is more than 5GB & contains 1.5 Lakh tables.
I have tried to backup server through phpmyadmin but no luck.
Best Answer
At a 5GB data size, you almost surely cannot and should not use a dump (myslqdump, phpmyadmin, etc) as a backup. The reason isn't the backup. The reason is because the restore will take a long time, potentially many days depending on the table structure and your server hardware. You need some type of file backup. Whether you use LVM snapshot or Percona XtraBackup or rsync or something else will depend on the storage engine you use, the hardware, filesystem, and a number of other factors. This is much too complex of a question to answer without a lot more detail, but I can simplify as follows: