Fork me on GitHub
Nation Pigeon

Viewing Monthly Archive February 2012

Restoring MySQL from data files

18th February 12 | Linux

MySQL stores all its data in the following location /var/lib/mysql/<database> Simply make a copy of these files and you have a backup, when restoring make sure its owned by mysql.

[ Read More → ]

MySQL Adding a database and table

18th February 12 | Linux

Log in with a user which has the correct privileges mysql> CREATE DATABASE port22; Query OK, 1 row affected (0.00 sec) Change to the new database. mysql> use port22; Database changed Create a new table with an auto increment ID, password and email fields. mysql> CREATE TABLE user ( -> id TINYINT NOT NULL AUTO_INCREMENT [...]

[ Read More → ]

Xrandr 1080p

9th February 12 | Linux

xrandr –newmode “1920x1080_50.00″ 141.50 1920 2032 2232 2544 1080 1083 1088 1114 -hsync +vsync xrandr –addmode VGA1 1920x1080_50.00 xrandr –output VGA1 –mode “1920x1080_50.00″ With many thanks to this blog post. (Link)

[ Read More → ]

Copyright © 2007 ∞ Nation Pigeon - Designed by Peter Mayanrd
Theme Based on Black-Green - Fork it on GitHub