dreamweaver and databases

Posted on 2005-05-08
Last Modified: 2010-04-25
the way my site is setup now, the database for my site is not in the site folder, its in the mysql folder...when i go to upload the site, is there a way to have dreamweaver also upload the database?

Question by:owen3979
    LVL 33

    Expert Comment

    I don't believe this can be done through Dreamweaver, but perhaps someone will prove me wrong (it's happened before).

    What I've always done in this situation is dump the database into a text file . . .

    ->     mysqldump dbname > dbname.txt

    . . . and then imported on the destination server . . .

    ->     mysql dbname < dbname.txt

    If you're using something like phpMyAdmin (preferably on both ends), you can use it to dump and then to import - a bit simpler.
    LVL 9

    Accepted Solution

    See this thread: http://Q_21359740.html

    I didn't provide the accepted solution (someone else did) but you may find something useful.

    humeniuk is right though, there is no native way to do this.

    Author Comment

    i actually just realized today that i could just leave my database on the  host and still test my site locally, so i'll  do that, unless that's not recommended.

    thanks for the help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
    I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now