Month: March 2009

How to Backup and Restore a MySQL Database Using mysqldump

How to Backup a MySQL Database With mysqldump 

mysqldump -u userNameWithPrivileges -p databaseName > outputFileName.sql

How to Restore a mysqldump Backup 

mysql -u userNameWithPrivileges -p database < outputFileName.sql

* Replace “userNameWithPrivileges” with the username of a MySQL account that can read/write to the database being backed up / restored.

MySQL logo

How to Reset the Admin Password in ColdFusion MX 6

  1. Locate the “neo-security.xml” file in the \lib\ subdirectory of your ColdFusion install
  2. Find the following line in the file 
    <var name=’admin.security.enabled’><boolean value=’true’/></var>

    and change it to

    <var name=’admin.security.enabled’><boolean value=’false’/></var>
  3. Restart the ColdFusion Application Server service.
  4. Now you can log straight into the admin interface without being prompted for a password.
  5. Go to the change password screen for the admin interface and then set a new password. DO NOT CHECK THE BOX near the top labeled something like “Use password”. Just press the submit button after specifying a password.
  6. Now reedit the “neo-security.xml” file and change the variable back to “true”.
  7. Then restart the Coldfusion Application Server services again to put the changes into effect.
  8. You should not be able to log into the admin interface with the new password that you set.

ColdFusion

How to Enable ReadyBoost for an ExpressCard SSD in Vista

Sometimes after inserting a new SSD ExpressCard device into your Vista computer for the first time you may see the following message under the device’s “ReadyBoost” tab: “Device interface is not supported”. Do the following to enable ReadyBoost for the device (assuming the device is ReadyBoost compatible):

  1. Start up the “Disk Management” manager under: Right-click over Computer in the Start menu->Manage->Storage->Disk Management
  2. Find the SSD device and right-click over it to bring up its properties
  3. Select the Policies tab
  4. Choose the option “Optimize for performance”
  5. Drive will remount and ReadyBoost should now be enabled for the device

Note: You can change the policy back to the default of “Optimize for quick removal” and the ReadyBoost option will still be enabled for the device. So the fact that you have to initially change the policy for the device just to enable ReadyBoost is probably a bug. This behavior was observed on an HP Pavilion DV6871US notebook computer with an 8GB Lexar ExpressCard SSD.

Lexar 8GB SSD

Sendmail Hangs When Starting Up or When Using It with PHP

If you notice Sendmail hanging up for many minutes while starting up at boot or while being used such as sending an email from a PHP script, it is probably a DNS lookup problem. Ensure your /etc/hosts file has the appropriate entries for your server that sendmail is running on:

127.0.0.1       localhost localhost.localdomain
192.168.1.80    www.foo.com www
192.168.1.80    www.foo.com.

Replace “www.foo.com” and “www” with your server’s fully qualified domain name and host name respectively. Replace “192.168.1.80” with the IP address of your server. The last entry with the “.” at the end is critical so don’t forget it.

Terminal