can you view a view in a table? I loaded a db to see settings of a view but can't access the site so wondering if I can view it via mysql?

OR can you reset the username and pass for admin in mysql?
Can you access the command line? If so, try to use Drush (the drupal shell command-line interface) to export the view settings.

If you use Drupal 6, this is possible once you install the Drush Views module so it won't help you since you can't access the site.

But if you use Drupal 7, you can use this patch.