mysql database restore backup

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql backup: C:\Parallels\Plesk\Databases\MySQL\bin>mysqldump.exe -u admin_user -pPASS
S admin_database > c:\file.sql

restore:
mysql -u user -p database < file.sql

MYSQL Query cache
http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm
http://www.cyberciti.biz/tips/enable-the-query-cache-in-mysql-to-improve-performance.html

How to write log into event logger in C#

using (System.Diagnostics.EventLog eventLog = new System.Diagnostics.EventLog("Application"))
{
eventLog.Source = "Application";
eventLog.WriteEntry("Before Call", System.Diagnostics.EventLogEntryType.Information, 101, 1);
}

The power of scrum

Book can be ordered here

BEGIN - ROLLBACK - COMMIT TRANSACTION

BEGIN TRANSACTION;
update Table1
set column1 = 'value1'
where key = 1

update Table2
set column2 = 'value2'
where key = 2


--COMMIT

--ROLLBACK

-- First run with "BEGIN TRANSACTION"
-- If it was OK then run "COMMIT"
-- If it was not OK then run "ROLLBACK"

List of checked out files in TFS 2010

TO be able to see files checked out you need to install TFS power tools

after that you will be able to run command prompt for visual studio

tf status itemspec [/collection:TeamProjectCollectionUrl] [/login:username,[password]] ([/workspace:workspacename[;workspaceowner]]|[/shelveset:shelvesetname[;shelvesetowner]])[/format:(brief|detailed)]
[/recursive][/user:(*|username)]

More Info

example
tf status "$/Project/MyApp" /collection:http://tfs:8080/tfs /user:myuser /recursive /workspace:myworkspace

To view it in Visual studio GUI

Right click on the top most folder that you want to start in
Choose "Find In Source Control"
Choose "Status"
Check "Recursive"
Check "Status"
Enter userid in the "Display files checked out to:" box (i have to include my domain, i.e. domain\userid)
Click "Find"

Read Text Files Using the JavaScript FileReader

Here is a simple example of reading file using javascript, more info on links
+
+
+

<input type="file" id="fileinput" />
<script type="text/javascript">
  function readSingleFile(evt) {
    //Retrieve the first (and only!) File from the FileList object
    var f = evt.target.files[0]; 

    if (f) {
      var r = new FileReader();
      r.onload = function(e) { 
       var contents = e.target.result;
        alert( "Got the file.n" 
              +"name: " + f.name + "n"
              +"type: " + f.type + "n"
              +"size: " + f.size + " bytesn"
              + "starts with: " + contents.substr(1, contents.indexOf("n"))
        );  
      }
      r.readAsText(f);
    } else { 
      alert("Failed to load file");
    }
  }

  document.getElementById('fileinput').addEventListener('change', readSingleFile, false);
</script>

Nexus 5 problem connecting to Windows 8

1. First make sure that the MTP is enabled on the Nexus 5: Settings > Storage > Menu > USB connection to the computer.

2. Plug your Nexus 5 into your computer via USB.

2. On Windows, open the device manager (on Windows 8, press "Ctrl+Q" then just use the search box at right hand side to search for it). You may need the administrator password to open it.

3. Once in the Device Manager, look for the name of your plugged in device. It may be given the name phone, Acer ADB Interface, or something else specific to your device. (It might be tricky to find for users unfamiliar with the device manager, so if you can't find it try unplugging the device and seeing which item disappears. You can just plug it in again afterwards and continue with the instructions.)

4. Right click on the device name and click "Update" by selecting local disk. Don't choose online because you'll just get a message telling you that your driver is up to date.

5. Choose MTP USB Driver.

6. Once the installation is complete, your device manager should show Nexus 5 instead of what you had before.