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?

Your Answer:

Login to answer

Other forums

Display error above the login forum help!
Hi guys. just so you know im not asking for someone to do this for me I just need to be pointed in t

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

Sort a two dimensional array.
Hi. I've set up a two dimensional array that reads as follows:

Code: $modifiedData = array(

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Suggestions for Functional module
Hello experts,
I Have done B.Sc(Mathematics) and MCA & have learnt SAP/ABAP but do n