Link to home
Start Free TrialLog in
Avatar of owen3979
owen3979

asked on

dreamweaver and databases

Hi-
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?

thanks,
owen
Avatar of humeniuk
humeniuk
Flag of Canada image

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.
ASKER CERTIFIED SOLUTION
Avatar of stengelj
stengelj
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of owen3979
owen3979

ASKER

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.
owen