• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

How do I find the database in my FTP directory?

Hi,

I've just taken over a web project from another web developer who's method of organizing the server had no rhyme or reason.   Everything's a mess, with groups of files in the last places you'd expect (I'm sure many of you have experience with this).

That said, how could I find the original database?  I have a copy of the source code, I'm running Visual Studio 2010, and have FTP access as well.  Would I run a search from a particular program?  

Any assistance would be greatly appreciated.

Thanks,
Dan
0
captainred
Asked:
captainred
  • 3
  • 2
  • 2
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
The source code, maybe web.config, will have the connection string that should tell you where the database is.  Database are Not usually under the web root with the HTML files.
0
 
Maverick_CoolCommented:
also Check in code for dataSource, if the code connects via a 'system data source' or 'user data source'.
In that case you should go to iis or system control panel to get details of connection string.
If it is directly in connection string, then use that url to locate your database.
0
 
captainredAuthor Commented:
Is there a way to search for files in the FTP with specific extensions, specifically MDF in this case?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Maverick_CoolCommented:
use a ftp client like FileZilla, it has search functionality with recursive option
0
 
Dave BaldwinFixer of ProblemsCommented:
There may be a way to search for it but it shouldn't be there with the rest of the files.  That would allow people to download your complete database.  No hosting company would support it being there.  Look first at 'web.config' and then at files that use the database to find the location.  Many hosting companies put the MS SQL and MySQL files elsewhere, often on a different server.  That would be a common if not standard practice.
0
 
captainredAuthor Commented:
I found the web.config file.  You're right - it's loaded with references to the database.  Many thanks!
0
 
Dave BaldwinFixer of ProblemsCommented:
You're welcome, thanks for the points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now