Free excel mysql import software for linux

MySQL Activity Report is a valuable database tuning aid.

The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.

The most important component of the MySQL Activity Report is mysqlard. This daemon collects the data from a MySQL server and stores these values in a Round Robin Database.

The mysqlard package also contains example graphing, cron and php scripts. The cron scripts can be used to keep archives of the generated graphics and the php script shows the generated graphics and tries to give some tuning tips.

Netacct-mysql is modified version of traffic accounting daemon net-acct which stores collected data in MySQL. It supports writing accounting information in a single line in MySQL per day for every IP (mrta style).
Netacct functions by analogy with sniffer, i.e. it keeps track of all the traffic passing through the network interfaces assigned by the configuration file. Data are stored in the memory and periodically saved in the database. The default data save period is 300 seconds (see option "flush" in the config file).
The application is used for accounting of the network traffic passed through your router/gateway. It is based on the libpcap library and functions as a userspace daemon. Options for dividing the network traffic into 4 categories:
- international
- peering
- direct
- local
The traffic accounts are saved in a database, and for the time being MySQL and Oracle are supported. As libpcap is used for gathering the network data the application runs (for the moment) on the following operating systems:
- Linux
- FreeBSD
- OpenBSD
- Solaris
For more detailed information regarding a particular OS, please read the FAQ file.
Enhancements:
- netacct.h:
- process.c:
- naccttab.sample:
- fixed disable fields in config file, now it works does not write some fields in dump file - fixed

MySQL Abstractor package contains PHP classes that implements a MySQL database abstraction layer.

It provides several classes. There is one for establishing connections and executing SQL queries, another for composing and executing SELECT, INSERT, UPDATE and DELETE queries from a list of parameters, and a wrapper class to simplify the usage of the other two classes.

Persistent::MySQL is a persistent class implemented using a MySQL database.

SYNOPSIS

use Persistent::MySQL;
use English; # import readable variable names like $EVAL_ERROR

eval { ### in case an exception is thrown ###

### allocate a persistent object ###
my $emp = new Persistent::MySQL($data_source, $username, $password, $table);

### define attributes of the object ###
$emp->add_attribute(empno, ID, Number, undef, 4);
$emp->add_attribute(ename, Persistent, VarChar, undef, 10);
$emp->add_attribute(job, Persistent, VarChar, undef, 9);
$emp->add_attribute(mgr, Persistent, Number, undef, 4);
$emp->add_attribute(hiredate, Persistent, DateTime, undef);
$emp->add_attribute(sal, Persistent, Number, undef, 7, 2);
$emp->add_attribute(comm, Persistent, Number, undef, 7, 2);
$emp->add_attribute(deptno, Persistent, Number, undef, 2);

### query the datastore for some objects ###
$emp->restore_where(qq{
sal > 1000 and
job = CLERK and
ename LIKE M%
}, "sal, ename");
while ($emp->restore_next()) {
printf "ename = %s, emp# = %s, sal = %s, hiredate = %sn",
$emp->ename, $emp->empno, $emp->sal, $emp->hiredate;
}
};

if ($EVAL_ERROR) { ### catch those exceptions! ###
print "An error occurred: $EVAL_ERRORn";
}

ABSTRACT

This is a Persistent class that uses a MySQL database table to store and retrieve objects. This class can be instantiated directly or subclassed. The methods described below are unique to this class, and all other methods that are provided by this class are documented in the Persistent documentation. The Persistent documentation has a very thorough introduction to using the Persistent framework of classes.

MySQLfs is Linux userspace filesystem which stores data in a MySQL database. The project uses FUSE to interface with the kernel.

Web Service Engine for MySQL is a storage engine for the MySQL database. The project takes basic SQL and translates this through the engine interface into HTTP request methods.
This gives you the ability to create, read, and delete pages on Web servers. Wikipedia becomes a table you can select on from your database.
Enhancements:
- Multiple attributes per table are now supported.
- The engine now handles tables with more than two columns by generating XML that is stored on the remote server.
- Tables with only two columns are stored as before, with the non-keyed attribute being directly provided to the remote provider.