Backup solution for huge 150GB database.

[John_jony]

I'm using to back up a 150GB (MariaDB) database: But the server started not responding during the backup for a few minutes so I am looking for another solution to replace mysqldump. Any other solution for a huge database?

 

[WebKitty]

mysqldump is your best choice, but it depends on the flags you use with the command. Try something like this:

mysqldump --max_allowed_packet=1G --single-transaction --quick --lock-tables=false

Or add directly to my.cnf inside [mysqldump]

skip-add-locks
single-transaction
max_allowed_packet = 1G

 

[BrolySSJ]

If you are looking to back up something that is that big then i think that an external harddrive can be teh best option and if you do this it needs to be an ssd as well.