Alpha alphaolomi

Mysql Quick Commands

Using Command-Line Tools

MySQL and MariaDB include two command-line tools that you can use to quickly backup and restore databases. The mysqldump tool is used to export the contents of a database to a text file, while the mysql client can be used to import data from a text file into a MySQL/MariaDB database.

To backup a MySQL/MariaDB database from the command line, follow these steps:

Launch a new Windows command shell using the "Shell" button in the XAMPP control panel.

Heroku with Node.js

Deploy the app

In this step you will deploy the app to Heroku.

Create an app on Heroku, which prepares Heroku to receive your source code.

heroku create

bits

Snippets of things I re-use but always forget exactly how to write it

HTML boilerplate

<!doctype html>
<html lang="en">
<head>

Custom Localhost URL

For Windows

Assuming using XAMPP Server

Open [C:\Windows\System32\Drivers\etc\hosts](file://C:\Windows\System32\Drivers\etc\hosts)

127.0.0.1     something.local

	'AF' => 'Afghanistan',
	'AX' => 'Aland Islands',
	'AL' => 'Albania',
	'DZ' => 'Algeria',
	'AS' => 'American Samoa',
	'AD' => 'Andorra',
	'AO' => 'Angola',
	'AI' => 'Anguilla',
	'AQ' => 'Antarctica',
	'AG' => 'Antigua And Barbuda',


	# *****************************************************************************
	# CODING STYLE > MAKING YOUR CODE READABLE
	# *****************************************************************************


	# 1. Avoid abbreviating variable names.
	# 2. Write out your function argument names.
	# 3. Document your classes and methods.
	# 4. Comment your code.