Linx Trix

November 19, 2007

Mov to Avi or mov2avi for your mp4 player

Filed under: Uncategorized, easy — admin @ 6:59 pm

So you got yourself one of these chinese wholesale mp4 players? And they accept only avi files where you may have a mov file which needs to be converted to avi? And you happen to be on Linux? Just hit this and it should solve your problem:

mencoder -oac mp3lame -ovc lavc -vf scale=0:0:0:0:0:0:qpal somemovfile.mov -o outavifile.avi

For this mov2avi trick of course you have to have mencoder installed which will do the conversion for your sweet new mp4 player. BTW, the scale command is to get 352×288, but you can omit it.
This is not something much on topic, but a simple google search on the mov 2 avi won’t help you much so I thought to be nice and put this information out for any of you guys looking for it.

Share and Enjoy:
  • del.icio.us
  • Digg
  • Reddit
  • Slashdot
  • StumbleUpon
  • Live
  • Propeller
  • Technorati
  • Google Bookmarks
  • YahooMyWeb

November 9, 2007

Importing large data files in MySQL

Filed under: easy, mysql — admin @ 2:04 pm

You tried phpmyadmin, you tried cat some_large_file | mysql -uuser -p -Ddatabase but it complains too? Then simply do SOURCE <large file name> while in the mysql console and it will work.

The only problem could be if you still get the error on some lines is to increase the max_allowed_packet if there are large blob’s in your dump.

There are some alternatives like BigDump, but that’s installing additional tools for the job which is not always necessary.

Share and Enjoy:
  • del.icio.us
  • Digg
  • Reddit
  • Slashdot
  • StumbleUpon
  • Live
  • Propeller
  • Technorati
  • Google Bookmarks
  • YahooMyWeb

November 8, 2007

static-routes don’t not work with dhcpd

Filed under: medium, routing — admin @ 8:17 pm

So you need to add a static route next to the default route? Well it’s not documented, and it’s not so easy to find, but here it is:

# MS routes: adds extras to supplement routers option
option ms-classless-static-routes code 249 = array of integer 8;
# RFC3442 routes: overrides routers option
option rfc3442-classless-static-routes code 121 = array of integer 8;
option routers 172.22.0.1;
option ms-classless-static-routes 24, 172, 22, 99, 172, 22, 0, 1 ;
option rfc3442-classless-static-routes 24, 172, 22, 99, 172, 22, 0, 1,
0, 172, 22, 0, 1 ;

More info here .

Share and Enjoy:
  • del.icio.us
  • Digg
  • Reddit
  • Slashdot
  • StumbleUpon
  • Live
  • Propeller
  • Technorati
  • Google Bookmarks
  • YahooMyWeb

Powered by WordPress