restoring huge sql file from comman line mysql in MAC OSX.

Install xampp
stop mac default apache server if its running using command "sudo apachectl stop"
Open configuration panel of xampp
start mysql from manage server option

open ~/.profile by using
nano ~/.profile
copy following text to .profile

export
PATH=/opt/local/bin:/opt/local/sbin:/Applications/xampp/xamppfiles/bin:$PATH

save and exit t using  ctrl + o , ctrl x


type in terminal, mysql -h localhost -u root -p 789798

you will be logged in to mysql console.
 mysql> create database test;

mysql> use database test;

mysql> source /path/to/sql/file/test1.sql

ERROR: Plugin 'PushPlugin' not found, or is not a CDVPlugin. Check your plugin mapping in config.xml

Solution that worked for me:

http://stackoverflow.com/questions/18403225/phonegap-3-0-ios-plugins-not-found

11down vote

Deleting the platforms/ios folder is not a solution for me as all manual customizations to the xcode project will be lost. But there is a simple way around: In XCode, goto Build Phases -> open the Compiled Sources dropdown. Click + and add the missing plugin .m file that should be in your Plugins directory (but is missing from the compiled sources). http://trickortip.com/526/andres-felipe-diaz-2/geek-tips-how-to-and-tricks/how-to-access-the-mysql-command-line-in-xampp-from-mac-os-x-terminal.html/

IOS developement Error No Provisioning Profiles with a valid signing identity in xocde5

Solution:
http://stackoverflow.com/questions/20398176/no-provisioning-profiles-with-a-valid-signing-identity-in-xocde5

up vote2down vote

Close Xcode Use keychain to delete your developer certificate and private key. Use Developer Center to revoke/delete your developer certificate. Use Developer Center to delete all the invalid development provisioning profiles. Run Xcode > Preferences > Accounts > (Double click your team) > Refresh. Xcode will prompt to submit a request to get a new developer certificate signed. (Choose yes). (Optional) Have you team leader approve the pending certificate in the Developer Center. Press refresh again to have Xcode download the new provisioning profiles. You should now be able to select one of the Team Provisioning profiles to run in debug mode. Shortcuts Command-Shift-3: Take a screenshot of the screen, and save it as a file on the desktop Command-Shift-4, then select an area: Take a screenshot of an area and save it as a file on the desktop Command-Shift-4, then space, then click a window: Take a screenshot of a window and save it as a file on the desktop Command-Control-Shift-3: Take a screenshot of the screen, and save it to the clipboard Command-Control-Shift-4, then select an area: Take a screenshot of an area and save it to the clipboard Command-Control-Shift-4, then space, then click a window: Take a screenshot of a window and save it to the clipboard In Leopard and later, the following keys can be held down while selecting an area (via Command-Shift-4 or Command-Control-Shift-4): Space, to lock the size of the selected region and instead move it when the mouse moves Shift, to resize only one edge of the selected region Option, to resize the selected region with its center as the anchor point

Setting static ip and enabling internet sharing in MAC OS

Steps to set static ip in MAC OS
http://www.howtogeek.com/howto/22161/how-to-set-up-a-static-ip-in-mac-os-x/

Enable MAC internet sharing
http://osxdaily.com/2012/01/05/enable-internet-sharing-mac-os-x/