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

closed as too broad by MeenakshiSundaram R, Arunendra, Qaisar Satti, Murtuza Zabuawala, 7ochem Jan 30 '17 at 9:59

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

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

  • 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
  • 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
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

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