I generally dislike when movies are divided in two or more parts, although it’s just one more click to load 2nd or 3rd file, I prefer joining them together. Up until recently I was using avimerge tool fromtranscode package to do all of my merging, just because it was so simple to do with:
avimerge -i inputfile1.avi inputfile2.avi -o outputfile.avi
Continue reading “How to merge video files under Linux”
In case you have forgotten your root password for MySQL database, you can change it by first killing all mysql processes with:
killall mysql or /etc/init.d/mysql stop (for Debian users)
Now you have to start mysql again with this command:
mysqld --skip-grant-tables &
Continue reading “MySQL root user hack”
After you tried to log in with root user three times and got the message “maximum number of log ins exceeded” you have to restart the computer.
On the GRUB menu, press “E” once to enable edit, and press “E” again on the kernel line to edit it. Near the end of this line change value “ro” to “rw” and add “init=/bin/bash” at the end of this line.
Now boot into Linux and you will have root shell access where you can change the password or do whatever you please.
If mysql-bin.xxxyyy logs are eating up your partition space. This is the right trick for you:
# login to mysql
mysql -u root -p
# create latest log mysql-bin.0000xy
# purge all logs before mysql-bin.0000xy
purge binary logs to 'mysql-bin.0000xy';
In order to minimize writing to disk you could try to move your firefox cache folder into /tmp we created earliner in our RAM.
In your “about:config” add the following entry:
add a string value of “/tmp”.
Ofcourse your cache will be erased each time you reboot, but who cares we are trying to minimize disk usage, so that we can prolong our battery life.
Since I have created 100MB /tmp drive, I have decided to leave firefox cache at the default setting of 50000 (50MB).
browser.cache.disk.capacity (integer) 50000