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): ...