How to restore a MySQL database from directory files/disk (vs. dump)? The Next CEO of Stack...
TikZ: How to fill area with a special pattern?
Is it ok to trim down a tube patch?
Can you teleport closer to a creature you are Frightened of?
(How) Could a medieval fantasy world survive a magic-induced "nuclear winter"?
Airplane gently rocking its wings during whole flight
Inexact numbers as keys in Association?
From jafe to El-Guest
Aggressive Under-Indexing and no data for missing index
Which one is the true statement?
Expectation in a stochastic differential equation
Is it professional to write unrelated content in an almost-empty email?
What connection does MS Office have to Netscape Navigator?
How to Implement Deterministic Encryption Safely in .NET
Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?
Expressing the idea of having a very busy time
Lucky Feat: How can "more than one creature spend a luck point to influence the outcome of a roll"?
Purpose of level-shifter with same in and out voltages
Can this note be analyzed as a non-chord tone?
Spaces in which all closed sets are regular closed
free fall ellipse or parabola?
Yu-Gi-Oh cards in Python 3
Reference request: Grassmannian and Plucker coordinates in type B, C, D
How do I fit a non linear curve?
Where do students learn to solve polynomial equations these days?
How to restore a MySQL database from directory files/disk (vs. dump)?
The Next CEO of Stack OverflowImport or restore MySQL databases from var directoryMySQL: how to restore from a previously saved copy of the data directory?Creating database from dump, InnoDB tables created, ISAM tables notMySQL database neither exists nor doesn'tCan't login to local phpmyadminHow to recover MySQL database on xampp/windows using ib/frm files?CentOS - Trying to backup/restore a MySQL database?Why all rows are cleared during REPAIR TABLE operation of MySQL?How to restore XAMPP server from backup?Migrate MySQL database from Windows 7 to CentOS server
This is from one AMPPS setup (on macOS) to another (Linux). I copied the directory from a hard drive backup into the new AMPPS installation. So the database itself does show up in phpMyAdmin but it appears to be empty. The directory itself does not; there is evidence of the tables as .frm and .MYD files.
linux backup mysql phpmyadmin ampps
edited 1 hour ago
JakeGould
32.2k1098141
asked 1 hour ago
MWAMWA
33
add a comment |
This is from one AMPPS setup (on macOS) to another (Linux). I copied the directory from a hard drive backup into the new AMPPS installation. So the database itself does show up in phpMyAdmin but it appears to be empty. The directory itself does not; there is evidence of the tables as .frm and .MYD files.
linux backup mysql phpmyadmin ampps
edited 1 hour ago
JakeGould
32.2k1098141
asked 1 hour ago
MWAMWA
33
Try stopping the MySQL server, then go into the data directory MySQL uses as delete any file that matches theib_logfile*pattern. Typically this isib_logfile0andib_logfile1files. These are essentially cache files that MySQL uses for the Innocences DB storage engine. They can be regenerated when MySQL starts up again. So start it up again and things should then be good. Also, this should go without saying, always keep a backup off the physical DB directories you are attempting to move over so you can be assured nothing is lost if something goes wrong.
– JakeGould
1 hour ago
add a comment |
This is from one AMPPS setup (on macOS) to another (Linux). I copied the directory from a hard drive backup into the new AMPPS installation. So the database itself does show up in phpMyAdmin but it appears to be empty. The directory itself does not; there is evidence of the tables as .frm and .MYD files.
linux backup mysql phpmyadmin ampps
edited 1 hour ago
JakeGould
32.2k1098141
asked 1 hour ago
MWAMWA
33
This is from one AMPPS setup (on macOS) to another (Linux). I copied the directory from a hard drive backup into the new AMPPS installation. So the database itself does show up in phpMyAdmin but it appears to be empty. The directory itself does not; there is evidence of the tables as .frm and .MYD files.
linux backup mysql phpmyadmin ampps
linux backup mysql phpmyadmin ampps
edited 1 hour ago
JakeGould
32.2k1098141
asked 1 hour ago
MWAMWA
33
edited 1 hour ago
JakeGould
32.2k1098141
asked 1 hour ago
MWAMWA
33
edited 1 hour ago
JakeGould
32.2k1098141
edited 1 hour ago
JakeGould
32.2k1098141
edited 1 hour ago
JakeGould
32.2k1098141
32.2k1098141
asked 1 hour ago
MWAMWA
33
asked 1 hour ago
MWAMWA
33
asked 1 hour ago
MWAMWA
33
33
Try stopping the MySQL server, then go into the data directory MySQL uses as delete any file that matches theib_logfile*pattern. Typically this isib_logfile0andib_logfile1files. These are essentially cache files that MySQL uses for the Innocences DB storage engine. They can be regenerated when MySQL starts up again. So start it up again and things should then be good. Also, this should go without saying, always keep a backup off the physical DB directories you are attempting to move over so you can be assured nothing is lost if something goes wrong.
– JakeGould
1 hour ago
add a comment |
Try stopping the MySQL server, then go into the data directory MySQL uses as delete any file that matches theib_logfile*pattern. Typically this isib_logfile0andib_logfile1files. These are essentially cache files that MySQL uses for the Innocences DB storage engine. They can be regenerated when MySQL starts up again. So start it up again and things should then be good. Also, this should go without saying, always keep a backup off the physical DB directories you are attempting to move over so you can be assured nothing is lost if something goes wrong.
– JakeGould
1 hour ago
Try stopping the MySQL server, then go into the data directory MySQL uses as delete any file that matches the
ib_logfile* pattern. Typically this is ib_logfile0 and ib_logfile1 files. These are essentially cache files that MySQL uses for the Innocences DB storage engine. They can be regenerated when MySQL starts up again. So start it up again and things should then be good. Also, this should go without saying, always keep a backup off the physical DB directories you are attempting to move over so you can be assured nothing is lost if something goes wrong.– JakeGould
1 hour ago
Try stopping the MySQL server, then go into the data directory MySQL uses as delete any file that matches the
ib_logfile* pattern. Typically this is ib_logfile0 and ib_logfile1 files. These are essentially cache files that MySQL uses for the Innocences DB storage engine. They can be regenerated when MySQL starts up again. So start it up again and things should then be good. Also, this should go without saying, always keep a backup off the physical DB directories you are attempting to move over so you can be assured nothing is lost if something goes wrong.– JakeGould
1 hour ago
add a comment |
0
active
oldest
votes
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1419763%2fhow-to-restore-a-mysql-database-from-directory-files-disk-vs-dump%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
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1419763%2fhow-to-restore-a-mysql-database-from-directory-files-disk-vs-dump%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
Try stopping the MySQL server, then go into the data directory MySQL uses as delete any file that matches the
ib_logfile*pattern. Typically this isib_logfile0andib_logfile1files. These are essentially cache files that MySQL uses for the Innocences DB storage engine. They can be regenerated when MySQL starts up again. So start it up again and things should then be good. Also, this should go without saying, always keep a backup off the physical DB directories you are attempting to move over so you can be assured nothing is lost if something goes wrong.– JakeGould
1 hour ago