backup and restore mysql in ubuntu

although i use ubuntu with shell, you can use whatever linux's distribution, command should like the same

backup mysqlmysqldump -u [username] -p [password] [database'name] > [backup'sname]
exp: mysqldump -u root -p 123 mysite > mysite.bak.sql


restore from file backupmysql -u [username] -p [password] [database'name] < [backup'sname]

note that the only different is mysql <> mysqldump and > <> <exp: mysql -u root -p 123 mysite < mysite.bak.sql
click here for more details

happy coding!