Hi, I’d like to create a full backup of one of my production databases. However, the database that I want to back up is very big (two or three tables have over 14 million rows) and when I’ve tried to back it up in the past, I’ve received ‘segmentation’ errors. I’d like to then restore this backup to my ‘beta’ environment so that I can develop new features using a copy of the live data.
I know that DreamHost do an automatic database backup, but I’m led to believe that this is incremental and I don’t think there’s a way of restoring it to a different database (at least not from the DreamHost panel). Just wondered if anyone could give me any pointers as to how to achieve the above.
Thanks in advance