#1146 table 'db.tablename' doesnt exist
I use AMPPS for localhost server purpose. I was working on one of my client site on localhost.
When I start working the other day, it suddenly start giving me such error
table does not exist Even though I can clearly see tables on left hand side bar as you can see in attached image.
If I click on columns in table, it show such error.
I tried lots of ways mentioned on net. But I am unable to solve the issue. I don't know what exactly happened there.
Please help me out. Any help will do.
Thanks, Mahesh
mysql database mysqli phpmyadmin
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
add a comment |
I use AMPPS for localhost server purpose. I was working on one of my client site on localhost.
When I start working the other day, it suddenly start giving me such error
table does not exist Even though I can clearly see tables on left hand side bar as you can see in attached image.
If I click on columns in table, it show such error.
I tried lots of ways mentioned on net. But I am unable to solve the issue. I don't know what exactly happened there.
Please help me out. Any help will do.
Thanks, Mahesh
mysql database mysqli phpmyadmin
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
may be files of the tables got corrupted.
– Madhur Sharma
Nov 23 '18 at 10:48
how can it get corrupted..? Is there any solution for that..?
– Mahesh Yadav
Nov 23 '18 at 10:50
will you please run theshow tablescommand in sql section.
– Madhur Sharma
Nov 23 '18 at 10:59
try this link . this can sort out your problem dba.stackexchange.com/questions/133481/…
– Madhur Sharma
Nov 23 '18 at 11:00
add a comment |
I use AMPPS for localhost server purpose. I was working on one of my client site on localhost.
When I start working the other day, it suddenly start giving me such error
table does not exist Even though I can clearly see tables on left hand side bar as you can see in attached image.
If I click on columns in table, it show such error.
I tried lots of ways mentioned on net. But I am unable to solve the issue. I don't know what exactly happened there.
Please help me out. Any help will do.
Thanks, Mahesh
mysql database mysqli phpmyadmin
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
I use AMPPS for localhost server purpose. I was working on one of my client site on localhost.
When I start working the other day, it suddenly start giving me such error
table does not exist Even though I can clearly see tables on left hand side bar as you can see in attached image.
If I click on columns in table, it show such error.
I tried lots of ways mentioned on net. But I am unable to solve the issue. I don't know what exactly happened there.
Please help me out. Any help will do.
Thanks, Mahesh
mysql database mysqli phpmyadmin
mysql database mysqli phpmyadmin
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
asked Nov 23 '18 at 10:44
Mahesh YadavMahesh Yadav
3716
3716
may be files of the tables got corrupted.
– Madhur Sharma
Nov 23 '18 at 10:48
how can it get corrupted..? Is there any solution for that..?
– Mahesh Yadav
Nov 23 '18 at 10:50
will you please run theshow tablescommand in sql section.
– Madhur Sharma
Nov 23 '18 at 10:59
try this link . this can sort out your problem dba.stackexchange.com/questions/133481/…
– Madhur Sharma
Nov 23 '18 at 11:00
add a comment |
may be files of the tables got corrupted.
– Madhur Sharma
Nov 23 '18 at 10:48
how can it get corrupted..? Is there any solution for that..?
– Mahesh Yadav
Nov 23 '18 at 10:50
will you please run theshow tablescommand in sql section.
– Madhur Sharma
Nov 23 '18 at 10:59
try this link . this can sort out your problem dba.stackexchange.com/questions/133481/…
– Madhur Sharma
Nov 23 '18 at 11:00
may be files of the tables got corrupted.
– Madhur Sharma
Nov 23 '18 at 10:48
may be files of the tables got corrupted.
– Madhur Sharma
Nov 23 '18 at 10:48
how can it get corrupted..? Is there any solution for that..?
– Mahesh Yadav
Nov 23 '18 at 10:50
how can it get corrupted..? Is there any solution for that..?
– Mahesh Yadav
Nov 23 '18 at 10:50
will you please run the
show tables command in sql section.– Madhur Sharma
Nov 23 '18 at 10:59
will you please run the
show tables command in sql section.– Madhur Sharma
Nov 23 '18 at 10:59
try this link . this can sort out your problem dba.stackexchange.com/questions/133481/…
– Madhur Sharma
Nov 23 '18 at 11:00
try this link . this can sort out your problem dba.stackexchange.com/questions/133481/…
– Madhur Sharma
Nov 23 '18 at 11:00
add a comment |
0
active
oldest
votes
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%2f53445176%2f1146-table-db-tablename-doesnt-exist%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 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%2f53445176%2f1146-table-db-tablename-doesnt-exist%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
may be files of the tables got corrupted.
– Madhur Sharma
Nov 23 '18 at 10:48
how can it get corrupted..? Is there any solution for that..?
– Mahesh Yadav
Nov 23 '18 at 10:50
will you please run the
show tablescommand in sql section.– Madhur Sharma
Nov 23 '18 at 10:59
try this link . this can sort out your problem dba.stackexchange.com/questions/133481/…
– Madhur Sharma
Nov 23 '18 at 11:00