Re: [lms] Dump bazy przerywa dzialanie - LMS 1.11.17
podejrzewam bardziej to, czyli prawa dostępu http://anothermysqldba.blogspot.com/2013/12/error-1356-hy000.html
W dniu 11 maja 2016 11:04 użytkownik Marcin marcin@nicram.net napisał:
spróbuj użyć "-f" https://mysqltech.wordpress.com/2011/11/18/invalid-views-can-break-backups/
W dniu 11 maja 2016 10:59 użytkownik tdabek@go2.pl tdabek@go2.pl napisał:
Ja to robię tak:
mysqldump -u -p --single-transaction --routines --triggers --databases lms > lms.sql
Dzieki za odpowiedz, niestety nadal dokladnie ten sam komunikat. Zdaje sobie sprawe to to cos namieszane w tabeli/widoku customersmail.view ale nie bardzo chce tego hardcorowo dotykac zeby nie popsuc bardziej. Czy ktos z szanownych kolegow potrafi nakierowac na dalsze postepowanie zeby ta tabele naprawic? Co jeszcze moge sprawdzic? Gdzie "uderzyc" zeby nie popsuc bardziej?
Dzieki z gory, pozdrawiam TD _______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
-- Pozdrawiam Marcin / nicraM
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
11 maj 2016 12:19 PM "tdabek@go2.pl" tdabek@go2.pl napisał(a):
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>
Zamiast localhost wpisz 127.0.0.1 Co pokazuje?
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 _______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
Dnia 11 maja 2016 12:23 Marcin marcin@nicram.net napisał(a):
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>
Zamiast localhost wpisz 127.0.0.1 Co pokazuje?
Mowisz i masz :)
mysql> show grants for 'root'@127.0.0.1; +---------------------------------------------------------------------+ | Grants for root@127.0.0.1 | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION | +---------------------------------------------------------------------+ 1 row in set (0.00 sec)
Pzdr TD
uczestnicy (2)
-
Marcin -
tdabek＠go2.pl