Problem with database " rm_wlan1 "

Issues related to applications and software problems
Post Reply
pompastic
Posts: 8
Joined: 2021/05/25 22:59:18

Problem with database " rm_wlan1 "

Post by pompastic » 2021/05/25 23:10:39

Hello everyone

Trying to make backup from my database using webmin ->Servers ->MySql Database Server and chose database
an error show up
SQL show index from `rm_wlan1` failed : Incorrect file format 'rm_wlan1'

any suggestions please

Regards

User avatar
TrevorH
Site Admin
Posts: 33191
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Problem with database " rm_wlan1 "

Post by TrevorH » 2021/05/25 23:22:25

At a guess, you've accidentally created a file or directory inside your mysql data directory, usually /var/lib/mysql, or in one of its sub-directories called something like "rm wlan1". Check what's there with ls -la /var/lib/mysql or find /var/lib/mysql -iname "rm*" and see what you get.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

pompastic
Posts: 8
Joined: 2021/05/25 22:59:18

Re: Problem with database " rm_wlan1 "

Post by pompastic » 2021/05/25 23:35:04

thanks for reply
the other database work fine

pompastic
Posts: 8
Joined: 2021/05/25 22:59:18

Re: Problem with database " rm_wlan1 "

Post by pompastic » 2021/05/25 23:44:58

Code: Select all

[root@localhost ~]# ls -la /var/lib/mysql
total 542756
drwxr-xr-x.  7 mysql mysql        208 May 23 18:43 .
drwxr-xr-x. 31 root  root           4096 Jan  5 17:47 ..
-rw-rw----.  1 mysql mysql        16384 May 23 18:40 aria_log.00000001
-rw-rw----.  1 mysql mysql        52 May 23 18:40 aria_log_control
drwx------.  2 mysql mysql        74 Feb  7 10:56 conntrack
-rw-rw----.  1 mysql mysql        18874368 May 26 01:32 ibdata1
-rw-rw----.  1 mysql mysql        268435456 May 26 01:32 ib_logfile0
-rw-rw----.  1 mysql mysql        268435456 May 26 01:32 ib_logfile1
drwx------.  2 mysql mysql        4096 Jan  5 17:49 mysql
srwxrwxrwx.  1 mysql mysql     0 May 23 18:43 mysql.sock
drwx------.  2 mysql mysql        4096 Jan  5 17:49 performance_schema
drwx------.  2 mysql mysql        4096 May 26 01:30 radius

pompastic
Posts: 8
Joined: 2021/05/25 22:59:18

Re: Problem with database " rm_wlan1 "

Post by pompastic » 2021/05/25 23:46:34

Code: Select all

/var/lib/mysql/radius/rm_wlan.MYI
/var/lib/mysql/radius/rm_wlan1.frm
/var/lib/mysql/radius/rm_wlan1.MYD

Post Reply