Command Mysql MySQL

  1. Home
  2. MySQL
  3. Command Mysql
  4. Recreate the database in interactive mode
user$ mysql -u root -p
Enter password: xxxx
mysql> CREATE DATABASE dbname; --  if dbname does not yet exist
mysql> USE dbname;
mysql> SOURCE backupfile;