?
Solved

Importing to MySql

Posted on 2014-03-17
7
Medium Priority
?
524 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:johnhardy
ID: 39935418
XAMMP
0
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

649 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