How to use Mysql CLI in xampp

I love working with Linux and CLI. It helps boost speed to a great extent and it feels like Windows’ xampp often limits that because I mostly tend to avoid using command line. I’m finally writing this to change that and be equally as proficient on Windows. MySQL Bin Location {$xampp}/mysql/bin/mysql.exe Mysqldump Bin Location {$xampp}/mysql/bin/mysqldump.exe How to import and export files Import files Login to mysql by running {$xampp}/mysql/bin/mysql.exe -u user -p Select database by running use {$database_name} Import a file by running source {$path_to_file.sql} Export files Export a table by running mysql\bin\mysqldump.exe -u root -p database_name table > table.sql

December 11, 2020 · 1 min · 100 words · Saqib Razzaq

How to create a virtual host in xampp

Let’s say $xampp = 'xampp_installation_directory' Open {$xampp}\apache\conf\extra\httpd-vhosts.conf Add following snippet for a normal project <VirtualHost *:80> DocumentRoot "{$xampp}\htdocs\project_name" ServerName project_name.localhost <Directory "F:\xampp\htdocs\project_name"> Options Indexes FollowSymLinks AllowOverride All Require all granted </Directory> </VirtualHost> Add following snippet for a Laravel project <VirtualHost *:80> DocumentRoot "{$xampp}/htdocs/project_name/public" ServerName project_name.localhost <Directory "F:\xampp\htdocs\lara8/project_name"> Options Indexes FollowSymLinks AllowOverride All Require all granted </Directory> </VirtualHost>

July 21, 2020 · 1 min · 57 words · Saqib Razzaq

Markdown Syntax Guide

This article offers a sample of basic Markdown syntax that can be used in Hugo content files, also it shows whether basic HTML elements are decorated with CSS in a Hugo theme. ...

March 11, 2019 · 3 min · 446 words · Hugo Authors