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