PHP Mysql - 导出整个数据库

Question

I would like the administrator on my website to give the option to export the whole database of the website on one click, just a simple submit button which will save the database in .csv or sql to the PC, is this possible at all?

Answer 1

One option would be to stream the output of the mysqldump command using passthru. If you set the proper headers the output can be downloadable.