PHP/SQL n00b - Need to backup SQL DB before upgrade

[Jwoodall]

Hi all.

Short & Sweet, I hope.

I use phpwebhosting.com as my host (in case someone is familiar with them). I don't believe I can access via telnet my site (pretty sure it's my fault, using NAT).

How can I backup my site/database before I upgrade to 2.2.8?

I had a friend set it up for me originally and he doesn't normally do upgrades he does fresh installs and I figure I need to start figuring this out -- so I'm asking you guys for help and this time I'll do the work. I'm a total n00b to this really, other than modifying user rights etc... I am (very) familiar with PC's though.

Any help would be appreciated.

Thanks.

[filburt1]

If you have Telnet/SSH: http://www.vbulletin.com/manual/movingservers.html
If you don't, cross your fingers, hope your database is extremely small, and try using the backup feature of the admin CP or http://phpmyadmin.sourceforge.net/ .

[Jwoodall]

Is there a chance I'll break it using the CP admin backup?

Well, this can't be good:
Warning: fopen("./forumbackup-09-28-2002.sql", "w") - Permission denied in /home2/rooster/www/lol/forums/admin/backup.php on line 245

Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home2/rooster/www/lol/forums/admin/backup.php on line 248

Dumping access


Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home2/rooster/www/lol/forums/admin/backup.php on line 248

Dumping adminlog


Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home2/rooster/www/lol/forums/admin/backup.php on line 248

Dumping announcement


Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 53812 bytes) in /home2/rooster/www/lol/forums/admin/backup.php on line 107

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 0 bytes) in Unknown on line 0

But, I was able to save it to a file on my machine.. but honestly, it doesn't look big enough to be what I want.

[eva2000]

Originally posted by Jwoodall
Is there a chance I'll break it using the CP admin backup?

Well, this can't be good:


But, I was able to save it to a file on my machine.. but honestly, it doesn't look big enough to be what I want. you need to create a directory in /admin

i.e. /admin/backups chmod to 777 or 666

and then

in vB admin backup specify path to

/full/path/forum/admin/backups

but generally my advice is to use telnet/ssh mysqldump as explained above and here http://www.webmasterbase.com/article/678 to backup your database as vB and phpmyadmin methods of backing up are prone to such problems and timeouts leaving database backup incomplete

[Jwoodall]

I can probably follow those instructions, but as I did say in my first post, I can't seem to Telnet in...C:\..>telnet rooster.phpwebhosting.com

Connecting To rooster.phpwebhosting.com...Could not open connection to the host, on port 23: Connect failed

[eva2000]

you may need to install a SSH secure telnet client such as secureCRT to ssh telnet into your server