Mobile app version of vmapp.org
Login or Join
Odierno851

: Php.ini changes not taking effect in Siteground I am importing an sql file for a magento website, however, It gives me this error: Unknown: Input variables exceeded 1000. To increase the limit

@Odierno851

Posted in: #Cpanel #Magento #Phpmyadmin #SharedHosting

I am importing an sql file for a magento website, however, It gives me this error:

Unknown: Input variables exceeded 1000. To increase the limit change
max_input_vars in php.ini


Then I modified the max_input_vars to 3000 in the php.ini but it doesn't seem to take effect.
I'm pretty new at this and it's driving me nuts.

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Odierno851

1 Comments

Sorted by latest first Latest Oldest Best

 

@Welton855

So it turns out that my sql file got corrupted when exporting from phpmyadmin. Instead, I exported from command line with this command:

mysqldump -u [USER] -p [PASS] db-name > db-name.sql


Or if it's too large then you can zip it.

mysqldump -u [USER] -p [PASS] db-name | gzip > db-name.gz

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme