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


1 Answer 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. Sep 24, 2018 at 14:03
  • @EricHepperle-CodeSlayer2010 I posted my answer 20 months ago. Please feel free to post new answer to reflect updated options. Sep 24, 2018 at 15:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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