admin

Posts By admin

• mac

  How do I find out how much RAM I have on my Mac OSX desktop, laptop, or server?

  From the command line (Terminal.app), you can run the following command: /usr/sbin/system_profiler SPHardwareDataType | grep Memory: The resulting output will look like...

• unix

  How do I enable the console in VMWare ESXi?

  Accessing the hidden & unsupported ESXi console so it can be accessed remotely is pretty easy to do, but there’s no easy...

• unix

  How do I determine what package a file belongs to on my Linux server?

  To find out what package a file belongs to, you can use the rpm command. To do so, just run rpm -qf...

• unix

  How do I adjust cups on my Linux server so it doesn’t stop on error?

  Sometimes communication errors occur and cups stops. To prevent this from happening, you can adjust the ErrorPolicy to use an alternate behavior....

• unix

  How do I resolve the cups error /usr/lib/cups/backend/lpd failed?

  When the cups server is in a stopped state with the StateMessage /usr/lib/cups/backend/lpd failed, you can review the file /var/log/cups/error_log. . What...

• database

  How do I query my MySQL database for a particular column?

  If you’re looking to find a particular column name on your MySQL server, you can use a query like the following: select...

• unix

  How do I run a local rsync backup to copy data on my Linux server?

  Using rsync to keep a local copy or migrate data is very useful because it picks up where it left off if...

• database

  How do I run a mysqldump on my MySQL Linux server?

  The following script can be used to create a mysqldump by schema name: #!/bin/bash TODAY=$(date +%m”-“%d”-“%Y) HOSTNAME=$(hostname -s) for db in $(echo...

• database

  How do I set up replication on my Linux MySQL database server?

  1. Install MySQL (mysql-server) on the master and slave servers if it’s not already installed. You can do so using ‘yum install...

• database

  How do I find active queries in my Oracle database?

  To find active queries in your Oracle database, you can use the following command: SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time FROM...