How can you backup WordPress’s database without server access? It is very easy to backup WordPress’s databasse by installing the WP-DB-Backup plugin. This plugin allows you to easily backup the database immeddiately as well as to schedule a hourly, nightly, or weekly backup of the database as well. It is highly recommended to backup not only…
Details
Below shows how to display the arp table in a Fortinet 200A device running FortiOS version 3.0 or higher. Short Answer: Type “get system arp” from the CLI You can just type “get sys arp” from the CLI of the Fortinet 200A to get the ARP table. If you are running a previous version of…
Details
Having a framework to automatically run all of your unit tests is important, but in a strongly dynamic language like Python, it can be difficult to find all of the tests to run in a batch. [nose][] makes the whole process much easier, by automatically finding all modules containing unittest.TestCase subclasses, allowing nonsubclassed simple test…
Details
Any administrator who is responsible for one or more MySQL servers has probably run across the indispensable [mytop][], but a similar tool for PostgreSQL is less well known. However, Cosimo Streppone has ported and converted [mytop][] to [pgtop][], a Perl package to provide the same functionality – monitoring of threads, performance, reads and writes per…
Details
With some of the security changes in Vista you can no longer release/renew IP addresses or flushdns with a normal user account even if that account is within the administrator’s group. When you attempt this with any user except for the “administrator” user you get the message: “The requested operation requires elevation” To get around this issue…
Details
Recently I worked on a network installation using Fortinet 200A firewalls. During the process of getting BGP operational with the colo provider they requested information about or BGP prefixes. They requested that we provide the output to “sh ip bgp” or “show ip bgp” to them.
Troel has written a great summary of the SQL standard for the timestamp data type along with its implementation in the big 5 databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and DB2). MySQL It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to…
Details
Rails’ ActiveRecord displays the exact SQL queries it performs into the development log. It is inconvenient to watch this log while you’re working in the `script/console` environment, however, and most advice for redirecting that log to STDOUT seemed not to work. Thanks to [Jamis Buck](http://weblog.jamisbuck.org/2007/1/31/more-on-watching-activerecord “More on watching ActiveRecord”), though, the solution has come to…
Details
Error: /usr/local/lib/ruby/1.8/irb/completion.rb:10:in `require’: no such file to load — readline (LoadError) When attempting to run irb you get the above error.
Details