Can't Backup database

[krg2k]

Hello
we have a vb2 db we are trying to backup using 'mysqldump' the database is about 5gb but whenever we run mysqldump it only backs up 2.1gb of the whole thing !?

I don't know why it does that but we really need to get a full backup of the vb2 db so we can convert it to the new vb3 forum that we have

any suggestion or help will be greatly appreciate it
thanks

[Marco van Herwaarden]

i would start by contacting your host about this. My first guess would be that your OS is limiting files to a max of 2Gb on the volume where you are trying to store the backup.

Try dumping each table to it's own backup file.

you will need to access your site via SSH too, because via anyother technique will give you a file limit for downloading and access...

request from your host to have a database backup via a cronjob... will cut the problem.

[Marco van Herwaarden]

"mysqldump" is used from commandline nexialys.

yeah, but not all the commandline systems use SSH...

[Marco van Herwaarden]

Sorry but t does not matter what kind of commandline you have. As long as you have an OS prompt where you can run commands it is all the same: Telnet, SSH, cmd.exe, whatever.

[krg2k]

thanks guys for your replies

1. we are the host we have access to the physical machine
2. the original DB file is 5gb+ and its on the same partition where we are trying to use mysqldump > file.sql
3. is there any way we could just copy over the original mysql data file "the actual 5gb file" and import it ? or copy it over ?