Posts

MySql Drop All Tables

One line command: mysqldump -u[user] -p[ssht...] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[user] -p[sshht...] [DATABASE] Can also be used with the -h option in both places. If you use the empty -p options, you'll have to enter the password twice after running the command. The 2nd time, the password will show in clear text while typing.

Fixing an MBP OSX Superdrive that's rejecting DVDs

A lot of discussions online give this solution for fixing an MBP Superdrive that's acting out or rejecting DVDs. 1. Switch off Mac 2. Wrap the thin screen wiping cloth around a thin visiting card 3. Insert gently in Superdrive for about 2cm and clean side-to-side (the lens is supposedly a little to the left). Unbelievable as it sounds, it worked for me too! Try it at your own risk, of course.

Find the biggest MySql tables

SELECT CONCAT(table_schema, '.', table_name),        CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows,        CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,        CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,        CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,        ROUND(index_length / data_length, 2)                                           idxfrac FROM   information_schema.TABLES ORDER  BY data_length + index_length DESC LIMI...

Why Can't I Edit a Drupal Node That I Have Permission to Edit?

http://redfinsolutions.com/blog/why-cant-i-edit-drupal-node-i-have-permission-edit Edit your node and check what input type it is set to use Go to Site Configuration > Input Formats and then make sure that the corresponding input type is configured to allow the role to use that type.

Google Search By Image

Been waiting years for this! Works very well in recognizing identical pictures and even locations and landmarks from personal photographs.. But does not seem powerful enough for facial recognition yet. Inside Google Search · Search by Image Google Search By Image: Use A Snapshot As Your Search Query

Android browser simulate desktop browser

Start debug mode by typing about:debug in address window Use the new settings now available in the browser menu to simulate a desktop browser. The browser will now ignore mobile websites and stay at the main website for all addresses.

ubuntu youtube download

sudo apt-get install youtube-dl youtube-dl http://www.youtube.com/watch?v=QY8g_IsI_gY