This Tutorial will help you how to move big database smoothly

STEP 1 :- Login to your Cpanel : http://yoururl.com/cpanel

STEP 2 :- Go to phpMyAdmin


STEP 3:- Select the Database which u want to Move

STEP 4:- Select the Tables as shown in Picture ( userhit_adt have 74 tables ) So we will take few few one by one. Clicking the Export Tab in right panel to export the Database in parts.



Export the those tables as .zip and once downloaded then rename those with 1 , 2 , 3 digits Ex : userhit_adt.zip -> userhit_adt1.zip

STEP 5 :- Do Step 4 till your all Tables downloaded.

STEP 6 :- Login to another Hosting and go inside phpAdmin then select the database which u want to Populate with old database ( Make sure the new database should be empty )

STEP 7 :- Click import tab in right panel and then import all parts one by one.

Thats it