Get dump of MySQL DB from Live Site

Posted on 16th Feb 2014 07:03 pm by admin

I'm after an easy, but secure way of generating and importing a MySQL dump from a remote server.

The way I want to achieve this is as follows:

1) I will have a page on my localhost server with a form that submits to a script on the live server
2) The script on the live server receives the request and beings to generate the dump data
3) Once generated it sends back this data to a script on my localhost server
4) The script on my localhost server receives the data and runs the queries

What methods can be used to achieve this? I know possibly the easiest method would be to just POST the data in a hidden form variable, but I'm not too convinced this is secure.

I've heard I can use XML as an alternative option, but not too sure about this. Anyone got any suggestions?

Other php-forum

PHP Cannot redeclare class
I have 6 files, and two of them do not seem to want to play well. I keep getting a "Cannot rede

Troubles with a spider class
I am building a spider that will crawl through random whitepages (eg. anywho.com, switchboard.com, w

Problem with an browser game.
Hello,i just joined that great forum and i got php prob,its kinda freaky...anyway i got browser game

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

Shopping Cart
Can anyone direct me to a Simple, Basic structure of a shopping cart.
New to classes. I want to s

using explode() to fill in checkboxes
Hi

I have a field stored in a table that contains regions in the UK separated by commas. Ther

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit