ERROR: Can't initialize batch_readline - may be the input source is a directory or a block device

mamp-pro
Evanss picture Evanss · Feb 11, 2015 · Viewed 17.9k times · Source

I have Mamp Pro. Im trying to import a databse via the command line as its too large for PHPMyAdmin using these instructions: http://nickhardeman.com/308/export-import-large-database-using-mamp-with-terminal/

When I enter the following im prompted for my password: 

/applications/MAMP/library/bin/mysql -u root -p DBNAME.sql < /Applications/MAMP/htdocs/FOLDERNAME

However when I enter it I get this message:

ERROR: Can't initialize batch_readline - may be the input source is a directory or a block device.

Answer

Gilberto Trevi&#241;o picture Gilberto Treviño · Mar 24, 2015

I think you have something wrong with that command, it should be:

/applications/MAMP/library/bin/mysql -u root -p DBNAME < /Applications/MAMP/htdocs/FOLDERNAME/BACKUP_FILENAME.sql

Related questions

MAMP Pro 3.05 on Mavericks updated to Yosemite - Apache does not start

I have been running MAMP Pro 3.05 successfully in Yosemite up to DP4 on a partition that was a clean install of Yosemite. I now have run the installer for DP5 over my Mavericks install, and now that MAMP Pro install …

Read More
Apache not starting on MAMP Pro

Apache wont start and it throws an error: OR Apache couldn't be started. Please check the log file for more information. dyld: Symbol not found: _iconv Referenced from: /usr/lib/libmecabra.dylib Expected in: /Applications/MAMP/Library/lib/libiconv.2.dylib …

Read More
PHP Artisan Migrate with MAMP and Unix Socket

I was developing my application originally in Laravel 4.2 but have since decided to move it to the 5.0 version so that it covers a lot more changes and strengths that 5.0 has over 4.2. I am trying to run my migratiosn however I …

Read More