mysql backup

you will need to have the database servers ip or dns name



mysqldump --opt databasename > path_and_filname.sql



or from your cmd prompt



mysqldump -h hostserver -u username -ppasword --opt databasename > path_and_filname.sql



restoring it is the above with the > changed to < if im not mistak