Hello friends,

I have a private health group at http://www.hpscleansing.com/group

Total Registrations: 765, Active Members: 715 -
Total Threads: 1,836, Total Posts: 21,270


When I do a backup of the group it is now close to 80 MB... i live in thailand and don't have broadband access so to download this to my laptop via ftp takes 7 hours.

My questions are:

1) Does anyone know how to compress the backup... is there a function in the vb cpanel to do this?

2) If yes, how to use it, instructions please.

3) If no, can it be compressed before ftp'ing through the cpanel at the hoster. I use hostrocket to host my site (floris's suggestion and it has been a good one).

4) If yes to #3, can someone please give detailed instructions step by step. I have very little pc knowledge so it is hard to figure this out on my own.

Thanks.

Hope this thread helps someone else.

Peace,
jos

Hi,

do you have shell access or access to the MySQL Daemon? Then the easiest way would be executing the following command:

mysqldump --opt --user=dbuser --password=dbpassword database | gzip > name.sql.gz

Before I explain further details about a cronjob check out if you have ssh access ;)

ok thanks friend, checking with them right now... will revert back here in a day or two once i get the answer from them.


jos

Hello Stormblast,

I just got this back from the hoster. Please advise is this is what you were looking for. Thanks!!

==============

Shell Access has been enabled for your account. Please use a
SSH2 capable program to connect to our servers. Set your SSH
Client to:

If you need a SSH2 capable client program, give PuTTY a try,
it is available right at:

http://www.chiark.greenend.org.uk/~sgtatham/putty/



===================

Yup Jos, that's the service you need. Now you need to download PuTYy from the net (it is free) and connect to your server using this. This will give you a sort of command prompt at the root access of your web space and you can then execute the command that Stormblast provided.

This will create a compressed backup copy of your database on the root of your web space.

Hey guys and gals thanks.

I went to putty to download but i am confused from all the download options. are these options referrring to the operating system on my laptop (which is xp) or the operating system of the hosting service which is linux.

can someone please advise which files i need to download?

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

thanks.
jos

http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe

You should use putty.exe, listed under "For Windows 95, 98, ME, NT, 2000 and XP on Intel x86". :)

Ok friends,

I downloaded the putty to my laptop from http://the.earth.li/~sgtatham/putty...t/x86/putty.exe
thanks deo, that was easy, no decisions to make, just clicked on the link.

Now, what's next?
What's the next step that I need to do?

Walking me through this will help others, those who follow in our steps... so please try to make the instructions clear so that others will benefit in their groups.

Peace
jos

instead of using gzip, why not use a better compression. in linux (and bsd), tar or bzip2 (or even both) would give better compression than plain gzip (bzip2 being the better one in my opinion).

usage would be something like this;

mysqldump --opt --user=dbuser --password=dbpassword database | bzip2 > backup.bz2

That is really nice of host rocket!! Usually they don't give it.
You can use SecureCRT (which is what I use) for SSH2 sessions.

Good luck, www.vbulletin.com/docs/html > appendix : tech documents > has mysql database backup, restore docs!!!!!!!

now i'm confused.

jos

With SSH client like SecureCRT or PuTTY you can connect to the host on a port with the user/pass for the account (usually the same as ftp)

Once logged in you can use the instructions as provided by the vb online manual to export your vb database to a .sql file
once exported, you can download it with your ftp client as a normal file to your hard drive.