![]() |
BACKUP problems
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 |
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 |
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 [DATE]1203728487[/DATE] at [TIME]1203728487[/TIME] --------------- 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 |
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. |
hi snakes
dead on nr 2, but have put up extern db access, have to wait 2 hours to try regarding Enter the Quote:
thanks for helping |
on the server.
save it to your vhost account, where you ftp in at ie.. path to -> /home/username/ |
All times are GMT. The time now is 10:10 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|