MySQL Forums :: Newbie :: Will increaseing table size affect current data?


Advanced Search

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!

Connor

Options: ReplyQuote


Subject Written By Posted
Will increaseing table size affect current data? Connor Brannigan 09/04/2009 09:33AM
Re: Will increaseing table size affect current data? Tao Yang 09/04/2009 01:37PM
Re: Will increaseing table size affect current data? Connor Brannigan 09/04/2009 01:53PM
Re: Will increaseing table size affect current data? Connor Brannigan 09/08/2009 06:50AM
Re: Will increaseing table size affect current data? Tom Melly 09/08/2009 06:54AM
Re: Will increaseing table size affect current data? Connor Brannigan 09/08/2009 11:41AM
Re: Will increaseing table size affect current data? Rick James 09/08/2009 09:16PM
Re: Will increaseing table size affect current data? Connor Brannigan 09/09/2009 07:12AM
Re: Will increaseing table size affect current data? Connor Brannigan 09/09/2009 03:01PM


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.