-bash-2.05b$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| avions |
| copper |
| egroupdb |
| mysql |
| test |
+--------------------+
6 rows in set (0.10 sec)
mysql> use egroudb;
ERROR 1049 (42000): Unknown database 'egroudb'
mysql> use egroupdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)
J'ai verifie les permissions, elles me sembles bonnes:
bash-2.05b# cd /var/db/
drwx------ 7 mysql mysql 9216 Jan 3 19:49 mysql
bash-2.05b# cd mysql
drwx------ 2 mysql mysql 11264 Jan 2 20:20 egroupdb
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Thierry
Thierry a écrit :
Bonjour, J'ai un soucis avec mysql/freebsd 6.2 :
-bash-2.05b$ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | avions | | copper | | egroupdb | | mysql | | test | +--------------------+ 6 rows in set (0.10 sec)
mysql> use egroudb; ERROR 1049 (42000): Unknown database 'egroudb' mysql> use egroupdb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed mysql> show tables; ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)
J'ai verifie les permissions, elles me sembles bonnes:
bash-2.05b# cd /var/db/ drwx------ 7 mysql mysql 9216 Jan 3 19:49 mysql bash-2.05b# cd mysql drwx------ 2 mysql mysql 11264 Jan 2 20:20 egroupdb
Les tables sont toutes: -rw-rw---- 1 mysql mysql
Merci pour votre aide.
Je viens aussi de trouver ces logs:
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_quota.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_quota.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_shares.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_shares.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_versioning.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)
Et pourtant: -rw-rw---- 1 mysql mysql 8788 Jan 2 20:20 phpgw_vfs2_mimetypes.frm ... meme chose pour les autres ....
Thierry a écrit :
Bonjour,
J'ai un soucis avec mysql/freebsd 6.2 :
-bash-2.05b$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| avions |
| copper |
| egroupdb |
| mysql |
| test |
+--------------------+
6 rows in set (0.10 sec)
mysql> use egroudb;
ERROR 1049 (42000): Unknown database 'egroudb'
mysql> use egroupdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)
J'ai verifie les permissions, elles me sembles bonnes:
bash-2.05b# cd /var/db/
drwx------ 7 mysql mysql 9216 Jan 3 19:49 mysql
bash-2.05b# cd mysql
drwx------ 2 mysql mysql 11264 Jan 2 20:20 egroupdb
Les tables sont toutes: -rw-rw---- 1 mysql mysql
Merci pour votre aide.
Je viens aussi de trouver ces logs:
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_quota.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_quota.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_shares.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_shares.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)
Et pourtant: -rw-rw---- 1 mysql mysql 8788 Jan 2 20:20
phpgw_vfs2_mimetypes.frm ... meme chose pour les autres ....
-bash-2.05b$ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | avions | | copper | | egroupdb | | mysql | | test | +--------------------+ 6 rows in set (0.10 sec)
mysql> use egroudb; ERROR 1049 (42000): Unknown database 'egroudb' mysql> use egroupdb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed mysql> show tables; ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)
J'ai verifie les permissions, elles me sembles bonnes:
bash-2.05b# cd /var/db/ drwx------ 7 mysql mysql 9216 Jan 3 19:49 mysql bash-2.05b# cd mysql drwx------ 2 mysql mysql 11264 Jan 2 20:20 egroupdb
Les tables sont toutes: -rw-rw---- 1 mysql mysql
Merci pour votre aide.
Je viens aussi de trouver ces logs:
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_quota.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_quota.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_shares.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_shares.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_versioning.frm' (errno: 24) 080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file: './egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)
Et pourtant: -rw-rw---- 1 mysql mysql 8788 Jan 2 20:20 phpgw_vfs2_mimetypes.frm ... meme chose pour les autres ....