XAMPP Note

Environment

• Windows 10
• XAMPP for Windows 7.2.4(PHP 7.2.4)
• MySQL
• Apache
• PHP

Setting

• Add D:\xampp\mysql\bin\ to  the PATH environment variable.
• Test URL:localhost:80
• MySQL Default User:root , Password:
• Create DB URL: http://127.0.0.1/phpmyadmin
• Import a sql file to create tables: 
  Ex. mysql -u root -p db_name < file.sql
• Create D:\xampp\php\logs folder , file php_error_log.txt will create here.
• Use mysqldump to make a backup of an entire database
  mysqldump -u root db_name > backup-file.sql

Reference

• https://stackoverflow.com/questions/17666249/how-to-import-an-sql-file-using-the-command-line-in-mysql
• https://www.apachefriends.org/index.html