Chapter 19 Application

Question 1

Change to a directory with the mysqldump utility (or set a path)

cd e:\xampp\mysql\bin

Answer 1

mysqldump -u root -p csci>e:csci.sql

Question 2

Restore(to copy a file of sql commands and data into the csci database):
E:\xampp\mysql\bin> mysql -u root -p csci < e:\csci.sql

Answer 2

mysql -u root -p csci