Cacher is the code snippet organizer for pro developers

-- # clone with data
-- mysqldump -uroot -p my_project -r my_project.sql

-- # without data
-- mysqldump -uroot -p my_project -r my_project.sql --no-data

-- # with limited amount of data
-- mysqldump -u [user] -p[password] [dbname] -r [file].sql --opt --where="1 limit 1000"



CREATE DATABASE [dbname]
  DEFAULT CHARACTER SET utf8
  DEFAULT COLLATE utf8_general_ci;;
  
USE [dbname];
SOURCE [db_source].sql;