[SOLVED] Can't access a table with phpmyadmin

devilboy09 · 07-24-2016, 11:59 AM

i have a database an i can view it's tables with phpmyadmin but there is a table that i can't do anything to it.not repairing nor optimizing.

please help me to resolve this issue

TB0ne · 07-24-2016, 12:19 PM

Quote:

Originally Posted by devilboy09

i have a database an i can view it's tables with phpmyadmin but there is a table that i can't do anything to it.not repairing nor optimizing. please help me to resolve this issue

You've been here for FIVE YEARS now...you should know that, unless you provide usable details, there is NOTHING we can tell you...we can't guess.

You say nothing about your version/distro of Linux, MySQL, what you've done/tried, ANY diagnostics at all? Short answer: look in your MySQL logs for hints. Chances are, it has to do with permissions on that table. Longer answer: no guesses, since you provide no details.

devilboy09 · 07-24-2016, 12:31 PM

Quote:

Originally Posted by TB0ne

You've been here for FIVE YEARS now...you should know that, unless you provide usable details, there is NOTHING we can tell you...we can't guess.

You say nothing about your version/distro of Linux, MySQL, what you've done/tried, ANY diagnostics at all? Short answer: look in your MySQL logs for hints. Chances are, it has to do with permissions on that table. Longer answer: no guesses, since you provide no details.

sorry about that.i use cloudlinux on my server and the version of mysql is 5.6.22.when i connect to phpmyadmin all of the tables from a certain db works fine but there is just one table that seems to have a issue.when i click to brows it it just shows Loading phrase on the screen and nothing happens.

i tries to repair and optimize the table but they didn't help.also the table size is 23KB.

btw which log files should i check ?

TB0ne · 07-24-2016, 02:28 PM

Quote:

Originally Posted by devilboy09

sorry about that.i use cloudlinux on my server and the version of mysql is 5.6.22.when i connect to phpmyadmin all of the tables from a certain db works fine but there is just one table that seems to have a issue.when i click to brows it it just shows Loading phrase on the screen and nothing happens. i tries to repair and optimize the table but they didn't help.also the table size is 23KB.

23k is TINY. And, unless you have permissions to access that database/table, clicking ANYTHING that affects it won't do anything, obviously. Contact your hosting provider, and ask them. Since this is a hosted server, unless YOU set up MySQL and configured EVERYTHING on it, they will have to assist you.

Quote:

btw which log files should i check ?

Quite obviously, the MySQL log files, since you're trying to access a MySQL database.

devilboy09 · 07-25-2016, 12:10 PM

thank you for your response but i'm the sys admin and i checked everything.i can't even repair or check that table.every table on that db works fine but i don't know why i have this stupid problem with this table
!!!

devilboy09 · 07-25-2016, 01:35 PM

i get this error

myisamchk: warning: 1 client is using or hasn't closed the table properly

when i issue this command

myisamchk /var/lib/mysql/nanofa_eshterak/members.MYI

Habitual · 07-25-2016, 01:44 PM

Well, I'm not debugging phpmyadmin, that's for sure! Soooo.........
try it from c-line?

http://www.thegeekstuff.com/2011/12/mysqlcheck/

seems to suggest:

Code:

mysqlcheck -c nanofa_eshterak members -u root -p

Please let us know.

devilboy09 · 07-25-2016, 01:59 PM

didn't work.the db size is just 10MB and it takes a long time and nothing returns in std output

TB0ne · 07-25-2016, 03:28 PM

Quote:

Originally Posted by devilboy09

thank you for your response but i'm the sys admin and i checked everything.i can't even repair or check that table.every table on that db works fine but i don't know why i have this stupid problem with this table!!!

You're the admin, so you should know (as said in the first reply), to provide details. Again, you've been here five years....

Quote:

Originally Posted by devilboy09

i get this error

myisamchk: warning: 1 client is using or hasn't closed the table properly

when i issue this command myisamchk /var/lib/mysql/nanofa_eshterak/members.MYI

Ok...so did you try to look that error up? The very first hit in Google:
http://dev.mysql.com/doc/refman/5.7/...ble-close.html

...along with MANY others, with suggestions as to how to repair it:
http://dba.stackexchange.com/questio...these-warnings

Quote:

Originally Posted by devilboy09

didn't work.the db size is just 10MB and it takes a long time and nothing returns in std output

Interesting, especially since you said in post #3, your first reply, that it was 23k...and now it's 10MB...which is it? And you do realize that nothing returning, means the command finished, right?

Have you tried running "REPAIR TABLE xxxx" from the mysql prompt?????

Habitual · 07-25-2016, 03:44 PM

Quote:

Originally Posted by devilboy09

didn't work.

Nothing personal, but this^ doesn't work for me.
IIRC myisamchk is a very verbose utility.

Good Luck.

devilboy09 · 07-26-2016, 01:53 AM

Quote:

Originally Posted by TB0ne

You're the admin, so you should know (as said in the first reply), to provide details. Again, you've been here five years....

Ok...so did you try to look that error up? The very first hit in Google:
http://dev.mysql.com/doc/refman/5.7/...ble-close.html

...along with MANY others, with suggestions as to how to repair it:
http://dba.stackexchange.com/questio...these-warnings

Interesting, especially since you said in post #3, your first reply, that it was 23k...and now it's 10MB...which is it? And you do realize that nothing returning, means the command finished, right?

Have you tried running "REPAIR TABLE xxxx" from the mysql prompt?????

i said earlier that i tried to repair and check the table, of course i did it from CLI.
btw i said the table is 23K the whole database has size of 23MB

TB0ne · 07-26-2016, 07:31 AM

Quote:

Originally Posted by devilboy09

i said earlier that i tried to repair and check the table, of course i did it from CLI.

Saying "of course" is meaningless....we can't guess/know what you've done or tried can we? We've given you several things to do/try, and aside from "of course", you've not said what you HAVE done, or posted the results of those commands. If you're not going to participate in the conversation, there's not much point in posting.

Quote:

btw i said the table is 23K the whole database has size of 23MB

Ok..but 23MB is still tiny.

Habitual · 07-26-2016, 02:27 PM

Quote:

Originally Posted by TB0ne

Saying "of course" is meaningless....we can't guess/know what you've done or tried can we? We've given you several things to do/try, and aside from "of course", you've not said what you HAVE done, or posted the results of those commands. If you're not going to participate in the conversation, there's not much point in posting.

Ok..but 23MB is still tiny.

It's a baby-fart of a db.
I had a 31G Zabbix with a busted table.
Crunched all night long.

23MB? Pft. I think I lost that formatting.

If you're worried about it, export it first.

Code:

mysql -uroot -p nanofa_eshterak > /path/to/$(date +%F)-nanofa_eshterak.sql

Habitual · 07-26-2016, 02:34 PM

Quote:

Originally Posted by devilboy09

i get this error

myisamchk: warning: 1 client is using or hasn't closed the table properly

when i issue this command

myisamchk /var/lib/mysql/nanofa_eshterak/members.MYI

I think you need to stop mysql first...?

Code:

sudo service mysql-server stop

and then run

Code:

sudo myisamchk /var/lib/mysql/nanofa_eshterak/members.MYI

and then restart mysql-server

Code:

sudo service mysql-server start

Is there something "special" about members?

devilboy09 · 07-27-2016, 05:43 AM

Quote:

Originally Posted by Habitual

It's a baby-fart of a db.
I had a 31G Zabbix with a busted table.
Crunched all night long.

23MB? Pft. I think I lost that formatting.

If you're worried about it, export it first.

Code:

mysql -uroot -p nanofa_eshterak > /path/to/$(date +%F)-nanofa_eshterak.sql

that's the problem i can't make a backup from db