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

Any meaningful project for a new C++ programmer?
I want to do some meaningful program, so I can help myself to learn

Assume I know the fol

need to add "sizes" to shopping cart
Hey guys, I am trying to figure out a way to add a "size" selector on to this bit of code.

How to ... (FAQs)
... get e-mail notifications As several people asked how to get e-mail notifications when new posti

$_FILES array
Ok,

I just started experimenting with PHP today. My goal right now is to have people be able

Linked Keywords
I am trying to get a script that makes my predefined keyword converted to links and / or converted t

Changes to hosting company's server has affected web contact form
I started a thread a couple of months ago about the contact forms on my client's website. Basically

Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

PHP & MS Access - Line Break
Hey Guys!

I'm pulling records from an MS Access database and listing them using PHP and I'm r

Script not running properly
Hello Everyone
This is a basic script for posting to a database. I'm not sure why it doesn't work