mysql -u sadmin -p PASSWORD DB_NAME_TO_OVERWRITE < YOURSQLFILE.sql A quick google turns up http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/
2008/5/30 Roger Searle <[EMAIL PROTECTED]>: > Hi, I have a HH machine running in vmware that has mediawiki freshly > installed and configured, I can browse to the main page of the wiki and > could begin creating articles etc. I have a mysql backup of a wiki that I > had previously when running Gutsy (which broke on upgrading to Hardy). I > created this using the mysql administrator tool - creates a .sql dump file > that I am now wanting to restore and replace the database of the freshly > installed wiki. > I can use the MySQL Administrator tool's Restore Backup function to do a > restore, however I am lost at the point of understanding where this restored > database has gone, but more importantly how to replace the database of the > freshly installed wiki and therefore see the previously created articles. > Any pointers on where to look or how to go about such a process would be > greatly appreciated. > Cheers, > Roger >
