jake RSS


jakehofman.com

Archive

Jul
28th
Tue
permalink

tip: mysql

use show tables like “table_name” to see if a table exists http://bit.ly/SjdBG

tips  mysql 
Apr
23rd
Wed
permalink

tip: mysql

if you do not have lock permissions on a mysql server and want to do a mysqldump, use the —skip-lock-tables option (with caution)

tips  mysql 
Feb
18th
Mon
permalink

tip: trac,mysql

due to bug with trac interacting with mysql, create the trac database as: CREATE DATABASE trac DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

tips  trac  mysql 
permalink

tip: mysql

if you receive an error about mysql.procs_priv not existing, use mysql_fix_privilege_tables (with, optionally, the —password= switch)

tips  mysql 
Sep
19th
Tue
permalink

tip: mysql

if you forget your root password, kill mysql, edit a file and place SET PASSWORD FOR root@localhost = PASSWORD(‘MyNewPassword’); in it, and issue a mysqld_safe —init-file=path/to/file &

tips  mysql 
Jun
6th
Tue
permalink

tip: mysql

use mysql_real_escape_string to make input to db safe

tips  mysql 
Aug
17th
Wed
permalink

tip: mysql

left join happens first, then comment right join table

tips  mysql