Newly imported database lost all views, Newly imported database lost all views |
Newly imported database lost all views, Newly imported database lost all views |
belowHeights00 |
Aug 23 2015, 10:16 AM
Post
#1
|
Member Group: Members Posts: 67 Joined: 4-February 14 Member No.: 20,319 |
I had a website with database and all and I recently imported all tables to different database. I had multiple views with queries all in working order. Now that I imported it...all my views seem to be gone and have changed to regular tables which interferes with my queries. Is this normal and if so...how could I either fix it easily without having to redo every view...or re-import the database leaving the views as they should.
I am using phpmyadmin and all queries are mysql. I'm sorry if not enough information I'll gladly post more if needed. Thank you very much. The problem is that without my views I do not know what the view queries were. |
belowHeights00 |
Aug 23 2015, 10:52 AM
Post
#2
|
Member Group: Members Posts: 67 Joined: 4-February 14 Member No.: 20,319 |
I've narrowed it down to the error: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
This is stopping my views from being populated, but I don't know how to fix this. I've changed all entries in my .sql file to reflect the new user but nothing changed. |
Lo-Fi Version | Time is now: 16th June 2024 - 08:29 AM |