i use create raw data files mysql-master-slave replication,after setup,it's return table xxx doesn't exists when query on partitioned tables,but it's work ok on other tables.
and,when change use mysqldump, it's work ok.
can me fix problem?
if partition table did not work other tables did , mysqldump worked fine, best guess partitioned data not stored in same place rest of data. thus, when used tar, zip, or rsync method copy data directory, left out data made partitioned table. need locate partitioned data stored , moved on along rest of data directory.
based on comment below, however, have called famous schrodinger table. based on schrodinger's cat paradox, mysql thinks table exists, because shows when run show tables, not allow query of it; in exist not exist.
usually result of not copy on metadata (as in ibdata1 file, , ib_logfiles) correctly. 1 thing can test is, if possible, remove partition tables , try rsync again. if still getting error, has nothing fact table partitioned. then, test lead me believe did not copy data on correctly.
Comments
Post a Comment