Mysql WorkBench Import and Export

You can export your bank in the Workbench in Management - > Data Export . Select the database, choose the directory and filename and click% with%. An sql file will be generated.

On another computer, in the Workbench, click Start Export - > Management , search for the previously generated sql file and click Data Import/Restore .

This is version 6.1 of the MySQL Workbench.

<?php
$username = "root";
$password = "root";
$hostname = "localhost";
$dbname   = "test";

header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename='.basename($dbname . "_" .date("Y-m-d_H-i-s").".sql"));

$command = "C:\AppServ\MySQL\bin\mysqldump --add-drop-table --host=$hostname     --user=$username --password=$password ".$dbname;

system($command);
?>