Tuesday, October 20, 2020

Merge Multiple Whatsapp db into one

 

 

There will be three main phase you need to perform. You can get all required file in the attachment. Make sure you backup your end result before jump into the next phase.

Phase A: Decrypt and obtain msgstore.db file
This is the easiest method I can find and NO ROOT is required to perform this. All you need is to follow the instruction below.

INSTRUCTIONS:

  1. Extract "WhatsAppKeyExtract.zip" (from attachment) on your computer maintaining the directory structure.
  2. Browse to the extracted folder and click on "WhatsAppKeyExtract.bat".
  3. Enable USB Debugging on your device.
  4. Connect your device via USB**, unlock your screen and wait for "Full backup" to appear.
  5. Leave the password field blank and tap on "Back up my data".
  6. The "extracted" folder will now contain your "whatsapp.key", "msgstore.db" and "wa.db".
**If you have never used USB Debugging before, you may also need to verify the fingerprint.

(Credited to TripCode for providing this application! Here is the link to original thread.)

For my case, I have three backup files that named msgstore.db.crypt, msgstore.db.crypt7 and msgstore.db.crypt8. Although I know there might be other easier method to achieve this, I choose to restore each file (by uninstall and install WhatsApp) and run the above method to get my decrypted file. Hence I can be sure that all decrypted file will come in the same structure (I will show you what this mean later) and prevent any error that may cause by that.

Phase B: Edit and prepare database for merge
This will be a bit tricky. But in general, you MUST make sure that you have no overlapping message history between your files.

INSTRUCTION:
  1. Download SQLite Database Browser and install on your computer.
  2. Open the database you want to edit.
  3. Click on [Browse Data] tab.
  4. In Table drop down menu, click on [messages] (You will see all your WhatsApp message here).
  5. Use it like you are using Excel, select any row that is overlapping (EXCEPT the row with many [-1] value) and click on [Delete Record], then click on [Write Changes] (this means you have save the change to the database).
  6. Keep doing this for your remaining file and close all windows of SQLite Database Browser when you are done.
(Thanks ztedd for posting his own method where I get inspired from. This is the link to his original post.)

For my case, the number of column of all my file when display in "messages" table is different (newer WhatsApp database file have more data type). This is the reason I restore and run backup again to make sure all my file have the same structure. Also, a quick tips to figure out which row is overlapping or duplicate is export the messages table to CSV file and open it with Excel. You will need to copy the first few column of each database and paste them together, then use the feature that come with Excel such as Filter and Remove Duplicate to identify which row number you need to remove from actual database file.

IMPORTANT - Never edit your database on excel and import it back to your original database. This will remove all thumbnail, link, emoticon and etc. and show you some weird message when you restore back to your device.

Phase C: Merge database file
This method only can merge two file at once. You may need to do this several time depending how many database you want to merge. I suggest you start from the oldest to newest.

INSTRUCTION:
  1. Rename the older file to old.db.
  2. Rename the newer file to new.db
  3. Create a new folder called Merge and copy the file old.db, new.db and merjapp.jar into it.
  4. Run Command Prompt on your computer (or click on Start Menu and search for cmd)
  5. In Command Prompt, type each of the following separately and press Enter:
    Code:
    cd desktop
    
    cd merge
  6. You now should see [C:\Users\<UserName>\Desktop\Merge>] in cmd window.
  7. Now type the following and press Enter:
    Code:
    java.exe -jar merjapp.jar -old old.db -new new.db
  8. You should see a "Done!" is displayed and a new file named output.db will be created in the Merge folder.
  9. If you have other database to merge, repeat the steps above by rename the output.db to old.db.
  10. Once you are done, rename the output.db to msgstore.db and it is ready to restore into WhatsApp.
(Credited to namnoops for this merge application! This is the link to original thread.)

For my case, I have to run this steps twice to merge 3 databases. I get error the first time I run this because some messages is overlapping and this is the reason for Phase B to edit my database. Once I got my merged database, I renamed it to msgstore.db (without encrypt again) and have no problem restore back to my device. I also copy and paste all my backed up WhatsApp folder to my device (except the file in Database folder) for the picture in WhatsApp to work.

Disclaimer: I do not know any coding behind all these so if you have any questions I will try to answer but the best bet is to go back to the original thread.

Below is some other method that I found online but can't figure out how to do it. You may try it at your own risk.

 

Tuesday, May 22, 2018

Why is copying files takes long time within the local network

solution below ... after disabled the LSO then see the difference of copying ....

From xxK/bites   to xxM/bites


Disabling "Large Send Offload (LSO)" in network adapter properties

Large Send Offload is a technique of improving network performance while at the same time reducing CPU overhead. Apparently it does not work very well, so it was suggested to disable it.
LSO is an option located in a Device Manager under your network adapter, so this solution requires Administrator Privileges.
Follow these steps:
  1. Click Start Menu, right-click on Computer and select Properties
  2. Under Control Panel  located on the left side of the window click on Device Manager
  3. You will get a list of all devices on your machine. Expand Network Adapters.
  4. Find your Network Card and double-click on it.
  5. Select Advanced tab. You will get a list filled with different options.
  6. Select Large Send Offload V2 (IPv4) and set the value to Disabled
  7. Do the same for Large Send Offload V2 (IPv6) if it is available
  8. Click OK
After clicking OK, I tried to send a file over the LAN network. The transfer speed started very slow, but it was gradually picking up speed. I decided to restart the computer and try to send that file again and this time it worked like a charm.
Now that sending of files worked as it should, I also checked speed for receiving files. It turned out that it was still slow but all I had to do to fix that was to disable Large Send Offload V2 on the other computer. Once done,  the problem was solved for receiving files as well.

Monday, October 23, 2017

TTF not a valid font error - windows xp or windows 7

Have you happen to try to install some new font and your windows stated that its not a valid font .
Well this seems to happen due to your firewall setting is set to disabled.


Login as the administrator/Admin  user...

Start ... type Services.msc

search for windows firewall

if status is disable .... enable it and click OK

go to the fonts that u wish to install..

select All and right click and install


and it done.

Sunday, February 3, 2008

xp recover if files corructed

When Will This Recovery Work?
You'll want to use the steps on this page to recover from a corrupted registry when you have already tried other options such as System Restore and you receive a message similar to one of the following when you try to boot your computer with Windows XP.

* Windows XP could not start because the following file is missing or corrupt: \WINDOWS\SYSTEM32\CONFIG\SYSTEM

* Windows XP could not start because the following file is missing or corrupt: \WINDOWS\SYSTEM32\CONFIG\SOFTWARE

* Stop: c0000218 {Registry File Failure} The registry cannot load the hive (file): \SystemRoot\System32\Config\SOFTWARE or its log or alternate

* System error: Lsass.exe
When trying to update a password the return status indicates that the value provided as the current password is not correct.

Be careful using this procedure in other circumstances or with an OEM version of Windows XP since OEM installations create passwords and user accounts that did not exist previously and may cause you not to be able to log into the Recovery Console to restore files.

Booting into the Recovery Console

You'll need to use the Windows XP Recovery Console to fix a corrupted registry, this will either require you to boot from a Windows XP Installation CD or boot directly to the Recovery Console if its installed. Follow these steps to boot into the Recovery Console from a Windows XP Installation CD.

1) Place your Windows XP in the CD-ROM Drive
2) Restart your computer and make sure your BIOS is set to boot from CD
3) When you see the following command press the space bar.

"press any key to boot from cd..."

4) Wait until you see the "Welcome to Setup" screen, and press R to start the Recovery Console
5) Choose which Windows installation you wish to load (this is usually #1 unless you have a multi-boot system)
6) Type the administrator password and Press Enter
7) You should now be at the C:\Windows> prompt

Copy Repair Files Using the Recovery Console

This procedure assumes Windows is installed on Drive C, if you have installed Windows on another drive, please substitute the appropriate drive letter in the procedure below.

At the Recovery Console command prompt, type the following lines, pressing ENTER after you type each line:

md tmp
copy c:\windows\system32\config\system c:\windows\tmp\system.bak
copy c:\windows\system32\config\software c:\windows\tmp\software.bak
copy c:\windows\system32\config\sam c:\windows\tmp\sam.bak
copy c:\windows\system32\config\security c:\windows\tmp\security.bak
copy c:\windows\system32\config\default c:\windows\tmp\default.bak

delete c:\windows\system32\config\system
delete c:\windows\system32\config\software
delete c:\windows\system32\config\sam
delete c:\windows\system32\config\security
delete c:\windows\system32\config\default

copy c:\windows\repair\system c:\windows\system32\config\system
copy c:\windows\repair\software c:\windows\system32\config\software
copy c:\windows\repair\sam c:\windows\system32\config\sam
copy c:\windows\repair\security c:\windows\system32\config\security
copy c:\windows\repair\default c:\windows\system32\config\default

Type exit to quit Recovery Console. Your computer will restart, press F8 as it starts and choose Safe Mode.

Restart in Safe Mode and Find a Recent Snapshot Backup

Restart your computer in Safe Mode by pressing F8 during the initial bootup and choosing Safe Mode. Once in Safe Mode, you need to make sure the files and folders are visible so you can access them. Follow these instructions to accomplish this.

1. Open My Computer
2. Click on the Tools menu, then click Folder Options.
3. Click the View tab.
4. Under Hidden files and folders, click to select Show hidden files and folders, and then click to clear the Hide protected operating system files (Recommended) check box.
5. Click Yes when the dialog box that confirms that you want to display these files appears.

In My Computer, Double-click the drive where you installed Windows XP (usually Drive C) to display a list of the folders. then double-click on the "System Volume Information" folder. This folder contains the system restore points stored on your computer. The folders will look similar to

_restore{EE42BEB8-700A-495F-8004-53D26C2E12C5}

You might receive an access denied error message similar to the following when trying to access the System Volume Information folder.

C:\System Volume Information is not accessible. Access is denied.

This is generally caused because the user you are logged in under does not have permissions set on the folder. To fix this, follow the instructions in the Microsoft Knowledge Base article 309531 to gain access and continue. Each version of Windows XP is different on how to change these permissions.

Once you have access to the snapshots, use the instructions below to copy one of the latest snapshots to the Windows\TMP directory so you have access to it.

1) In the System Volume Information Folder, click on View, and then click Details to display the date of each snapshot folder.
2) Double-click on a folder that was not created at the current time but rather before the problem started.
3) Double-click on the Snapshot subfolder
4) Using your normal windows copy and paste techniques, highlight the following files and copy them into the C:\Windows\TMP folder

* _REGISTRY_USER_.DEFAULT
* _REGISTRY_MACHINE_SECURITY
* _REGISTRY_MACHINE_SOFTWARE
* _REGISTRY_MACHINE_SYSTEM
* _REGISTRY_MACHINE_SAM

5) Rename the files that you just copied into the C:\Windows\TMP folder by right-clicking on each filename and choosing Rename, then typing the new name. Repeat this for each file in the list below.

* Rename _REGISTRY_USER_.DEFAULT to DEFAULT
* Rename _REGISTRY_MACHINE_SECURITY to SECURITY
* Rename _REGISTRY_MACHINE_SOFTWARE to SOFTWARE
* Rename _REGISTRY_MACHINE_SYSTEM to SYSTEM
* Rename _REGISTRY_MACHINE_SAM to SAM

6) Once you have renamed the files, restart your computer again with the Recovery Console (refer to the instructions above to do this)

Replace the Repair Files with a Current Backup of the Registry

After rebooting the computer and starting the Recovery Console again, type the following commands at the prompt to replace the files with a current backup. You'll need to press Enter after each command.

del c:\windows\system32\config\sam
del c:\windows\system32\config\security
del c:\windows\system32\config\software
del c:\windows\system32\config\default
del c:\windows\system32\config\system

copy c:\windows\tmp\software c:\windows\system32\config\software
copy c:\windows\tmp\system c:\windows\system32\config\system
copy c:\windows\tmp\sam c:\windows\system32\config\sam
copy c:\windows\tmp\security c:\windows\system32\config\security
copy c:\windows\tmp\default c:\windows\system32\config\default

After the files have been replaced, type EXIT at the command prompt to restart Windows in normal mode.

Use System Restore to Return to a Good Backup Point

Because there is more to a System Restore than just the registry files, follow these steps to restore your computer to a good backup point.

1. Click Start, and then click All Programs.
2. Click Accessories, and then click System Tools.
3. Click System Restore, and then click Restore to a previous Restore Point and finish the restore.

windows limited connectivity issue xp sp2

"This connection has limited or no connectivity. You might not be able to access the Internet or some network resources. "

Solutions to the problem are varied, however most of the solutions found on the web just mask the problem by simply guiding the user through turning off this notification. Now this solution may work great for systems that are showing a false positive error, but what if the system genuinely has lost its local area connection or the connection is unstable, what then?

One possible answer involves a bug in Service Pack 2 of Windows XP dealing with a loss of network connectivity for workstations that use Microsoft’s L2TP-based virtual private networking (VPN) client to connect to servers that are connected to NAT-based networks. However, this bug seems to appear in situations that are not associated with VPNs either.

If patching Windows XP for this bug does not fix the problem, read through the list below of other causes and fixes. You may have to reinstall your firewall, rebuild the configuration in your router, drop your connection speed from 100Mbps to 10Mbps, or assign static IP addresses to your computers in the network to resolve this issue.

How do I know if my system is affected by this bug?

If you have installed Windows XP Service Pack 2 and are experiencing any of the following symptoms, this bug is affecting your system.

*

After installing Windows XP SP2, your network connection reports a problem with "Limited or No Connectivity"
*

You have trouble connecting to the Internet or your local area network after installing Windows XP Service Pack 2.
*

Your network connection gets stuck "Acquiring IP Address"

What Steps Can I Take to Fix This Problem?

If you are receiving this error, you should run the Microsoft patch (KB884020) for it. Follow the instructions below to do this. Alternatively, you can download a zip file with the patch, registry file, and instructions by clicking here.

1) Download the patch from Microsoft's site
2) Run the update to install it
3) Run this short Registry fix to complete the update. Type the following lines in Notepad and save the file as FixReg.reg on your desktop, then double click on it to install into your registry.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\IPSec]
"AssumeUDPEncapsulationContextOnSendRule"=dword:00000002

4) Reboot your computer

If you experience the error message again, reboot your computer first. In most cases this will solve many connectivity issues that are not associated with this SP2 bug.

My Connection Works, Can I just disable the warning message?

If your local area connection is working properly and you simply want to disable the warning message follow these steps.

1) Open Control Panel
2) Open Network Connections and Right Click on the Local Area Connection and click on Properties
3) Uncheck the following option on the General Tab

"Notify me when this connection has limited or no connectivity"

4) Click OK and close the Network Connections window

What If Installing this Patch Doesn't Help?
Other Causes For This Problem

If you are still experiencing this error message even after running the patch shown above, you may be experiencing one of several problems shown below:

1) Your Network or DSL router may have bad or missing information. Powercycle your router and/or rebuild the configuration in your router.

2) Double-check your cabling to the computer. Make sure you have the correct type of cabling, straight-through CAT 5 or possibly a crossover cable and try another cable or test the cable to make sure its working properly.

3) Check your network card to make sure its configured correctly and working properly. Many times setting the network card to 10Mbps/Full Duplex will solve this issue. To do this, open Control Panel, System, Device Manager. Go to the properties of the Network card, click on the Advanced tab and find the Link Speed and Duplex section. Change it from Auto Detect to 10Mbps/Full Duplex.

4) Check and test your firewall. Your firewall, especially if its a software firewall like ZoneAlarm, Black Ice, Norton Firewall or something else could be blocking the connection. Disable your firewall and test the connection. You may have to resolve the problem by even uninstalling and reinstalling the firewall.

5) Check your IP address assignments and workgroup settings in the computer for accuracy. Statically assign IPs to the computers in your network.

6) Reset your TCP/IP stack by downloading and running WinsockXPFix.exe a Visual Basic program designed to fix corrupted TCP/IP issues, host file problems and a variety of other connectivity issues.

Boost your PC startup

One of the questions I am often asked is how to speed up the time it takes Windows to load or boot. There are a variety of factors (both hardware and software) involved in lowering the amount of time it takes for Windows to load. I will go over most of these ways in this page starting with changes in the system BIOS and moving onward from there.

All of these changes are optional, and do not need to be carried out. Instead, they are offered as suggestions to try to lower the time it takes for Windows to boot. Some of these changes are very advanced and should only be attempted if you are comfortable with making the changes and have your data backed up.



System BIOS Changes

One of the first places to help speed boot time in Windows is to make some simple changes to the system BIOS. The BIOS or Basic Input/Output System is a set of instructions and commands built into the motherboard that allows the computer to know what type of hardware is connected and how to communicate with that hardware. You'll first have to gain access to the BIOS setup screen to make any changes. Do not make changes to the system settings in the BIOS lightly, one mistake can render the computer unbootable and cause more problems than its worth. For this reason, do not attempt making changes to the system BIOS unless you are willing to accept the risk along with it. With that said, you'll want to follow the directions below and make some simple changes to speed up the boot process.

1) You must start with the computer completely off, not in sleep or hibernation mode. Then turn the computer on.

2) Enter the system BIOS screen by the manufacturers suggestion. Depending on the computer, this may involve pressing the DEL key, pressing F1, Pressing F10, holding down CTRL-ALT-S, or a variety of other keystrokes to get to the BIOS screen. For a more complete list of keystrokes to enter the BIOS screen, visit Michael Steven's page on the subject.

3) Once in the BIOS setup, look for a BOOT menu and select it with your keyboard arrow keys, Tab, and Enter.
4) In most modern BIOS screens, you'll find an option for Quick Boot. Enable this to skip memory tests and other minor Power On Self Tests (POST).

Quick Boot Mode

5) Find an option for Boot Device Priority next, and change the first boot device to be the hard drive. Changing this option will speed up the boot process, but it will also not allow the computer to boot from a floppy disk or CD-ROM. If booting from anything other than the hard drive is important to you, please skip this step. If later on, you need to boot from a CD-ROM, simply re-enter the BIOS setup and make the CD-ROM the first boot device.

Boot Device Priority

6) Choose the option to Exit and Save Changes and the computer will reboot.

There are other options in the BIOS to speed up boot time such as choosing the exact settings for your hard drive, and disabling AUTO DETECT of hard drives and other media. However I am skipping those changes and leaving them for a later discussion.

Changes to Windows Settings

The next group of changes to consider will be to the many Windows settings. We will use a handy tool called the System Configuration Utility to accomplish most of these changes. Follow the steps below to open and use this tool.

Startup Tab Changes

1) Click on Start, Run and type MSCONFIG and press Enter

2) Click on the STARTUP tab in the System Configuration Utility to view all the items that begin on Startup. An example is shown below.

MSCONFIG Startup Tab

Each item on the Startup tab that is checked loads immediately after Windows starts. If there are lots of items here, this will slow down the boot time for Windows considerably. Each of these items can be toggled on or off simply by using the checkmark box to the left of the item.

The column directly to right of the checkmark is the Name of the program, while the next column over is the location on the hard drive or other device of the file. Finally the last column shows where in the computer the file is started from. This location could be in the registry as is the case with all the locations that begin with HKLM or HKCU, or it could be in the Windows Startup folder found under ALL PROGRAMS in Windows XP.

You can examine each of these startup items and uncheck any that are not necessary. How do you know which ones are not necessary? Well, in most computer configurations, you'll want drivers running for your graphics or video controller and sound card, and most likely an antivirus and firewall running. Other startup items are usually extras that could be eliminated from boot up. To discover what a particular item is used for, jot down the name for the item and go over to a site called Process Library, type in the name of the process and click Find. This is a very handy tool for discovering which startup items are truly needed.

When you are done modifying the checkmarks to the Startup tab, click OK and you'll be asked to reboot the system.

Windows Services Changes

Once the computer is rebooted, click on Start, Run and type MSCONFIG and press Enter again. This will reopen the System Configuration Utility. Click on the Services tab, then click on the option at the bottom called "Hide All Microsoft Services" to see what unnecessary Windows services are running that can be removed. Generally speaking, you want services related to your video/sound cards and antivirus or firewall programs left running. Other services may not be essential and can be removed. Remember to only remove unessential services or you risk experiencing boot problems. Use Google to search for information on unfamiliar services. Another good resource is Black Viper's Strange Services page.

Windows Services in MSCONFIG


Hardware Changes to Increase Boot Time

Adding more Memory (RAM)

Other than upgrading the motherboard and CPU, you can generally increase the amount of RAM in your computer to make it load programs and applications faster and provide a more enjoyable computing experience. You'll want to check your motherboard to make sure you have available slots and the maximum amount of RAM you can add to your particular motherboard.

Replacing your Hard Drive with a Faster RPM Drive

If you have a slower hard drive such as a 5400 RPM or slower, you may want to consider upgrading to a faster 7200 RPM
hard drive. The difference in RPM speed will generally be quite noticeable.

Changing to Static IP

If your computer is connected to a local area network that you control and you have a DHCP server enabled on your router, during the boot process the computer queries the network to valid IP address. You can shave seconds off your boot time by assigning a valid IP address to your computer instead of using DHCP to assign it. To setup a Static IP for your computer, follow these directions.

1) Click on Start, Run
2) Type NCPA.CPL and press Enter to open the Network Connection Control Panel
3) Right-click on the Local Area Connection and choose Properties
4) Click on Internet Protocol (TCP/IP) and click Properties
5) You should see a screen similar to the one below. Fill in your static IP, subnet, default gateway, and DNS server information and click OK. If you aren't sure of your IP ranges on your router, consult your router manual or a friend that is more knowledgeable in networking terminology. Again, this is an optional item and does not necessarily need to be accomplished. Using DHCP is fine, although you sacrifice a few seconds for an IP to be assigned to from the network.

Assigning a Static IP Address

Switching from Master/Slave to Cable Select

In a recent article, I talk about how changing the configuration on the hard drive from Master to Cable Select reduced the boot time on this particular machine by 2 minutes.

Other Windows Performance Tips

Reduce the Number of Fonts installed

Every font that is installed in Windows has to load when Windows starts. The more fonts you have installed, the slower Windows loads. Although you can safely have around 1000 fonts loaded in Windows, I like to keep my font list closer to 300-500 or fewer if possible. There are certain fonts that are definitely required by Windows, so be careful in removing any fonts from your computer unless you know they are not needed. Fonts such as Verdana,Arial,Trebuchet, Tahoma, Tahoma, Times New Roman, MS Sans Serif, and Courier New should be left on your system. Follow the directions below to remove extra fonts from Windows XP.

1) Open My Computer
2) Double-click on Drive C
3) Click on File, New Folder and title it Fonts Backup
4) Double-click on the Windows folder to open it
5) Double-click on the Fonts folder
6) Highlight the fonts you wish to remove, click on Edit and choose COPY
7) Navigate back to the C:\Fonts Backup folder and PASTE these fonts into your backup folder
8) Return to the Fonts Folder and right-click on any fonts you previously copied to the backup folder, then choose Delete.

If you accidentally removed a font, simply reverse the procedure by copying and pasting the font back into the Windows\Fonts folder.

Disk Cleanup, Scandisk, and Defrag

Performing regular hard drive maintenance on your computer every few months will not only catch problems before they cause serious damage but also make your hard drive run at its optimal level. Follow these instructions to clean up the drive and defrag it.

1) Open My Computer
2) Right-click on the hard drive usually Drive C
3) Click on the Tools tab
4) Under Error Checking, click on Check Now. Optionally, you may want to check the boxes to "Automatically Fix File Errors" and "Scan For and Attempt Recovery for Bad Sectors"
5) Next, click on the General tab and click on Disk Cleanup. After the computer calculates the amount of files to remove, place a checkmark next to the type of files you wish to remove and click Ok. Read the descriptions for each type of file to determine if you should delete it.
6) Finally, click on the Tools tab again and under Defragmentation click Defragment Now
7) Click on the hard drive you wish to defrag, click on Analyze and then click on Defragment. This process may take some time to complete.

Virus/Spyware Scans

Finally, you'll want to complete a thorough virus and spyware scan of your system. I recommend running an online virus scan first, then a check for spyware. You can click on the following links to check your system for viruses.

Online Virus Scanners

Trend Micro Housecall
BitDefender Scan Online
Ewido Online Scanner
Jotti's Online Malware Scan
Kaspersky Online Scanner
Panda Activescan
McAfee FreeScan
eTrust Antivirus Web Scanner
Symantec Security Check
Dr.Web Online Check

Trojan Scanner
TrojanScan by WindowsSecurity.com

Spyware Scanners

Lavasoft Ad-Aware SE 1.06
Spybot Search and Destroy 1.4
Microsoft Windows Defender
Using a Different Antivirus, Firewall, or AntiSpyware Program

If your computer is still running slow after changing and checking all of these options, it might be time to use a different program for antivirus, firewall, or antispyware security. A blog on the net called The PC Spy has a graph displaying the boot delay time from most of the popular products on the market including Symantec, McAfee, Trend Micro, ZoneAlarm, and more.

Not surprisingly, Symantec's Internet Security products top the list with a 40+ % boot delay, followed by Panda Antivirus, and Zone Alarm. So, while these products may help prevent infections and attacks, they also are contributing greatly to the slowdown your computer is experiencing. Avast, AVG, NOD32, and others perform much better according to this chart.

Tips or Myths

There are other miscellanous tips on the web that may help speed up the Windows boot time, but there are also some very controversial ones.

Emptying the Windows Prefetch Folder

The Prefetch folder found at C:\WINDOWS\PREFETCH is often a source of controversy concerning its effect on boot time. This folder preloads some applications to enable faster opening of the most used programs. There are tips on the web that point to changing a registry value or emptying the prefetch folder will improve boot time. From my experience, deleting the contents of the prefetch folder DOES NOT improve boot time and only slows the time required to open programs. There is a limit to how many items will be loaded into the folder so it doesn't get overloaded, so why would anyone empty this folder when its purpose is to speed up loading of applications. You can read more about the Prefetch Myth on XP Myths.

Disable the Windows Boot Logo

Many sites recommend disabling the animated Windows boot logo to help speed up the time it takes to boot. Although it may decrease the time by a couple seconds, the anxiety caused by facing a blank screen and wondering if Windows has stalled or froze during bootup outweighs the second or two you may save. Although if you wish to disable the Windows boot logo, follow these steps:

1) Click on Start, Run and type MSCONFIG and press Enter
2) Click on the BOOT.INI tab
3) Click the NOGUIBOOT checkbox and click OK
4) Reboot the computer

Using BootVis

When Windows XP first came out, Microsoft had a utility called BootVis, which was a performance tracing tool that Microsoft developed from software developers and system designers. It was used to identify performance issues while developing new PC products, but is no longer distributed. Microsoft states on their web page for BootVis

"Please note that Bootvis.exe is not a tool that will improve boot/resume performance for end users. Contrary to some published reports, Bootvis.exe cannot reduce or alter a system's boot or resume performance. The boot optimization routines invoked by Bootvis.exe are built into Windows XP. These routines run automatically at pre-determined times as part of the normal operation of the operating system."

I personally have tried Bootvis and saw a couple seconds improvement on overall boot time, but nothing extreme in lowering overall bootup speed.

Conclusion

Although I tried to include as much information as possible in this article, I have intentionally left some tips, hacks, and changes out. The basic steps in this article should improve your system boot up time considerably which in turn should give you a happier computing experience.

Wednesday, October 3, 2007

Full TCP/IP reinstallation - error code 2

netsh int ip reset resetlog.txt >>> no effect
non-full reinstall of TCP/IP using only the have disk method. >>> no effect
netsh Winsock reset >>> no effect
http://www.snapfiles.com/get/winsockxpfix.html >>> no effect
reinstalling network card >>> no effect

MY SOLUTION:::

Step #1
Full uninstall of TCP/IP ... no ********.
----------------------------------------------------------------------
These steps are copied from http://support.microsoft.com/kb/325356
11. Locate the Nettcpip.inf file in %winroot%\inf, and then open the file in Notepad.
12. Locate the [MS_TCPIP.PrimaryInstall] section.
13. Edit the Characteristics = 0xa0 entry and replace 0xa0 with 0x80.
14. Save the file, and then exit Notepad.
15. In Control Panel, double-click Network Connections, right-click Local Area Connection, and then select Properties.
16. On the General tab, click Install, select Protocol, and then click Add.
17. In the Select Network Protocols window, click Have Disk.
18. In the Copy manufacturer's files from: text box, type c:\windows\inf, and then click OK.
19. Select Internet Protocol (TCP/IP), and then click OK.
Note This step will return you to the Local Area Connection Properties screen, but now the Uninstall button is available.
20. Select Internet Protocol (TCP/IP), click Uninstall, and then click Yes.
RESTART

succesfull uninstallation of TCP/IP will remove numerous keys from the registry including
HKLM/system/CurrentControlSet/services/tcpip
HKLM/system/CurrentControlSet/services/dhcp
HKLM/system/CurrentControlSet/services/dnscache
HKLM/system/CurrentControlSet/services/ipsec
HKLM/system/CurrentControlSet/services/policyagent
HKLM/system/CurrentControlSet/services/atmarpc
HKLM/system/CurrentControlSet/services/nla
These represent various interconnected and interdependant services.

For good measure you should delete the following keys before reinstalling TCP/IP in step #2
HKLM/system/CurrentControlSet/services/winsock
HKLM/system/CurrentControlSet/services/winsock2

Step #2
Reinstall of TCP/IP
----------------------------------------------------------------------
Following the above substep #13, replace the 0x80 back to 0xa0, this will eliminate the related "unsigned driver" error that was encountered during the uninstallation phase.

Return to "local area connection"> properties > general tab > install > Protocol > TCP/IP

You may receive an "Extended Error" failure upon trying to reinstall the TCP/IP, this is related to the installer sub-system conflicting with the security database status.

to check the integrity of the security database
esentutl /g c:\windows\security\Database\secedit.sdb

There may be a message saying database is out of date
first try the recovery option
esentutl /r c:\windows\security\Database\secedit.sdb

this did not work for me, I needed the repair option
esentutl /p c:\windows\security\Database\secedit.sdb

rerun the /g option to ensure that integrity is good and database is up to date.

Now return to the "local area network setup"
choose install > protocol > tcp/ip and try again

reboot..


Finally try to get a correct tcpip.sys file and replace the existing one at this location or maybe its not there at all...c:\windows\system32\drivers....

you want a good tcpip.sys try at this website...

http://trustyfiles.com/help-sw-xpsp2.php