SQL Databases: Can you back up?

Memo · 05-06-2003, 11:32 PM

So I just placed an order for my new domain name: mymomsaysimcool.com and will start working on the site soon. I will probably have a message board on there and was wondering a few things. Is there a way to back up the SQL data stored on the server onto a regular windows xp machine incase the host ever goes out of business? I'd hate to lose the entire board.

coleslaw · 05-06-2003, 11:38 PM

Yes, you can easily do this. Depending on the message board software used, it's usually within the admin tools that allow you to make a backup for offline purposes.

hapoo · 05-06-2003, 11:45 PM

what flavor sql will you be using?

Memo · 05-06-2003, 11:57 PM

I'm not sure. I have not ordered any webhosting yet. Probably MySQL? I'm not too savvy with the SQL I can only set up the DBs through web interfaces and such.

Slaw: Know do you know any message boards that have that option?

P.S. Anyone know any cheap webhsots with PHP and MySQL?

coleslaw · 05-07-2003, 12:04 AM

vBulletin, phpBB (free) and ikonboard (free) all feature database backups. I believe that this is a necessary feature of any mainstream message board, so they should all have it.

coleslaw · 05-07-2003, 12:55 AM

Quote:

Originally posted by UT Memo
P.S. Anyone know any cheap webhsots with PHP and MySQL?

I'll put my opinion in here. Solid Internet has been fast and reliable for me, and it's pretty cheap too. Starting at ~$30/yr for the starter package - it's not too shabby. I'd recommend going with (at least) the standard package (~$60/yr or $5/mo) for your needs.

Joshua · 05-07-2003, 06:52 AM

[$.02]

Powweb Has been very good to me at $7.77 per month. If you pay a year in advance, they wave the setup fee and you get a month free.

[/$.02]

dbax791 · 05-07-2003, 12:20 PM

Yes, ask if your host has cpanel. It will allow you do download your databases. I do this periodically, plus my host backs up my dbs every night.

phpbb is a good free one.

05-06-2003, 11:32 PM	#1
Memo Admiral Join Date: Apr 2001 Location: East Village Posts: 5,659	SQL Databases: Can you back up? So I just placed an order for my new domain name: mymomsaysimcool.com and will start working on the site soon. I will probably have a message board on there and was wondering a few things. Is there a way to back up the SQL data stored on the server onto a regular windows xp machine incase the host ever goes out of business? I'd hate to lose the entire board.

05-06-2003, 11:38 PM	#2
coleslaw Arrrhh! Join Date: May 2000 Location: LI NY Posts: 6,807	Yes, you can easily do this. Depending on the message board software used, it's usually within the admin tools that allow you to make a backup for offline purposes. __________________ A priest, a paladin and Varimathras walk into a bar...

05-07-2003, 06:52 AM	#7
Joshua Rear Admiral Upper Half Join Date: Jan 2001 Location: Long Island, NY Posts: 3,390	[$.02] Powweb Has been very good to me at $7.77 per month. If you pay a year in advance, they wave the setup fee and you get a month free. [/$.02] __________________ The Apexer formerly known as SnotRocket. "Like I **ing said, "Ok, so I hear it may be a repost. Blah But I had never seen it, so..." ** you Canta." -Jenny 12/4/2003

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

05-06-2003, 11:45 PM	#3
hapoo Fleet Admiral Join Date: Jan 2000 Location: 742 Evergreen Terrace, Springfield USA Posts: 9,276	what flavor sql will you be using?

05-06-2003, 11:57 PM	#4
Memo Admiral Join Date: Apr 2001 Location: East Village Posts: 5,659	I'm not sure. I have not ordered any webhosting yet. Probably MySQL? I'm not too savvy with the SQL I can only set up the DBs through web interfaces and such. Slaw: Know do you know any message boards that have that option? P.S. Anyone know any cheap webhsots with PHP and MySQL?

05-07-2003, 12:04 AM	#5
coleslaw Arrrhh! Join Date: May 2000 Location: LI NY Posts: 6,807	vBulletin, phpBB (free) and ikonboard (free) all feature database backups. I believe that this is a necessary feature of any mainstream message board, so they should all have it.

05-07-2003, 12:20 PM	#8
dbax791 Rear Admiral Lower Half Join Date: Feb 2000 Location: Arizona Posts: 2,177	Yes, ask if your host has cpanel. It will allow you do download your databases. I do this periodically, plus my host backs up my dbs every night. phpbb is a good free one.

User Name
Password
Remember Me?