Can't import database
Posted by: jeannetteliu (128.173.35.---)
Date: March 11, 2013 10:47PM

I am trying to import a .sql into MySQL but I keep getting the error 'You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.' I even changed the php.ini file to increase the size of the upload_max_filesize, memory_limit and post_max_size. It still did not fix the issue. I dont know what the issue anymore. Please help.

Options: ReplyQuote
Re: Can't import database
Posted by: RiggsFolly (---.as13285.net)
Date: March 12, 2013 01:09AM

Use the MySQL console.

wampmanager -> mysql -> MySQL Console

enter blank as the password unless you have added a password to the 'root' userid

once you see the ' mysql> ' prompt enter

source c:\folder\your\backup\is\in.sql

This will run a restore of any size

Options: ReplyQuote
Re: Can't import database
Posted by: jeannetteliu (128.173.35.---)
Date: March 12, 2013 02:25AM

Thank you. I got it to work. I had to create the database under a schema first which I did not know about. Thank you again.

Options: ReplyQuote


Sorry, only registered users may post in this forum.