So I was working with a database driven website, I transferred correctly from the server to work on it on my computer, and I knew it was correct because I checked the mySQL files on both the server and local installation and they looked exactly the same at first. The problem I had was that, when I installed the CMS system in my computer to work on it, the CMS would work as a fresh install. But the files that I transferred such as web pages and work were not being read. I reinstalled it many times thinking It was a problem with local files, and even reinstalled my local server.
But the real problem was in the mySQL files, the local installation was reading the mySQL but not the tables I wanted it to read. It was reading table fields from the fresh mySQL installation those table fields had no prefix, the ones I transferred had a prefix on them so they were just being ignored. After a few days of frustration, I opened the mySQL file both files side by side went line by line and with a little luck and help I noticed the difference. I just erased the table fields from the fresh install and replaced it with the modified table fields I wanted to use, modified as in the prefix erased. Thats how I solved a database transfer problem, I am sure there are better ways of doing it but for now I know of one thing to look out for when transferring databases.