Re: Backup to cloud?

On 2016-12-13 2:08 PM, Lew Pitcher wrote:
> On Tuesday December 13 2016 13:37, in comp.databases.mysql, "Rhino"
> <no_offline_contact_at_example.com> wrote:
>
>> I know of The Cloud
>
> You write "the cloud" as if it were a single, tangable thing.
> It's not. "The cloud" refers to services hosted on systems accessable through
> a network; typically, Internet-accessable services, but not necessarily.
>
Fair enough. As I tried to imply, I have only a sketchy conceptual knowledge of "the Cloud" and even that might be an overstatement.

>> but I haven't had to write code that works with the
>> cloud yet. Is it possible to back up a MySQL database (using the current
>> Windows version) to the cloud?
>
> It is possible to back up or replicate a MySQL database through a network
> connection. "The Cloud" could, in this case, be another instance of the MySQL
> server, running on another system, accessable through your network. Or, it
> could be an rsync, rcp or even ftp server, again running on another system
> accessable through your network.
>
>> If so, how does one write the command to
>> do so? I'm not sure what the syntax should look like.
>
> The simplest way might be to use mysqldump or mysqlhotcopy to dump the
> database to a file, then rsync it to the remote system ("the cloud"). Read
> the documentation on mysqldump, mysqlhotcopy, and your favourite file
> transfer program (rsync, rcp, etc), for the details on this approach.
>
> If you have access to a second MySQL server on "the cloud", then you can have
> your MySQL server "replicate" databases, in real-time to the second MySQL
> server. This isn't an easy thing to set up, as it needs both MySQL servers to
> recognize the configuration. If this interests you, see
> http://dev.mysql.com/doc/refman/5.7/en/replication.html
> for details.
>
>> If it is not possible to do a backup directly to the cloud, how could I
>> do it indirectly?
>
> Directly: use replication
> Indirectly: mysqldump and rcp (or other)
>
>
> HTH
>
It does indeed! Now I know where to look so that I can choose the best option for my circumstances. :-) Thank you!

-- 
Rhino