rlm_sql Error

[Antonio Modesto]

2012/8/13 Alan DeKok <aland at deployingradius.com>

> Antonio Modesto wrote:
> > My tables is using MyISAM engine, as this server is running freeradius
> > 1.X, it's quite old. The problem is that I've dumped my database to
> > another server to do some tests, and tried to alter the engine to see
> > how long it would take, after some hours running I've simply given up.
>
>   Why alter the engine?  Just create a table on the new system, with the
> new engine.  Then, import the old data.
>
>   If you have data going back years, you're better off just starting
> over.  All old data stays on the old machine, and new data goes to the
> new machine.


I'm thinking I'll let on radacct just the rows for active sections, and put
the old acct data in a separate database. That's a lot of old radacct data.




> > I'm thinking about making a backup of this table and truncating it. As
> > it's not possible for us to wait so long to alter the table engine (We
> > don't have backup yet).
>
>   That's a problem.
>
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120813/4df732d9/attachment.html>