PHP mysqldump file import

Question

I want backup my local database and import that database from live website. I'm tried something. please see below..

My Backup code

<?php
$dbhost = "localhost"; 
$dbuser = "root";  
$dbpass = 'password'; 
$dbname = "database"; 

$backupfile ='database.sql';
$backupdir = dirname(__FILE__);
$source = $backupdir.'/'.$backupfile;
system("mysqldump -h $dbhost -u $dbuser --password='$dbpass' $dbname  > $backupfile");

?>
<form action="http://www.example.com/restore_database.php" method="post">
    <input type="text" name="backup_file" value="<?php echo $source; ?>"/>
    <input type="submit" />
</form>

my restore_database.php (example.com/restore_database.php)

<?php
$dbhost = "localhost";
$dbuser = "username";
$dbpass = 'password';
$dbname = "database";
$filename = $_POST['backup_file'];

mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to MySQL server: ' . mysql_error());
mysql_select_db($dbname) or die('Error selecting MySQL database: ' . mysql_error());

$templine = '';
$lines = file($filename);
foreach ($lines as $line) {
    if (substr($line, 0, 2) == '--' || $line == '')
        continue;
    $templine .= $line;
    if (substr(trim($line), -1, 1) == ';') {
        mysql_query($templine) or print('Error performing query \'<strong>' . $templine . '\': ' . mysql_error() . '<br /><br />');
        $templine = '';
    }
}
?>

In my localhost , I'm successfully tested this. for my live site I think file path not detect correctly. I have no idea about this. please help me. Thanks.

why don't you use a shell script instead of leaving these URLS (example.com/restore_database.php) open to the users to play with ... on your server add the simple scripts to backup/restore or add a script on your local host to connect to the remote server and backup/restore. — a14m
– a14m, Commented Sep 1, 2013 at 15:27
ok can you tell me if you want to have the backup on the local or live server ? — a14m
– a14m, Commented Sep 1, 2013 at 15:32
i have an localhost appliaction. i want backup that database and restore to my live site database. — SAFEER N
– SAFEER N, Commented Sep 1, 2013 at 15:33
so you have access to the live site ... and you want to backup the data on a directory on the live site or on a directory on your localhost ? — a14m
– a14m, Commented Sep 1, 2013 at 15:37

a14m · Accepted Answer · 2013-09-01 16:05:07Z

2

assuming that the live site lay on the ip 134.122.12.109 and you are using UNIX

on your local host create these files and ~/backupdir directory

backup.sh

#!/bin/bash
mysqldump -uusername -pPassword database > ~/backupdir/backupFile.sql

restore.sh

#!/bin.bash
mysql -h 134.122.12.109 -uliveSiteUsername -pLiveSitePassword database < ~/backupdir/backupFile.sql

now you can backup your localhost by running ./backup.sh

and you can restore the live site by using ./restore.sh

hope that demonstrated the idea.

responding to your comment

let the restore_database.php be

<?php
$dbhost = "localhost";
$dbuser = "username";
$dbpass = 'password';
$dbname = "database";
$filename = $_POST['backup_file'];
system("mysql -h $dbhost -u $dbuser --password='$dbpass' $dbname < $filename");
?>

edited Sep 1, 2013 at 16:05

answered Sep 1, 2013 at 15:46

a14m

8,0808 gold badges56 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SAFEER N Over a year ago

1) my website hosted in shared ip. 2) my application run on wamp 3)in my question method , i just want one click. all other process will do jquery.

a14m Over a year ago

in that case i suggest you go with the scripts method... and since you run windows the you will have to know where mysql directory is. and where mysqldump directory is. they are probably in 'C:\wamp\bin\mysql\mysql5.1.33\bin\mysqldump.exe' and in 'C:\wamp\bin\mysql\mysql5.1.33\bin\mysql.exe'. so you have to run C:\wamp\bin\mysql\mysql5.1.33\bin\mysqldump.exe -uusername -pPassword database > file.sql to backup and run C:\wamp\bin\mysql\mysql5.1.33\bin\mysql.exe -h 134.122.12.109 -uliveSiteUsername -pLiveSitePassword database < file.sql to restore from the cmd yourself

Collectives™ on Stack Overflow

PHP mysqldump file import

1 Answer 1

backup.sh

restore.sh

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

backup.sh

restore.sh

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related