How can I transfer Mysql data to another computer and add it to an exist database
I'm trying to transfer Mysql data to another computer and add it to an exist database
Here is the condition:
1. Computer A, A has a database named 'Test';
2. Computer B, B has a database named 'Formal';
3. Test and Formal have exactly the same tables and fields.
4. I use A to get new data and add the data to B.
5. Remote connection to B's MySQL is forbidden.
Here is how I deal with it now:
1. Create a 'Transfer' database in B;
2. Dump Source's data into test.sql;
3. Copy test.sql to B;
4. Backup Formal database;
5. Source test.sql to Transfer database.
6. Use a script to take Transfer's data and add to Target.
I am wondering if I can add Test's data into Formal database directly?
I am not a native English speaker and fresh new in MySQL, so if there is any confusion upthere, please tell me and i'll try my best to make it clear.
mysql
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
bumped to the homepage by Community♦ 31 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Sep 3 '14 at 9:53
This question came from our site for professional and enthusiast programmers.
|
show 2 more comments
I'm trying to transfer Mysql data to another computer and add it to an exist database
Here is the condition:
1. Computer A, A has a database named 'Test';
2. Computer B, B has a database named 'Formal';
3. Test and Formal have exactly the same tables and fields.
4. I use A to get new data and add the data to B.
5. Remote connection to B's MySQL is forbidden.
Here is how I deal with it now:
1. Create a 'Transfer' database in B;
2. Dump Source's data into test.sql;
3. Copy test.sql to B;
4. Backup Formal database;
5. Source test.sql to Transfer database.
6. Use a script to take Transfer's data and add to Target.
I am wondering if I can add Test's data into Formal database directly?
I am not a native English speaker and fresh new in MySQL, so if there is any confusion upthere, please tell me and i'll try my best to make it clear.
mysql
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
bumped to the homepage by Community♦ 31 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Sep 3 '14 at 9:53
This question came from our site for professional and enthusiast programmers.
Is this a Read-Write -splitting case?
– heikkim
Sep 3 '14 at 7:01
this command should do the task for you -mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname
– Murtaza
Sep 3 '14 at 7:03
@Murtaza: Remote connection to computer B is forbidden. But i am now working on mysqldump to see if i can do something else with it. Thanks!
– billy_lu
Sep 3 '14 at 14:33
@heikkim: I don't know exactly what 'Read-Write -splitting' is, but i don't think it is.
– billy_lu
Sep 3 '14 at 14:46
How do you do "3. Copy test.sql to B;" if you have no remote access to B? Copy the test.sql to a USB stick, then ship the stick to location B?
– ypercubeᵀᴹ
Sep 4 '14 at 13:15
|
show 2 more comments
I'm trying to transfer Mysql data to another computer and add it to an exist database
Here is the condition:
1. Computer A, A has a database named 'Test';
2. Computer B, B has a database named 'Formal';
3. Test and Formal have exactly the same tables and fields.
4. I use A to get new data and add the data to B.
5. Remote connection to B's MySQL is forbidden.
Here is how I deal with it now:
1. Create a 'Transfer' database in B;
2. Dump Source's data into test.sql;
3. Copy test.sql to B;
4. Backup Formal database;
5. Source test.sql to Transfer database.
6. Use a script to take Transfer's data and add to Target.
I am wondering if I can add Test's data into Formal database directly?
I am not a native English speaker and fresh new in MySQL, so if there is any confusion upthere, please tell me and i'll try my best to make it clear.
mysql
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
I'm trying to transfer Mysql data to another computer and add it to an exist database
Here is the condition:
1. Computer A, A has a database named 'Test';
2. Computer B, B has a database named 'Formal';
3. Test and Formal have exactly the same tables and fields.
4. I use A to get new data and add the data to B.
5. Remote connection to B's MySQL is forbidden.
Here is how I deal with it now:
1. Create a 'Transfer' database in B;
2. Dump Source's data into test.sql;
3. Copy test.sql to B;
4. Backup Formal database;
5. Source test.sql to Transfer database.
6. Use a script to take Transfer's data and add to Target.
I am wondering if I can add Test's data into Formal database directly?
I am not a native English speaker and fresh new in MySQL, so if there is any confusion upthere, please tell me and i'll try my best to make it clear.
mysql
mysql
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
edited Sep 5 '14 at 5:56
billy_lu
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
asked Sep 3 '14 at 6:56
billy_lubilly_lu
11
11
bumped to the homepage by Community♦ 31 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 31 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Sep 3 '14 at 9:53
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Sep 3 '14 at 9:53
This question came from our site for professional and enthusiast programmers.
Is this a Read-Write -splitting case?
– heikkim
Sep 3 '14 at 7:01
this command should do the task for you -mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname
– Murtaza
Sep 3 '14 at 7:03
@Murtaza: Remote connection to computer B is forbidden. But i am now working on mysqldump to see if i can do something else with it. Thanks!
– billy_lu
Sep 3 '14 at 14:33
@heikkim: I don't know exactly what 'Read-Write -splitting' is, but i don't think it is.
– billy_lu
Sep 3 '14 at 14:46
How do you do "3. Copy test.sql to B;" if you have no remote access to B? Copy the test.sql to a USB stick, then ship the stick to location B?
– ypercubeᵀᴹ
Sep 4 '14 at 13:15
|
show 2 more comments
Is this a Read-Write -splitting case?
– heikkim
Sep 3 '14 at 7:01
this command should do the task for you -mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname
– Murtaza
Sep 3 '14 at 7:03
@Murtaza: Remote connection to computer B is forbidden. But i am now working on mysqldump to see if i can do something else with it. Thanks!
– billy_lu
Sep 3 '14 at 14:33
@heikkim: I don't know exactly what 'Read-Write -splitting' is, but i don't think it is.
– billy_lu
Sep 3 '14 at 14:46
How do you do "3. Copy test.sql to B;" if you have no remote access to B? Copy the test.sql to a USB stick, then ship the stick to location B?
– ypercubeᵀᴹ
Sep 4 '14 at 13:15
Is this a Read-Write -splitting case?
– heikkim
Sep 3 '14 at 7:01
Is this a Read-Write -splitting case?
– heikkim
Sep 3 '14 at 7:01
this command should do the task for you -
mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname– Murtaza
Sep 3 '14 at 7:03
this command should do the task for you -
mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname– Murtaza
Sep 3 '14 at 7:03
@Murtaza: Remote connection to computer B is forbidden. But i am now working on mysqldump to see if i can do something else with it. Thanks!
– billy_lu
Sep 3 '14 at 14:33
@Murtaza: Remote connection to computer B is forbidden. But i am now working on mysqldump to see if i can do something else with it. Thanks!
– billy_lu
Sep 3 '14 at 14:33
@heikkim: I don't know exactly what 'Read-Write -splitting' is, but i don't think it is.
– billy_lu
Sep 3 '14 at 14:46
@heikkim: I don't know exactly what 'Read-Write -splitting' is, but i don't think it is.
– billy_lu
Sep 3 '14 at 14:46
How do you do "3. Copy test.sql to B;" if you have no remote access to B? Copy the test.sql to a USB stick, then ship the stick to location B?
– ypercubeᵀᴹ
Sep 4 '14 at 13:15
How do you do "3. Copy test.sql to B;" if you have no remote access to B? Copy the test.sql to a USB stick, then ship the stick to location B?
– ypercubeᵀᴹ
Sep 4 '14 at 13:15
|
show 2 more comments
1 Answer
1
active
oldest
votes
In MySql you can it import it in the GUI
http://www.phpmyadmin.net/home_page/images/screenshots/users.png
there you can import and export it with a data.sql
or you you save the data from A in an dataset and then you update the dataset in the b database or other around so you have copy the database B to A
p.s. admins pls put the image in i cant do it
p.s.billy i explained it with the image
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f75566%2fhow-can-i-transfer-mysql-data-to-another-computer-and-add-it-to-an-exist-databas%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In MySql you can it import it in the GUI
http://www.phpmyadmin.net/home_page/images/screenshots/users.png
there you can import and export it with a data.sql
or you you save the data from A in an dataset and then you update the dataset in the b database or other around so you have copy the database B to A
p.s. admins pls put the image in i cant do it
p.s.billy i explained it with the image
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
add a comment |
In MySql you can it import it in the GUI
http://www.phpmyadmin.net/home_page/images/screenshots/users.png
there you can import and export it with a data.sql
or you you save the data from A in an dataset and then you update the dataset in the b database or other around so you have copy the database B to A
p.s. admins pls put the image in i cant do it
p.s.billy i explained it with the image
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
add a comment |
In MySql you can it import it in the GUI
http://www.phpmyadmin.net/home_page/images/screenshots/users.png
there you can import and export it with a data.sql
or you you save the data from A in an dataset and then you update the dataset in the b database or other around so you have copy the database B to A
p.s. admins pls put the image in i cant do it
p.s.billy i explained it with the image
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
In MySql you can it import it in the GUI
http://www.phpmyadmin.net/home_page/images/screenshots/users.png
there you can import and export it with a data.sql
or you you save the data from A in an dataset and then you update the dataset in the b database or other around so you have copy the database B to A
p.s. admins pls put the image in i cant do it
p.s.billy i explained it with the image
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
edited Sep 4 '14 at 9:40
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
answered Sep 3 '14 at 9:45
Florian HofmeisterFlorian Hofmeister
11
11
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f75566%2fhow-can-i-transfer-mysql-data-to-another-computer-and-add-it-to-an-exist-databas%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
Is this a Read-Write -splitting case?
– heikkim
Sep 3 '14 at 7:01
this command should do the task for you -
mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname– Murtaza
Sep 3 '14 at 7:03
@Murtaza: Remote connection to computer B is forbidden. But i am now working on mysqldump to see if i can do something else with it. Thanks!
– billy_lu
Sep 3 '14 at 14:33
@heikkim: I don't know exactly what 'Read-Write -splitting' is, but i don't think it is.
– billy_lu
Sep 3 '14 at 14:46
How do you do "3. Copy test.sql to B;" if you have no remote access to B? Copy the test.sql to a USB stick, then ship the stick to location B?
– ypercubeᵀᴹ
Sep 4 '14 at 13:15