MysqlDump

MySQL, PostgreSQL, SQLite
günter
Posts: 38
Joined: 2002-10-03 12:32

MysqlDump

Post by günter » 2004-03-04 17:19

Hallo,

Ich versuche für ein Backup folgendes:

mysqldump -A -C --password=xxxxx >all.sql

Aber es werden längst nicht alle DB´s beackupt, any Idea ?

deanwickert
Posts: 77
Joined: 2003-05-13 23:20
Location: Lahnstein

Re: MysqlDump

Post by deanwickert » 2004-03-04 17:39

Günter wrote:Hallo,

Ich versuche für ein Backup folgendes:

mysqldump -A -C --password=xxxxx >all.sql

Aber es werden längst nicht alle DB´s beackupt, any Idea ?

Root-Passwort verwendet?

günter
Posts: 38
Joined: 2002-10-03 12:32

Re: MysqlDump

Post by günter » 2004-03-04 17:46

Hallo,

Ja, das rootpw hab ich verwendet

günter
Posts: 38
Joined: 2002-10-03 12:32

Re: MysqlDump

Post by günter » 2004-03-05 10:54

Folgende Fehlermeldung:

mysqldump: Can't get CREATE TABLE for table 'bb1_object2board' (Can't open file: 'bb1_object2board.MYD'. (errno: 145))
/bin/tar: home/www/webXXX/html/ dasdasd : file changed as we read it
/bin/tar: home/www/web31/log/access_log: file changed as we read it
/bin/tar: home/www/web68/log/access_log: file changed as we read it
/bin/tar: Error exit delayed from previous errors

robertw
Posts: 165
Joined: 2002-12-17 16:10
Location: Berlin

Re: MysqlDump

Post by robertw » 2004-03-05 12:24

Code: Select all

# perror 145
Error code 145:  Unknown error 145
145 = Table was marked as crashed and should be repaired

Schau mal hier nach:
http://www.mysql.com/doc/en/Crashing.html und
http://www.mysql.com/doc/en/Corrupted_M ... ables.html und

Code: Select all

man myisamchk
Robert