Solved

Importing to MySql

Posted on 2014-03-17
7
505 Views
Last Modified: 2014-03-17
I exported a database from MySql on my server to my local PC

When I try to import the DB into phpMyAdmin it fails.

The test file is over 5 MBytes

I received 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.

Can anyone say why this may be happening please?
Many Thanks

John
0
Comment
Question by:johnhardy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39935379
Probably the file was not uploaded, as it exceeds the upload_max_filesize (by default 2M) on php.ini.

Modify that and all should be well.

HTH,
Dan
0
 

Author Comment

by:johnhardy
ID: 39935413
Thanks Dan
How do I modify please?
0
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39935415
What are you using? WAMP? XAMPP?
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:johnhardy
ID: 39935418
XAMMP
0
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 39935445
Go to XAMPP Control Panel, on the Apache line click Config, the click on php.ini.

Once you have php.ini opened, search for "upload_max_filesize" and change it from 2M to 6M or whatever you need.

Save, then restart Apache (click on Stop, wait, click on Start).

See images.
xampp go to php.iniphp.ini
0
 

Author Closing Comment

by:johnhardy
ID: 39935500
Very many thanks Dan
So easy when you put it like that!
Cheers

John
0
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39935504
Glad I could help!
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question