?
Solved

How do I find the database in my FTP directory?

Posted on 2011-03-19
7
Medium Priority
?
246 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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
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 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 83

Expert Comment

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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
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 …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

801 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