Dnia 11 maja 2016 11:05 Marcin marcin@nicram.net napisał(a):
podejrzewam bardziej to, czyli prawa dostępu http://anothermysqldba.blogspot.com/2013/12/error-1356-hy000.html
Wg tego otrzymuje:
mysql> select * from customermailsview; ERROR 1356 (HY000): View 'lms.customermailsview' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysql>
mysql> show create view lms.customermailsview \G ERROR 1356 (HY000): View 'lms.customermailsview' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysql>
mysql> show grants for 'root'@'localhost'; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '***465FF1427CFDE787DFCD127C494370D51BF00*' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.04 sec)
mysql>
spróbuj użyć "-f" https://mysqltech.wordpress.com/2011/11/18/invalid-views-can-break-backups/
Idac tym przykladem mam to:
mysql> select VIEW_DEFINITION from information_schema.VIEWS where table_name = 'customermailsview'; +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | VIEW_DEFINITION | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | select `lms`.`customercontacts`.`customerid` AS `customerid`,group_concat(`lms`.`customercontacts`.`contact` separator ',') AS `email` from `lms`.`customercontacts` where ((`lms`.`customercontacts`.`type` = 8) and (`lms`.`customercontacts`.`contact` <> '')) group by `lms`.`customercontacts`.`customerid` | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set, 1 warning (0.01 sec)
mysql>
I teraz czy powyzsze cos wiecej mowia? Moze to nakieruje na rozwiazanie problemu. Narazie jeszcze "-f' nie zrobilem a chcialem pokazac te wyniki.
Moze ktos odplatnie mi to naprawi? :)
Osobiscie boje sie kombinowac zeby nie zepsuc bazy, ostatnia kopie sprawna mam z grudnia wiec za duzy bylby mlyn gdyby ta obecna baza padla calkiem.
pozdrawiam TD