mysql backup/restore problem

Unlimited Shared hosting & Unlimited Disk Space from $5.95 - Dreamhost
Solid Managed VPS with 4 IP's from $60 - Liquid Web
Lightning Fast Dedicated Servers & 1GB RAM from $149 - Liquid Web
#1 Domain Registration with WHOIS Privacy - Just $9.95

This Dreamhost thread was started by jon-) on 2009-12-18 14:57:18:

Post Reply? 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 Jon

Join in on the original post at the Dreamhost Forum, Get a Dreamhost Plan or view our Review of Dream Host.