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.