title: MySQL type view and permission to export
body: <p>I've been given an phpmyadmin username and password to the firms MySQL database. </p>
  
  <p>I exported the database with an SQL dump of what I thought was all the data. However it looks like there is a certain table I got the structure of but not the data.. I noticed that table is the type of "View" and if I try to export it separately it shows: CREATE ALGORITHM=UNDEFINED DEFINER=... </p>
  
  <p>Does this mean I need some user with a higher permission to get access to export the the data?</p>
  
  <p>Here is the line from when I export the view: </p>
  
  <pre><code>CREATE ALGORITHM=UNDEFINED DEFINER=`**********` SQL SECURITY DEFINER VIEW `NERVMUSCACCP` AS select `NERVNAME`.`NerveCode` AS `Code`,`NERVNAME`.`NerveName` AS `NAME`,`NERVNAME`.`ShortNerveName` AS `ShortName` from `NERVNAME` union select `MUSCNAME`.`MuscleCode` AS `MuscleCode`,`MUSCNAME`.`MuscleName` AS `MuscleName`,`MUSCNAME`.`ShortMuscleName` AS `ShortMuscleName` from `MUSCNAME` union select `ACCPNAME`.`Code` AS `Code`,`ACCPNAME`.`Name` AS `Name`,`ACCPNAME`.`ShortAccPName` AS `ShortAccPName` from `ACCPNAME`;
  </code></pre>