Backup a mysql database and download as a file

Question

How to backup the mysql database and download it as a .sql file by using PHP Codes

Answer 1

Do you have phpmyadmin? If so you can export it from there by clicking "Export" at the top (on the selected table/db).

Answer 2

mysqldump -u username -p password database > file

Alternatively, phpMyAdmin can do this too with the Export tool.

Answer 3

Use phpmyadmin

Edit:

You can use shell_exec to execute this command

mysqldump -u username -p password database > file

This will generate a dump file,and then redirect user to this generated file.

Answer 4

If you have phpMyAdmin you can do it at the Export menu.

If you look for a command-line tool take a look at mysqldump.

Answer 5

A very simple solution would be something like (first example): http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/using-php-to-backup-mysql-databases.aspx

Naturally this will only make a Data dump of the table.

What you could do is use this code:

http://snipplr.com/view/173/mysql-dump/

What this code does is actually gets a description of the table (i.e its structure), creates all the tables and pushes data. pretty much like any other tool does.

Then its just a matter of saving it from string to a file (file_put_contents() for instance or something similar, depending on your preference and need)