Query failed : Table 'tbl_knowledgebase_qns' is read only

disoft · #1 29.04.2007, 12:35

Hallo @all,

erst zum Sachverhalt:

1. Ich habe mir das Verzeichnis "/var/lib/mysql/" gesichert und den Server mit dem gleichen Grundsystem (PHP gleiche Version, MySQL gleiche Version, etc.) neu aufgesetzt.

2. Dann habe ich den Inhalt des o.g. gesicherten Verzeichnisses in das neue Verzeichnis /var/lib/mysql kopiert.

3. Die Tabellen werden komplett in PHPmyAdmin angezeigt.

Nun aber das Problem:

Wenn ich eine Webseite aufrufe, die auf die MySQL-Datenbank zugreift, erhalte ich beispielsweise diesen Fehler:

Query failed : Table 'tbl_knowledgebase_qns' is read only

Was hat dieses read only zu bedeuten?

Ich danke euch für eure Hilfe!

MfG

disoft

Huschi · #2 29.04.2007, 20:27

Dann zeig uns mal das Ergebnis von

Code:

ls -l /var/lib/mysql/
ls -l /var/lib/mysql/DBNAME/

huschi.

disoft · #3 30.04.2007, 13:45

Hallo Huschi,

vielen Dank für deine Antwort!

Hier das Ergebnis mit dem Befehl "ls -l /var/lib/mysql/":

Code:

total 20620
drwxr-xr-x  16 mysql mysql     4096 Apr 29 17:45 .
drwxr-xr-x  25 root  root      4096 Oct 13  2005 ..
drwx------   2 mysql mysql     4096 Apr 28 18:16 backup
drwx------   2 mysql mysql    28672 Apr 28 18:21 disoft
drwx------   2 mysql mysql     4096 Apr 28 18:21 flirt
drwx------   2 mysql mysql     4096 Apr 28 18:21 flirtvoting
drwx------   2 mysql mysql     4096 Apr 28 18:21 flirtwebcam
drwx------   2 mysql mysql     4096 Apr 28 18:21 games
drwx------   2 mysql mysql     4096 Apr 28 18:22 games18
drwx------   2 mysql mysql     4096 Apr 28 18:22 handyburner
drwx------   2 mysql mysql     4096 Apr 28 18:22 helpdesk
-rw-rw----   1 root  root   5242880 Apr 28 18:29 ib_logfile0
-rw-rw----   1 root  root   5242880 Oct 12  2005 ib_logfile1
-rw-rw----   1 root  root  10485760 Sep 13  2006 ibdata1
drwx------   2 mysql mysql     4096 Apr 28 18:22 monitoring
drwx------   2 mysql mysql     4096 Oct 12  2005 mysql
srwxrwxrwx   1 mysql mysql        0 Apr 28 18:29 mysql.sock
-rw-rw----   1 mysql mysql        0 Apr 29 17:45 mysqld.log
-rw-rw----   1 mysql mysql      219 Apr 28 18:29 mysqld.log.1
-rw-rw----   1 mysql mysql      261 Dec  9  2005 mysqld.log.4.gz
-rw-rw----   1 mysql mysql        5 Apr 28 18:29 mysqld.pid
drwx------   2 mysql mysql     4096 Apr 28 18:22 remind
drwx------   2 mysql mysql     4096 Apr 28 18:22 support
-rw-r--r--   1 mysql mysql        0 Oct 12  2005 update-stamp-4.1
drwx------   2 mysql mysql     4096 Oct 12  2005 visas

Und hier das Ergebnis von "ls -l /var/lib/mysql/disoft/" -> disoft ist eine Datenbank:

Code:

-rw-r--r--   1 root  root     8898 Oct  2  2006 olc_reviews.frm
-rw-r--r--   1 root  root        0 Oct  2  2006 olc_reviews_description.MYD
-rw-r--r--   1 root  root     1024 Oct  2  2006 olc_reviews_description.MYI
-rw-r--r--   1 root  root     8664 Oct  2  2006 olc_reviews_description.frm
-rw-r--r--   1 root  root   131160 Oct 29  2006 olc_sessions.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 olc_sessions.MYI
-rw-r--r--   1 root  root     8632 Oct  2  2006 olc_sessions.frm
-rw-r--r--   1 root  root      140 Oct  2  2006 olc_shipping_status.MYD
-rw-r--r--   1 root  root     3072 Dec  2 17:08 olc_shipping_status.MYI
-rw-r--r--   1 root  root     8758 Oct  2  2006 olc_shipping_status.frm
-rw-r--r--   1 root  root        0 Oct  2  2006 olc_specials.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 olc_specials.MYI
-rw-r--r--   1 root  root     8958 Oct  2  2006 olc_specials.frm
-rw-r--r--   1 root  root       72 Oct  2  2006 olc_tax_class.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 olc_tax_class.MYI
-rw-r--r--   1 root  root     8782 Oct  2  2006 olc_tax_class.frm
-rw-r--r--   1 root  root      164 Oct  2  2006 olc_tax_rates.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 olc_tax_rates.MYI
-rw-r--r--   1 root  root     8892 Oct  2  2006 olc_tax_rates.frm
-rw-r--r--   1 root  root        0 Oct  2  2006 olc_vornamen.MYD
-rw-r--r--   1 root  root     1024 Oct  2  2006 olc_vornamen.MYI
-rw-r--r--   1 root  root     8608 Oct  2  2006 olc_vornamen.frm
-rw-r--r--   1 root  root        0 Oct  2  2006 olc_whos_online.MYD
-rw-r--r--   1 root  root     1024 Oct  2  2006 olc_whos_online.MYI
-rw-r--r--   1 root  root     8840 Oct  2  2006 olc_whos_online.frm
-rw-r--r--   1 root  root    23332 Oct  2  2006 olc_zones.MYD
-rw-r--r--   1 root  root     9216 Dec  2 17:08 olc_zones.MYI
-rw-r--r--   1 root  root     8698 Oct  2  2006 olc_zones.frm
-rw-r--r--   1 root  root     7524 Oct  2  2006 olc_zones_to_geo_zones.MYD
-rw-r--r--   1 root  root     4096 Dec  2 17:08 olc_zones_to_geo_zones.MYI
-rw-r--r--   1 root  root     8802 Oct  2  2006 olc_zones_to_geo_zones.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 orders.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 orders.MYI
-rw-r--r--   1 root  root    12430 Sep 17  2006 orders.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 orders_products.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 orders_products.MYI
-rw-r--r--   1 root  root     9138 Sep 17  2006 orders_products.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 orders_products_attributes.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 orders_products_attributes.MYI
-rw-r--r--   1 root  root     8938 Sep 17  2006 orders_products_attributes.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 orders_products_download.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 orders_products_download.MYI
-rw-r--r--   1 root  root     8878 Sep 17  2006 orders_products_download.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 orders_recalculate.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 orders_recalculate.MYI
-rw-r--r--   1 root  root     8804 Sep 17  2006 orders_recalculate.frm
-rw-r--r--   1 root  root      140 Sep 17  2006 orders_status.MYD
-rw-r--r--   1 root  root     3072 Dec  2 17:08 orders_status.MYI
-rw-r--r--   1 root  root     8686 Sep 17  2006 orders_status.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 orders_status_history.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 orders_status_history.MYI
-rw-r--r--   1 root  root     8830 Sep 17  2006 orders_status_history.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 orders_total.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 orders_total.MYI
-rw-r--r--   1 root  root     8790 Sep 17  2006 orders_total.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 payment_moneybookers.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 payment_moneybookers.MYI
-rw-r--r--   1 root  root     8800 Sep 17  2006 payment_moneybookers.frm
-rw-r--r--   1 root  root     1576 Sep 17  2006 payment_moneybookers_countries.MYD
-rw-r--r--   1 root  root     4096 Dec  2 17:08 payment_moneybookers_countries.MYI
-rw-r--r--   1 root  root     8600 Sep 17  2006 payment_moneybookers_countries.frm
-rw-r--r--   1 root  root      624 Sep 17  2006 payment_moneybookers_currencies.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 payment_moneybookers_currencies.MYI
-rw-r--r--   1 root  root     8614 Sep 17  2006 payment_moneybookers_currencies.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 payment_qenta.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 payment_qenta.MYI
-rw-r--r--   1 root  root     8754 Sep 17  2006 payment_qenta.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 personal_offers_by_customers_status_0.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 personal_offers_by_customers_status_0.MYI
-rw-r--r--   1 root  root     8700 Sep 17  2006 personal_offers_by_customers_status_0.frm
-rw-r--r--   1 root  root       90 Oct  2  2006 personal_offers_by_customers_status_1.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 personal_offers_by_customers_status_1.MYI
-rw-r--r--   1 root  root     8700 Sep 17  2006 personal_offers_by_customers_status_1.frm
-rw-r--r--   1 root  root       90 Oct  2  2006 personal_offers_by_customers_status_2.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 personal_offers_by_customers_status_2.MYI
-rw-r--r--   1 root  root     8700 Sep 17  2006 personal_offers_by_customers_status_2.frm
-rw-r--r--   1 root  root       90 Oct  2  2006 personal_offers_by_customers_status_3.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 personal_offers_by_customers_status_3.MYI
-rw-r--r--   1 root  root     8700 Sep 17  2006 personal_offers_by_customers_status_3.frm
-rw-r--r--   1 root  root       90 Oct  2  2006 personal_offers_by_customers_status_4.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 personal_offers_by_customers_status_4.MYI
-rw-r--r--   1 root  root     8700 Oct  1  2006 personal_offers_by_customers_status_4.frm
-rw-r--r--   1 root  root       76 Dec  2 17:08 products.MYD
-rw-r--r--   1 root  root     3072 Dec  2 17:08 products.MYI
-rw-r--r--   1 root  root    10266 Oct  1  2006 products.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_attributes.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 products_attributes.MYI
-rw-r--r--   1 root  root     9106 Sep 17  2006 products_attributes.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_attributes_download.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 products_attributes_download.MYI
-rw-r--r--   1 root  root     8828 Sep 17  2006 products_attributes_download.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_content.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 products_content.MYI
-rw-r--r--   1 root  root     8932 Sep 17  2006 products_content.frm
-rw-r--r--   1 root  root     1868 Mar 29 22:48 products_description.MYD
-rw-r--r--   1 root  root     3072 Mar 30 20:22 products_description.MYI
-rw-r--r--   1 root  root     9154 Sep 17  2006 products_description.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_graduated_prices.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 products_graduated_prices.MYI
-rw-r--r--   1 root  root     8652 Sep 17  2006 products_graduated_prices.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_images.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 products_images.MYI
-rw-r--r--   1 root  root     8692 Sep 17  2006 products_images.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_notifications.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 products_notifications.MYI
-rw-r--r--   1 root  root     8662 Sep 17  2006 products_notifications.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_options.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 products_options.MYI
-rw-r--r--   1 root  root     8698 Sep 17  2006 products_options.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_options_values.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 products_options_values.MYI
-rw-r--r--   1 root  root     8726 Sep 17  2006 products_options_values.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_options_values_to_products_options.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 products_options_values_to_products_options.MYI
-rw-r--r--   1 root  root     8778 Sep 17  2006 products_options_values_to_products_options.frm
-rw-r--r--   1 root  root       18 Dec  2 17:08 products_to_categories.MYD
-rw-r--r--   1 root  root     2048 Dec  2 17:08 products_to_categories.MYI
-rw-r--r--   1 root  root     8622 Sep 17  2006 products_to_categories.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_vpe.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 products_vpe.MYI
-rw-r--r--   1 root  root     8682 Sep 17  2006 products_vpe.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_xsell.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 products_xsell.MYI
-rw-r--r--   1 root  root     8754 Sep 17  2006 products_xsell.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 products_xsell_grp_name.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 products_xsell_grp_name.MYI
-rw-r--r--   1 root  root     8742 Sep 17  2006 products_xsell_grp_name.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 reviews.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 reviews.MYI
-rw-r--r--   1 root  root     8898 Sep 17  2006 reviews.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 reviews_description.MYD
-rw-r--r--   1 root  root     1024 Sep 17  2006 reviews_description.MYI
-rw-r--r--   1 root  root     8664 Sep 17  2006 reviews_description.frm
-rw-r--r--   1 root  root     6284 Apr 19 10:45 sessions.MYD
-rw-r--r--   1 root  root     2048 Apr 19 17:21 sessions.MYI
-rw-r--r--   1 root  root     8632 Sep 17  2006 sessions.frm
-rw-r--r--   1 root  root      140 Sep 17  2006 shipping_status.MYD
-rw-r--r--   1 root  root     3072 Dec  2 17:08 shipping_status.MYI
-rw-r--r--   1 root  root     8758 Sep 17  2006 shipping_status.frm
-rw-r--r--   1 root  root        0 Sep 17  2006 specials.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 specials.MYI
-rw-r--r--   1 root  root     9014 Sep 17  2006 specials.frm
-rw-r--r--   1 root  root        0 Sep 16  2006 sponsoring_acls.MYD
-rw-r--r--   1 root  root     1024 Dec  2 17:08 sponsoring_acls.MYI
-rw-r--r--   1 root  root     8765 Sep 16  2006 sponsoring_acls.frm
-rw-r--r--   1 root  root     8816 Apr 20 02:59 sponsoring_adclicks.MYD
-rw-r--r--   1 root  root    11264 Apr 20 02:59 sponsoring_adclicks.MYI
-rw-r--r--   1 root  root     8738 Sep 16  2006 sponsoring_adclicks.frm
-rw-r--r--   1 root  root    78960 Dec 15 22:15 sponsoring_adstats.MYD
-rw-r--r--   1 root  root   133120 Dec 16 15:22 sponsoring_adstats.MYI
-rw-r--r--   1 root  root     8760 Sep 16  2006 sponsoring_adstats.frm
-rw-r--r--   1 root  root    61280 Apr 22 21:39 sponsoring_adviews.MYD
-rw-r--r--   1 root  root    50176 Apr 22 21:39 sponsoring_adviews.MYI
-rw-r--r--   1 root  root     8738 Sep 16  2006 sponsoring_adviews.frm
-rw-r--r--   1 root  root      132 Dec 16 15:48 sponsoring_affiliates.MYD
-rw-r--r--   1 root  root     2048 Dec 19 15:51 sponsoring_affiliates.MYI
-rw-r--r--   1 root  root     8916 Sep 16  2006 sponsoring_affiliates.frm
-rw-r--r--   1 root  root    25104 Apr 23 06:00 sponsoring_banners.MYD
-rw-r--r--   1 root  root     2048 Apr 23 06:00 sponsoring_banners.MYI
-rw-r--r--   1 root  root     9801 Sep 16  2006 sponsoring_banners.frm
-rw-r--r--   1 root  root        0 Apr 23 06:00 sponsoring_cache.MYD
-rw-r--r--   1 root  root     1024 Apr 23 06:00 sponsoring_cache.MYI
-rw-r--r--   1 root  root     8602 Sep 16  2006 sponsoring_cache.frm
-rw-r--r--   1 root  root     1252 Apr 21 23:00 sponsoring_clients.MYD
-rw-r--r--   1 root  root     2048 Apr  1 00:00 sponsoring_clients.MYI
-rw-r--r--   1 root  root     9376 Sep 16  2006 sponsoring_clients.frm
-rw-r--r--   1 root  root     2752 Apr 23 06:00 sponsoring_config.MYD
-rw-r--r--   1 root  root     2048 Apr 15 23:00 sponsoring_config.MYI
-rw-r--r--   1 root  root    12458 Dec 15 19:21 sponsoring_config.frm
-rw-r--r--   1 root  root        0 Sep 16  2006 sponsoring_images.MYD
-rw-r--r--   1 root  root     1024 Sep 16  2006 sponsoring_images.MYI
-rw-r--r--   1 root  root     8642 Sep 16  2006 sponsoring_images.frm
-rw-r--r--   1 root  root    21352 Dec 16 16:11 sponsoring_session.MYD
-rw-r--r--   1 root  root     2048 Dec 20 18:19 sponsoring_session.MYI
-rw-r--r--   1 root  root     8652 Sep 16  2006 sponsoring_session.frm
-rw-r--r--   1 root  root     1920 Apr 22 23:00 sponsoring_targetstats.MYD
-rw-r--r--   1 root  root     4096 Apr 22 23:00 sponsoring_targetstats.MYI
-rw-r--r--   1 root  root     8700 Sep 16  2006 sponsoring_targetstats.frm
-rw-r--r--   1 root  root  6839128 Apr 23 06:00 sponsoring_userlog.MYD
-rw-r--r--   1 root  root    24576 Apr 23 06:00 sponsoring_userlog.MYI
-rw-r--r--   1 root  root     8786 Sep 16  2006 sponsoring_userlog.frm
-rw-r--r--   1 root  root       96 Dec 16 15:48 sponsoring_zones.MYD
-rw-r--r--   1 root  root     4096 Dec 18 14:03 sponsoring_zones.MYI
-rw-r--r--   1 root  root     9006 Sep 16  2006 sponsoring_zones.frm
-rw-r--r--   1 root  root       72 Mar 29 22:48 tax_class.MYD
-rw-r--r--   1 root  root     2048 Mar 30 01:19 tax_class.MYI
-rw-r--r--   1 root  root     8782 Sep 17  2006 tax_class.frm
-rw-r--r--   1 root  root      220 Mar 29 22:48 tax_rates.MYD
-rw-r--r--   1 root  root     2048 Mar 30 01:19 tax_rates.MYI
-rw-r--r--   1 root  root     8892 Sep 17  2006 tax_rates.frm
-rw-r--r--   1 root  root      396 Apr 19 10:45 whos_online.MYD
-rw-r--r--   1 root  root     1024 Apr 19 17:21 whos_online.MYI
-rw-r--r--   1 root  root     8840 Sep 17  2006 whos_online.frm
-rw-r--r--   1 root  root    23336 Sep 17  2006 zones.MYD
-rw-r--r--   1 root  root     9216 Dec  2 17:08 zones.MYI
-rw-r--r--   1 root  root     8698 Sep 17  2006 zones.frm
-rw-r--r--   1 root  root     7887 Sep 17  2006 zones_to_geo_zones.MYD
-rw-r--r--   1 root  root     5120 Dec  2 17:08 zones_to_geo_zones.MYI
-rw-r--r--   1 root  root     8802 Sep 17  2006 zones_to_geo_zones.frm

Hoffe, du kannst da was draus erkennen.

Danke dir! :-)

MfG

disoft

Huschi · #4 30.04.2007, 14:03

chown mysql:mysql /var/lib/mysql/disoft/*
chmod 660 /var/lib/mysql/disoft/*

huschi.