problem with dump please help

[Essam]

hi,

I'm trying to backup my database, however, the dumping stops suddenly giving this error "Terminated"

So , I decided to backup each table separatlely. I was able to backup all of the tables except (attachment). The size of this table is 3GB.

Any suggestion?

[eva2000]

with such a size you should use telnet/shell method

log into your site via shell/telnet/SSH and switch to root user

and to backup your entire database

1. close forum
2. type

mysqldump --opt -u root -p forumdatabasename > /path/to/backup.sql

wait for a while before it returns to prompt.. with a 3gb database it could take at least 15 - 45 minutes to return to prompt depending on your server cpu and memory specs

[Essam]

man, you are the best :) ... it worked.

you should be paid for the support you're doing all the over the net! how can you find time for helping others?

[eva2000]

Originally posted by Essam
man, you are the best :) ... it worked.

you should be paid for the support you're doing all the over the net! how can you find time for helping others? your welcome :)

i do work officially for vBulletin/Jelsoft ;)

[Essam]

do you also work for , say, rackshack? :rolleyes:

[eva2000]

Originally posted by Essam
do you also work for , say, rackshack? :rolleyes: nah only vB :)

the other forums just feed my vB addiction :o