how to import 800 mb sql file in localhost using xampp [closed]

Question

I have been trying to import my magento website database which size is 800 mb in phpmyadmin xampp and having error

''You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.''

Answer 1

You can import database using command line

mysql -u username -p database_name < file.sql

or you can try

mysql -u username -p password    // (press enter)
use database_name ;             // (press enter)
source sql_file_name.sql ;     // (press enter)

Refer

Answer 2

You should try this.

mysql -u root -p db_name < d:\pathToSql\file.sql

Answer 3

open php.ini, and set the max_input_vars to 300000000, then restart apache

and in localhost/phpmyadmin:

1. Select Database you want to Export
2. On Top tab menu click Export
3. Then click go

Answer 4

you can direct import from your terminal using below command,

/opt/lampp/bin/mysql -u root -p databasename < /opt/lampp/htdocs/databasepathtill.sql

Hope this will help you