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
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.
answered Jan 6 '17 at 18:09
-
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
