RE: missing data after partitioning an existing table

2014-05-23 Thread Roland RoLaNd
mysqldump file.. alter table  p3_dna_new  DISABLE KEYS; LOCK TABLES `p3_dna_new` WRITE; INSERT INTO p3_dna_new SELECT * FROM p3_dna_old;  ## It finishes after a while, with absolutely no error nor warning.  ## if i issue the following:  select count(*) from p3_dna_new;  ## it will be differen

RE: missing data after partitioning an existing table

2014-05-23 Thread Roland RoLaNd
SERT INTO p3_dna_new SELECT * FROM p3_dna_old; It finishes after a while, with absolutely no error nor warning. if i issue the following: select count(*) from p3_dna_new; it will be different than the result of select count(*) from p3_dna_old; If there's an issue, shouldn'

Re: missing data after partitioning an existing table

2014-05-23 Thread Christophe
Hi there, Le 23/05/2014 21:06, Roland RoLaNd a écrit : > [...] Ouch This post is somewhat ... unreadable ! Please format ! Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql