Hello All, You cannot import using phpMyAdmin , if the backup file size is big. How to import big .sql file in Mysql ? Solution: E:\xampp\mysql\bin> mysql -u <username> -p /* you have to change this path E:\xampp\mysql\bin , if you have installed XAMPP in different path */ mysql>password : <enter your password here> mysql> create database <databsename> /* if needed */ mysql> use <databasename> mysql> source <sql file full path name eg, c:\temp\backup.sql> /* only .sql file , not zip or gzipped files */ We can use this for local server / shell access server only not shared hosting server.