Ok, here's a question that's been on my mind for quite some time:
I see lots of talk of table dumps and the like for backing up SQL databases.
However, I know for a fact - because I've tried it on both Linux and Windows -
that you can just as easily copy the database files and move them somewhere
else, an copy them back if necessary. Now I realise that on a system that's open
to lots of people that's messy, but on some systems - quite a lot actually -
there would be only one admin. So what's wrong with doing it this way? Also,
isn't the fact that MySQL hasn't got transactions tantamount to the same thing?
But I guess you can lock the tables, so...
See, now you see how much of an amateur I am when it comes to these things -
reasonably good all-round, but not an expert in anything! :)
adam
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
