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

How to get MySQL Table Storage Sizes

Getting MySQL Database Storage Sizes If you’...

Read more

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

There are 0 comments