MySQL database backup is really critical for my company's business, can anyone share some experience on this?

  • 1
    What have you found yourself? what area's are critical? is it the data/consistency/uptime.. I think with some common sense you can devise a plan that suits your companies needs, otherwise hire a database consultant to do this for you – Joel Harkes Oct 26 '17 at 12:20
  • What are you doing at the moment to ensure data integrity and security? Maybe if you explained this, we could tell you what you could/should be doing (more) and/or what you're doing wrong? – Vérace Oct 26 '17 at 12:38
  • More answers: dba.stackexchange.com/a/2853/1876 – Rick James Oct 29 '17 at 14:03
  • Thank you for your help. Now we are using cloud database services from Alibaba Cloud. But I need to figure out the strategy for backup and recovery. – webguy Nov 7 '17 at 7:30

I think what you're looking for is mysqldump. Something like the following should get it done:

mysqldump -u root -p --databases DB_NAME > databasename.sql

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.