Export each tables from a database into a separate files using mysqldump command
How to export each table from a database into separate files using the mysqldump command. Create a script file with the following code snippet.
MySql
Import sql file using mysql CLI in ubuntu
Open terminal by pressing alt+ctrl T