how to backup database in mysql + a piece code example Example: mysql dump restore mysql -u [user] -p [database_name] < [filename].sql