phpmyadmin and database problem

[gorski]

I can't upload db by phpmyadmin.

When we try to upload a file.sql or file.gz

there is a error

"Cannot find a sql tables"

But it work on another server.

maybe phpadmin restart can help, how to do that ?

-----------------
Second error (in my friend account)

that problem is visible in phpbb forum
--------------
Can't open file: 'ibf_topics.MYI'. (errno: 144)
Error
SQL :
SHOW KEYS FROM `ibf_topics`
MySQL return massage:

#1016 - Can't open file: 'ibf_topics.MYI'. (errno: 144)


Maybe someone have a idea to fix that problems ?

I appreciate any help !

[gorski]

I tryed :

cd /usr/local/directadmin/scripts
./phpMyAdmin.sh

But it not help :/

[DirectAdmin Support]

Hello,

You can't just rename an sql file to a gz file.. the gz file is gzipped while the sql file is plain text for the database. You'd need to either run the sql file through mysql manually or you'll have to gzip the sql file then try again.


#1016 - Can't open file: 'ibf_topics.MYI'. (errno: 144)
That means the table is corruped. You'd need to try:

REPAIR TABLE ibf_topics

from a mysql prompt (or phpMyAdmin).

John

[gorski]

I find a problem :)

tmp was full :)

Soory for that problem :)