I've got a customer with a site on shared hosting, and I wanted a backup of the site db, the hosting company will only do a backup for $200. I've managed to dump the db to an sql script but it's 750mb - so struggled to import it with sql manager and other tools.
Is there a umbraco package that can export the entire db?
Are there any other options?
I can go down the sql script import route, but the log table is massive so I could do with emptying that first.
Export/Backup Umbraco Database
I've got a customer with a site on shared hosting, and I wanted a backup of the site db, the hosting company will only do a backup for $200. I've managed to dump the db to an sql script but it's 750mb - so struggled to import it with sql manager and other tools.
Is there a umbraco package that can export the entire db?
Are there any other options?
I can go down the sql script import route, but the log table is massive so I could do with emptying that first.
Thanks
Maybe you can use the script mentioned here.
http://our.umbraco.org/forum/getting-started/installing-umbraco/44121-Scripting-your-MSSQL-with-powershell
is working on a reply...