hacknotes

create database mernis; use mernis; SET CHARSET utf8; CREATE TABLE `kimlik` ( ID bigint ( 15 ) unsigned auto_increment primary key, TCKIMLIK bigint ( 11 ) unsigned null, ADI varchar ( 50 ) null, SOYADI varchar ( 50 ) null, ANAADI varchar ( 50 ) null, BABAADI varchar ( 50 ) null, CINSIYET varchar ( 1 ) null, DOGUMYERI varchar ( 50 ) null, DOGUM_TARIHI varchar ( 50 ) null, KIMLIK_IL varchar ( 50 ) null, KIMLIK_ILCE varchar ( 50 ) null, IL varchar ( 50 ) null, ILCE varchar ( 50 ) null, MAHALLE varchar ( 50 ) null, SOKAK varchar ( 50 ) null, KAPI_NO varchar ( 50 ) null, DIGER varchar ( 50 ) null ) ENGINE =InnoDB DEFAULT CHARSET =utf8 COLLATE =utf8_turkish_ci ; create index ADI on kimlik ( ADI ) ; create index SOYADI on kimlik ( SOYADI ) ; create index TCKIMLIK on kimlik ( TCKIMLIK ) ;  LOAD DATA LOCAL INFILE '/yedek/mernis.csv' IGNORE INTO TABLE kimlik FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'...

DELETE FROM wp_terms WHERE LENGTH(name) > 34           SELECT * FROM `wp_term_taxonomy` WHERE term_id not in (select term_id from wp_terms) DELETE FROM `wp_term_taxonomy` WHERE term_id not in (select term_id from wp_terms) DELETE FROM wp_term_relationships WHERE term_taxonomy_id NOT IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);

  <?php   /**   * PHP script that perform a find and replace in a database dump (tested with   * MySQL) with adjustments of the PHP serialize founded.   *   * Don't forget to escape your "special characters":   * "a$b" -> "a\$b"   * "a"b" -> "a\"b"   * "a`b" -> "a\`b"   * "a!b" -> "a"'!'"b" or 'a!b'   *   * Usage:   * $ db-far [options] [search] [replace] [file]   *   * Example:   * Domain replacement with a backup file "dump.sql.old".   * $ db-far --backup-ext=...