Backing up Large .SQL Files
 

I've got a large ( 114 meg ) sql backup which I need to backup. I have a dedicated server with full access to admin commands if I'll need to execute any. phpMyadmin will not upload the .sql because of it's size. I've reviewed other topics related to this issue and the only responce I've found was to execute the .sql in little pieces. Many of my sections are to large to execute in little pieces. Can anybody help?

Thanks. :bunny:

there is a vb backup restore hack here in beta hacks, you can for example try it

Run a Telnet/ SSH command.

mysqldump --opt -u USERNAME -pPASSWORD DATABASE_NAME > /YOURDIRECTORY/database.sql

You can even put it in as a daily cron job.

How do you set up cron jobs??

You need access to your server. Then, either edit crontab or add a file into cron.daily. If you have CPanel you can do this via Cpanel as well.

Thank you Erwin :)

How would you backup the difference in a weekly sql file?

That way you won't have to restore 150 plus mb each time?

One of my techies installed a file onto the server which is like, backuprestore.php (I think) and said I should use that instead of the vB default backup since it's very unreliable. Anyone familiar with this method?

I think it is worth while to mention that the sql file should be archived in to a .gz or zip file
when download this should make the file size more smaller if you havent already done so
you can do this in phpmyadmin.