Solved

Importing to MySql

Posted on 2014-03-17
7
497 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
  • 4
  • 3
7 Comments
 
LVL 34

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 34

Expert Comment

by:Dan Craciun
ID: 39935415
What are you using? WAMP? XAMPP?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:johnhardy
ID: 39935418
XAMMP
0
 
LVL 34

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 34

Expert Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

774 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