I am trying to import a 70 MB .sql file in PHPMYADMIN but it give me the limit error:
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
I have changed the values of upload_max_filesize, memory_limit and post_max_size
in the php.ini and have restarted xampp but its still not working ??? please help
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
mysql dbname < importfile.sql
pv importfile.sql | mysql dbname
gives you a progress bar.pv
is available in EPEL for RHEL/CentOS, and probably via Your Favorite Package Manager™ in other distributions.