But again in a large company this is all agreed to.
Originally posted by pando
the problem withj export import is not that you can lose 24 hour or 48 hours data whateever
the problem is you need to recreate a new database, import is slow as hell, can your company afford 5 ~6 hours downtime (for a small database)? our development database ranges from 10gb to 100gb, if I had to restore the 50gb+ ones how long it would take? probably one whole day, with backup takes one hour or less or more but not a whole day that's for sure
if you can afford that downtime so then go ahead and do your export/import