Hello Christian -
On Sat, 27 May 2000, Christian Steger wrote:
> hello there!
>
> first of all i wonna say thanks, for the extrem fast and efficient reply to
> my problems
> regarding the radiator/radmin.
>
> everything is working fine.
>
> there is just one mor question i have:
>
> in fact that the accountingtable will growing and growing, does someone have
> a simple script where i can expire the RADIATORACCOUNTINGTABLE?
>
This is generally something your DBA would do, using the database tools
included with your database. In your case, with mySQL, you would use the
mysqldump utility.
Here is the help output from mysqldump:
mysqldump Ver 6.0 Distrib 3.22.24, for pc-linux-gnu (i586)
By Igor Romanenko, Monty, Jani & Sinisa. This software is in public Domain
This software comes with ABSOLUTELY NO WARRANTY
Dumping definition and data mysql database or table
Usage: mysqldump [OPTIONS] database [tables]
-a, --all Include all MySQL create options
-#, --debug=... Output debug log. Often this is 'd:t:o,filename`
-?, --help Display this help message and exit.
-c, --complete-insert Use complete insert statements.
-C, --compress Use compression in server/client protocol
-e, --extended-insert Allows utilization of the new, much faster
INSERT syntax
--add-drop-table Add a 'drop table' before each create
--add-locks Add locks around insert statements
--allow-keywords Allow creation of column names that are keywords
--delayed Insert rows with INSERT DELAYED
-F --flush-logs Flush logs file in server before starting dump
-f, --force Continue even if we get an sql-error.
-h, --host=... Connect to host.
-l, --lock-tables Lock all tables for read.
-t, --no-create-info Don't write table creation info.
-d, --no-data No row information.
-O, --set-variable var=option
give a variable a value. --help lists variables
--opt Same as --add-drop-table --add-locks --all
--extended-insert --quick --use-locks
-p, --password[=...] Password to use when connecting to server.
If password is not given it's solicited on the tty.
-P, --port=... Port number to use for connection.
-q, --quick Don't buffer query, dump directly to stdout.
-S, --socket=... Socket file to use for connection.
-T, --tab=... Creates tab separated textfile for each table to
given path. (creates .sql and .txt files).
NOTE: This only works if mysqldump is run on
the same machine as the mysqld daemon.
-u, --user=# User for login if not current user.
-v, --verbose Print info about the various stages.
-V, --version Output version information and exit.
-w, --where= dump only selected records; QUOTES mandatory!
EXAMPLES: "--where=user='jimf'" "-wuserid>1" "-wuserid<1"
Use -T (--tab=...) with --fields-...
--fields-terminated-by=...
Fields in the textfile are terminated by ...
--fields-enclosed-by=...
Fields in the importfile are enclosed by ...
--fields-optionally-enclosed-by=...
Fields in the i.file are opt. enclosed by ...
--fields-escaped-by=...
Fields in the i.file are escaped by ...
--lines-terminated-by=...
Lines in the i.file are terminated by ...
Possible variables for option --set-variable (-O) are:
max_allowed_packet current value: 25165824
net_buffer_length current value: 1047551
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
