restore problem

2013-09-08 Thread Trianon33
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

Re: restore problem

2013-09-08 Thread Trianon33
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

Re: restore problem

2013-09-08 Thread Michael Dykman
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

Re: restore problem

2013-09-08 Thread Trianon33
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

Re: restore problem

2013-09-08 Thread Andrew Moore
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