1

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.''

2

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

| improve this answer | |
  • i tried with above command but i did not get solution – Sarvesh Tiwari Jan 30 '17 at 5:19
  • it's always works. can you tell me what is error – Vaibhav Ahalpara Jan 30 '17 at 5:22
  • i wrote above command after pressing enter i did not get anything – Sarvesh Tiwari Jan 30 '17 at 5:32
  • may be database importing start . i am editing answer – Vaibhav Ahalpara Jan 30 '17 at 9:03
  • 1
    i accept this answer. its is working for me – Sarvesh Tiwari Jan 30 '17 at 10:07
0

You should try this.

mysql -u root -p db_name < d:\pathToSql\file.sql
| improve this answer | |
  • i tried bro but i did not get solutions – Sarvesh Tiwari Jan 30 '17 at 6:22
  • is there any error message on your terminal ? – Ramkishan Suthar Jan 30 '17 at 6:23
  • You should cross check your sql file path, db name and phpmyadmin username. – Ramkishan Suthar Jan 30 '17 at 6:24
  • the system can not find the file specified – Sarvesh Tiwari Jan 30 '17 at 6:24
  • I think then sql file path is the only problem. – Ramkishan Suthar Jan 30 '17 at 6:25
0

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
| improve this answer | |
0

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

| improve this answer | |
  • i am using xampp not lamp – Sarvesh Tiwari Jan 30 '17 at 7:14
  • then just check for mysql file path in place of opt lampp – Yogesh Jan 30 '17 at 7:16

Not the answer you're looking for? Browse other questions tagged or ask your own question.