I have a .sql database compressed in rar format. The size is 210 MB. When it is extracted, the size is 1 GB. Due to slow connection, I am getting trouble uploading a 1GB .sql file to the server. Can I upload the rar to the server and extract it from there using cpanel?
I think you should be able to extract rar file from cPanel but I am not sure. You can convert it zip format. zip file can be extracted from cPanel. Also, to use your database you will need to restore it from PHPMyAdmin or from SSH. PHPMyAdmin will not work in our case due to large database size. Kailash
Yes, you can unpack rar files from the File Manager. Just highlight the file, and click the Extract button. But, I'm not sure you'll be able to load a file hosted on your server into phpmyadmin, so you will need to use SSH to run the SQL code.
Guys, can you please explain what this SSH is all about. Where to access SSH. I have no idea about SSH. Please explain. Thanks.
If you are on a shared server, probably SSH access will be disabled. You can request your host to enable it. You can use software like PuTTy to access your account via SSH. In case if your host do not allow SSH, you will need to request them to restore your database. Kailash