i want to upload sql file into database but it is the size of the file is more. However server's phpmyadmin's import database limit is just 50mb so i am not able to upload it How can i increase this default size limit?
Asked
Active
Viewed 51 times
2 Answers
0
Use SQLYog to import database..your problem will be solved surely.
lakshman
- 656
- 4
- 18
-
Could you elaborate more your answer adding a little more description about the solution you provide? – abarisone Apr 02 '15 at 06:05
-
Yeah.. SQLYog is a database tool like phpmyadmin but opposite to the memory concern it handles larger file to be imported. Install it & with the credentials import the database. – lakshman Apr 02 '15 at 06:10
0
You can change the limits in the php.ini file. See this post.
As an alternative I recommend using MySQL Workbench rather than SQL Yog. It's freeware.
But with any external tool (Either SQL Yog and MySQL Workbench) you would have to make sure that external access is allowed for your user on your database server instance.
Please note: You have possibly overlooked this, but you mention 'exporting' in your question title, but then 'importing' in the actual question.
