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:

Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
66 Like 52 Dislike
Previous forums Next forums
Other forums

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat

Data type mismatch
Hi,
I am migrating data from algol to c.I mapped real datatype in algol to double datatype in

Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter

same querie, or a new one??
Hi guys,

I'm still working on this drop down list. I've got the actual drop down list to wor

radio button reamains checked
Hello i'm trying to keep the state off my radio buttons so it shows which ones where clicked after t

Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gri

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

php mysql query from input textbox
Hi,

I have a text box, in that i have given the mysql query. I can able to get the query in v

What's best way to get a user's Word doc converted to simple html and images?
Hi all,

I was just wondering if anybody has any experience of this.
Basically, I'm buildin

How would I convert this into code using an if statement?
ES equals exam score m equals $mean s equals $total. I already coded my mean and total so I'm not g

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash