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

Databases

Posted by Fatimah Anwar
.a{fill-rule:evenodd;}techdegree
Fatimah Anwar
Android Development Techdegree Student 10,416 Points

help me .. how i can save changes in database file (mySQL)

my friend sent a database file to me .. i did some changes with rows (add, delete, copy ..etc) by using XAMPP control panel .. but in the code file i did not find any changes .. it still an original file!! so we cannot exchange the updated file between us coz there is no update!!

should I change the codes line by line? so what is the benefit of graphical interface of XAMPP?

2 Answers

Leandro Botella Penalva
Leandro Botella Penalva
17,618 Points
Leandro Botella Penalva
Leandro Botella Penalva
17,618 Points

Hi Fatima,

I guess what your friend sent to you was a group of SQL statements that creates a database and tables. However once you import the file the data is not saved in that file. It is managed by MySQL internally.

To get an updated file to send it to anyone you will need to export your database. In your case using XAMPP you can do it so by using the export tab in phpMyAdmin.

Fatimah Anwar
seal-mask
.a{fill-rule:evenodd;}techdegree
Fatimah Anwar
Android Development Techdegree Student 10,416 Points
Fatimah Anwar
.a{fill-rule:evenodd;}techdegree
Fatimah Anwar
Android Development Techdegree Student 10,416 Points

Thanks .. i did it ❤