11-29-2009, 10:55 PM
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
![[Image: vdcuuu.gif]](http://i47.tinypic.com/vdcuuu.gif)
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.
![[Image: 6psqgy.gif]](http://i46.tinypic.com/6psqgy.gif)
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
STEP 1 :- Login to your Cpanel : http://yoururl.com/cpanel
STEP 2 :- Go to phpMyAdmin
![[Image: vdcuuu.gif]](http://i47.tinypic.com/vdcuuu.gif)
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.
![[Image: 6psqgy.gif]](http://i46.tinypic.com/6psqgy.gif)
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