DB backup

[Mr H]

I just backed up my DB doing a SQL dump and the file, saved as "vbulletin.sql" was only 1.6MB. My board has about 2,200 members and about 50,000 posts.

Does that file seem about right or does it seem too small?

This is my first backup so I just want to make sure it worked okay.

Thanks.

[filburt1]

Originally posted by Mr H
I just backed up my DB doing a SQL dump and the file, saved as "vbulletin.sql" was only 1.6MB. My board has about 2,200 members and about 50,000 posts.

Does that file seem about right or does it seem too small?

This is my first backup so I just want to make sure it worked okay.

Thanks.

No, that sounds too small to me. I have around 500 members and 50,000 posts, and my database is 20 MB.

Did you use phpMyAdmin (bad) or SSH (good)?

[Mr H]

Originally posted by filburt1
No, that sounds too small to me. I have around 500 members and 50,000 posts, and my database is 20 MB.

Did you use phpMyAdmin (bad) or SSH (good)?

phpMyAdmin. I'm not sure what I'd have to type to do it in SSH.

[filburt1]

Originally posted by Mr H
phpMyAdmin. I'm not sure what I'd have to type to do it in SSH.

Click the link.

[Steve Machol]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

http://www.vbulletin.com/manual/movingservers.html

And here is some more info:

http://www.webmasterbase.com/article/678

[Mikhailtech]

TelNet is insecure, you definitely want to use SSH. You will need an SSH client (search on Google for "putty ssh" or something) and your host should be able to tell you the exact path to mysql on your server. I could be wrong but I believe phpMyAdmin is limited to 2mb for downloads. Most PHP applications time out before they can get any kind of decent DB transfer.

[Mr H]

Originally posted by Mikhailtech
TelNet is insecure, you definitely want to use SSH. You will need an SSH client (search on Google for "putty ssh" or something) and your host should be able to tell you the exact path to mysql on your server. I could be wrong but I believe phpMyAdmin is limited to 2mb for downloads. Most PHP applications time out before they can get any kind of decent DB transfer.

My host doesnt not offer SSH or telnet access...

[Steve Machol]

Then unfortunately you will not be able to make reliable backups. I'd suggest finding a more suitable host.