Removing video noize on video seek (progressive download)

There are two rules:

1. IF FPS = 29,97 -> FPS = 30, GOP = 10*FPS, keyint_min = FPS
2. refs=1 (you can change it at x264 preset)

Restoring a single table from mysqldump

So... Let's run!

# gzip -cd mysqldatabase.sql.gz > mysqldatabase.sql

# sed -n "/^-- Table structure for table \`your_mysql_table\`/,/^-- Table structure for table/p" mysqldatabase.sql > your_mysql_table.sql

Based on this great article


-- vladget