Mysql Workbench Import and Export

Question

I have a Mysql Workbench Database with the data filled and I want to pass this data all filled to another Mysql Workbench, but on another computer.

Is it possible to do that or I’ll have to fill out all the data again?

Answer 1

You can export your bank on the Workbench at Management-> Data Export. Select the database, choose the directory and file name and click Start Export. An sql file will be generated.

On another computer, on the Workbench, click on Management-> Data Import/Restore, browse the previously generated sql file and click on Start Import.

This is version 6.1 of Mysql Workbench.

Answer 2

<?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);
?>