Using MySQL WorkBench to recover a .BAK fileShould I use the datetime or timestamp data type in MySQL?How to get a list of user accounts using the command line in MySQL?When to use MongoDB or other document oriented database systems?Create a new database with MySQL WorkbenchMySQL Workbench cannot load mysql.procMySQL error code: 1175 during UPDATE in MySQL Workbenchmysql workbench error opening EERHow to import an SQL file using the command line in MySQL?Export Data from mysql Workbench 6.0Converting a SQL server .bak file in to a DB in MYSQL
Why do some professors with PhDs leave their professorships to teach high school?
How to draw this center trajectory of rolling ball?
Are all instances of trolls turning to stone ultimately references back to Tolkien?
Dates on degrees don’t make sense – will people care?
Should I prioritize my 401k over my student loans?
How do I professionally let my manager know I'll quit over smoking in the office?
What's currently blocking the construction of the wall between Mexico and the US?
Do I have to explain the mechanical superiority of the player-character within the fiction of the game?
.NET executes a SQL query and Active Monitor shows multiple rows blocking each other
Drawing people along with x and y axis
Does this Wild Magic result affect the sorcerer or just other creatures?
How does the spell Remove Curse interact with a Sword of Vengeance?
Can you find x?
Why aren't non-isolated DC-DC converters made for high wattage applications?
Hot coffee brewing solutions for deep woods camping
Is this proposal by U.S. presidential candidate Pete Buttigieg to change the composition of the Supreme Court constitutional?
What happens to Cessna electric flaps that are moving when power is lost?
What did River say when she woke from her proto-comatose state?
Is it damaging to turn off a small fridge for two days every week?
Inaccessible base class despite friendship
Dystopia where people are regularly forced to move, protagonist must move daily
Why tighten down in a criss-cross pattern?
Prime sieve in Python
Unusual mail headers, evidence of an attempted attack. Have I been pwned?
Using MySQL WorkBench to recover a .BAK file
Should I use the datetime or timestamp data type in MySQL?How to get a list of user accounts using the command line in MySQL?When to use MongoDB or other document oriented database systems?Create a new database with MySQL WorkbenchMySQL Workbench cannot load mysql.procMySQL error code: 1175 during UPDATE in MySQL Workbenchmysql workbench error opening EERHow to import an SQL file using the command line in MySQL?Export Data from mysql Workbench 6.0Converting a SQL server .bak file in to a DB in MYSQL
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I am extremely new to MySQL and databases. My objective is convert a .BAK file to a database. So far I have downloaded MySQL Workbench. From there I am lost as to the process of converting the .BAK file to a database.
Any and all help would be welcomed
mysql mysql-workbench
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
add a comment |
I am extremely new to MySQL and databases. My objective is convert a .BAK file to a database. So far I have downloaded MySQL Workbench. From there I am lost as to the process of converting the .BAK file to a database.
Any and all help would be welcomed
mysql mysql-workbench
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
.bakis usually used for all kinds of backup files. What makes you think this file contains a database script?
– Mike Lischke
Apr 3 '18 at 7:10
I know that there exists a database script in the .BAK file due to the circumstances under which the file was given to me. It should just contain inventory items for a basic neighborhood store
– harpooooooon
Apr 6 '18 at 2:54
So this is a DB dump file? If so, rename it to.sqland use theRestoresection in the Admin part to load it into your server.
– Mike Lischke
Apr 6 '18 at 9:16
add a comment |
I am extremely new to MySQL and databases. My objective is convert a .BAK file to a database. So far I have downloaded MySQL Workbench. From there I am lost as to the process of converting the .BAK file to a database.
Any and all help would be welcomed
mysql mysql-workbench
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
I am extremely new to MySQL and databases. My objective is convert a .BAK file to a database. So far I have downloaded MySQL Workbench. From there I am lost as to the process of converting the .BAK file to a database.
Any and all help would be welcomed
mysql mysql-workbench
mysql mysql-workbench
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
asked Apr 2 '18 at 23:31
harpooooooonharpooooooon
12
12
.bakis usually used for all kinds of backup files. What makes you think this file contains a database script?
– Mike Lischke
Apr 3 '18 at 7:10
I know that there exists a database script in the .BAK file due to the circumstances under which the file was given to me. It should just contain inventory items for a basic neighborhood store
– harpooooooon
Apr 6 '18 at 2:54
So this is a DB dump file? If so, rename it to.sqland use theRestoresection in the Admin part to load it into your server.
– Mike Lischke
Apr 6 '18 at 9:16
add a comment |
.bakis usually used for all kinds of backup files. What makes you think this file contains a database script?
– Mike Lischke
Apr 3 '18 at 7:10
I know that there exists a database script in the .BAK file due to the circumstances under which the file was given to me. It should just contain inventory items for a basic neighborhood store
– harpooooooon
Apr 6 '18 at 2:54
So this is a DB dump file? If so, rename it to.sqland use theRestoresection in the Admin part to load it into your server.
– Mike Lischke
Apr 6 '18 at 9:16
.bak is usually used for all kinds of backup files. What makes you think this file contains a database script?– Mike Lischke
Apr 3 '18 at 7:10
.bak is usually used for all kinds of backup files. What makes you think this file contains a database script?– Mike Lischke
Apr 3 '18 at 7:10
I know that there exists a database script in the .BAK file due to the circumstances under which the file was given to me. It should just contain inventory items for a basic neighborhood store
– harpooooooon
Apr 6 '18 at 2:54
I know that there exists a database script in the .BAK file due to the circumstances under which the file was given to me. It should just contain inventory items for a basic neighborhood store
– harpooooooon
Apr 6 '18 at 2:54
So this is a DB dump file? If so, rename it to
.sql and use the Restore section in the Admin part to load it into your server.– Mike Lischke
Apr 6 '18 at 9:16
So this is a DB dump file? If so, rename it to
.sql and use the Restore section in the Admin part to load it into your server.– Mike Lischke
Apr 6 '18 at 9:16
add a comment |
1 Answer
1
active
oldest
votes
I'm probably late but I think I can help since I'm encountering the same problem.
A .bak file is in few words a MS SQL database backup file, which can be opened and managed with no problem with the Microsoft tools.
You are (I guess) trying to convert the .bak (MSSQL) into .sql (MySQL). I'm trying this same thing btw.
I found this web and so far this worked for some tables:
https://www.silicongadget.com/software/database/import-mssql-bak-files-to-mysql/2955/
Oh btw in point 9 of the tutorial linked, the migration tool can be found clicking "Database" (in the toolbar top left thing) > "Migration Wizard". Just to clear since it's not explained in the tutorial and unexperienced people can get stuck.
If you have any question let me know and I will try to solve it.
Best of luck!
answered Mar 25 at 8:47
PauPau
1
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%2f49620171%2fusing-mysql-workbench-to-recover-a-bak-file%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
I'm probably late but I think I can help since I'm encountering the same problem.
A .bak file is in few words a MS SQL database backup file, which can be opened and managed with no problem with the Microsoft tools.
You are (I guess) trying to convert the .bak (MSSQL) into .sql (MySQL). I'm trying this same thing btw.
I found this web and so far this worked for some tables:
https://www.silicongadget.com/software/database/import-mssql-bak-files-to-mysql/2955/
Oh btw in point 9 of the tutorial linked, the migration tool can be found clicking "Database" (in the toolbar top left thing) > "Migration Wizard". Just to clear since it's not explained in the tutorial and unexperienced people can get stuck.
If you have any question let me know and I will try to solve it.
Best of luck!
answered Mar 25 at 8:47
PauPau
1
add a comment |
I'm probably late but I think I can help since I'm encountering the same problem.
A .bak file is in few words a MS SQL database backup file, which can be opened and managed with no problem with the Microsoft tools.
You are (I guess) trying to convert the .bak (MSSQL) into .sql (MySQL). I'm trying this same thing btw.
I found this web and so far this worked for some tables:
https://www.silicongadget.com/software/database/import-mssql-bak-files-to-mysql/2955/
Oh btw in point 9 of the tutorial linked, the migration tool can be found clicking "Database" (in the toolbar top left thing) > "Migration Wizard". Just to clear since it's not explained in the tutorial and unexperienced people can get stuck.
If you have any question let me know and I will try to solve it.
Best of luck!
answered Mar 25 at 8:47
PauPau
1
add a comment |
I'm probably late but I think I can help since I'm encountering the same problem.
A .bak file is in few words a MS SQL database backup file, which can be opened and managed with no problem with the Microsoft tools.
You are (I guess) trying to convert the .bak (MSSQL) into .sql (MySQL). I'm trying this same thing btw.
I found this web and so far this worked for some tables:
https://www.silicongadget.com/software/database/import-mssql-bak-files-to-mysql/2955/
Oh btw in point 9 of the tutorial linked, the migration tool can be found clicking "Database" (in the toolbar top left thing) > "Migration Wizard". Just to clear since it's not explained in the tutorial and unexperienced people can get stuck.
If you have any question let me know and I will try to solve it.
Best of luck!
answered Mar 25 at 8:47
PauPau
1
I'm probably late but I think I can help since I'm encountering the same problem.
A .bak file is in few words a MS SQL database backup file, which can be opened and managed with no problem with the Microsoft tools.
You are (I guess) trying to convert the .bak (MSSQL) into .sql (MySQL). I'm trying this same thing btw.
I found this web and so far this worked for some tables:
https://www.silicongadget.com/software/database/import-mssql-bak-files-to-mysql/2955/
Oh btw in point 9 of the tutorial linked, the migration tool can be found clicking "Database" (in the toolbar top left thing) > "Migration Wizard". Just to clear since it's not explained in the tutorial and unexperienced people can get stuck.
If you have any question let me know and I will try to solve it.
Best of luck!
answered Mar 25 at 8:47
PauPau
1
answered Mar 25 at 8:47
PauPau
1
answered Mar 25 at 8:47
PauPau
1
answered Mar 25 at 8:47
PauPau
1
1
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%2f49620171%2fusing-mysql-workbench-to-recover-a-bak-file%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
.bakis usually used for all kinds of backup files. What makes you think this file contains a database script?– Mike Lischke
Apr 3 '18 at 7:10
I know that there exists a database script in the .BAK file due to the circumstances under which the file was given to me. It should just contain inventory items for a basic neighborhood store
– harpooooooon
Apr 6 '18 at 2:54
So this is a DB dump file? If so, rename it to
.sqland use theRestoresection in the Admin part to load it into your server.– Mike Lischke
Apr 6 '18 at 9:16