PHP & MySQL, Tutorials

Running mysqldump with PHP

Every project should have regular backups. Writing database tables to a file using PHP while possible is not recommended, it's much better to use MySQL for that.

MySQL has a function called mysqldump that exports a database to a file, this is ran using SSH. For those times when you don't have access to SSH here is a simple way to create a backup using mysqldump by running exec and passing in the command and the login credentials and lastly defining the name of the file to be created.

In the code below the file will be created inside a backups folder then have the date and time as its filename. Make sure the backups folder has write permissions.

$toDay = 'backups/'.date('d-m-Y-H-i-s');
$dbhost = 'localhost';
$dbuser = 'database username';
$dbpass = 'password';
$dbname = 'databsase name';

exec("mysqldump --user=$dbuser --password='$dbpass' --host=$dbhost $dbname > ".$toDay.".sql");

 

David Carr

David Carr

For the past 12 years, I’ve been developing applications for the web using mostly PHP. I do this for a living and love what I do as every day there is something new and exciting to learn.

In my spare time, the web development community is a big part of my life. Whether managing online programming groups and blogs or attending a conference, I find keeping involved helps me stay up to date. This is also my chance to give back to the community that helped me get started, a place I am proud to be apart of.

Besides programming I love spending time with friends and family and can often be found together going out catching the latest movie, staying in playing games on the sofa or planning a trip to someplace I’ve never been before.