30
Oct/08
0

mySQL: How to backup/restore SQL databases through SSH

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
Tagged as: , ,
30
Oct/08
0

Windows: Cannot add Active Directory Users and Computers snap-in in Windows XP 64 bit

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.

Tagged as: ,
30
Oct/08
0

Windows: Fixed size pop-up window is smaller than the contents and cannot be resized

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.

Tagged as:
30
Oct/08
0

Debian: Sync time and date with external servers

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.

29
Oct/08
0

Windows: Create an administrative package for network/GPO deployment for Adobe Acrobat product family

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