How big is your database?

Lieutenant Joined: Jan 20, 2004 Posts: 213

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.

Sergeant Joined: Aug 26, 2004 Posts: 75

6 MB gzipped
Donno how big it is extracted because my HD couldn't handle that.

Posted: Mon Sep 27, 2004 12:30 pm

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

Support Mod Joined: Mar 19, 2003 Posts: 308

Unzipped 205 megabytes, zipped around 25 megabytes

Nuke Cadet Joined: Sep 24, 2004 Posts: 8

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?

Posted: Tue Sep 28, 2004 2:24 am

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.

Private Joined: Aug 08, 2003 Posts: 43

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

Lieutenant Joined: Jan 20, 2004 Posts: 213

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

Nuke Soldier Joined: Sep 28, 2004 Posts: 11

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.

Lieutenant Joined: Jan 20, 2004 Posts: 213

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

Nuke Soldier Joined: Sep 28, 2004 Posts: 11

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.

Lieutenant Joined: Jan 20, 2004 Posts: 213

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

Thanks again,

Brandon

Nuke Soldier Joined: Sep 28, 2004 Posts: 11

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.

Nuke Soldier Joined: Aug 03, 2004 Posts: 12

Tarred: 511 MB

Nuke Soldier Joined: Sep 28, 2004 Posts: 11

11 Websites each backup ranging from 38MB to 77MB backed up twice a day.