Move MySql database in Rails
I am working on a Rails application in Lubuntu. It has MySQL database at the back end. I want to move the application with the Database to my new Ubuntu OS. I can move the Rails project by using Git, but I am not sure how to move the MySQL database. I was wondering if there is a quick way to move the database. I would appreciate any help.
Thanks
mysql ruby-on-rails
asked Nov 15 '18 at 19:07
user3723326user3723326
142
add a comment |
I am working on a Rails application in Lubuntu. It has MySQL database at the back end. I want to move the application with the Database to my new Ubuntu OS. I can move the Rails project by using Git, but I am not sure how to move the MySQL database. I was wondering if there is a quick way to move the database. I would appreciate any help.
Thanks
mysql ruby-on-rails
asked Nov 15 '18 at 19:07
user3723326user3723326
142
add a comment |
I am working on a Rails application in Lubuntu. It has MySQL database at the back end. I want to move the application with the Database to my new Ubuntu OS. I can move the Rails project by using Git, but I am not sure how to move the MySQL database. I was wondering if there is a quick way to move the database. I would appreciate any help.
Thanks
mysql ruby-on-rails
asked Nov 15 '18 at 19:07
user3723326user3723326
142
I am working on a Rails application in Lubuntu. It has MySQL database at the back end. I want to move the application with the Database to my new Ubuntu OS. I can move the Rails project by using Git, but I am not sure how to move the MySQL database. I was wondering if there is a quick way to move the database. I would appreciate any help.
Thanks
mysql ruby-on-rails
mysql ruby-on-rails
asked Nov 15 '18 at 19:07
user3723326user3723326
142
asked Nov 15 '18 at 19:07
user3723326user3723326
142
asked Nov 15 '18 at 19:07
user3723326user3723326
142
asked Nov 15 '18 at 19:07
user3723326user3723326
142
asked Nov 15 '18 at 19:07
user3723326user3723326
142
142
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Follow these steps:
1) For exporting the db dump into the local system
mysqldump -u [username] -p [db_name] > [sql_file_name.sql]
2) Make its tar for easily share with other system:
tar -czvf [any_name.tar.gz] [sql_file_name.sql]
3) Move it to the other system where you have to import it.
4) Untar the file:
tar -xzf [any_name.tar.gz]
5) Import database:
mysql -u [username] -p [db_name] < [sql_file_name.sql]
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
add a comment |
You can move the data by taking a mysqldump.
mysqldump -u [user_name] -p -h [hostname] [database_name] > [file_name.sql]
Use this in the terminal and enter the password, upon on success it will give a mysql dump sql file which you can later to use to restore your database to another machine. Also since the structure of database remaining the same, applying migrations from rails will show no changes, then you are good to work with it in the new machine
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53326366%2fmove-mysql-database-in-rails%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Follow these steps:
1) For exporting the db dump into the local system
mysqldump -u [username] -p [db_name] > [sql_file_name.sql]
2) Make its tar for easily share with other system:
tar -czvf [any_name.tar.gz] [sql_file_name.sql]
3) Move it to the other system where you have to import it.
4) Untar the file:
tar -xzf [any_name.tar.gz]
5) Import database:
mysql -u [username] -p [db_name] < [sql_file_name.sql]
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
add a comment |
Follow these steps:
1) For exporting the db dump into the local system
mysqldump -u [username] -p [db_name] > [sql_file_name.sql]
2) Make its tar for easily share with other system:
tar -czvf [any_name.tar.gz] [sql_file_name.sql]
3) Move it to the other system where you have to import it.
4) Untar the file:
tar -xzf [any_name.tar.gz]
5) Import database:
mysql -u [username] -p [db_name] < [sql_file_name.sql]
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
add a comment |
Follow these steps:
1) For exporting the db dump into the local system
mysqldump -u [username] -p [db_name] > [sql_file_name.sql]
2) Make its tar for easily share with other system:
tar -czvf [any_name.tar.gz] [sql_file_name.sql]
3) Move it to the other system where you have to import it.
4) Untar the file:
tar -xzf [any_name.tar.gz]
5) Import database:
mysql -u [username] -p [db_name] < [sql_file_name.sql]
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
Follow these steps:
1) For exporting the db dump into the local system
mysqldump -u [username] -p [db_name] > [sql_file_name.sql]
2) Make its tar for easily share with other system:
tar -czvf [any_name.tar.gz] [sql_file_name.sql]
3) Move it to the other system where you have to import it.
4) Untar the file:
tar -xzf [any_name.tar.gz]
5) Import database:
mysql -u [username] -p [db_name] < [sql_file_name.sql]
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
answered Nov 16 '18 at 5:32
Cryptex TechnologiesCryptex Technologies
810213
810213
add a comment |
add a comment |
You can move the data by taking a mysqldump.
mysqldump -u [user_name] -p -h [hostname] [database_name] > [file_name.sql]
Use this in the terminal and enter the password, upon on success it will give a mysql dump sql file which you can later to use to restore your database to another machine. Also since the structure of database remaining the same, applying migrations from rails will show no changes, then you are good to work with it in the new machine
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
add a comment |
You can move the data by taking a mysqldump.
mysqldump -u [user_name] -p -h [hostname] [database_name] > [file_name.sql]
Use this in the terminal and enter the password, upon on success it will give a mysql dump sql file which you can later to use to restore your database to another machine. Also since the structure of database remaining the same, applying migrations from rails will show no changes, then you are good to work with it in the new machine
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
add a comment |
You can move the data by taking a mysqldump.
mysqldump -u [user_name] -p -h [hostname] [database_name] > [file_name.sql]
Use this in the terminal and enter the password, upon on success it will give a mysql dump sql file which you can later to use to restore your database to another machine. Also since the structure of database remaining the same, applying migrations from rails will show no changes, then you are good to work with it in the new machine
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
You can move the data by taking a mysqldump.
mysqldump -u [user_name] -p -h [hostname] [database_name] > [file_name.sql]
Use this in the terminal and enter the password, upon on success it will give a mysql dump sql file which you can later to use to restore your database to another machine. Also since the structure of database remaining the same, applying migrations from rails will show no changes, then you are good to work with it in the new machine
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
answered Nov 15 '18 at 19:15
Jeffy MathewJeffy Mathew
1125
1125
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53326366%2fmove-mysql-database-in-rails%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
