mysql back up and restore with dump file

Run this commande from command prompt in windows:
mysqldump --opt -uUsername -pPassword mydatabase > "file.sql"
to restore:
mysqlimport -uUsername -pPassword mydatabase file.sql

Find and replace:

update `jos_content` set introtext = replace(introtext,'http://','http://');
update `jos_modules` set content = replace(content,'http://','http://');