Restoring a Dump : mysqldump « MySQL Utilities « MySQL Tutorial

Restoring a dump depends on what you have actually dumped.

c:\mysql\bin\mysql -u root -p myDatabase < myDatabase.sql

or to add a non-existent table to a database...

c:\mysql\bin\mysql -u root -p myDatabase < employee.sql

26.4.mysqldump
	26.4.1.	mysqldump
	26.4.2.	Restoring a Dump
	26.4.3.	Automatically drop any tables that exist before restoring the stored tables with the ' --add-drop-table '
	26.4.4.	Create the database if it doesn't already exist with '--databases' option to specify the database we wish to back up
	26.4.5.	Optimising a dump
	26.4.6.	Using mysqldump to copy databases
	26.4.7.	To make a copy of live data