Hi There,
We are reaching 4GB with one of our tables (v4.1 on debian sarge) and
are needing to run:
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;
as per the documentation.. I would be greatful for any input on best
practices to do this, as the database needs to be offline for the
absolute minimal amount of time.... so the fastest process that i can
think of would be:
1). Backup everything! :)
2). mysqldump the table to a file
3). drop the table
4). recreate the table structure
5). do the alter
6). import the data back in
Other questions are... can the alter be done to live data? how does this
work?
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]