Importing to MySql

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
johnhardyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dan CraciunConnect With a Mentor IT ConsultantCommented:
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
 
Dan CraciunIT ConsultantCommented:
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
 
johnhardyAuthor Commented:
Thanks Dan
How do I modify please?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Dan CraciunIT ConsultantCommented:
What are you using? WAMP? XAMPP?
0
 
johnhardyAuthor Commented:
XAMMP
0
 
johnhardyAuthor Commented:
Very many thanks Dan
So easy when you put it like that!
Cheers

John
0
 
Dan CraciunIT ConsultantCommented:
Glad I could help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.