• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 697
  • Last Modified:

Moving MySql Databases local pc to local pc

I wish move several mysql databases from one local pc to another.

I moved the first database by creating a dump file in Navicat.

I then imported this via phpmyadmin. This went very well and all is working.

I then tried to move another MySql datbase, (the dump file size is 6,031) but am getting 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 This is located at
http://localhost/phpmyadmin/doc/html/faq.html#faq1-16."

faq1-16 says
The first things to check (or ask your host provider to check) are the values of upload_max_filesize,
memory_limit and post_max_size in the php.ini configuration file.
All of these three settings limit the maximum size of data that can be submitted and handled by PHP.
One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

I  set upload_max_filesize=20M
and post_max_size=20M
memory_limit=128M

But it made no difference, I still get the same error.

Has anyone suggestions where I may be going wrong please?

Many thanks

John
0
johnhardy
Asked:
johnhardy
  • 2
1 Solution
 
Dan CraciunIT ConsultantCommented:
After you made changes to php.ini, did you restart the web server? I always forget to do that...

Simply check with phpinfo() if the changes are in effect.

HTH,
Dan
0
 
johnhardyAuthor Commented:
Thank Dan
Regards

John
0
 
Dan CraciunIT ConsultantCommented:
Glad I could help!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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