Database Size

Red Squirrel · Post by **Red Squirrel** » Sat May 17, 2003 11:16 pm

Just for fun facts, here is a log of the size of our database backups. Notice how it was shrinking at first! That log was started when we went on this host.

---------------------+
Date | Size |
---------------------+
Apr 04 2003 2.69MB
Apr 07 2003 2.12MB
Apr 09 2003 2.15MB
Apr 13 2003 2.24MB
Apr 15 2003 2.81MB
Apr 23 2003 4.23MB
Apr 26 2003 4.54MB
Apr 26 2003 4.62MB
May 01 2003 3.83MB
May 04 2003 5.16MB
May 11 2003 5.70MB
May 17 2003 6.08MB

Archived topic from Iceteks, old topic ID:692, old post ID:5593

Chris Vogel · Post by **Chris Vogel** » Sat May 17, 2003 11:26 pm

Cool.... I think....

What is the maximum you will let it be before you do "cuts" to it?

Archived topic from Iceteks, old topic ID:692, old post ID:5597

Wren · Post by **Wren** » Sat May 17, 2003 11:35 pm

tak, don't encourage a squirrel to do "cuts".

Archived topic from Iceteks, old topic ID:692, old post ID:5600

Red Squirrel · Post by **Red Squirrel** » Sat May 17, 2003 11:36 pm

I never plan to do any cuts. I hope I'll never have to. It's always nice to be able to look back. Especially when you find multiple "merry Christmas" threads dated different years.

I just hope sql does not have some kind of limit to how big it can be. The only problem I see is when the database reaches a few Gigs, it will time out when uploading.

Archived topic from Iceteks, old topic ID:692, old post ID:5601

Chris Vogel · Post by **Chris Vogel** » Sat May 17, 2003 11:40 pm

Wren wrote: tak, don't encourage a squirrel to do "cuts".

I never plan to do any cuts.

What a relief!

Archived topic from Iceteks, old topic ID:692, old post ID:5605

Red Squirrel · Post by **Red Squirrel** » Sat May 17, 2003 11:44 pm

And if ever I decide to remove a forum, I'll move all the posts in the most "on topic" one.

Archived topic from Iceteks, old topic ID:692, old post ID:5610

wldkos · Post by **wldkos** » Mon May 19, 2003 1:22 pm

Hey, how do you re-upload the backups? I can't seem to figure that out.

Archived topic from Iceteks, old topic ID:692, old post ID:5847

Red Squirrel · Post by **Red Squirrel** » Mon May 19, 2003 1:59 pm

I usually do it through phpmyadmin, well that's the only way I know.

If you run your own server, you don't even need to backup the database file, just copy the folder "data" found in your sql install, or wherever it is (usually it's "mysql/database" if I remember). Then to restore, you simply copy that folder back from the backup. Comes in handy for when you get hacked or something.

Archived topic from Iceteks, old topic ID:692, old post ID:5853

wldkos · Post by **wldkos** » Tue May 20, 2003 3:27 am

Red Squirrel wrote: I usually do it through phpmyadmin, well that's the only way I know.

If you run your own server, you don't even need to backup the database file, just copy the folder "data" found in your sql install, or wherever it is (usually it's "mysql/database" if I remember). Then to restore, you simply copy that folder back from the backup. Comes in handy for when you get hacked or something.

hmmm that sounds good and much faster since I do not need to download and wait. Thanks red. Is there a safe way to test this out?

Archived topic from Iceteks, old topic ID:692, old post ID:5944

Red Squirrel · Post by **Red Squirrel** » Tue May 20, 2003 9:32 am

You could download easyphp that's what I used for the server before, and still use it for local. It's old and outdated version of sql and php but it does the job. If you have a linux box, even better since you can install the latest versions.

Go to http://www.easyphp.org It's for windows only though, but that's probably what you need.

Good luck!

Archived topic from Iceteks, old topic ID:692, old post ID:5947

wldkos · Post by **wldkos** » Tue May 20, 2003 10:48 pm

But my server is linux, why would a window client help me? And what does this do?

Btw, didn't you say that I could just check the /mysql/data for my forum? and how would i back it up? Un tar.gz it right there?

Archived topic from Iceteks, old topic ID:692, old post ID:5973

Red Squirrel · Post by **Red Squirrel** » Tue May 20, 2003 11:15 pm

I'm not sure how it works for linux. There should be a folder with subfolders with the names of your databases, just copy that entire folder to a backup location, copy it back to restore. for remote backup you need to log in to phpmyadmin to download the .sql file and to restore you do it through that as well. It's good to know both ways and test them to make sure they work.

Archived topic from Iceteks, old topic ID:692, old post ID:5975

wldkos · Post by **wldkos** » Wed May 21, 2003 4:28 pm

so I m thinking that I should try both?

Archived topic from Iceteks, old topic ID:692, old post ID:5977

Red Squirrel · Post by **Red Squirrel** » Wed May 21, 2003 4:36 pm

Yep, both ways to backup, that way you know how to do each one. On your own server it's easier to do the copy folder way but if your isp finds out (or if some birdbrain (ex: martz) reports it) it's good to know the server side way for when you are paying a host.

Archived topic from Iceteks, old topic ID:692, old post ID:5978

wldkos · Post by **wldkos** » Wed May 21, 2003 4:37 pm

<img src='http://worldchaos.no-ip.com:12123/~jamie/mysql.png' border='0' alt='IceTeks forums posted image by wldkos'>

does this look correct? If so, I can just copy this directory when ever I want to make a backup and say make forum.tar.gz? and when I want to update it back, just untar it there?

Archived topic from Iceteks, old topic ID:692, old post ID:5979

Red Squirrel · Post by **Red Squirrel** » Wed May 21, 2003 4:43 pm

You used your localhost image....

can't see it.

Archived topic from Iceteks, old topic ID:692, old post ID:5981

wldkos · Post by **wldkos** » Wed May 21, 2003 4:53 pm

bahhh! hahah sorry, didn't realize that.

Archived topic from Iceteks, old topic ID:692, old post ID:5982

Red Squirrel · Post by **Red Squirrel** » Wed May 21, 2003 5:04 pm

Yep, that looks like it. Just copy the entire folder and there should be another folder called "sql" or "database" or something, you NEED that, that's what keeps the record of those files and what database they are for and stuff. I learned that the hard way. To be safe, just backup the whole sql folder, that way, at least if something is wrong, you know everything is there. When you do a test backup, you'll then know what you need and what you don't by adding a bit at a time.

Archived topic from Iceteks, old topic ID:692, old post ID:5983

Red Squirrel · Post by **Red Squirrel** » Wed May 21, 2003 5:05 pm

By the way what OS is that? Is it Linux? Looks cool.

(yeah, I need to try out linux soon, I'm not a true geek if I don't even know how it looks like

)

Archived topic from Iceteks, old topic ID:692, old post ID:5984

wldkos · Post by **wldkos** » Wed May 21, 2003 6:16 pm

Red Squirrel wrote: By the way what OS is that? Is it Linux? Looks cool.

(yeah, I need to try out linux soon, I'm not a true geek if I don't even know how it looks like )

ok, I think that is my database, what I just showed you. When I tried getting this board running on lycos, they have phpadmin and I remember seeing these files to backup. I will check for the other thing that you mentioned as well, later. Btw, how can I do a test backup? I want to see if this will work, but how can I do it without sacrificing my whole forum?

and that was red hat 8.0, you can make it look like anything you want. Also, Today I just used partition magic to give me a 4 gig partition and I am going to install Debian 3.0 on there later. You should try that as well red.

Archived topic from Iceteks, old topic ID:692, old post ID:5985

Red Squirrel · Post by **Red Squirrel** » Wed May 21, 2003 6:27 pm

For a test backup, the best way, (but long) to do it would be to do a whole backup image of your current partition (just store it somewhere on another partition or something) then wipe that partition and clean install Linux and set everything up, then restore the backup, and if it works, it's ok. Then just restore the drive image (that way you dont have to set everything the way it was, if there was a lot of other programs and stuff installed). Or you can't "wait and see". That's what I did...

Archived topic from Iceteks, old topic ID:692, old post ID:5987

wldkos · Post by **wldkos** » Thu May 22, 2003 1:32 am

uhhh, i mean a backup of the forum....

Archived topic from Iceteks, old topic ID:692, old post ID:6021

Red Squirrel · Post by **Red Squirrel** » Thu May 22, 2003 9:31 am

Yeah, but the only way to simulate a real crash would to be wipe everything. Just deleting the database and restoring it will work, but there could always be some files somewhere else that we both don't know about (kind of like copying a program files folder on a different pc and you realize it needs like 100 dlls)

Archived topic from Iceteks, old topic ID:692, old post ID:6035

wldkos · Post by **wldkos** » Thu May 22, 2003 11:32 am

Red Squirrel wrote: Yeah, but the only way to simulate a real crash would to be wipe everything. Just deleting the database and restoring it will work, but there could always be some files somewhere else that we both don't know about (kind of like copying a program files folder on a different pc and you realize it needs like 100 dlls)

yes. I understand that now, but I really do not want to "simulate" a crash on my linux box after 3 months of trying to get this to work

. I will back up the forum vey regularly though.

oh, and I think I am on 6 1/2 days straight with no problems and no speed loss whatsoever with linux. i remember running just an ftp off that machine with Win98se and the slowness by the end of two days.

Archived topic from Iceteks, old topic ID:692, old post ID:6039