Can't import database through phpmyadmin file

Question

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 200MB I am trying to import this on local and phpMyAdmin is saying:

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

i am try to edit php.ini

 php_value upload_max_filesize 220M //file size
 php_value post_max_size 220M
 php_value max_execution_time 200
 php_value max_input_time 200

Please help I really need this to work.

possible duplicate of [Can't import database through phpmyadmin file size too large](http://stackoverflow.com/questions/9593128/cant-import-database-through-phpmyadmin-file-size-too-large) — Dipesh Parmar, Jun 12 '15 at 13:24

score 0 · Answer 1 · answered Jun 16 '14 at 17:30

0

Try to run this command.

mysqldump --opt -h localhost -u username -p databasename | gzip > database-2014-06-16.gz

In this way, you can save gz (compressed) format of database dump

answered Jun 16 '14 at 17:30

Naveed Ramzan

3,565
3
25
30

score -1 · Answer 2 · edited Jun 12 '15 at 14:34

-1

php_value upload_max_filesize 220M //file size
php_value post_max_size 220M

This values are related to php itself not phpmyadmin.

edited Jun 12 '15 at 14:34

josliber

43,891
12
98
133

answered Jun 12 '15 at 13:21

ManelAcacio

21
5

Can't import database through phpmyadmin file

2 Answers2