techguru-sampan.blogspot.com

Hi Guys,               Many times we have seen that when the operating system get failure due to something miss happening or miss handled with the system and the system contains the very important databases which you don't wanna loose at any cost and you do not have any backup for that. So I am writing this technique how to recover the Oracle 10G database on this situation. It is very interesting & the easiest way to recover the database.If something like this happened with you then don't worry go with the below mentioned steps and restore your database: For recovering the database we have to need following files. 1.       Database datafiles 2.       Control files 3.       Redologs 4.       Parameter files 5.       Other database related files Database datafiles: Database data files are physical files which are stored on secondary memory. These files are used to store the physical data. Database data files are only written by the Oracle DB Writer. T

Hi Guys,            Here I am writing the technique of recovering the mysql database using the Binary logs.This technique is very useful and very simple as per my experienced.Most of the users have loosed their data & not able to recover the data base. Please  follows the below mentioned steps. 1. Enabling the Binary logs 2. Convert binary logs into text file 3. Edit the text file & Import the text file to Mysql database 1.   First of all we have to enable the mysql binary logs for recovering the database of mysql because when the binary logs enables then each & every operation of mysql are recorded in binary logs by which we can restore the database easily from binary logs. We can enable the binary logs by adding the line to file my.ini which is located on C:\Program Files\MySQL\MySQL Server 5.0. Below are the statement which need to be add log -bin=d: \file-bin where d drive is the path of binary logs where you want to store the binary logs & fil

Hi Friends,                   If you want to see the table details like how much size are using the table and how many   rows contained in table with table name wise, then its very simple please use below mentioned query. and see the result. SELECT TABLE_NAME AS "Table Name", table_rows AS "Quant of Rows",  ROUND((data_length + index_length)/(1024*1024),2) AS "Total Size Mb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema='databasename'; Regards, Sampan

Hi Guys,               If you have forgotten your window-7 login password then dont worry. As per my experience its very simple & easy to reset the password, login again and access your data and other important documents. Please follow the  below mentioned steps and access of system.  First of all you must have the window-7 OS bootable cd, insert the cd into your system and restart the computer and boot from cd and press f8 for bypass the system and choose the Safe mode with command prompt. Then select the option Repair Your Computer and go to the command prompt as mentioned below.   3. Now before using the sticky key file please the backup the key file into safe location, copy the sethc.exe file from OS-windows location using below mention cmd. copy c:\windows\system32\sethc.exe  c:\ after that copy the command prompt executable file (cmd.exe) over the sticky key file using below mentioned command. copy c:\windows\system32\cmd.exe c:\windows\system32\sethc.ex