?
Solved

How do I find the database in my FTP directory?

Posted on 2011-03-19
7
Medium Priority
?
256 Views
Last Modified: 2012-05-11
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
Comment
Question by:captainred
  • 3
  • 2
  • 2
7 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 35172851
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
 
LVL 7

Expert Comment

by:Maverick_Cool
ID: 35173041
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
 

Author Comment

by:captainred
ID: 35173250
Is there a way to search for files in the FTP with specific extensions, specifically MDF in this case?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 7

Expert Comment

by:Maverick_Cool
ID: 35173269
use a ftp client like FileZilla, it has search functionality with recursive option
0
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 1000 total points
ID: 35173294
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
 

Author Comment

by:captainred
ID: 35173356
I found the web.config file.  You're right - it's loaded with references to the database.  Many thanks!
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 35173467
You're welcome, thanks for the points.
0

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question