[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

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
0
johnhardy
Asked:
johnhardy
  • 4
  • 3
1 Solution
 
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
 
Dan CraciunIT ConsultantCommented:
What are you using? WAMP? XAMPP?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
johnhardyAuthor Commented:
XAMMP
0
 
Dan CraciunIT 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
 
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now