Skip to content

Instantly share code, notes, and snippets.

View ayberkcal's full-sized avatar

clbk ayberkcal

19 followers · 50 following
View GitHub Profile
@ayberkcal
ayberkcal / mysql-faster-imports.sh
Created November 29, 2020 02:19 — forked from OZZlE/mysql-faster-imports.sh
Linux Bash Script to toggle faster mysql db imports
#!/usr/bin/env bash
# USAGE: mysqlOptimizeForImports <- before importing
# mysqlDefaultSettings <- to go back to normal
# Based on https://dba.stackexchange.com/questions/83125/mysql-any-way-to-import-a-huge-32-gb-sql-dump-faster/83385#83385
mysqlStateFile="$HOME/mysql.optimized.for.exports"
mysqlConfigLocation="/etc/mysql/my.cnf" # <-- change to the correct for your system, should be for global mysql settings
@ayberkcal
ayberkcal / gist:c641c798472e088eac71ed41ce53c8e8
Created March 3, 2017 07:18 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
@ayberkcal
ayberkcal / gist:3c64fad26775758627696518c78699ca
Created March 3, 2017 07:18 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
@ayberkcal
ayberkcal / jobs.sql
Created July 27, 2014 19:20 — forked from hasantayyar/jobs.sql
/*
* source: https://github.com/onurdegerli/job-titles
*/
CREATE TABLE IF NOT EXISTS `job_title` (
`job_title_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent_job_title_id` int(10) unsigned NOT NULL DEFAULT '0',
`title_en` varchar(255) NOT NULL,
`title_tr` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`job_title_id`)
@ayberkcal
ayberkcal / pk.sql
Created July 27, 2014 19:18 — forked from serdardalgic/pk.sql
This file has been truncated, but you can view the full file.
/*
Türkiye'nin il, ilçe , semt, mahalle, posta kodu veritabanı
GÜNCEL : 19.04.2013
Kaynak : PTT
Oluşturan : http://www.twitter.com/tserpico
*/
DROP TABLE IF EXISTS `pk`;
CREATE TABLE `pk` (
`mahalle_id` bigint(10) NOT NULL AUTO_INCREMENT,
@ayberkcal
ayberkcal / name_gender.csv
Created July 27, 2014 19:10 — forked from muatik/name_gender.csv
Aad M
Aadam M
Aaden M
Aadje F
Aadu M
Aaf ?F
Aafke ?
Aafkea F
Aafko M
Aage M
@ayberkcal
ayberkcal / cities.json
Created July 27, 2014 19:05 — forked from muatik/cities.json
[
{
"city": "Oranjestad",
"code": "AW"
},
{
"city": "Kabul",
"code": "AF"
},
{
@ayberkcal
ayberkcal / word_country_data.sql
Created July 27, 2014 19:05 — forked from muatik/word_country_data.sql
-- MySQL dump 10.13 Distrib 5.1.51, for pc-linux-gnu (i686)
--
-- Host: 127.0.0.1 Database: world
-- ------------------------------------------------------
-- Server version 5.1.51-debug-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
@ayberkcal
ayberkcal / turkce_isimler.sql
Created July 27, 2014 19:00 — forked from ismailbaskin/turkce_isimler.sql
-- Turkce isimler sozlugu twitter : http://twitter.com/tserpico
CREATE TABLE `isimler` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`isimler` varchar(255) DEFAULT NULL,
`cinsiyet` varchar(255) DEFAULT NULL COMMENT 'erkek : E , kadın : K , uniseks : U',
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
-- ----------------------------