You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 337 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - How big is your database? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
OCSupertones
Lieutenant
Lieutenant


Joined: Jan 20, 2004
Posts: 213


PostPosted: Mon Sep 27, 2004 8:51 am Reply with quoteBack to top

When you backup from the admin page, what is the size of your database?

My db has been growing steadily and is about 18.5 mb right now.

_________________
Free advertising for your website, free info here.

Join Here.
Find all posts by OCSupertonesView user's profileSend private messageVisit poster's website
FreeBee
Sergeant
Sergeant


Joined: Aug 26, 2004
Posts: 75


PostPosted: Mon Sep 27, 2004 10:41 am Reply with quoteBack to top

6 MB gzipped
Donno how big it is extracted because my HD couldn't handle that.
Find all posts by FreeBeeView user's profileSend private message
Mesum
Support Staff
Support Staff


Joined: Mar 11, 2003
Posts: 842

Location: Chicago

PostPosted: Mon Sep 27, 2004 12:30 pm Reply with quoteBack to top

I think close to 150MB I might be a little off tho.

_________________
Only FREE Dating site for Desis.
Find all posts by MesumView user's profileSend private messageVisit poster's websiteAIM AddressYahoo MessengerMSN Messenger
luchtzak
Support Mod
Support Mod


Joined: Mar 19, 2003
Posts: 308


PostPosted: Mon Sep 27, 2004 1:28 pm Reply with quoteBack to top

Unzipped 205 megabytes, zipped around 25 megabytes

_________________
Luchtzak Aviation - Snookerforum Belgium
Find all posts by luchtzakView user's profileSend private messageVisit poster's website
stupidcelebrity
Nuke Cadet
Nuke Cadet


Joined: Sep 24, 2004
Posts: 8


PostPosted: Mon Sep 27, 2004 9:35 pm Reply with quoteBack to top

I'm not sure what mine is, but I do know it crashes PhpMyAdmin when I try to reupload it. Anyone know of a way around this besides downloading file by file?

_________________
Domain Names | Graphic/Web Design | Hosting
Find all posts by stupidcelebrityView user's profileSend private messageVisit poster's website
edogs
Lieutenant
Lieutenant


Joined: Sep 10, 2003
Posts: 172

Location: Russia

PostPosted: Tue Sep 28, 2004 2:24 am Reply with quoteBack to top

We host and work with many clients, and can say that DB size 100-500Mb it's more or less regular situation.

stupidcelebrity wrote:
I'm not sure what mine is, but I do know it crashes PhpMyAdmin when I try to reupload it. Anyone know of a way around this besides downloading file by file?

The best way is to use mysqldump utility.
Another option to use cpanel for download dump and restore it if needed.
Anyway, if phpmyadmin crashes during uploading/downloading it's well known bug. phpmyadmin can't handle big DB. In such case it's a problem of hoster, he have to solve it.
Find all posts by edogsView user's profileSend private messageVisit poster's websiteICQ Number
ryanrbftp
Private
Private


Joined: Aug 08, 2003
Posts: 43


PostPosted: Tue Sep 28, 2004 7:12 am Reply with quoteBack to top

My database is around 100MB. I always use mysqldump when backing up - I do this using secure shell to my server.


Last edited by ryanrbftp on Fri Oct 15, 2004 8:31 am; edited 1 time in total
Find all posts by ryanrbftpView user's profileSend private messageVisit poster's website
OCSupertones
Lieutenant
Lieutenant


Joined: Jan 20, 2004
Posts: 213


PostPosted: Tue Sep 28, 2004 10:42 am Reply with quoteBack to top

Is there a better way to backup than with the admin panel?

_________________
Free advertising for your website, free info here.

Join Here.
Find all posts by OCSupertonesView user's profileSend private messageVisit poster's website
Dynamics
Nuke Soldier
Nuke Soldier


Joined: Sep 28, 2004
Posts: 11


PostPosted: Tue Sep 28, 2004 10:53 am Reply with quoteBack to top

Personally I don't like the admin panel backup. I use Mysql Administrator to run daily backups on all my sites. Nice thing about it is that you can schedule your backups with in minutes and restore them all or partially in less than a minute.
Find all posts by DynamicsView user's profileSend private messageSend e-mail
OCSupertones
Lieutenant
Lieutenant


Joined: Jan 20, 2004
Posts: 213


PostPosted: Tue Sep 28, 2004 10:57 am Reply with quoteBack to top

Dynamics, I am on a shared host...can I still do that?

_________________
Free advertising for your website, free info here.

Join Here.
Find all posts by OCSupertonesView user's profileSend private messageVisit poster's website
Dynamics
Nuke Soldier
Nuke Soldier


Joined: Sep 28, 2004
Posts: 11


PostPosted: Tue Sep 28, 2004 11:01 am Reply with quoteBack to top

As long as you can give the ip, username and password of your database I don't see why not. I used to rent from recongamers.com and they had shared hosting. If your database server is labeled as localhost then it probably won't work. But if your host is kind enough to give you the ip of the mysql server then it shouldn't be a problem, especially since your running it from your own machine.
Find all posts by DynamicsView user's profileSend private messageSend e-mail
OCSupertones
Lieutenant
Lieutenant


Joined: Jan 20, 2004
Posts: 213


PostPosted: Thu Sep 30, 2004 2:40 pm Reply with quoteBack to top

Can you explain how it is done? Or is there a tutorial somewhere?

Thanks again,

Brandon

_________________
Free advertising for your website, free info here.

Join Here.
Find all posts by OCSupertonesView user's profileSend private messageVisit poster's website
Dynamics
Nuke Soldier
Nuke Soldier


Joined: Sep 28, 2004
Posts: 11


PostPosted: Thu Sep 30, 2004 2:49 pm Reply with quoteBack to top

The download and info on this is available here
http://dev.mysql.com/downloads/administrator/index.html There are some good screen shots there and some info on how it works. The application has a XP look to it so its pretty user friendly. I think there is some information on how to use it once downloaded and installed. Try it out and if you run into any brick walls let me know and I will see if I can help. I run this both at work and at home for dozens of websites.
Find all posts by DynamicsView user's profileSend private messageSend e-mail
gt_swagger
Nuke Soldier
Nuke Soldier


Joined: Aug 03, 2004
Posts: 12


PostPosted: Fri Oct 01, 2004 7:25 am Reply with quoteBack to top

Tarred: 511 MB
Find all posts by gt_swaggerView user's profileSend private message
Dynamics
Nuke Soldier
Nuke Soldier


Joined: Sep 28, 2004
Posts: 11


PostPosted: Fri Oct 01, 2004 11:22 am Reply with quoteBack to top

11 Websites each backup ranging from 38MB to 77MB backed up twice a day.
Find all posts by DynamicsView user's profileSend private messageSend e-mail
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.049 Seconds - 214 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::