Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Ben Weinberger
1,869 PointsAdding your database when deploying a site
I have purchased a domain and hosting through godaddy, downloaded cyberduck and have successfully added my files, but I'm wondering how I add/copy my mysql database to my new hosting? I can create a new database and tables with the cPanel X, but would love to be able to just take the same database tables and data I currently have and plop it in.
Thank you in advance for your answer.
2 Answers
James Barnett
39,199 PointsThere are basically 3 ways to do that:
- PHPMyAdmin
- MySQL Workbench
- mysqldump command
You can read all about these 3 ways to import a mysql database in this very helpful article I find via a quick google for mysql export.
Ben Weinberger
1,869 PointsGreat. Thank you!