How to import large database file in php myadmin

1. create a new database in localhost/phpmyadmin in browser like "personal_blog"
2. put your .sql file in specific folder
3. open xampp control panel & click shell button from right side
4. type this command " mysql -u root -p personal_blog < G:\personal_blog.sql"
5. Lets enjoy........
6. if face this problem : ERROR 1813 (HY000) at line 164704: Tablespace for table 'cashbook_live.stock_summeries' exists. Please DISCARD the tablespace before IMPORT
7. create a new database another name and try ageain. from step 1 .....

How to transfer old database file in xampp manually

1. copy only folder from old mysql->data folder
2. Paste this in new mysql->data folder clt+a
3. go to phpmyadmin in browser and click empty session data
4. stop php & mysql in xampp server
5. copy ibdata1 from old data to new data folder
6. stop php & mysql in xampp server
7. Lets enjoy........