Mysql WorkBench import and export

I have a bank on MySQL Workbench with the data filled in and I want to pass that data all filled in to another MySQL Workbench, but on another computer.

Is it possible to do this or will I have to fill in the data all over again?

Author: ChrisAdler, 2014-04-23
Source

2 answers

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

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

This is version 6.1 of MySQL Workbench.

 6
Author: Lucas Henrique, 2014-04-23 17:24:17 
<?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);
?>
 0
Author: Flaviano Silva, 2014-06-18 12:15:24