MySQL dump and pump

mysqldump -u root -p async_mysql_test > async_mysql_test_backup.sql

 

create database if not exists async_mysql_test_backup;

mysql -u root -p async_mysql_test_backup < async_mysql_test_backup.sql

C:\Users\fred>mysqldump -u root -p async_mysql_test > async_mysql_test_backup.sql
Enter password: ****

C:\Users\fred>mysql -u root -p async_mysql_test_backup < async_mysql_test_backup.sql
Enter password: ****

C:\Users\fred>

 

 

use async_mysql_test_backup;
show tables;
select * from test_tb;