databases
OpenOffice.org 3.3.0 RC2- A multi-platform office productivity suite
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 [...]
How to Backup the entire Mysql Server Databases
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
10 of the Best Free Linux Relational Databases
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 puts database in hand, on iPhone
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 [...]
How to display the first lines of a file in Linux
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 [...]
How to Generate reports from archived databases – Websense
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 [...]
How to Backup and Restore Mysql Databases
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 [...]
How to Monitor MySQL’s performance
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 [...]
Script to backup all mysql database and upload to FTP
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.
How to Get IP geolocation on Ubuntu with MaxMind geoip
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.
How to use a local MySQL database to do IP addresses geolocation
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 [...]
How to Install Elgg – An open, flexible social networking engine
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 [...]
How to Create tables in Mysql – PHP & MySQL Code
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 [...]