MySQL error 1462 database.table contains view recursion
after exporting/importing a table from another database and renaming it as
such:
mysqldump -uroot -p --no-create-db db1 original_table > dump.sql
mysql -uroot -p db2 < dump.sql
mysql -uroot -D db2 -e 'RENAME TABLE original_table TO new_table;'
I try to select from the new table :
mysql -uroot -p
>use db2;
>select * from new_table;
and I get the following error :
ERROR 1462 (HY000): `db2`.`new_table` contains view recursion
I can't find much on google about this one, can anyone help? my mysql
version is 5.1.67-0ubuntu0.10.04.1
Thanks!
Chris
No comments:
Post a Comment