I am actually trying to sort of migrate my current ecommerce website which is on wordpress into another new hosting & for that I just take a backup of my main wordpress file which includes all of plugins, themes etc and other one is database sql file.

When I’m trying to upload .sql file in the new database that I have created, it’s just take decent amount of time, after that there will be a server error message occur.

When I looked into databases files to see the percentage of successful filed that has been uploaded, some of the files status are successful and some of them are failed.

I need a best optimize solution of it !

I’m expecting a sort of beginner guide so that I can restore my website in new hosting & domain.