IT knowledge base for systems administrators
Use this CMDLET to dispay the mailbox/user size usage for each of your users on your Exchange 2007 server in an easy to read formatted list.
Get-MailboxStatistics -Server SERVERNAME | Sort-Object -Property TotalItemSize | Format-Table DisplayName,TotalItemSize
You can go one step further and display the list in decending format which will place the people using the most [...]
Continue reading " Display Exchange 2007 mailbox size usage "
Are you looking for a free open source alternative to CPanel?
Check out http://www.syscp.de.
Here is a simple command that will retrieve the first name, last name, and email addresses from Active Directory.
dsquery user -name * -limit 500 | dsget user -fn -ln -email >
emails.txt
-limit command
You can change the “-limit 500″ value to whatever you would like the query limited to. IE: If you would only [...]
Continue reading " Export names and email addresses from Active Directory to CSV "
It’s easy to backup a MySQL database by using the MySQLdump command. Just follow the steps below:
mysqldump -u root -p halicom_wp > halicom.sql
You will be prompted for the MySQL password for your particular user.
Change the following variables for your specific environment:
root is the username for mysql
halicom_wp is the database name that you want to do [...]
Continue reading " Backing Up Your MySQL Databases With MySQLDump "
Once you have finished creating your website, and your content management software doesn’t automatically do it for you, you will want to generate a site map. This site map helps Google spider your site and understand how often it should check those pages for updates, the latest modification date, and how your website’s pages are [...]
Tellmatic is one of the best, full featured, open source PHP MySQL Newsletter Script. More information is available here: http://sourceforge.net/projects/tellmatic/
You can download Tellmatic here: http://sourceforge.net/project/showfiles.php?group_id=190396&package_id=223396&release_id=631831
Tellmatic Installation Instructions:
Unpack the archive file to your local harddisk.
Copy the directory tellmatic-[xxx] or the content of this directory completely to your server via ftp into a directory of your [...]
Continue reading " Free Open Source PHP MySQL Newsletter Script "
Change your root password using mysqladmin
If you currently do not have a root password set, follow these steps to setup root password for first time:
$ mysqladmin -u root password NEWPASS
To change your root password, then enter this command
$ mysqladmin -u root -p oldpassword NEWPASSWORD
You’ll then be prompted to enter your old password
Change MySQL password for [...]
