rdlmda · August 23, 2016 19:07
diff --git a/Basic MySQL b/Basic MySQL
 Some very basic MySQL operations
diff --git a/comments.sql b/comments.sql
 # This comment continues to the end of line
 -- This comment continues to the end of line
 /* this is an in-line comment */
 /*
 this is a
 multiple-line comment
 */
diff --git a/create_user_and_db.sql b/create_user_and_db.sql
 # Create a new user, a new DB and grant privileges on this DB

 CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 GRANT USAGE ON `database`. * TO 'username'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
 CREATE DATABASE IF NOT EXISTS `database` ;
 GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'localhost';
diff --git a/export_mysql.sh b/export_mysql.sh
 mysqldump --databases -u [user] -p [database] | gzip > [filename.sql.gz]
diff --git a/import_mysql.sh b/import_mysql.sh
 gunzip < [compressed_filename.sql.gz]  | mysql -u [user] -p[password] [databasename]
	# This comment continues to the end of line
	-- This comment continues to the end of line
	/* this is an in-line comment */
	/*
	this is a
	multiple-line comment
	*/
	# Create a new user, a new DB and grant privileges on this DB

	CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
	GRANT USAGE ON `database`. * TO 'username'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
	CREATE DATABASE IF NOT EXISTS `database` ;
	GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'localhost';