DEV Community

Sihar Simbolon
Sihar Simbolon

Posted on • Edited on

Perbandingan backup dan restore database MariaDB menggunakan mysqldump,mydumper, mysql dan myloader

#mysql #mydumper #myloader

Backup menggunakan mydumper 

time mydumper -h ip_address -u nama_usernya -p passwordnya --database nama_databasenya --outputdir nama_foldernya --logfile alamat_logfilenya.log
0.46s user 0.17s system 17% cpu 3.542 total
Enter fullscreen mode Exit fullscreen mode

Backup menggunakan mysqldump 

time mysqldump -h ip_address -u nama_usernya --databases nama_databasenya -p > nama_backup_file.sql
Enter password: 
0.38s user 0.13s system 7% cpu 7.241 total
Enter fullscreen mode Exit fullscreen mode

Restore menggunakan myloader 

time myloader -u nama_usernya -p passwordnya --database=nama_databasenya --directory=nama_folder_hasil_export_dari_mydumper    
0.04s user 0.06s system 7% cpu 1.467 total
Enter fullscreen mode Exit fullscreen mode

Restore menggunakan mysql 

time mysql -u nama_usernya -p < nama_backup_file.sql
0.29s user 0.04s system 5% cpu 6.398 total
Enter fullscreen mode Exit fullscreen mode

Dari percobaan di atas, didapat hasil backup menggunakan mydumper lebih cepat begitu juga restore menggunakan mysql

Top comments (0)

Read next

adityabhuyan profile image

Best Practices for Handling Sensitive Data in MySQL Databases

Aditya Pratap Bhuyan -

grahamthedev profile image

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

GrahamTheDev -

themodernpk profile image

How to FIX: Error: MySQL shutdown unexpectedly

Pradeep Kumar -

mdarifulhaque profile image

Automated CSV and Excel Data Import to MySQL and PostgreSQL Databases Using PHP

MD ARIFUL HAQUE -