MySQL Forums
Forum List  »  Newbie

Will increaseing table size affect current data?
Posted by: Connor Brannigan
Date: September 04, 2009 09:33AM

Hi There,

I have just hit the max table size default for MySQL (4Gbish) and I want to run the following query against it in order to increase the max size:

ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=50;

Want I want to know is, will running this query affect in any way the data currently being held in the table?

Thanks for any and all answers!


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.