MYSQL Backup from simple text to phpmyadmin

Question

I have been seriously searching for an SQL code to backup my database. I use xampp as my local server and also phpmyadmin. I simply want to do something like:

    <?php

          $conn = mysqli_connect("localhost", "root", " ", "products");
          if(!$conn){
             die("Unable to connect ".mysql_error());
          }else{
              $backup = "BACKUP DATABASE products";
              $backup_query = mysqli_query($conn, $backup)
          }
   ?>

How do I backup my database and output it in .sql format on the local computer and possibly upload to recover a damaged database? Thank you so much!

please see this https://stackoverflow.com/questions/22195493/export-mysql-database-using-php-only — D Coder, Nov 23 '17 at 09:55

score 0 · Answer 1 · answered Nov 23 '17 at 11:37

0

You can use the shell statement "mysqldump" and call it with php like:

<?php
$dbhost = 'localhost';
$dbuser = 'username';
$dbpassword = 'password';
$dbname = 'datenbankname';
$dumpfile = 'backups/' . $dbname . '_' . date("Y-m-d_H-i-s") . '.sql.gz';

passthru("mysqldump --user=$dbuser --password=$dbpassword --host=$dbhost $dbname | gzip -c  > $dumpfile");
echo "-- Dump finished -- ";
echo $dumpfile;

answered Nov 23 '17 at 11:37

episch

388
2
19

Thanks so much. I appreciate. I'll try it out! – neltino Nov 27 '17 at 08:26

MYSQL Backup from simple text to phpmyadmin

1 Answers1