PHP MySQL database export

[gnawz]

Hi,

I need a script that I can put in my admin panel to back up/restore, export/import a MySQL database.
Something to use online, instead of PHPMyAdmin

Somebody please help.

[nathj]

Try a Google search

Alternatively you can use a desktop application such as Navicat (commercial product) or what about MySQL WorkBench

That's my suggestion, personally I use Navicat or PHPMyAdmin if the host provides it.

nathj

[Atli]

You could try doing mysqldump using one of the program execution functions and then output the dump file. You could even try zipping it first if you want that.

Then, if the user wants to restore the database, you simply have them upload the backup file and execute it using one of the program execution functions.
Something like this should work:
[code=php]exec("mysql -u Username -pPassword < /path/to/backup/file.sql");[/code]

[gnawz]

I need to do something like have a button or link that a user clicks then it opens a browse window for the user to select where to save the backup copy of the database...

[dlite922]

I need to do something like have a button or link that a user clicks then it opens a browse window for the user to select where to save the backup copy of the database...

Do what Atli is suggesting, but program it to a button or a link.

You need to know at least the basics of PHP programming.




Dan