MySQL 5.6: I'm experimenting with copying data from one table to another in different ways. The source table is on a remote server and has about 500,000 rows - I use the federated engine to connect. I first tried this:
mysql > create table tgt as select * from src;
This is very fast, takes only a few seconds, but it gives warnings:
... | Warning | 1299 | Invalid TIMESTAMP value in column 'created_timestamp' at row 265975 | | Warning | 1299 | Invalid TIMESTAMP value in column 'created_timestamp' at row 265976 | ... 64 rows in set (0.00 sec)
I tried instead to do it with a stored procedure, opening a cursor, fetching rows and inserting them, but it takes forever; I canceled after 10 min.
So, is there a way to locate the rows that cause the problem? I tried
select ... limit #first_row,#last_row;, but it doesn't appear to work, and I'm not sure if it is entirely reliable any way.