Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...How to clean out DBHow to clean out DB
Previous
 
Next
New Post
12/22/2008 4:28 PM
 
Tom Mortensen


Joined: 3/31/2004
Posts: 48

Hi.

I'm setting up a new site from scratch with a new host as my old host just vanished into thin air :(

The initial setup attempts were unsuccessful (the usual back and forth about permissions until the host gets it right). I want to get through the entire install process  "clean" from start to finish to minimize risk of future trouble. Now, I can remove and re-upload all files but I need the host's support to remove and re-create the DB, which probably on't happen until tomorrow now.

Is there any simple way I can wipe all the tables, procedures etc. from the DB myself? I started deleting tables one by one using the Server Management Studio, but it'll take forever and I've already run into trouble as some tables can't be deleted (something about foreign keys).

Any help would be deeply appreciated.

\tom
 
New Post
12/22/2008 6:43 PM
 
ROB AX

Joined: 9/3/2004
Posts: 2185

You absolutely have to get another host.

Given that you appreciate the risks and the need to be clean and tidy with your site, you simply cannot build and maintain a DNN site in a serious manner without the ability to create, delete, export and restore databases, and apply file permissions at will. Zipping up the file system and exporting the database to download as a backup is also vital. Even a cheap $10 Webhost4life account gives you this sort of access, and many of the others do as well. Once you have all this sorted out, you can settle into a relatively safe build and maintain routine... which will give you time to start thinking about how to get enough resources to make the site work at a reasonable speed.

Do this now rather than later and save yourself a ton of drama.

Regards,
Rob
 
New Post
12/25/2008 5:39 PM
 
Darnell Jordan

www.lehighacreslive.com
Joined: 4/7/2006
Posts: 271

Tom Mortensen wrote

Hi.

I'm setting up a new site from scratch with a new host as my old host just vanished into thin air :(

The initial setup attempts were unsuccessful (the usual back and forth about permissions until the host gets it right). I want to get through the entire install process  "clean" from start to finish to minimize risk of future trouble. Now, I can remove and re-upload all files but I need the host's support to remove and re-create the DB, which probably on't happen until tomorrow now.

Is there any simple way I can wipe all the tables, procedures etc. from the DB myself? I started deleting tables one by one using the Server Management Studio, but it'll take forever and I've already run into trouble as some tables can't be deleted (something about foreign keys).

Any help would be deeply appreciated.

\tom

 

Who was you old hosting company? BTW, I use www.webhostforasp.net and love them! Good price and GREAT service!

If God does not live in Colorado, I bet he visits there a lot!!
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...How to clean out DBHow to clean out DB


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out