How can I export MySQL database with a PHP script?

Question

I need one script that when I open the script.php page for example, that export me one database from MySQL to an SQL document, and I don't know how to do it in PHP, can some one help me with that?

Edited Code:

<?php

$dbhost   = "localhost";
$dbuser   = "root";
$dbpwd    = "";
$dbname   = "activmanagement";
$dumpfile = $dbname . "_" . date("Y-m-d_H-i-s") . ".sql";

passthru("D:/wamp/bin/mysql/mysql5.6.17/bin/mysqldump --opt --host=$dbhost --user=$dbuser --password=$dbpwd $dbname > $dumpfile");

// report - disable with // if not needed
// must look like "-- Dump completed on ..." 

echo "$dumpfile "; passthru("tail -1 $dumpfile");

?>

This line:

passthru("D:/wamp/bin/mysql/mysql5.6.17/bin/mysqldump --opt --host=$dbhost --user=$dbuser --password=$dbpwd $dbname > $dumpfile");

just use `mysqldump` https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html — , May 27 '15 at 23:13
@Dagon so i edited my question and i used that code and it worked, but im runing in wamp like u see if my website was on a host the part on "This line" it would be different right? — Richard, May 27 '15 at 23:25
the path to mysqldump would be different, everything else is the same — , May 27 '15 at 23:27
@Dagon so how can i see the right path if i host my website? :s — Richard, May 27 '15 at 23:28
how would i know how your host has set its servers up? how about asking them? — , May 27 '15 at 23:29
but if the website is hosted the path its the same or almost the same in any host right? — Richard, May 27 '15 at 23:30
their path (if its needed) to `mysqldump` could be *anything* — , May 27 '15 at 23:31
hoo, but if it does not need a path so what would be the code? — Richard, May 27 '15 at 23:45
pipe it `mysqldump -u usuario -p --all-databases | gzip > dump.sql.gz` — , May 28 '15 at 00:18
Possible duplicate of [PHP regular backup of mysql data](http://stackoverflow.com/questions/38916163/php-regular-backup-of-mysql-data) — e4c5, Aug 15 '16 at 05:25

score 0 · Answer 1 · edited May 23 '17 at 12:16

0

Refer PHP - exec() vs system() vs passthru(). You just need something like this

<?php
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = '';
    $dbname   = 'activmanagement';

    $sql_backup_file = $dbname . date("Y-m-d-H-i-s") . '.gz';
    $dump = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $sql_backup_file";

    system($dump);
?>

edited May 23 '17 at 12:16

Community

1
1

answered Jun 01 '15 at 12:29

mysqlrockstar

2,536
1
19
36

How can I export MySQL database with a PHP script?

1 Answers1