Page 1 of 1

Terminal no longer importing

Posted: Fri May 07, 2021 12:28 am
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!

Re: Terminal no longer importing

Posted: Fri May 07, 2021 4:04 am
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!

Re: Terminal no longer importing

Posted: Fri May 07, 2021 11:12 am
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?

Re: Terminal no longer importing

Posted: Sat May 08, 2021 1:07 am
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 :?:

Re: Terminal no longer importing

Posted: Sat May 08, 2021 11:49 am
by mampsupportmod
Ah, not MAMP Pro