CODEWITHSUNDEEP
phpphpmyadminresizedbimport
bhavin
bhavin

Reputation: 1

i am having difficulty on exporting issues on sql

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?

Upvotes: -2

Views: 54

Answers (2)

phpPhil
phpPhil

Reputation: 926

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.

Upvotes: 0

lakshman
lakshman

Reputation: 656

Use SQLYog to import database..your problem will be solved surely.

Upvotes: 0

Related Questions