MySQL
Taking Backup of MySQL DB
November 6, 2014
0
, ,

Format:
mysqldump -u datbaseusername -ppassword datbasename> /directorylocation/backup.sql

Example with Password Provided:
mysqldump -u db_suser_base -p654321 pwcstores_base> /home/pwcstores.com/src/pwcstores.sql

Example with No Password Provided:
mysqldump -u db_suser_base -p pwcstores_base> /home/pwcstores.com/src/pwcstores.sql

About author

ZERIN

CEO & Founder (BdBooking.com - Online Hotel Booking System), CEO & Founder (TaskGum.com - Task Managment Software), CEO & Founder (InnKeyPro.com - Hotel ERP), Software Engineer & Solution Architect

Upgrading MySQL 5.6 to 5.7 – Group By Does not work anymore

Recently I have updated one of my server MySQL, th...

Read more
mariadb_mysql

MySQL how To – show open database connections

MySQL Current Connection Query Information You can...

Read more

Linux How to Find Files based on the File Size

If you want to search all the files that are more ...

Read more

There are 0 comments