PSADUMP error

[yoohosting]

I got this error on a full psadump :

[Wed Oct 5 23:16:33 2005] dumping mysql database psa2 ... error!
/usr/bin/mysqldump: Got error: 1016: Can't open file: 'BackupTasks.ibd' (errno: 1) when using LOCK TABLES
An error was occured during execution: "/usr/bin/mysqldump -uadmin -p********* --quote-names 'psa2'"
[root@ik59165 bckups]#

What can be the prob?
thanks

 

[yoohosting]

Nobody has this error? or the solution?

I need to transfert all user from a server to a new one.

 

[Bob11]

I have the same error since I upgrade to mysql 4.1.12 from art

Thinq u use a lot of tables (1000>) in one database?

For more details see: http://lists.mysql.com/bugs/11608

Use mysqldump wth this option will work: --skip-lock-tables

But for psadump I don't now, I still wait for the next version of mysql. Hope this problem is solved then.

 

[yoohosting]

I solved my probleme by deleting (moving) all db giving error and I put theme in the place manualy

And I saw after the migration that some tables were broken.. PSADUMP / PSARESTORE is realy a bad solution

 

[rgc2004]

hello in /etc/my.cnf
to add :
open_files_limit=8192

and by I finalize to restart mysqld