Back up From the Command Line (using mysqldump)
Taking mysql backup from terminal is as simple.
$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
uname -username
p -password
dbname-database
opt -mysqldump option
Ex: mysqldump -u root -p Tutorials > tut_backup.sql
Taking the backup of a table
With mysqldump command you can specify certain tables of your database you want to backup.
Ex: mysqldump -u root -p Server user role > tab_backup.sql
here Server is the database name,user & role are the tables in Server database.
No comments :
Post a Comment