Syncing MySQL between computers?

[ibbadib]

Hey there,

 

I am developing a Ruby on Rails application, for a school project. I have been developing all of the app so far on my laptop, and I have been using Git (and bitbucket), as version control (My first time, so still learning).

Today I tried cloning the project to my Ubuntu Gnome desktop, and all the project files was cloning perfectly.

 

Anyhow, the App can not find the database I created on my laptop, so how do I sync the MySQL databases?

 

Thanks :-)

[StackUnderflow]

mysqldump -u root -ppassword databasename > databasename.sql

Transfer the .sql file to ubuntu and

mysql -u root -ppassword

create database databasename;

exit

mysql -u root -ppassword databasename < databasename.sql

 

For more, google mysqldump.

[Master Disaster]

Is the database open to the internet?

[ibbadib]

Is the database open to the internet?

No. Don't intend to make it.

[ibbadib]

mysqldump -u root -ppassword databasename > databasename.sql

Transfer the .sql file to ubuntu and

mysql -u root -ppassword

create database databasename;

exit

mysql -u root -ppassword databasename < databasename.sql

 

For more, google mysqldump.

You sir,

 

Are awesome :-)