Import sql file using mysql CLI in ubuntu

How to export each table from a database into separate files using the mysqldump command. Create a script file with the following code snippet. #!/bin/bash T_PATH=Downloads/tables_templates for TB in `mysql -u root -proot -N -B -e 'show tables from drupal'`; do echo "Backing up $TB" mysqldump --add-drop-table --add-locks --complete-insert -u root...