Mysql Dump to Backup Database

بسم الله Bismillah You can accomplish this using the mysqldump command-line function. For example: If it’s an entire DB, then: $ mysqldump -u [uname] -p db_name > db_backup.sql If it’s all DBs, then: $ mysqldump -u [uname] -p --all-databases > all_db_backup.sql If it’s specific tables within a DB, then: $ mysqldump -u [uname] -p db_name table1 table2 > table_backup.sql You can even go as far as auto-compressing the output using gzip (if your DB is very big):...

September 5, 2024 · 1 min · Masari