Sql backup via phpmyadmin

[Sp32]

Hey I am wondering my backups are becoming about 80mb (Growing at a fast rate)

but in phpmyadmin it only allows import of: 51,200 KiB

I don't need to back up at the moment but what do I do if I need to restore a back up?

[Bellardia]

You have to use another method such as Impex which you can download from the vbulletin site, or something I used called 'bigdump'. It's a php file that executes your queries in batches, try google, it should come up.

[Sp32]

Thanks.

[markbolyard]

You should also read this: https://vborg.vbsupport.ru/showthread.php?t=106935

and if you don't have root access, you can always upload it to a private area on your hosting account and ask your host to restore it via the command line. Most host should do this for you at no cost.

[Sp32]

Thanks guys, I have root access to my server

[Marco van Herwaarden]

You have to use another method such as Impex which you can download from the vbulletin site, or something I used called 'bigdump'. It's a php file that executes your queries in batches, try google, it should come up.
ImpEx is not a backup/restore script!!!