MyBB Community Forums

Hey guys what's up?

I have a question regarding databases, restoring mySQL and all that.

First, this is how I take a backup of my site, I go in my Cpanel and I click:

http://i.imgur.com/9qo5rT1.png ( Full Backup

A full backup creates an archive of all of your website’s files and configuration. You can use this file to move your account to another server or to keep a local copy of your files.

Download a Full Website Backup)
_______________________________

Now is this the right way to take a backup inclusing .sql and all that?


And second one of the tables is corrupted even when repaired so people suggested me to upload a new .sql database.

Now I extract my full website backup .tar

And I click the folder mysql : http://i.imgur.com/1XHafK9.png


and I will take the .sql backup here: http://i.imgur.com/9nMVufQ.png which is 261 MB

I import it in the PhpMyAdmin here I see that the max upload is 55MiB, but my host is gonna increaze the upload size http://i.imgur.com/0vevE1K.png

So my question is am I doing it the right way?

Thank you so much for helping I really appreciate!

Don't upload the .sql file to your current database (if you have tables and such in it), create a new one. Other then that, everything seems right.

Also, if you create a new one, please note you have to edit your database name in the config.php file.