Mega Code Archive

 

Categories / MySQL / Command Mysql

 

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;