The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Newly imported database lost all views, Newly imported database lost all views
belowHeights00
post 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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
belowHeights00
post 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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 28th March 2024 - 09:41 AM