Link to home
Start Free TrialLog in
Avatar of johnhardy
johnhardyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Moving MySql Databases local pc to local pc

I wish move several mysql databases from one local pc to another.

I moved the first database by creating a dump file in Navicat.

I then imported this via phpmyadmin. This went very well and all is working.

I then tried to move another MySql datbase, (the dump file size is 6,031) but am getting the error

"No data was received to import. Either no file name was submitted,
or the file size exceeded the maximum size permitted by your PHP configuration.  
See FAQ 1.16 This is located at
http://localhost/phpmyadmin/doc/html/faq.html#faq1-16."

faq1-16 says
The first things to check (or ask your host provider to check) are the values of upload_max_filesize,
memory_limit and post_max_size in the php.ini configuration file.
All of these three settings limit the maximum size of data that can be submitted and handled by PHP.
One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

I  set upload_max_filesize=20M
and post_max_size=20M
memory_limit=128M

But it made no difference, I still get the same error.

Has anyone suggestions where I may be going wrong please?

Many thanks

John
ASKER CERTIFIED SOLUTION
Avatar of Dan Craciun
Dan Craciun
Flag of Romania image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of johnhardy

ASKER

Thank Dan
Regards

John
Glad I could help!