JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Query failed : Table 'tbl_knowledgebase_qns' is read only
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
Dann zeig uns mal das Ergebnis von
Code:
ls -l /var/lib/mysql/
ls -l /var/lib/mysql/DBNAME/
huschi.
Hier das Ergebnis
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
Last edited by a moderator: Apr 30, 2007
chown mysql:mysql /var/lib/mysql/disoft/*
chmod 660 /var/lib/mysql/disoft/*
huschi.