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

Hyperlink in PHP to MySQL record
Hello,

I am having trouble as i am new to php. I have connected to the database and I have di

Problem with php's rename function
So, i'm having a problem with the php rename function. Basically my script 'delete_user.php' attempt

Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

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

function validate_dimension($value,$name) {
<

question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or

Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the

Comment Mod System Effects all rows...
Sorry if its confusing but here is whats going on: I have a table in a database called comments and

PHP error (line 38) my website
Hello everyone, I'm new on this
and I got a web site thats got a error not showing the photos on<

php/mysql problem
Hey all,

Problem: im trying to setup a shop where people can use a drop-down list to select t

set xml path in flash when xml created in memorystream and webrequest
i am creating an xml file using memory stream and i want to load this xml file into the flash on cli