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.

[nexialys]

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. ;)

[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 ?