BACKUP problems

[skipper-denmark]

due the size of my DB, i can't take backup from the control panel, there is a time out

i try to do it from the phpadm controlpanel and that has a lot on choices, that I am not sure on,

the CP saids that my db Size i 204 but the file i get i 380mb
??

how can i test that the backup is OK?

please help

this is how it's looks
https://vborg.vbsupport.ru/external/2008/02/11.jpg

[snakes1100]

You should not be doing backups thru phpmyadmin.

The best way to backup your database is to use ssh.

mysqldump --opt -u -p dbname > /path/to/save/it/at/dbname.sql

[skipper-denmark]

thanks for the tip, but

sorry i am not into what ssh is, it seen that it kryptated program, but what program?

is was recommended this http://webyog.com/en/downloads.php

from host, but i can't get it to work.

is there a plugin that can be installed in vbulletin that can do it SAFE

--------------- Added 1203728487 at 1203728487 ---------------

i found PuTTY, but where to write what and where do i run the

mysqldump --opt -u -p dbname > /path/to/save/it/at/dbname.sql

and is the path to my computer og to the filesystem at my host?

I am realy far away from home

[snakes1100]

Putty

1. Enter your domain name or ip in the following box: "hostname or ip address"

2. click "open" at the bottom

3. You will be prompted for the user name and password to log into the server, if you dont have ssh access to the server it will fail at this point.

4. You will need the username & passwd from your config.php file or have the root username & passwd for the mysql server.

5. Enter the mysql command mysql --opt -uroot -p dbname > /path/to/save/dbname.sql and hit enter, it will prompt for your passwd for whatever usename you entered.

[skipper-denmark]

hi snakes

dead on nr 2, but have put up extern db access, have to wait 2 hours to try

regarding

Enter the mysql command mysql --opt -uroot -p dbname > /path/to/save/dbname.sql and hit enter, it will prompt for your passwd for whatever usename you entered.

it the program saving on the host or on my own computer.?

thanks for helping

[snakes1100]

on the server.

save it to your vhost account, where you ftp in at ie..

path to -> /home/username/