Mac psequel list database mac os x#

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 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)

Mac psequel list database mac os x#

MySQL pre-installed on Mac OS X Server Socket File /var/mysql/mysql.sock 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) 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. 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).

Some of the files only exist while the MySQL server is running (eg. 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. It is recommended to use Sequel Pro's Export and Import features (use a MySQL dump) to accomplish this. If you want to backup your data or copy data from one server to another, please don't copy the data files directly. This page documents the locations of commonly used files, for some often used MySQL installations. MySQL stores and accesses files in various places on your hard drive.