Registrations: Open.
Please register here.

Terminal no longer importing

All MAMP discussions around troubleshooting and anything related to MAMP. Be as detailed as possible here when posting an issue.
Post Reply
hderiau
Posts: 3
Joined: Fri May 07, 2021 12:02 am

Terminal no longer importing

Post by hderiau »

Hello

What could cause a MacOsX terminal no longer processing a mysql command?
I have been importing database for months without any problems doing
/applications/MAMP/library/bin/mysql -u root -p [database] < /Users/mac/Desktop/file.sql

and today, when I hit enter, I'm no longer asked for a password. it goes directly to $

I'm able to dump however
/applications/MAMP/library/bin/mysqldump -u root -p [database] > /Users/mac/Desktop/file.sql
works fine


I have installed a few things recently (docker, superset, RAWGraphs), might have broken something playing with mysql sockets having a hard time to connect superset with mysql if this can help...

in my $PATH:
/Library/Frameworks/Python.framework/Versions/3.9/bin
:/opt/anaconda3/bin:/opt/anaconda3/condabin
:/Users/mac/perl5/perlbrew/bin
:/Library/PostgreSQL/10/bin
:/Library/PostgreSQL/13/bin
:/Applications/MAMP/sonarscanner/bin
:/usr/local/bin
:/usr/bin
:/bin
:/usr/sbin
:/sbin

Thank you for your input!
hderiau
Posts: 3
Joined: Fri May 07, 2021 12:02 am

Re: Terminal no longer importing

Post by hderiau »

After digging a bit, I found out that my MAMP/Library/bin/mysql file is empty (ZERO bytes)

If I take replace it with a mysql file taken from another stack, I'm asked the password. So it looks my mysql file got wiped out. Any suggestion on how to recreate one?

Thanks!
User avatar
mampsupportmod
Site Admin
Posts: 88
Joined: Wed Jan 20, 2021 3:06 am

Re: Terminal no longer importing

Post by mampsupportmod »

hderiau wrote: Fri May 07, 2021 4:04 am After digging a bit, I found out that my MAMP/Library/bin/mysql file is empty (ZERO bytes)

If I take replace it with a mysql file taken from another stack, I'm asked the password. So it looks my mysql file got wiped out. Any suggestion on how to recreate one?

Thanks!
MAMP should re-create it by default I think if you try a reset from File menu. Give it a shot?
hderiau
Posts: 3
Joined: Fri May 07, 2021 12:02 am

Re: Terminal no longer importing

Post by hderiau »

Thank you for your suggestion

I solved my problem by doing a global dump of all my databases and reinstalling MAMP from scratch.

By the way, there is no "Reset" option in my File menu :?:
Attachments
Screen Shot 2021 05 07 At 5.52.42 PM
Screen Shot 2021 05 07 At 5.52.42 PM (43.16 KiB) Viewed 227 times
User avatar
mampsupportmod
Site Admin
Posts: 88
Joined: Wed Jan 20, 2021 3:06 am

Re: Terminal no longer importing

Post by mampsupportmod »

Ah, not MAMP Pro
Post Reply