How to Backup & Restore MySQL Database on Ubuntu

How to Backup & Restore MySQL Database on Ubuntu

Backup Only Table MySQL Database Using mysqldump

# mysqldump  -u[uname] -p[pass] [dbname] > [backupfile.sql]

Example

 mysqldump -uroot -pabcd  shopmanagementdb > shopmanagementdbback.sql

 

Backup Table and Store Produce MySQL Database Using mysqldump

#  mysqldump --routines -u [uname] -p[pass] [dbname] > [backupfile.sql]

Example

mysqldump  --routines -uroot -pabcd  shopmanagementdb > shopmanagementdbback.sql 

 

Restore MySQL Database

# mysql -u[uname] -p[pass] [dbname] < [backupfile.sql] 

Example

mysql -uroot -pabcd  shopmanagementdb < shopmanagementdbback.sql

0 comments:

Post a Comment