How to create a database that is a randomized subset of another db (mysql)?Is it possible to mysqldump a...
Reason for small-valued feedback resistors in low noise Op Amp
Including proofs of known theorems in master's thesis
Why can all solutions to the simple harmonic motion equation be written in terms of sines and cosines?
What is an efficient way to digitize a family photo collection?
Was the Spartan by Mimic Systems a real product?
Why write a book when there's a movie in my head?
Isn't a semicolon (';') needed after a function declaration in C++?
Unable to repartition non-mounted SD card
How do I avoid the "chosen hero" feeling?
Question from the 2011 IMC key stage III paper, about determining which number has to be removed, so the multiplication is the square of an integer
What does "south of due west" mean?
Is it possible to detect 100% of SQLi with a simple regex?
When does a person lose diplomatic status?
Why do single electrical receptacles exist?
Buying a "Used" Router
Is the UK legally prevented from having another referendum on Brexit?
Does an enchantment ability that gives -1/-1 to opponent creatures resolve before other abilities can be used on a 1/1 entering the battlefield
Taking an academic pseudonym?
Is the percentage symbol a constant?
Players preemptively rolling, even though their rolls are useless or are checking the wrong skills
How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?
Can't figure out a htaccess rule
Is it possible to narrate a novel in a faux-historical style without alienating the reader?
Can someone explain what a key is?
How to create a database that is a randomized subset of another db (mysql)?
Is it possible to mysqldump a subset of a database required to reproduce a query?Need to find duplicate entriesHow can this data be joined?MySQL: Delete a record from all tables in one shotMySQL cannot create foreign key, errors 1005, 150Count how many locks required for a MySQL (InnoDB) queryTransforming Huge Database table to Another TableMySQL: Is there a way to update a field so that all foreign key related fields are updated as well?MySQL Join QueryData Dump Lag With Open Query (MySQL Linked to SQL Server 2016)
I have a MySQL-DB containing 2 tables "records" and "features" linked by one foreign key in features referring to the primary key "id" in records.
My goal is to create a randomized but fixed subset of the data in the DB for machinelearning that can be dumped and hashed for reproducability.
So I thought it would be handy if I could draw a randomized subset of the data and move it to a seperate DB.
Is that possible and if yes: how?
mysql
asked 7 mins ago
WolfoneWolfone
1011
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a MySQL-DB containing 2 tables "records" and "features" linked by one foreign key in features referring to the primary key "id" in records.
My goal is to create a randomized but fixed subset of the data in the DB for machinelearning that can be dumped and hashed for reproducability.
So I thought it would be handy if I could draw a randomized subset of the data and move it to a seperate DB.
Is that possible and if yes: how?
mysql
asked 7 mins ago
WolfoneWolfone
1011
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a MySQL-DB containing 2 tables "records" and "features" linked by one foreign key in features referring to the primary key "id" in records.
My goal is to create a randomized but fixed subset of the data in the DB for machinelearning that can be dumped and hashed for reproducability.
So I thought it would be handy if I could draw a randomized subset of the data and move it to a seperate DB.
Is that possible and if yes: how?
mysql
asked 7 mins ago
WolfoneWolfone
1011
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a MySQL-DB containing 2 tables "records" and "features" linked by one foreign key in features referring to the primary key "id" in records.
My goal is to create a randomized but fixed subset of the data in the DB for machinelearning that can be dumped and hashed for reproducability.
So I thought it would be handy if I could draw a randomized subset of the data and move it to a seperate DB.
Is that possible and if yes: how?
mysql
mysql
asked 7 mins ago
WolfoneWolfone
1011
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
WolfoneWolfone
1011
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
WolfoneWolfone
1011
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
WolfoneWolfone
1011
asked 7 mins ago
WolfoneWolfone
1011
1011
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Wolfone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
Wolfone is a new contributor. Be nice, and check out our Code of Conduct.
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%2f230551%2fhow-to-create-a-database-that-is-a-randomized-subset-of-another-db-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Wolfone is a new contributor. Be nice, and check out our Code of Conduct.
Wolfone is a new contributor. Be nice, and check out our Code of Conduct.
Wolfone is a new contributor. Be nice, and check out our Code of Conduct.
Wolfone is a new contributor. Be nice, and check out our Code of Conduct.
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%2f230551%2fhow-to-create-a-database-that-is-a-randomized-subset-of-another-db-mysql%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
