• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

dreamweaver and databases

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?

1 Solution
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.
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.
owen3979Author Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now