[Gelöst] MySQL-Dump: Kein Backup unter MySQL 4.0.24
Posted: Wed Mar 07, 2007 4:56 pm
Hallo,
nach einem Update von MySQL 3.23 auf MySQl 4.0.24 funktioniert das Modul MySQL Dump nicht mehr.
FM: /usr/bin/mysqldump: Got error: 1044: Access denied for user: 'evmenden@localhost' to database 'evmenden' when doing LOCK TABLES
DB und User sind richtig.
Ich habe das Modul schon mal testhalber de- und neu installiert; brachte nix, leider.
Hier nochmal die kpl. Meldung:
May take a few minutes with large databases.
Task started
Executing...
(username and password not displayed)
'/usr/bin/mysqldump' --user=######## --password=######## --host=localhost --opt --verbose --default-character-set=latin1 evmenden 'cmsms_additional_htmlblob_users' 'cmsms_additional_htmlblob_users_seq' 'cmsms_additional_users' 'cmsms_additional_users_seq' 'cmsms_admin_bookmarks' 'cmsms_admin_bookmarks_seq' 'cmsms_admin_recent_pages' 'cmsms_admin_recent_pages_seq' 'cmsms_adminlog' 'cmsms_content' 'cmsms_content_props' 'cmsms_content_props_seq' 'cmsms_content_seq' 'cmsms_crossref' 'cmsms_css' 'cmsms_css_assoc' 'cmsms_css_seq' 'cmsms_event_handler_seq' 'cmsms_event_handlers' 'cmsms_events' 'cmsms_events_seq' 'cmsms_group_perms' 'cmsms_group_perms_seq' 'cmsms_groups' 'cmsms_groups_seq' 'cmsms_htmlblobs' 'cmsms_htmlblobs_seq' 'cmsms_module_bookmarks' 'cmsms_module_bookmarks_categories' 'cmsms_module_bookmarks_categories_seq' 'cmsms_module_bookmarks_seq' 'cmsms_module_bookmarks_to_categories' 'cmsms_module_deps' 'cmsms_module_feusers_belongs' 'cmsms_module_feusers_dropdowns' 'cmsms_module_feusers_grouppropmap' 'cmsms_module_feusers_groups' 'cmsms_module_feusers_groups_seq' 'cmsms_module_feusers_history' 'cmsms_module_feusers_loggedin' 'cmsms_module_feusers_propdefn' 'cmsms_module_feusers_properties' 'cmsms_module_feusers_properties_seq' 'cmsms_module_feusers_tempcode' 'cmsms_module_feusers_users' 'cmsms_module_feusers_users_seq' 'cmsms_module_guestbook' 'cmsms_module_guestbook_post' 'cmsms_module_guestbook_post_seq' 'cmsms_module_guestbook_seq' 'cmsms_module_guestbook_settings' 'cmsms_module_news' 'cmsms_module_news_categories' 'cmsms_module_news_categories_seq' 'cmsms_module_news_seq' 'cmsms_module_search_index' 'cmsms_module_search_items' 'cmsms_module_search_items_seq' 'cmsms_module_selfreg_properties' 'cmsms_module_selfreg_properties_seq' 'cmsms_module_selfreg_users' 'cmsms_module_selfreg_users_seq' 'cmsms_module_stat_data' 'cmsms_module_stat_data_seq' 'cmsms_module_stat_visitors' 'cmsms_module_stat_visitors_seq' 'cmsms_module_templates' 'cmsms_module_visitorstats' 'cmsms_module_visitorstats_seq' 'cmsms_modules' 'cmsms_permissions' 'cmsms_permissions_seq' 'cmsms_siteprefs' 'cmsms_templates' 'cmsms_templates_seq' 'cmsms_user_groups' 'cmsms_userplugins' 'cmsms_userplugins_seq' 'cmsms_userprefs' 'cmsms_users' 'cmsms_users_seq' 'cmsms_version'>>backups/backup-2007-03-07_17-52-07.sql 2>../modules/MysqlDump/dump-verbose.txt
Output...
-- Connecting to localhost...
/usr/bin/mysqldump: Got error: 1044: Access denied for user: 'evmenden@localhost' to database 'evmenden' when doing LOCK TABLES
Task completed
-- Linux MysqlDump 1.2.3 module [ --opt --verbose --default-character-set=latin1 ] prefix=cmsms_
-- MySQL dump 9.11
--
-- Host: localhost Database: evmenden
-- ------------------------------------------------------
-- Server version 4.0.24_Debian-10sarge2
-- Filesize : 259 bytes
ERROR : backups/backup-2007-03-07_17-52-07.sql MISSING or TOO SMALL
Die Rechte für das Verzeichnis /admin/backups/ sind 777
Viele Grüße
Thorsten
Hier steht die Lösung:
http://forum.cmsmadesimple.org/index.php/topic,13603.0.html
nach einem Update von MySQL 3.23 auf MySQl 4.0.24 funktioniert das Modul MySQL Dump nicht mehr.
FM: /usr/bin/mysqldump: Got error: 1044: Access denied for user: 'evmenden@localhost' to database 'evmenden' when doing LOCK TABLES
DB und User sind richtig.
Ich habe das Modul schon mal testhalber de- und neu installiert; brachte nix, leider.
Hier nochmal die kpl. Meldung:
May take a few minutes with large databases.
Task started
Executing...
(username and password not displayed)
'/usr/bin/mysqldump' --user=######## --password=######## --host=localhost --opt --verbose --default-character-set=latin1 evmenden 'cmsms_additional_htmlblob_users' 'cmsms_additional_htmlblob_users_seq' 'cmsms_additional_users' 'cmsms_additional_users_seq' 'cmsms_admin_bookmarks' 'cmsms_admin_bookmarks_seq' 'cmsms_admin_recent_pages' 'cmsms_admin_recent_pages_seq' 'cmsms_adminlog' 'cmsms_content' 'cmsms_content_props' 'cmsms_content_props_seq' 'cmsms_content_seq' 'cmsms_crossref' 'cmsms_css' 'cmsms_css_assoc' 'cmsms_css_seq' 'cmsms_event_handler_seq' 'cmsms_event_handlers' 'cmsms_events' 'cmsms_events_seq' 'cmsms_group_perms' 'cmsms_group_perms_seq' 'cmsms_groups' 'cmsms_groups_seq' 'cmsms_htmlblobs' 'cmsms_htmlblobs_seq' 'cmsms_module_bookmarks' 'cmsms_module_bookmarks_categories' 'cmsms_module_bookmarks_categories_seq' 'cmsms_module_bookmarks_seq' 'cmsms_module_bookmarks_to_categories' 'cmsms_module_deps' 'cmsms_module_feusers_belongs' 'cmsms_module_feusers_dropdowns' 'cmsms_module_feusers_grouppropmap' 'cmsms_module_feusers_groups' 'cmsms_module_feusers_groups_seq' 'cmsms_module_feusers_history' 'cmsms_module_feusers_loggedin' 'cmsms_module_feusers_propdefn' 'cmsms_module_feusers_properties' 'cmsms_module_feusers_properties_seq' 'cmsms_module_feusers_tempcode' 'cmsms_module_feusers_users' 'cmsms_module_feusers_users_seq' 'cmsms_module_guestbook' 'cmsms_module_guestbook_post' 'cmsms_module_guestbook_post_seq' 'cmsms_module_guestbook_seq' 'cmsms_module_guestbook_settings' 'cmsms_module_news' 'cmsms_module_news_categories' 'cmsms_module_news_categories_seq' 'cmsms_module_news_seq' 'cmsms_module_search_index' 'cmsms_module_search_items' 'cmsms_module_search_items_seq' 'cmsms_module_selfreg_properties' 'cmsms_module_selfreg_properties_seq' 'cmsms_module_selfreg_users' 'cmsms_module_selfreg_users_seq' 'cmsms_module_stat_data' 'cmsms_module_stat_data_seq' 'cmsms_module_stat_visitors' 'cmsms_module_stat_visitors_seq' 'cmsms_module_templates' 'cmsms_module_visitorstats' 'cmsms_module_visitorstats_seq' 'cmsms_modules' 'cmsms_permissions' 'cmsms_permissions_seq' 'cmsms_siteprefs' 'cmsms_templates' 'cmsms_templates_seq' 'cmsms_user_groups' 'cmsms_userplugins' 'cmsms_userplugins_seq' 'cmsms_userprefs' 'cmsms_users' 'cmsms_users_seq' 'cmsms_version'>>backups/backup-2007-03-07_17-52-07.sql 2>../modules/MysqlDump/dump-verbose.txt
Output...
-- Connecting to localhost...
/usr/bin/mysqldump: Got error: 1044: Access denied for user: 'evmenden@localhost' to database 'evmenden' when doing LOCK TABLES
Task completed
-- Linux MysqlDump 1.2.3 module [ --opt --verbose --default-character-set=latin1 ] prefix=cmsms_
-- MySQL dump 9.11
--
-- Host: localhost Database: evmenden
-- ------------------------------------------------------
-- Server version 4.0.24_Debian-10sarge2
-- Filesize : 259 bytes
ERROR : backups/backup-2007-03-07_17-52-07.sql MISSING or TOO SMALL
Die Rechte für das Verzeichnis /admin/backups/ sind 777
Viele Grüße
Thorsten
Hier steht die Lösung:
http://forum.cmsmadesimple.org/index.php/topic,13603.0.html