Where are mysql db files kept – MAMP PRO and more

Where are MySQL’s Files Kept?

MySQL stores and accesses files in various places on your hard drive. This page documents the locations of commonly used files, for some often used MySQL installations.

If you want to backup your data or copy data from one server to another, please don’t copy the data files directly. It is recommended to use Sequel Pro’s Export and Import features (use a MySQL dump) to accomplish this.

If you can’t find the files in the locations given here, it could be because you changed the configuration — these are only the default locations. Some of the files only exist while the MySQL server is running (eg. the socket file).

If your installation has no option file (my.cnf), you can create it in the base directory of your installation (see ‘Using Option Files’ section of the MySQL manual for more information).

If you can connect to your MySQL server, you can find many of these paths by selecting Show Server Variables… from the Database Menu in Sequel Pro.

MySQL installed with the official .pkg installer

Socket File
/tmp/mysql.sock
Data Files
/usr/local/mysql/data/
Error Log
/usr/local/mysql/data/HOSTNAME.err (insert your hostname)
Base Directory
/usr/local/mysql/ (this is a symbolic link)

MySQL pre-installed on Mac OS X Server

Socket File
/var/mysql/mysql.sock

MySQL 5 installed with MacPorts

Socket File
/opt/local/var/run/mysql5/mysqld.sock
Data Files
/opt/local/var/db/mysql5/
Error Log
/opt/local/var/db/mysql5/HOSTNAME.err (insert your hostname)

MySQL installed with MAMP

Socket File
/Applications/MAMP/tmp/mysql/mysql.sock
Data Files
/Applications/MAMP/db/mysql/
Base Directory
/Applications/MAMP/Library/
Error Log
/Applications/MAMP/logs/mysql_error_log

MySQL installed with MAMP PRO

MAMP PRO shares many paths with MAMP, with the following difference:

Data Files
/Library/Application Support/appsolute/MAMP PRO/db/mysql

MySQL installed with XAMPP

Socket File
/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
Data Files
/Applications/XAMPP/xamppfiles/var/mysql
Configuration File
/Applications/XAMPP/xamppfiles/etc/my.cnf

 

MySQL installed with Zend Server CE

Socket File  
/usr/local/zend/mysql/tmp/mysql.sock
http://www.sequelpro.com/docs/Where_are_MySQLs_Files

AMPSS MAMPS and OSX stop root password requests

 

works on Lion and Maverick 

Step 1: View current firewall rules.

sudo ipfw show 

Step 2: Add port forwarding rule (80 to 8080)

sudo ipfw add 100 fwd 127.0.0.1,8080 tcp from any to any 80 in 

If you want to remove your firewall rules run:

sudo ipfw flush

 

Creds: 

http://apple.stackexchange.com/questions/37418/how-can-i-open-port-80-so-a-non-root-process-can-bind-to-it

 

To Make Changes permanent

Persistence:

put your rules into a file :

/etc/ipfw.conf 

add at the very top of your file

flush 

Ensure that there are not leading or trailing whitespaces in any line.

add to ~/Library/LaunchAgents/com.yourdomain.ipfw.plist :

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> <key>Label</key> <string>com.yourdomain.ipfw</string> <key>Program</key> <string>/sbin/ipfw</string> <key>ProgramArguments</key> <array> <string>/sbin/ipfw</string> <string>-q</string> <string>/etc/ipfw.conf</string> </array> <key>RunAtLoad</key> <true/> </dict> </plist> 

Either reboot, or

launchctl load -w ~/Library/LaunchAgents/com.yourdomain.ipfw.plist 

the first time.

After that it is

launchctl load com.yourdomain.ipfw 

 

http://serverfault.com/questions/183542/how-to-permanently-redirect-port-80-to-8080-on-os-x

 

sudo chmod 644 ~/Library/LaunchAgents/com.yourdomain.ipfw.plist 

sudo chown root ~/Library/LaunchAgents/com.yourdomain.ipfw.plist

If any issues occur in console then try this thread 

 

 

http://apple.stackexchange.com/questions/3250/why-am-i-getting-a-dubious-ownership-of-file-error-when-launch-agent-runs-my

 

launchctl: Dubious ownership on file (skipping): /System/Library/LaunchAgents/com.yourdomain.ipfw.plist