witam,
stalo sie tak, ze zaszla potrzeba przeniesienia bazy z jednego serwera na drugi.
zrobilem to w standardowy sposob:
Kod
mysqldump -u root -p --opt scrumtool > scrumtool.sql
mysql -u root -p scrumtool < scrumtool.sql
generalnie dziala wszystko poza widokiem?
na starym serwerze wyglada to tak:
mysql> USE scrumtool;
DATABASE changed
mysql> SHOW TABLES;
+---------------------+
| Tables_in_scrumtool |
+---------------------+
| Defect |
| backlog |
| flag_defs |
| flags |
| releases |
| sprints |
| tickets |
+---------------------+
7 rows IN SET (0.00 sec)
mysql> SELECT * FROM backlog;
...tu pokzuje zawartosc...
na nowym to samo konczy sie tak:
mysql> USE scrumtool;
Reading TABLE information FOR completion of TABLE AND COLUMN names
You can turn off this feature TO get a quicker startup WITH -A
DATABASE changed
mysql> SHOW TABLES;
+---------------------+
| Tables_in_scrumtool |
+---------------------+
| Defect |
| backlog |
| flag_defs |
| flags |
| releases |
| sprints |
| tickets |
+---------------------+
7 rows IN SET (0.00 sec)
mysql> SELECT * FROM backlog;
ERROR 1356 (HY000): VIEW 'scrumtool.backlog' REFERENCES invalid TABLE(s) OR COLUMN(s) OR FUNCTION(s) OR definer/invoker of VIEW lack rights TO USE them
gdzies zanalazlem niby obejscie problemu:
mysql> CREATE SQL SECURITY INVOKER VIEW scrumtool.backlog AS SELECT * FROM backlog;
ERROR 1356 (HY000): VIEW 'scrumtool.backlog' REFERENCES invalid TABLE(s) OR COLUMN(s) OR FUNCTION(s) OR definer/invoker of VIEW lack rights TO USE them
ale to tez nie dziala. jak to naprawic? probowalem nawet recznie przrzucic pliki z /var/lib/mysql/scrumtool ale oczywiscie bez rezultatu.