Home

Welcome to the import-large-files-in-database wiki!

Importing database file from live server to local host. For small database file normal file upload works fine. The issue occurs when we have to upload larger file like in GB then normal import will provide error.

The to export large file in localhost database we will use command line interface. This is very simple, we just need to follow below step and it also take very less time to export.

1. first extract the file if it is zip
2. after that open cmd and go to cd c:/xampp/mysql/bin directory
3. after that use command mysql -u username -p pwd databasename < enter file path of database file which you want to export

Comment:- replace username with your database username and replace pwd with your database password and replace databasename with your database name