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 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