+
X
YOU MIGHT ALSO LIKE
Loading..
loading
Home »
Unlabelled »
How to Backup & Restore MySQL Database on Ubuntu
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