How to backup MySQL database in PHP

Question

I got this tutorial from the Internet  But I don t even have a basic understanding on how backup of a MySQL database through PHP would work    Using PHP to Backup MySQL Databases  Can you recommend some sites that I can use as a reference so that I can study it

User · Answer

try this 100  working    lt  php function dbbackup  host  user  pass  name  tables false   backup name false     set time limit 3000     mysqli   new mysqli  host  user  pass  name     mysqli- gt select db  name     mysqli- gt query  SET NAMES  utf8      queryTables    mysqli- gt query  SHOW TABLES     while  row    queryTables- gt fetch row             target tables      row 0         if  tables     false          target tables   array intersect   target tables   tables        content    SET SQL MODE     NO AUTO VALUE ON ZERO    r nSET time zone      00 00    r n r n r n   40101 SET  OLD CHARACTER SET CLIENT   CHARACTER SET CLIENT     r n   40101 SET  OLD CHARACTER SET RESULTS   CHARACTER SET RESULTS     r n   40101 SET  OLD COLLATION CONNECTION   COLLATION CONNECTION     r n   40101 SET NAMES utf8     r n-- r n-- Database      name    r n-- r n r n r n   foreach  target tables as  table        if  empty  table                 continue              result    mysqli- gt query  SELECT   FROM     table            fields amount  result- gt field count    rows num  mysqli- gt affected rows       res    mysqli- gt query  SHOW CREATE TABLE    table    TableMLine  res- gt fetch row          content      n n   TableMLine 1     n n      TableMLine 1  str ireplace  CREATE TABLE     CREATE TABLE IF NOT EXISTS     TableMLine 1        for   i   0   st counter   0   i  lt   fields amount     i     st counter 0                 while  row    result- gt fetch row                            if   st counter 100    0     st counter    0                                    content      nINSERT INTO    table   VALUES                              content      n                    for  j 0   j lt  fields amount   j                                   row  j    str replace   n     n   addslashes  row  j                       if  isset  row  j                                           content         row  j                                           else                                        content                                            if   j lt   fields amount-1                                          content                                                       content                    if      st counter 1  100  0  amp  amp   st counter  0      st counter 1   rows num                                  content                                   else                                content                                    st counter  st counter 1                   content     n n n      content      r n r n   40101 SET CHARACTER SET CLIENT  OLD CHARACTER SET CLIENT     r n   40101 SET CHARACTER SET RESULTS  OLD CHARACTER SET RESULTS     r n   40101 SET COLLATION CONNECTION  OLD COLLATION CONNECTION        backup name    backup name    backup name    name        date  H-i-s       date  d-m-Y      sql   ob get clean     header  Content-Type  application octet-stream     header  Content-Transfer-Encoding  Binary     header  Content-Length      function exists  mb strlen     mb strlen  content   8bit    strlen  content         header  Content-disposition  attachment  filename      backup name         echo  content  exit    dbbackup  host    user    password    database       gt    check on github

User · Answer

T Todua s answer   It s cool  However  it failed to backup my database correctly  Hence  I ve modified it   Please use like so  Backup Mysql Db  init  localhost   user   pass   db name    usr var output dir     Thank you      lt  php                                                                                                                                          Static class with functions for backing up database                                                                       PHP Version 5 6 31                                                                                                        class Backup Mysql Db    private function   construct           Initializes the database backup     param String  host mysql hostname     param String  user mysql user     param String  pass mysql password     param String  name name of database     param String  outputDir the path to the output directory for storing the backup file     param Array  tables  optional  to backup specific tables only like  array  mytable1   mytable2             param String  backup name  optional  backup filename  otherwise  it creates random name      EXAMPLE  Backup Mysql Db  init  localhost   user   pass   db name    usr var output dir            public static function init  host  user  pass  name   outputDir   tables false   backup name false        set time limit 3000         mysqli   new mysqli  host  user  pass  name           check connection        if  mysqli connect errno              printf  Connect failed   s n   mysqli connect error             exit                change database to  name      mysqli- gt select db  name            change character set to utf8        if    mysqli- gt set charset  utf8                   printf  Error loading character set utf8   s n    mysqli- gt error           exit                  list all tables in the database      queryTables    mysqli- gt query  SHOW TABLES         while  row    queryTables- gt fetch row                     target tables      row 0                 if user opted to backup specific tables only     if  tables     false                   target tables   array intersect   target tables   tables                date default timezone set  Africa Accra     set your timezone        content is the text data to be written to the file for backup      content    -- phpMyAdmin SQL Dump r n-- version 4 7 4     insert your phpMyAdmin version               r n-- https   www phpmyadmin net  r n-- r n-- Host     host               r n-- Generation Time    date  M d  Y  a t h i A  strtotime date  Y-m-d H i s   time                    r n-- Server version     mysqli- gt server info               r n-- PHP Version     phpversion         content      r n r nSET SQL MODE     NO AUTO VALUE ON ZERO    r nSET AUTOCOMMIT   0  r nSTART TRANSACTION  r nSET time zone      00 00    r n r n r n   40101 SET  OLD CHARACTER SET CLIENT   CHARACTER SET CLIENT     r n   40101 SET  OLD CHARACTER SET RESULTS   CHARACTER SET RESULTS     r n   40101 SET  OLD COLLATION CONNECTION   COLLATION CONNECTION     r n   40101 SET NAMES utf8mb4     r n r n-- r n-- Database                       name    r n-- r nCREATE DATABASE IF NOT EXISTS                      name    DEFAULT CHARACTER SET latin1 COLLATE latin1 swedish ci  r nUSE                      name              traverse through every table in the database     foreach  target tables as  table                if  empty  table    continue              result    mysqli- gt query  SELECT   FROM     table                      get the number of columns          fields amount  result- gt field count            get the number of affected rows in the MySQL operation          rows num  mysqli- gt affected rows               Retrieve the Table Definition of the existing table           res    mysqli- gt query  SHOW CREATE TABLE    table             TableMLine  res- gt fetch row              content      r n r n-- -------------------------------------------------------- r n r n   -- r n-- Table structure for table     table    r n-- r n r n             if the table is not empty         if  self  table is empty  table  mysqli                  content     TableMLine 1     n n    append the Table Definition                replace  case insensitively              content  str ireplace  CREATE TABLE     table       wherever you find this                                      DROP TABLE IF EXISTS     table     r nCREATE TABLE IF NOT EXISTS     table       replace with that                                      content    in this                content     -- r n-- Dumping data for table     table    r n-- r n                 content      nINSERT INTO     table       self  get columns from table  table   mysqli      VALUES r n  self  get values from table  table  mysqli                       else  otherwise if the table is empty                        content     TableMLine 1                       replace  case insensitively              content  str ireplace  CREATE TABLE     table       wherever you find this                                      DROP TABLE IF EXISTS     table     r nCREATE TABLE IF NOT EXISTS     table       replace with that                                      content    in this                         content      r n r n   40101 SET CHARACTER SET CLIENT  OLD CHARACTER SET CLIENT     r n   40101 SET CHARACTER SET RESULTS  OLD CHARACTER SET RESULTS     r n   40101 SET COLLATION CONNECTION  OLD COLLATION CONNECTION           date default timezone set  Africa Accra          format the time at this very moment and get rid of the colon   windows doesn t allow colons in filenames       date   str replace       -   date  jS M  y  h i s A   strtotime date  Y-m-d H i s   time               if there s a backup name  use it   otherwise device one      backup name    backup name    backup name    name         date    sql          Get current buffer contents and delete current output buffer     ob get clean             self  saveFile  content   backup name   outputDir        exit          Save data to file       param String  data The text data to be stored in the file      param String  backup name The name of the backup file      param String  outputDir  optional  The directory to save the file to      If unspecified  will save in the current directory          private static function saveFile  amp  data  backup name   outputDir               if    data                return false              try                  handle   fopen  outputDir         backup name    w             fwrite  handle   data           fclose  handle         catch  Exception  e               var dump  e- gt getMessage           return false            return true       Checks if table is empty     param String  table table in mysql database     return Boolean true if table is empty  false otherwise        private static function table is empty  table  mysqli         sql    SELECT   FROM  table        result   mysqli query  mysqli   sql         if  result                     if mysqli num rows  result   gt  0                          return false                     else                            return true                       return false         Retrieves the columns in the table      param String  table table in mysql database     return String a list of all the columns in the right format         private static function get columns from table  table   mysqli          column header            result   mysqli query  mysqli   SHOW COLUMNS FROM  table          while  row    result- gt fetch row                     column header         row 0                      remove leading and trailing whitespace  and remove the last comma in the string     return rtrim trim  column header                Retrieves the values in the table row by row in the table      param String  table table in mysql database     return String a list of all the values in the table in the right format        private static function get values from table  table   mysqli         values             columns             get all the columns in the table      result   mysqli query  mysqli   SHOW COLUMNS FROM  table          while  row    result- gt fetch row                    array push  columns  row 0                   result1   mysqli query  mysqli   SELECT   FROM  table            while traversing every row in the table row by row      while  row   mysqli fetch array  result1            values                    get the values in each column         foreach  columns as  col                            if the value is an Integer              values      self  column is of int type  table   col  mysqli                         row   col          do not surround it with single quotes                          row   col             otherwise  surround it with single quotes                        values   rtrim trim  values            r n                 return rtrim trim  values                   Checks if the data type in the column is an integer     param String  table table in mysql database     return Boolean true if it is an integer  false otherwise      private static function column is of int type  table   column  mysqli         q   mysqli query  mysqli  DESCRIBE  table          while  row   mysqli fetch array  q                  if   column        row  Field                            if  strpos    row  Type       int       false                                 return true                                     return false

User · Answer

While you can execute backup commands from PHP  they don t really have anything to do with PHP  It s all about MySQL  I d suggest using the mysqldump utility to back up your database   The documentation can be found here   http   dev mysql com doc refman 5 1 en mysqldump html  The basic usage of mysqldump is mysqldump -u user name -p name-of-database  gt file to write to sql  You can then restore the backup with a command like mysql -u user name -p  lt file to read from sql  Do you have access to cron  I d suggest making a PHP script that runs mysqldump as a cron job  That would be something like  lt  php   filename  database backup   date  G a m d y     sql     result exec  mysqldump database name --password your pass --user root --single-transaction  gt  var backups    filename  output    if empty  output      no output is good     else     we have something to log the output here     If mysqldump is not available  the article describes another method  using the SELECT INTO OUTFILE and LOAD DATA INFILE commands  The only connection to PHP is that you re using PHP to connect to the database and execute the SQL commands  You could also do this from the command line MySQL program  the MySQL monitor  It s pretty simple  you re writing an SQL file with one command  and loading executing it when it s time to restore  You can find the docs for select into outfile here  just search the page for outfile   LOAD DATA INFILE is essentially the reverse of this  See here for the docs

User · Answer

I would recommend using mysqldump and from php use the system command as suggested in the article you found

User · Answer

Based on the good solution that provided by tazo todua  I ve made some of changes since mysql connect has deprecated and not supported in new php version  I ve used mysqli connect instead and increased the performance of inserting values to the database    lt  php        Updated  Mohammad M  AlBanna   Website  MBanna info        MySQL server and database  dbhost    localhost    dbuser    my user    dbpass    my pwd    dbname    database name    tables           Call the core function backup tables  dbhost   dbuser   dbpass   dbname   tables      Core function function backup tables  host   user   pass   dbname   tables               link   mysqli connect  host  user  pass   dbname           Check connection     if  mysqli connect errno                  echo  Failed to connect to MySQL      mysqli connect error            exit             mysqli query  link   SET NAMES  utf8            get all of the tables     if  tables                        tables   array             result   mysqli query  link   SHOW TABLES            while  row   mysqli fetch row  result                          tables      row 0                       else                tables   is array  tables     tables   explode      tables               return             cycle through     foreach  tables as  table                 result   mysqli query  link   SELECT   FROM    table            num fields   mysqli num fields  result            num rows   mysqli num rows  result             return    DROP TABLE IF EXISTS    table               row2   mysqli fetch row mysqli query  link   SHOW CREATE TABLE    table             return     n n   row2 1     n n            counter   1             Over tables         for   i   0   i  lt   num fields   i                   Over rows             while  row   mysqli fetch row  result                                    if  counter    1                        return    INSERT INTO    table   VALUES                      else                       return                                             Over fields                 for  j 0   j lt  num fields   j                                            row  j    addslashes  row  j                         row  j    str replace   n     n   row  j                        if  isset  row  j       return        row  j          else    return                               if   j lt   num fields-1      return                                             if  num rows     counter                        return       n                     else                       return       n                                        counter                                   return    n n n                save file      fileName    db-backup-  time    -   md5 implode      tables      sql        handle   fopen  fileName  w         fwrite  handle  return       if fclose  handle            echo  Done  the file name is     fileName          exit

User · Answer

If you want to backup a database from php script you could use a class for example lets call it MySQL  This class will use PDO  build in php class which will handle the connection to the database   This class could look like this    lt  php   defined in your exampleconfig php   define  DBUSER   root    define  DBPASS       define  SERVERHOST   localhost      gt    lt  php   defined in examplemyclass php       class MySql          private  dbc          private  user          private  pass          private  dbname          private  host           function   construct  host  localhost    dbname  your databse name here    user  your username    pass  your password                 this- gt user    user               this- gt pass    pass               this- gt dbname    dbname               this- gt host    host               opt   array                 PDO  ATTR ERRMODE              gt  PDO  ERRMODE EXCEPTION                 PDO  ATTR DEFAULT FETCH MODE   gt  PDO  FETCH ASSOC                            try                   this- gt dbc   new PDO  mysql host    this- gt host   dbname    this- gt dbname   charset utf8    user   pass   opt                             catch PDOException  e                    echo  e- gt getMessage                     echo  There was a problem with connection to db check credenctials                             end function             public function backup tables  tables             backup the db OR just a table                 host  this- gt host               user  this- gt user               pass  this- gt pass               dbname  this- gt dbname               data                     get all of the tables             if  tables                                        tables   array                     result    this- gt dbc- gt prepare  SHOW TABLES                      result- gt execute                                             while  row    result- gt fetch PDO  FETCH NUM                                            tables      row 0                                                else                                tables   is array  tables     tables   explode      tables                               cycle through             foreach  tables as  table                                 resultcount    this- gt dbc- gt prepare  SELECT count    FROM    table                    resultcount- gt execute                     num fields    resultcount- gt fetch PDO  FETCH NUM                    num fields    num fields 0                     result    this- gt dbc- gt prepare  SELECT   FROM    table                    result- gt execute                     data    DROP TABLE    table                        result2    this- gt dbc- gt prepare  SHOW CREATE TABLE    table                        result2- gt execute                                                 row2    result2- gt fetch PDO  FETCH NUM                    data     n n   row2 1     n n                    for   i   0   i  lt   num fields   i                                           while  row    result- gt fetch PDO  FETCH NUM                                                   data    INSERT INTO    table   VALUES                            for  j 0   j lt  num fields   j                                                            row  j    addslashes  row  j                                  row  j    str replace   n     n   row  j                                if  isset  row  j       data        row  j          else    data                                       if   j lt   num fields-1      data                                                             data       n                                                            data    n n n                               save filename              filename    db-backup-  time    -   implode      tables     sql                this- gt writeUTF8filename  filename  data             USE EXAMPLE             connection   new MySql SERVERHOST  your db name  DBUSER  DBPASS               connection- gt backup tables      OR backup tables  posts                connection- gt closeConnection                           end function             private function writeUTF8filename  filenamename  content       save as utf8 encoding                 f fopen  filenamename  w                    Now UTF-8 - Add byte order mark              fwrite  f  pack  CCC  0xef 0xbb 0xbf                 fwrite  f  content                fclose  f              USE EXAMPLE this is only used by public function above                 this- gt writeUTF8filename  filename  data                          end function             public function recoverDB  file to load               echo  write some code to load and proccedd  sql file in here                 USE EXAMPLE this is only used by public function above                recoverDB  some buck up file sql                           end function             public function closeConnection                 this- gt dbc   null            EXAMPLE OF USE             connection- gt closeConnection                 end function             END OF CLASS         gt    Now you could simply use this in your backup php   include   config php    include   myclass php         connection   new MySql SERVERHOST  your databse name here  DBUSER  DBPASS        connection- gt backup tables      Save all tables and it values in selected database        connection- gt backup tables  post table      Saves only table name posts table from selected database        connection- gt closeConnection      Which means that visiting this page will result in backing up your file    of course it doesn t have to be that way    you can call this method on every post to your database to be up to date all the time  however  I would  recommend to write it to one file at all the time instead of creating new files with time      as it is above    Hope it helps and good luck

User · Answer

using PHP function   EXPORT DATABASE  localhost    user    pass    db name       updated function code at github

User · Answer

A solution to take the backup of your Database in  quot dbBackup quot  Folder   Directory  lt  php error reporting E ALL       Define database parameters here    define  quot DB USER quot    root    define  quot DB PASSWORD quot    root    define  quot DB NAME quot    YOUR DATABASE NAME    define  quot DB HOST quot    localhost    define  quot OUTPUT DIR quot    dbBackup       Folder Path   Directory Name define  quot TABLES quot             Instantiate Backup Database and perform backup     backupDatabase   new Backup Database DB HOST  DB USER  DB PASSWORD  DB NAME     status    backupDatabase- gt backupTables TABLES  OUTPUT DIR     OK     KO   echo  quot Backup result   quot     status      The Backup Database class    class Backup Database        private  conn          Constructor initializes database        function   construct   host   username   passwd   dbName   charset    utf8               this- gt dbName    dbName           this- gt connectDatabase   host   username   passwd   charset                protected function connectDatabase   host   username   passwd   charset              this- gt conn   mysqli connect   host   username   passwd   this- gt dbName            if  mysqli connect errno                  echo  quot Failed to connect to MySQL   quot    mysqli connect error                exit                          change character set to  charset Ex    quot utf8 quot             if   mysqli set charset  this- gt conn   charset                 printf  quot Error loading character set  quot   charset  quot    s n quot   mysqli error  this- gt conn                exit                             Backup the whole database or just some tables Use     for whole database or  table1 table2 table3      param string  tables         public function backupTables  tables         outputDir                  try                  Tables to export                 if   tables                            tables   array                     result   mysqli query   this- gt conn   SHOW TABLES                      while    row   mysqli fetch row  result                           tables      row 0                                   else                    tables   is array  tables     tables   explode       tables                               sql    CREATE DATABASE IF NOT EXISTS      this- gt dbName    quot   n n quot                sql     USE      this- gt dbName    quot   n n quot                   Iterate tables                foreach   tables as  table                    echo  quot Backing up  quot     table    quot  table    quot                     result   mysqli query   this- gt conn   SELECT   FROM      table                        Return the number of fields in result set                  numFields   mysqli num fields  result                     sql     DROP TABLE IF EXISTS      table                         row2   mysqli fetch row  mysqli query   this- gt conn   SHOW CREATE TABLE      table                        sql    quot  n n quot     row2 1     quot   n n quot                    for   i   0   i  lt   numFields   i                           while   row   mysqli fetch row  result                               sql     INSERT INTO      table     VALUES                             for   j   0   j  lt   numFields   j                                   row  j    addslashes  row  j                                    row  j    ereg replace  quot  n quot    quot   n quot    row  j                                if  isset  row  j                                       sql      quot      row  j      quot                                  else                                    sql     quot  quot                                                              if   j  lt    numFields - 1                                      sql                                                                                           sql    quot    n quot                                              End    for loop                  mysqli free result  result      Free result set                   sql   quot  n n n quot                   echo  quot  OK  lt br  gt  quot     quot  quot                           catch  Exception  e                var dump  e- gt getMessage                 return false                     return  this- gt saveFile  sql   outputDir                  Save SQL to file  param string  sql        protected function saveFile  amp  sql   outputDir                  if    sql              return false           try                handle   fopen  outputDir     db-backup-     this- gt dbName    -    date  quot Ymd-His quot   time        sql    w                 fwrite  handle   sql               fclose  handle                mysqli close   this- gt conn              catch  Exception  e                var dump  e- gt getMessage                 return false                    return true              End    class Backup Database    gt

User · Answer

Here is a pure PHP class to perform backups on MySQL databases not using mysqldump or mysql commands  Backing up MySQL databases with pure PHP

User · Answer

From the answer of  DevWL  I got  Undefined offset      at   if   j lt   num fields-1      data            I made some changes to    preserve relationships  foreign keys  use Transactions remove the uneedy  num fields     class DBbackup    public  suffix   public  dirs   protected  dbInstance   public function   construct        try       this- gt dbInstance   new PDO  mysql host    dbhost   dbname    dbname        username   password       catch Exception  e        die  Error    e- gt getMessage             this- gt suffix   date  Ymd His         public function backup  tables             output    -- database backup -   date  Y-m-d H i s   PHP EOL      output     SET NAMES utf8   PHP EOL      output     SET sql mode    NO AUTO VALUE ON ZERO    PHP EOL      output     SET foreign key checks   0   PHP EOL      output     SET AUTOCOMMIT   0   PHP EOL      output     START TRANSACTION   PHP EOL       get all table names    if  tables                 tables             query    this- gt dbInstance- gt prepare  SHOW TABLES          query- gt execute         while  row    query- gt fetch PDO  FETCH NUM             tables      row 0                query- gt closeCursor            else         tables   is array  tables     tables   explode      tables            foreach  tables as  table           query    this- gt dbInstance- gt prepare  SELECT   FROM   table           query- gt execute          output     DROP TABLE IF EXISTS   table    PHP EOL         query2    this- gt dbInstance- gt prepare  SHOW CREATE TABLE   table           query2- gt execute          row2    query2- gt fetch PDO  FETCH NUM         query2- gt closeCursor          output    PHP EOL  row2 1      PHP EOL          while  row    query- gt fetch PDO  FETCH NUM               output     INSERT INTO   table  VALUES             for  j 0   j lt count  row    j                  row  j    addslashes  row  j                row  j    str replace   n     n   row  j               if  isset  row  j                  output         row  j                  else  output                     if   j lt  count  row -1                output                              output         PHP EOL                        output    PHP EOL PHP EOL       output     COMMIT         save filename      filename    db backup    this- gt suffix   sql       this- gt writeUTF8filename  filename  output         private function writeUTF8filename  fn  c       save as utf8 encoding        f fopen  fn  w          Now UTF-8 - Add byte order mark    fwrite  f  pack  CCC  0xef 0xbb 0xbf       fwrite  f  c      fclose  f           And usage example     Backup   new DBbackup     Backup- gt backup      This works great on MySQL 10 1 34-MariaDB   PHP    7 2 7

User · Answer

for using Cron Job  below is the php function   public function runback           filename     var www html local storage stores database backup     date  Y-m-d-H-i-s       sql                   db backup               command    mysqldump --single-transaction -h  dbhost -u dbuser -p dbpass yourdb name  gt   filename       system  command       if   command                     no output is good            echo  not done         else             we have something to log the output here            echo  done             There should not be any space between -u and username also no space between -p and password  CRON JOB command to run this script every sunday 8 30 am    gt  gt  crontab -e  30 8     7 curl -k https   www websitename com takebackup

User · Answer

Take a look here  It is a native solution written in php  You won t need to exec mysqldump  or cope with incomplete scripts  This is a full mysqldump clone  without dependencies  output compression and sane defaults   Out of the box  mysqldump-php supports backing up table structures  the data itself  views  triggers and events   MySQLDump-PHP is the only library that supports    output binary blobs as hex  resolves view dependencies  using Stand-In tables   output compared against original mysqldump  Linked to travis-ci testing system  testing from php 5 3 to 7 1  amp  hhvm  dumps stored procedures  dumps events  does extended-insert and or complete-insert  supports virtual columns from MySQL 5 7    You can install it using composer  or just download the php file  and it is as easy as doing   use Ifsnop Mysqldump as IMysqldump   try        dump   new IMysqldump Mysqldump  database    username    password         dump- gt start  storage work dump sql      catch   Exception  e        echo  mysqldump-php error       e- gt getMessage        All the options are explained at the github page  but more or less are auto-explicative    dumpSettingsDefault   array       include-tables    gt  array         exclude-tables    gt  array         compress    gt  Mysqldump  NONE       init commands    gt  array         no-data    gt  array         reset-auto-increment    gt  false       add-drop-database    gt  false       add-drop-table    gt  false       add-drop-trigger    gt  true       add-locks    gt  true       complete-insert    gt  false       databases    gt  false       default-character-set    gt  Mysqldump  UTF8       disable-keys    gt  true       extended-insert    gt  true       events    gt  false       hex-blob    gt  true     faster than escaped content         net buffer length    gt  self  MAXLINESIZE       no-autocommit    gt  true       no-create-info    gt  false       lock-tables    gt  true       routines    gt  false       single-transaction    gt  true       skip-triggers    gt  false       skip-tz-utc    gt  false       skip-comments    gt  false       skip-dump-date    gt  false       skip-definer    gt  false       where    gt             deprecated         disable-foreign-keys-check    gt  true

User · Answer

Try out following example of using SELECT INTO OUTFILE query for creating table backup  This will only backup a particular table    lt  php     dbhost    localhost 3036       dbuser    root       dbpass    rootpassword        conn   mysql connect  dbhost   dbuser   dbpass       if    conn           die  Could not connect      mysql error               table name    employee       backup file      tmp employee sql       sql    SELECT   INTO OUTFILE   backup file  FROM  table name       mysql select db  test db        retval   mysql query   sql   conn        if    retval           die  Could not take data backup      mysql error              echo  Backedup  data successfully n       mysql close  conn     gt

[php] How to backup MySQL database in PHP?

Examples related to php

Examples related to mysql