Export and Import MySQL database using PHP

PHP
1

I need to import and export mysql databases using php code, as a part of backing up and restoring database in the admin panel of the web site.
Someone help me out.
Need it soon.

2

lots of ways to do it… one way I’ve done it when dealing with large sql files is open a pipe to mysqladmin and dump the SQL into it.



 class Process
     {
     private $descriptorspec;
     private $process;
     private $pipes;

     public function __construct()
         {
         $this->descriptorspec = array(
                    0 => array("pipe", "r"),
                    1 => array("pipe", "w"),
                    2 => array("file", "/tmp/error-output.txt", "a")
             );
         }
     public function connect($command)
         {
         $this->process = proc_open($command,
                                    $this->descriptorspec,
                                    $this->pipes);
         if (!is_resource($this->process))
             return false;
         }

     public function send($message)
         {
         fwrite($this->pipes[0], $message);
         fflush($this->pipes[0]);
         }

     public function read()
         {
            while (!feof($this->pipes[1]))
                $response .= fgets($this->pipes[1], 1024);

         fflush($this->pipes[1]);

         return $response;
         }

     public function close()
         {
         fclose($this->pipes[0]);
         fclose($this->pipes[1]);
            return proc_close($this->process);
         }
     public function __destruct()
         {
         unset($this->descriptorspec);
         }
 }



/********** usage *****/
 $process =& new Process;
 $process->connect('mysqldump -u testuser -p --no-data testdb');
 $process->write('test');
 $response = $process->read();
 $process->close();

 echo nl2br($response);

this works… however the process class is “funny” as I cannot seem to read or wite to a proces after the initial read/writes. Still… works for the task at hand (you could replace the command with a mysql command… i.e. ‘mysql -u user -p db < sqlfile.sql’ and write your password to it. if you don’t have pcntl, you can use popen (www.php.net/popen).

Also, in the most barebones of ways, you could read from the sql file line by line and pass it to mysql_query. :slight_smile:

3

Thank you for the advice,
I tried it but I need the code that runs in the windows platform. Unix specific functions such as proc_open() could not be executed.
So please help me out.

4

Moved to a more appropriate forum. See Where should I post my thread? for details

Sean :slight_smile:

5

i use phpmyadmin

6

or better yet, call mysql’s mysqldump to have mysql do all the work…

a single line of php code will backup the stuff…