Techniquices

Ferramenta para diagramas: http://plantuml.com/activity-diagram-legacy

http://stackoverflow.com/questions/16735344/mysql-import-database-but-ignore-specific-table (...) The accepted answer by RandomSeed could take a long time! Importing the table (just to drop it later) could be very wasteful depending on size. For a file created using mysqldump - u user - ppasswd --opt --routines DBname > DBdump.sql I currently get a file about 7GB, 6GB of which is data for a log table that I don't 'need' to be there; reloading this file takes a couple of hours. If I need to reload (for development purposes, or if ever required for a live recovery) I skim the file thus: sed '/INSERT INTO `TABLE_TO_SKIP`/d' DBdump . sql > reduced . sql And reload with: mysql - u user - ppasswd DBname < reduced . sql This gives me a complete database, with the "unwanted" table created but empty. If you really don't want the tables at all, simply drop the empty tables after the load finishes. For multiple tables you could d

How to Find Your Lost Windows or Office Product Keys If you’re planning on  doing a reinstall of Windows  but can’t find your product key, you’re in luck because it’s stored in the Windows Registry. It’s just not easy to find, and it’s impossible to read without some help. Luckily, we’re here to help. As you can see in the screenshot above, the product ID is stored in the registry but is in a binary format that can’t be read by humans unless you are some sort of Cylon. You aren’t, are you? The great thing is that you can even recover a key, even from a computer that won’t boot anymore. All you need is access to the disk drive from a working computer. Keep reading for more. We’re not really sure why Microsoft went to great lengths to make it difficult to see the product keys for their software, especially since they are stored right in there in the registry and can be read by software, if not by humans. We can only assume that they don’t want anybody to re-use a key from an ol

Set paste values as default paste when using Ctrl + V with VBA code Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10! When you paste the data as values only, you need to click the little square at the corner of your selection and choose Values option each time after pasting the data. The following VBA code can help you to change the default paste to paste values. 1 . Hold down the  ALT + F11  keys to open the  Microsoft Visual Basic for Applications window . 2 . Click  Insert  >  Module , and paste the following code in the  Module  Window. VBA code: Set paste values as default paste when using Ctrl + V 1 2 3 Sub PasteasValue() Selection.PasteSpecial Paste:=xlPasteValues End Sub 3 . Then save and close the code, and press  Alt + F8  keys to open the  Macro  dialog box. 4 . In the  Macro  dialog, choose the used macro name  PasteasValue  and then click  Options  button, see screenshot: 5 . Then in the  Macro Optio

In https://scottiestech.info/2014/11/11/repair-missing-user-folders-in-windows-7/ Repair missing User folders in Windows 7 November 11th, 2014 Goto comments Leave a comment At some point, you’ll probably run into a problem that doesn’t seem to have an easy solution: one of your default User folders in Windows 7 (My Documents, My Pictures, My Music, My Videos, Downloads, and Desktop) will suddenly disappear. Try as you might, you won’t be able to restore these user folders, because they are actually “special”. Windows treats them differently than a normal folder you might create yourself, and they even have pretty icons, like so: There is a lot of info out there on how to fix these built-in Windows 7 folders, but it’s all rather complicated. So, here’s the boiled-down, anybody-can-do-it version on how to restore your missing User folders – or so I hope! First, a few bits of info you’ll need to keep in mind. The default locations for the User folders in Windows 7

http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html http://dev.mysql.com/doc/refman/5.6/en/mysqlimport.html http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump