Archive for October, 2008
mySQL: How to backup/restore SQL databases through SSH
by Ali on Oct.30, 2008, under Linux, SQL
To backup your database through SSH (create SQL dump):
mysqldump --opt -u user -p dbname > {path}/backup.sql
To restore:
mysql -u user -p dbname < {path}/backup.sql
Windows: Cannot add Active Directory Users and Computers snap-in in Windows XP 64 bit
by Ali on Oct.30, 2008, under Windows
AD Users and Computers, and a few other administrative snap-in’s are 32 bit components. To add those snap-in’s to your mmc you will have to run mmc with /32 switch.
In order to be able to save your console for future use and be able to access all 32 and 64 bit components, you need to save two copies. Run an instance using mmc.exe and the other mmc.exe /32, then save both with different names you can recognize.
Windows: Fixed size pop-up window is smaller than the contents and cannot be resized
by Ali on Oct.30, 2008, under Windows
This usually happens on laptops where resolution is high and font size is set to large or custom. Simply change your font size in display properties – Settings tab – Advanced and reduce font size until all page is visible. You may have to reboot and will need to have administrative privileges to change font size.
Debian: Sync time and date with external servers
by Ali on Oct.30, 2008, under Debian
Install ntpdate:
aptitude install ntpdate
To update manually:
ntpdate <time server> (ntpdate pool.ntp.org or ntpdate time.nist.gov)
Create a cron job to have your server sync at intervals you like.
Windows: Create an administrative package for network/GPO deployment for Adobe Acrobat product family
by Ali on Oct.29, 2008, under Windows
Search for Adobe Customization Wizard 9 (8 for Acrobat 8.0 family). Install and run the programs. You will be asked to navigate to location where you .msi file is… the rest is easy!
Adobe Customization Wizard can be used for the following Adobe software:
Adobe Acrobat 3D
Adobe Acrobat Professional
Adobe Acrobat Standard
Adobe Acrobat Elements
Adobe Reader