Restore MySQL database from sql dump file?

This is more of a personal note for myself because I keep forgetting the syntax :p.

When developing web applications I often, 'mess around' with the database and I then need to restore it to make sure everything is running ok, (or simply to run some kind of test again and again).
MySQL, (my current development database here), allows me to reload the db from the command line. And the command is...

Replace USERNAME with your database username, DATABASE with your database name and of course the 'dumpo.sql' with the name of your sql dump file.

You will then be asked to enter your password and the update should happen with not too much problems.

if you get an error message like "'mysql.exe' is not recignized as ab internal or external command, ...." this is because mysql is not in your &#xpa;th%, so you will need to run the command above with the full path where mysql.exe is located, (normally in your program files directory).

06h37 - 5/31/2011 - post comment

JournalHome.com has created this blog for the purpose of keeping members and visitors up to date with JournalHome.com site information.
The easiest way to stay up to date is by using the RSS/XML feed.
Place this URL within your rss aggregator and it will automatically update itself whenever a new journal entry is published.