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?

No comments posted yet

Your Answer:

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

Comparing MySql data and arrays.
I have a mysql table set up like this:
idsubjectbodyuseriddatetimetags1blog subjectblog body111|2

IMAGE - SERVER SIDE scripting help...
How to receive pixel data of an image and buid a bitmap file on the server using the HTTP POST metho

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

how do I show what a user have selected from a checkbox?
From my code below, how would i show which check boxes have been checked and which radio buttons sel

php code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat

Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other

Preventing blank or already entered values
Im trying to learn how to place a read file line by line and prevent duplicate entries and also BLAN

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

remove trailing slash from array
I have the following array which contains trailing slashes I need to remove. What is the best way to

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

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