Backup to Dropbox in Ubuntu

[FernandoGarcia]

How about:

Code:

myisamchk -r -f datalog.MYI

Also, another thing to try, is to move directly into that file's folder and run the above command, another suggestion would be to stop mysql, run the command, restart mysql.

It worked thank you very much.

I'm not sure if did it before, now I just did a reboot before try this command.

The backup to Dropbox worked during a week and today I had this error. I'm worried to use it again.

I know that this error is related with backup because the last data in database was exactly before run the cron.daily is this night.

[TGates]

I'm not sure. I do not use this module. What was the last time the affected table was accessed before the backup?

[FernandoGarcia]

1 or 2 minutes.

[TGates]

I'm not sure how the backup would affect the DB tables since it does not write to them, only optimizes and copies them and ZIPs them up. Chances are something is going on with the script that uses the table or there is something hidden you are missing.

[FernandoGarcia]

Hi!

I have the script running since my last post without problems untill now.


Thanks for your attention.

Best regards.

[TGates]

 
Not much information in your post...

Although I believe it was mentioned that they were changing their API... The module will have to be updated I guess. I don't have the time, but there maybe somebody else around here that could take on the task...?

[FernandoGarcia]

Hi!
Well, I have the database crashed again.
The time of last data stored and cron job for this script is equal.
I'll disable it again.
Best regards.