2012/8/13 Alan DeKok <[email protected]> > 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 > >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
