Insert your USB drive and open the Terminal. Once it's done downloading, leave it there and do not run it. How to Make a Bootable PCUnlocker USB on Mac Using Terminalĭownload the PCUnlocker ISO image and save it to the Downloads folder. And everything is done now.How to create a bootable PCUnlocker USB after you're locked out of Windows? If you don't have access to a Windows machine, you can use the Terminal to make a bootable PCUnlocker USB on Mac OS X. Provide that and the database will be exported in few seconds, depending upon the size of the database. It'll ask for the password of database user. Depending on where you have kept your database file, change that part of the command. In the above example, I have my database file on the root folder (Macintosh HD). mysql -u database_username -p database_name < /database_file.sql So enter the following command: cd /Applications/MAMP/Library/bin/Ĭhange the path, if your installation is different. If you have installed MAMP, then MySQL is installed in “/Applications/MAMP/Library/bin/” directory.

Then change directory to where MySQL is installed. But you will find very less resource on Importing MySQL Database in Mac Terminal. You will find many resources on web discussing about how to Import MySQL Database in linux. So you should always prefer importing large MySQL database using command line, i.e. During this process, if you encounter any other problem, then you will have a bigger headache. Then when phpMyAdmin will execute huge number of lines SQL, crossing the maximum execution time and again starting from the point, whether it just crossed maximum execution time. Then it’ll take a bit long time to upload the huge database file. Your application may not need to upload such large files, but you need to modify this for uploading large database dump file. For this you need to change your php settings (you need to modify php.ini file). First you need to allow to upload a large file. Exporting large database in phpMyAdmin is not much difficult (however the “command line” method is better), but importing large database in phpMyAdmin is a real headache.

Few days back I have posted “How to Dump MySQL Database to a file on Windows”.

Sql on mac terminal