REAP WHAT YOU SOW
To import SQL file in XAMPP MySQL, first has to go to XAMPP MySQL bin then do the command standard Mysql import command line.
|
1 |
/Applications/XAMPP/bin |
|
1 |
./mysql -u <username> -p <database_name> < <sql_file> |
Example:
|
1 |
./mysql -u wanrazali -p property_price_trends < /Users/wanrazalimatsah/Downloads/Original/hd_postmeta.sql |
You can access XAMPP 8.2.4 MySQL via command line in MacOS by following these steps.
|
1 |
/Applications/XAMPP/xamppfiles/bin/ |
|
1 |
./mysql -u username -p |
If successful, XAMPP will connect to MariabDB instead of MySQL
You can double check by getting all databases in the MariaDB.
|
1 |
show databases; |
I installed XAMPP then after installation the XAMPP control manager appeared after that. If you restart your computer, I wonder where I can launch it because XAMPP is not appeared in LaunchPad.
Applications folder of XAMPP also has so many files.
Go to Applications -> XAMPP -> xamppfiles .
Then click on manager-osx.
Key in your password and then the XAMPP control manager will appear.
I wanted to disable my warning message from my php installation. To do so
I need to configure my php.ini file. I searched on the internet but couldn’t find a direct answers where to change my php.ini on MacOS Catalina.
For MacOS Catalina the location of php.ini is located at /etc/
You can verify it by printing phpinfo() and look for “Loaded Configuration File (php.ini) path”
For my MacOS Catalina, the location of php.ini is located at /etc/. As you can see there is no php.ini is loaded (None).
To load your own php.ini, copy the default file into your new php.ini
|
1 |
sudo cp /etc/php.ini.default /etc/php.ini |
Open the php.ini, in this case I’m using atom to open it.
|
1 |
sudo atom /etc/php.ini |
Then change php error reporting into
|
1 |
error_reporting = E_ERROR |
Save it then restart apache.
|
1 |
sudo apachectl restart |
Then check the php.ini file is loaded correctly by printing the phpinfo. It will shows /etc/php.ini at “Loaded Configuration File” row.
or you can run php –ini to see the loaded configuration file.
When you refresh the website, the warning php message will disappear.
You can use same technique for MacOS Big Sur on MacBook Pro M1.
