OpenOffice.org is both an Open Source product and a project. The product is a multi-platform office productivity suite. It includes the key desktop applications, such as a word processor, spreadsheet, presentation manager, and drawing program, with a user interface and feature set similar to other office suites. Sophisticated and flexible, OpenOffice.org also works transparently with [...]
To backup the entire database of a Mysql Server use the mysqldump command, Please look at the below stated command.In that we are backing up the entire database to a file called dump_file21102009 mysqldump -u root -p –all-databases –master-data=2 > dump_file21102009
To provide an insight into the quality of software that is available, we have compiled a list of 10 open source Relational Database Management Systems. Hopefully, there will be something of interest here for anyone who wants to store data in an efficient way. More: continued here
HanDBase, fromÂ DDH Software, is an easy-to-use relational database system ported from Palm OS to theÂ iPhone. (HanDBaseÂ sells for $9.99 from iTunes.) The application ships with a starter gallery of databases that include a checkbook, customer list, shopping list, movie list, password keeper, and billing log. If none of the included databases meet your needs, you can [...]
Sometimes you may want to take a look at a file, only to the first lines of it, this is specially useful when you are watching at CSV files that you may be using to work with MySQL or PosgreSQL databases, in this cases what we need is to look at the head of the [...]
Reporter can generate reports from the current log database or from an archived log database. Use theÂ OptionsÂ dialog box to specify which log database to use when generating reports. To select a log database for reporting: SelectÂ OptionsÂ from the ReporterÂ ToolsÂ menu. TheÂ Select Data SourceÂ dialog box appears. Select theÂ Machine Data SourceÂ tab. Highlight the desired Data Source Name (ODBC connection [...]
Sometimes you may want to backup only one or more tables from a database. There are some practical reasons for wanting to do this. You may have a message board / forums application that uses MySQL to store its data and you want to create a brand new forum with the same users as the [...]
Here are some ideas, how you can monitor the database performance of your MySQL installation. Monitoring is always an iterative and continuous process. You need to learn what patterns are OK for your database and what are the signs of slight problems or even dangerous situations. Below are the main items you can use to [...]
This article uses postfix as the mail transport agent (MTA), as opposed to sendmail, the default MTA for CentOS. Dovecot is used to allow users to access their email by either imap or pop protocols. We assume a domain name of example.com which should be changed by the reader and can be either a real [...]
In this howto I will show you a simple bash script that dump ALL mysql databases on your server compressed to GZIP and then make a nice tar.gz file with them and upload it to the FTP of your choice.
MaxMind GeoIP is a collection of APIs for looking up the location of an IP address. It includes support for lookup of country, region, city, latitude, and longitude. Free GeoLite databases are available for the country and city.
Delivering content relative to the physical location of your users is an excellent (and fairly easy) way to fine-tune the content youâ€™re delivering to be most relevent to the people visiting your site. Two simple ways of doing this are to use an IP-based geolocation lookup, or to do a manual radius search (like a [...]
Sometime it is necessary to block incoming connection or traffic from specific remote host. iptables is administration tool for IPv4 packet filtering and NAT under Linux kernel. Following tip will help you to block attacker or spammers IP address. Â The blocklist is create with an API I wrote and you can use wget to update [...]
Elgg is an open, flexible social networking engine, designed to run at the heart of any socially-aware application. Building on Elgg is easy, and because the engine handles common web application and social functionality for you, you can concentrate on developing your idea. Elgg is open source. That means, when you use Elgg, you have [...]
Before you can enter data (rows) into a table, you must first define what kinds of data will be stored (columns). We are now going to design a MySQL query to summon our table from database land. In future lessons we will be using this table, so be sure to enter this query correctly! PHP [...]