Solved

How do I find the database in my FTP directory?

Posted on 2011-03-19
7
244 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 83

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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 7

Expert Comment

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

Accepted Solution

by:
Dave Baldwin earned 250 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 83

Expert Comment

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

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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