1. fyonnetti
  2. MAMP - Troubleshooting
  3. Monday, 13 January 2020

Accessing mysql from the command line will cause MAMP's UI to crash; I get the "Application Not Responding" error. Apache, PHP, and MySQL are still running, it's just the UI that crashes.

The 2 main commands I run are mysql (import), and mysqldump. The database import sizes range from 5MB to 350MB.

Would adjusting any of the settings in my.cnf help? Maybe add more RAM to max_allowed_packet?

 

System: macOS 10.15.x and MAMP Pro 5.5.1.



Accepted Answer Pending Moderation
0
Votes
Undo

Accessing mysql from the command line will cause MAMP's UI to crash; I get the "Application Not Responding" error. Apache, PHP, and MySQL are still running, it's just the UI that crashes.

The 2 main commands I run are mysql (import), and mysqldump. The database import sizes range from 5MB to 350MB.

Would adjusting any of the settings in my.cnf help? Maybe add more RAM to max_allowed_packet?

 

System: macOS 10.15.x and MAMP Pro 5.5.1.

Any useful errors in the the mysql_error log when it gets locked up? Can you try the same commands using PHP_ADMIN? 

  1. more than a month ago
  2. MAMP - Troubleshooting
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo

The only error message I'm getting when running a mysql import command is:

[Note] Access denied for user 'root'@'localhost' (using password: NO)

 

phpMyAdmin seems to only freeze MAMP for a few secs. But phpMyAdmin is giving me issues on importing databases larger then 50MB even though I up'd the post_max_size and upload_max_filesize to 500M. 

 

Sorry, I realize that's not very helpful information. Can you reproduce the issue on your end by importing a database larger than 100MB?

  1. more than a month ago
  2. MAMP - Troubleshooting
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!