Hello all,As this is my first post to this list (though reading for some time yet), I maybe not complete in asking my question. Apologies for that.On the other hand, this is not a prio 1 problem, so if it takes some mailing, that's ok.I have a website on my private webserver, which consist of some
Hello,
Thanks for your quick reply.
I use WEBMIN and within the Webmin modules you can make simply a SQL backup,
which is in fact a flat file consisting of MYSQL commands.
Explains this enough?
Thanks, BR
Op 8 sep. 2013, om 21:02 heeft Luis H. Forchesatto
luisforchesa...@gmail.com het
I would suggest that you test your backup file on another full-featured
server to determine that it is a valid first. I have done a little work
with the raspberry pi and I doubt that the mysql distribution for that
platform comes with all the features your server-class ubuntu does, so it
is quite
H, this remark makes sense, thanks for reminding that.
Since I have a backup in SQl format (it is readable statements), I was thinking
on splitting the backup file in several separate restores and execute them
manually in consecutive order.
Hmmm, the idea attracts me.
Wait for some
I would suggest making a physical backup. Shutdown MySQL on source, copy
datadir and start on the the destination server. (observe configuration
differences between the two machines)
*Benefits;* consistent backup of non-transactional files.
*Drawbacks;* downtime required.
On Sun, Sep 8, 2013 at