1

I wanted to execute

mysqldump -u username -p –all-databases > dump.sql

However, I can't see the appropriate field in PHPMYADMIN. Where I can do that?

SQL error

screenshot

1

The command you posted does not execute from within PHPMYADMIN

That is supposed to be executed in the OS Shell

There are many web pages that explain running a backup of MySQL with PHP

For example, if you go to How to backup your Mysql database with phpMyAdmin, you will learn how to do the backup starting from the Export tab as well as doing the mysqldump from the OS.

  • Both of these pages are outdated and don't reflect current options, leaving a lot to be inferred which will be confusing for newbies. – Eric Hepperle - CodeSlayer2010 Sep 24 '18 at 14:03
  • @EricHepperle-CodeSlayer2010 I posted my answer 20 months ago. Please feel free to post new answer to reflect updated options. – RolandoMySQLDBA Sep 24 '18 at 15:46

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.