1.4 GB file too big to restore

[b3zra1y]

So, this isn't *really* a VB question - but it's directly affecting my ability to create a backup site.
I have a 1.4 GB MySQL DB backup file.
When trying to upload to my remote hosting provider ... it times out.

I've looked at the SQL file, but I'm not - at the moment - familiar with how it's put together.
So, I'd rather not do surgery on it.

Is there another approach ?

THANKS

[Lynne]

Store your attachments in the file system and I would guess the backup size will go waaaay down. (I have a database that is only 370MB as a zip (over 1.5M posts) and yet I have over 20 GB in attachments.) Also, ask your host about ssh access to be able to do backups without worrying about timing out.

[Reycer]

Just use a bigdump.php I had the same problem here a while back and this really helped. Just open it (attached php file) edit your database details, upload to your server, point to it in your browser and the just follow the on-screen prompts. When done simply delete from your server.

[b3zra1y]

awesome
THANKS