phpmyadmin and database problem

G

gorski

Verified User
Joined
Mar 12, 2004
Messages
12
I can't upload db by phpmyadmin

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 !
 
Last edited:
I tryed :

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

But it not help :/
 
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
 
You must log in or register to reply here.
Back
Top