Knoda is a graphical database frontend for KDE

3 settembre 2009 - Fonte: http://linuxlandit.blogspot.com/

knoda Description

Knoda is a graphical database  frontend for KDE. Knoda allows you to:
* define and delete databases;
* create, alter, and delete tables, indexes, and referential integrity;
* add, change, and delete data in tables;
* define, execute, and store SQL queries;
* define, execute, and store queries...

Leggi il seguito »

Nessun commento »

Inserito in , , ,

Showing Databases, Tables, and Columns

15 maggio 2009 - Fonte: http://linuxlandit.blogspot.com/
Mysqlshow can be used to quickly look at which databases exist, their tables, and the table’s
columns.
With the mysql program you can get the same information with the SHOW commands.

mysqlshow is invoked like this:
shell> mysqlshow [OPTIONS] [database [table [column]]]
• If no database is given, all matching databases are shown.
• If no table is given, all matching tables in the database are shown.
• If...

Leggi il seguito »

Nessun commento »

Inserito in , ,

MySQL Databases Overview

13 maggio 2009 - Fonte: http://linuxlandit.blogspot.com/
bdb_cache_size The bu er that is allocated to cache index and rows for BDB tables.
If you don’t use BDB tables, you should start mysqld with --skip-bdb to not waste
memory for this cache.
bdb_log_buffer_size The bu er that is allocated to cache index and rows for BDB
tables. If you don’t use BDB tables, you should set this to 0 or start mysqld with
--skip-bdb to not waste memory for this cache.
bdb_home The value of the --bdb-home option.
bdb_max_lock The maximum number of locks (1000 by default) you can have active on
a BDB table. You should increase this if you get errors of type bdb: Lock table is out
of available locks or Got error 12 from ... when you have do long transactions or
when mysqld has to examine a lot of rows to calculate...

Leggi il seguito »

Nessun commento »

Inserito in , ,

MySQL: String Collating Support

13 maggio 2009 - Fonte: http://linuxlandit.blogspot.com/
If the sorting rules for your language are too complex to be handled with the simple sort_
order[] table, you need to use the string collating functions.
Right now the best documentation on this is the character sets that are already imple-
mented. Look at the big5, czech, gbk, sjis, and tis160 character sets for examples.
You must specify the strxfrm_multiply_MYSET=N value in the special comment at the top
of the file. N should...

Leggi il seguito »

Nessun commento »

Inserito in , ,

MySQL: Optimize and Repair Tables

13 maggio 2009 - Fonte: http://linuxlandit.blogspot.com/
You can, in most cases, also use the command OPTIMIZE TABLES to optimise and repair
tables, but this is not as fast or reliable (in case of real fatal errors) as myisamchk. On the
other hand, OPTIMIZE TABLE is easier to use and you don’t have to worry about ushing
tables. See Section 4.5.1 [OPTIMIZE TABLE], page 226.

Even that the repair in myisamchk is quite secure, it’s always a good idea to make a backup
BEFORE doing...

Leggi il seguito »

Nessun commento »

Inserito in , , , , ,

Database Administration Language Reference

12 maggio 2009 - Fonte: http://linuxlandit.blogspot.com/
OPTIMIZE TABLE Syntax
OPTIMIZE TABLE tbl_name[,tbl_name]...
OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have
made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB,
or TEXT columns). Deleted records are maintained in a linked list and subsequent INSERT
operations reuse old record positions. You can use OPTIMIZE TABLE to reclaim the unused
space and to defragment...

Leggi il seguito »

2 commenti »

Inserito in , ,

MySQL Client-Side Scripts and Utilities

12 maggio 2009 - Fonte: http://linuxlandit.blogspot.com/
Overview of the Client-Side Scripts and Utilities
All MySQL clients that communicate with the server using the mysqlclient library use
the following environment variables:
Name Description
MYSQL_UNIX_PORT The default socket; used for connections to localhost
MYSQL_TCP_PORT The default TCP/IP port
MYSQL_PWD The default password
MYSQL_DEBUG Debug-trace options when debugging
TMPDIR The directory where temporary tables/files...

Leggi il seguito »

Nessun commento »

Inserito in ,

Adding New Users to MySQL

12 maggio 2009 - Fonte: http://linuxlandit.blogspot.com/
You can add users two di erent ways: by using GRANT statements or by manipulating the
MySQL grant tables directly. The preferred method is to use GRANT statements, because
they are more concise and less error-prone. See Section 4.3.1 [GRANT], page 193.
There are also a lot of contributed programs like phpmyadmin that can be used to create
and administrate users. See Section 1.6.1 [Portals], page 23.
The examples below show how...

Leggi il seguito »

1 commento »

Inserito in , , , ,