MySQL dumps with PHP - Good Tips

Posted on Jun 24, 2013
To make a MySQL Dump with PHP, you'll simply have to execute the following Command in PHP script:
(The code below as one line in your PHP-script).
passthru("/usr/bin/mysqldump --opt --host=$dbhost --user=$dbuser
--password=$dbpwd $dbname > $dump_file_name");

MYSQL-HOST = MySQL server adress (mysql15**.examplehost.net).
USERNAME = the username for the database.
PASSWORD = the password for the database.
DATABASENAME = the name on the database.

Another bit of code that does the same job, better coded maybe.
<?php
$dbhost   = "mysql15**.examplehost.net";
$dbname   = "DATABASENAME";
$dbuser   = "USERNAME";
$dbpwd    = "PASSWORD";
$dumpfile = $dbname . "_" . date("Y-m-d_H-i-s") . ".sql";

© Twiwoo 2020 Cookie Policy