Is it possible to migrate back from Amazon Aurora to native MySQL in Amazon RDS?
I saw Amazon introduced new Amazon Aurora MySQL migration from native MySQL to Amazon Aurora MySQL.
Would it be possible to migrate back from Amazon Aurora to regular MySQL with Amazon RDS?
mysql amazon-web-services amazon-rds amazon-rds-aurora
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
asked Sep 26 '15 at 7:36
DrorDror
64011022
add a comment |
I saw Amazon introduced new Amazon Aurora MySQL migration from native MySQL to Amazon Aurora MySQL.
Would it be possible to migrate back from Amazon Aurora to regular MySQL with Amazon RDS?
mysql amazon-web-services amazon-rds amazon-rds-aurora
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
asked Sep 26 '15 at 7:36
DrorDror
64011022
1
Can you usemysqldumpto export your database from Aurora and use that output to repopulate your MySQL database?
– Matt Houser
Sep 26 '15 at 14:02
add a comment |
I saw Amazon introduced new Amazon Aurora MySQL migration from native MySQL to Amazon Aurora MySQL.
Would it be possible to migrate back from Amazon Aurora to regular MySQL with Amazon RDS?
mysql amazon-web-services amazon-rds amazon-rds-aurora
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
asked Sep 26 '15 at 7:36
DrorDror
64011022
I saw Amazon introduced new Amazon Aurora MySQL migration from native MySQL to Amazon Aurora MySQL.
Would it be possible to migrate back from Amazon Aurora to regular MySQL with Amazon RDS?
mysql amazon-web-services amazon-rds amazon-rds-aurora
mysql amazon-web-services amazon-rds amazon-rds-aurora
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
asked Sep 26 '15 at 7:36
DrorDror
64011022
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
asked Sep 26 '15 at 7:36
DrorDror
64011022
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
edited Sep 26 '15 at 14:35
ydaetskcoR
23.1k46179
23.1k46179
asked Sep 26 '15 at 7:36
DrorDror
64011022
asked Sep 26 '15 at 7:36
DrorDror
64011022
asked Sep 26 '15 at 7:36
DrorDror
64011022
64011022
1
Can you usemysqldumpto export your database from Aurora and use that output to repopulate your MySQL database?
– Matt Houser
Sep 26 '15 at 14:02
add a comment |
1
Can you usemysqldumpto export your database from Aurora and use that output to repopulate your MySQL database?
– Matt Houser
Sep 26 '15 at 14:02
1
1
Can you use
mysqldump to export your database from Aurora and use that output to repopulate your MySQL database?– Matt Houser
Sep 26 '15 at 14:02
Can you use
mysqldump to export your database from Aurora and use that output to repopulate your MySQL database?– Matt Houser
Sep 26 '15 at 14:02
add a comment |
2 Answers
2
active
oldest
votes
Amazon's Aurora is MySQL wire compatible so you can always use tools such as mysqldump to get your data back out into a form that you could use to import back into a regular MySQL instance running in RDS, an EC2 instance or anywhere else for that matter.
Since posting this answer Amazon has also released the Database Migration Service which can be used to do zero downtime migrations between MySQL -> Aurora MySQL (Aurora also now supports PostgreSQL) and back. It also supports heterogeneous migrations such as from Oracle to Aurora MySQL or a number of other sources and targets.
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
1
Thank you for your answer. To be more specific . To migrate from MySQL to Amazon's Aurora you just do migration in RDS console with a few clicks. I was wonder if it is possible to do vice versa. Migrate from Amazon's Aurora to MySQL from RDS console?
– Dror
Sep 26 '15 at 15:57
1
No, you cannot migrate from Aurora to MySQL from the RDS console. If you need to do a minimum-downtime migration from Aurora then you can use some of the replication options listed here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
– Laurion Burchall
Sep 26 '15 at 18:30
add a comment |
If it's a small database, you can use tools such as Navicat or MySQL Workbench to export the data out. For big databases, you can download aws cli either for Windows or Linux, for Linux it comes with a pre-installed on Amazon Linux AMI. Use aws configure to set up credentials and regions. Use mysqldump from the cli remember the --single-transaction option to avoid locking and take dump preferable from slave replica.
For a subset of the data, you can either use: (Windows example)
mysql> SELECT * FROM database.table
WHERE ......
into OUTFILE '/location/of/path/dumpfile.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "n";
Query OK....
to extract just what you need as flat files which is faster to load into any other MySQL env. You can also setup permission to load into s3 as flat files and export anywhere again if the file is not as big. But for huge data, please use mysqldump.
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
add a comment |
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%2f32794809%2fis-it-possible-to-migrate-back-from-amazon-aurora-to-native-mysql-in-amazon-rds%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
Amazon's Aurora is MySQL wire compatible so you can always use tools such as mysqldump to get your data back out into a form that you could use to import back into a regular MySQL instance running in RDS, an EC2 instance or anywhere else for that matter.
Since posting this answer Amazon has also released the Database Migration Service which can be used to do zero downtime migrations between MySQL -> Aurora MySQL (Aurora also now supports PostgreSQL) and back. It also supports heterogeneous migrations such as from Oracle to Aurora MySQL or a number of other sources and targets.
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
1
Thank you for your answer. To be more specific . To migrate from MySQL to Amazon's Aurora you just do migration in RDS console with a few clicks. I was wonder if it is possible to do vice versa. Migrate from Amazon's Aurora to MySQL from RDS console?
– Dror
Sep 26 '15 at 15:57
1
No, you cannot migrate from Aurora to MySQL from the RDS console. If you need to do a minimum-downtime migration from Aurora then you can use some of the replication options listed here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
– Laurion Burchall
Sep 26 '15 at 18:30
add a comment |
Amazon's Aurora is MySQL wire compatible so you can always use tools such as mysqldump to get your data back out into a form that you could use to import back into a regular MySQL instance running in RDS, an EC2 instance or anywhere else for that matter.
Since posting this answer Amazon has also released the Database Migration Service which can be used to do zero downtime migrations between MySQL -> Aurora MySQL (Aurora also now supports PostgreSQL) and back. It also supports heterogeneous migrations such as from Oracle to Aurora MySQL or a number of other sources and targets.
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
1
Thank you for your answer. To be more specific . To migrate from MySQL to Amazon's Aurora you just do migration in RDS console with a few clicks. I was wonder if it is possible to do vice versa. Migrate from Amazon's Aurora to MySQL from RDS console?
– Dror
Sep 26 '15 at 15:57
1
No, you cannot migrate from Aurora to MySQL from the RDS console. If you need to do a minimum-downtime migration from Aurora then you can use some of the replication options listed here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
– Laurion Burchall
Sep 26 '15 at 18:30
add a comment |
Amazon's Aurora is MySQL wire compatible so you can always use tools such as mysqldump to get your data back out into a form that you could use to import back into a regular MySQL instance running in RDS, an EC2 instance or anywhere else for that matter.
Since posting this answer Amazon has also released the Database Migration Service which can be used to do zero downtime migrations between MySQL -> Aurora MySQL (Aurora also now supports PostgreSQL) and back. It also supports heterogeneous migrations such as from Oracle to Aurora MySQL or a number of other sources and targets.
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
Amazon's Aurora is MySQL wire compatible so you can always use tools such as mysqldump to get your data back out into a form that you could use to import back into a regular MySQL instance running in RDS, an EC2 instance or anywhere else for that matter.
Since posting this answer Amazon has also released the Database Migration Service which can be used to do zero downtime migrations between MySQL -> Aurora MySQL (Aurora also now supports PostgreSQL) and back. It also supports heterogeneous migrations such as from Oracle to Aurora MySQL or a number of other sources and targets.
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
edited Sep 5 '17 at 14:45
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
answered Sep 26 '15 at 14:30
ydaetskcoRydaetskcoR
23.1k46179
23.1k46179
1
Thank you for your answer. To be more specific . To migrate from MySQL to Amazon's Aurora you just do migration in RDS console with a few clicks. I was wonder if it is possible to do vice versa. Migrate from Amazon's Aurora to MySQL from RDS console?
– Dror
Sep 26 '15 at 15:57
1
No, you cannot migrate from Aurora to MySQL from the RDS console. If you need to do a minimum-downtime migration from Aurora then you can use some of the replication options listed here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
– Laurion Burchall
Sep 26 '15 at 18:30
add a comment |
1
Thank you for your answer. To be more specific . To migrate from MySQL to Amazon's Aurora you just do migration in RDS console with a few clicks. I was wonder if it is possible to do vice versa. Migrate from Amazon's Aurora to MySQL from RDS console?
– Dror
Sep 26 '15 at 15:57
1
No, you cannot migrate from Aurora to MySQL from the RDS console. If you need to do a minimum-downtime migration from Aurora then you can use some of the replication options listed here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
– Laurion Burchall
Sep 26 '15 at 18:30
1
1
Thank you for your answer. To be more specific . To migrate from MySQL to Amazon's Aurora you just do migration in RDS console with a few clicks. I was wonder if it is possible to do vice versa. Migrate from Amazon's Aurora to MySQL from RDS console?
– Dror
Sep 26 '15 at 15:57
Thank you for your answer. To be more specific . To migrate from MySQL to Amazon's Aurora you just do migration in RDS console with a few clicks. I was wonder if it is possible to do vice versa. Migrate from Amazon's Aurora to MySQL from RDS console?
– Dror
Sep 26 '15 at 15:57
1
1
No, you cannot migrate from Aurora to MySQL from the RDS console. If you need to do a minimum-downtime migration from Aurora then you can use some of the replication options listed here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
– Laurion Burchall
Sep 26 '15 at 18:30
No, you cannot migrate from Aurora to MySQL from the RDS console. If you need to do a minimum-downtime migration from Aurora then you can use some of the replication options listed here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…
– Laurion Burchall
Sep 26 '15 at 18:30
add a comment |
If it's a small database, you can use tools such as Navicat or MySQL Workbench to export the data out. For big databases, you can download aws cli either for Windows or Linux, for Linux it comes with a pre-installed on Amazon Linux AMI. Use aws configure to set up credentials and regions. Use mysqldump from the cli remember the --single-transaction option to avoid locking and take dump preferable from slave replica.
For a subset of the data, you can either use: (Windows example)
mysql> SELECT * FROM database.table
WHERE ......
into OUTFILE '/location/of/path/dumpfile.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "n";
Query OK....
to extract just what you need as flat files which is faster to load into any other MySQL env. You can also setup permission to load into s3 as flat files and export anywhere again if the file is not as big. But for huge data, please use mysqldump.
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
add a comment |
If it's a small database, you can use tools such as Navicat or MySQL Workbench to export the data out. For big databases, you can download aws cli either for Windows or Linux, for Linux it comes with a pre-installed on Amazon Linux AMI. Use aws configure to set up credentials and regions. Use mysqldump from the cli remember the --single-transaction option to avoid locking and take dump preferable from slave replica.
For a subset of the data, you can either use: (Windows example)
mysql> SELECT * FROM database.table
WHERE ......
into OUTFILE '/location/of/path/dumpfile.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "n";
Query OK....
to extract just what you need as flat files which is faster to load into any other MySQL env. You can also setup permission to load into s3 as flat files and export anywhere again if the file is not as big. But for huge data, please use mysqldump.
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
add a comment |
If it's a small database, you can use tools such as Navicat or MySQL Workbench to export the data out. For big databases, you can download aws cli either for Windows or Linux, for Linux it comes with a pre-installed on Amazon Linux AMI. Use aws configure to set up credentials and regions. Use mysqldump from the cli remember the --single-transaction option to avoid locking and take dump preferable from slave replica.
For a subset of the data, you can either use: (Windows example)
mysql> SELECT * FROM database.table
WHERE ......
into OUTFILE '/location/of/path/dumpfile.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "n";
Query OK....
to extract just what you need as flat files which is faster to load into any other MySQL env. You can also setup permission to load into s3 as flat files and export anywhere again if the file is not as big. But for huge data, please use mysqldump.
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
If it's a small database, you can use tools such as Navicat or MySQL Workbench to export the data out. For big databases, you can download aws cli either for Windows or Linux, for Linux it comes with a pre-installed on Amazon Linux AMI. Use aws configure to set up credentials and regions. Use mysqldump from the cli remember the --single-transaction option to avoid locking and take dump preferable from slave replica.
For a subset of the data, you can either use: (Windows example)
mysql> SELECT * FROM database.table
WHERE ......
into OUTFILE '/location/of/path/dumpfile.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "n";
Query OK....
to extract just what you need as flat files which is faster to load into any other MySQL env. You can also setup permission to load into s3 as flat files and export anywhere again if the file is not as big. But for huge data, please use mysqldump.
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
answered Nov 6 '17 at 22:42
Son ZionSon Zion
11
11
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%2f32794809%2fis-it-possible-to-migrate-back-from-amazon-aurora-to-native-mysql-in-amazon-rds%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
1
Can you use
mysqldumpto export your database from Aurora and use that output to repopulate your MySQL database?– Matt Houser
Sep 26 '15 at 14:02