It starts off by listing all the formulas I have to install using Homebrew caddy (of course), dnsmasq, php, along with configuring a Caddy. Particularly this one Local web development setup on a Mac. I started reading through their documentation about setting up a local hosting environment which later led me to their forums. One day I came across an open-source webserver called Caddy that looked very interesting to me. I had searched the internet and tried many alternatives to MAMP Pro but had no luck. I have to import databases locally all the time so this was driving me absolutely crazy. These crashes occurred when using terminal to import or export MySQL databases or when running the same database commands from phpMyAdmin. And after spending some time troubleshooting by deleting hosts to limit the number, uninstalling/reinstalling MAMP Pro, switching PHP mode to identical/individual versions, etc, it turned out that interacting with MySQL was causing the UI crashes. For me, the AMP (Apache, MySQL, and PHP) environment worked well, it was MAMP’s UI that would freeze and turn my cursor into a spinning beach ball accompanied by the message “Application Not Responding.” I would have to force quit and restart the app every time I needed to make a change. But after the release of version 5, MAMP Pro has been very buggy and annoying to use. MySQL installed with Zend Server CE Socket File /usr/local/zend/mysql/tmp/mysql.We’ve been using MAMP Pro since version 1.x for most of our local testing and development. 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 MAMP PRO shares many paths with MAMP, with the following difference: Data Files /Library/Application Support/appsolute/MAMP PRO/db/mysql 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) 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |