How to create backup script with date?

Asked By Amanda Mitchel 30 points N/A Posted on - 12/09/2012

Hello fellows,

How to create backup script with date? I was a website developer in a specific company here in our place and I was told by our IT department project manager to create some backup every time we have some updates with the website. I am using mysql server over php programming language, I need your assistance.

Regards,

Amanda Mitchel.

• Status: Open
• Question Views: 898
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Development Software

Answered By Allen Kenneth 20 points N/A #166241

How to create backup script with date?

Hello Amanda,

The code will help you backup up your MySQL server using PHP, and the database script also adds date to the backup file name. Use this code:

 

set_time_limit(0);

$username = 'username';

$password = 'password';

$host = 'localhost';

/**

* Use your path here – Should be an existing path and should have the write permission

*/

$dump_path = './dumps/';

$dbc = mysqli_connect($host,$username,$password);

$result = mysqli_query($dbc,'SHOW DATABASES'); 

$database_list = array();

while($row = mysqli_fetch_array($result)) {

   $database_list[] = $row['Database'];

}

foreach ($database_list as $database) {

    $dump_name = $database.'_'.date('d-m-y');

    $dump_string = 'mysqldump –host '.$host.' –user='.$username.' –password='.$password.' '.$database.' > '.$dump_path.$dump_name.'.sql';

    exec($dump_string);

    $zip_cmd = 'gzip '.$dump_path.$dump_name.'.sql';

    exec ($zip_cmd );

}

mysqli_close($dbc);

For more help: http://firmy007.blogspot.in/2011/11/using-php-to-backup-entire-mysql-server.html

 

For more database back-up methods: https://www.noupe.com/development/10-ways-to-automatically-manually-backup-mysql-database.html

 

Hope this would be helpful. Regards!

About Allen Kenneth

Questions
1

Answers
100

Best Answers
74

• Vote Up 0 Vote Down

• Posted on - 12/13/2012
• Question Category: Development Software