Previous Thread
Next Thread
Print Thread
Hop To
There may be a bug with table backup #177930 02/07/2007 4:49 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
I must not understand how this works, but I would assume all data would be backed up such that you can backup and restore your complete message board.

My classic board had 477K posts and the size on disk of all the forums was ~300 meg

When I backup from the UBBT.7 Control Panel / Database Tools, and backup all tables.. the result is relative puny; about 5.5 meg.

I would assume this is just the schemas and that the actual data is elsewhere?
Do I have this right?


Last edited by luket; 02/07/2007 8:10 PM.

Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: luket] #177934 02/07/2007 5:56 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
I don't recommend backing up via the forum, it's going to take way longer than how it would be if you where to do it via MySQL directly through the command line (via SSH for example).

Also, all the data is would be text, so if you have it compressed (tar or gz for example) it will be tiny.

The command to create a backup of a mysql database:
MySQL Export: mysqldump -uuser -ppass db > db.sql
MySQL Import: mysql -h localhost -uuser -ppass db < db.sql

Please note that the -u -p and -h are required and that you must add in your username password and database name.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: Gizmo] #177954 02/07/2007 6:49 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
So you are saying "yes, all of the forum data would be in these backup files" ...

Then I'm wondering if there isn't a bug.
There is no way to compress 300 meg to 5 ..
I ran a test and compressed my Fourm28:
It's 19K files and 172 meg. It Zip'ed to 41 meg.

I may know what happened then.
When I was running the backup from the control panel (even though you do not recommend doing this :p) I DID notice something very strange… I saw one of the .sql files changing size! I'm sorry, I do not remember the name, but let's say it was ubbt_foo.sql …
As I watched the directory during the backup, this file would change to 200K, then 300K, then 200K, then 400K, then 200K… and it kept doing this until the backup finished.

Theory: Each forum was backed up to a single output file, overwriting the output from the forum before it. I speculate that the backup is everything + 1 forum (the last one backed-up.)




Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: luket] #177965 02/07/2007 8:17 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
If your backup was downloaded as a tar or a tgz file using the compression of the script you made the backup with; yes. If you have a .sql file, it is not likely, and is more likely that the script you used to generate the backup choked and fed you what it had recieved.

Also, ZIP is a way differant algoritm than Tar or Global Zip; or Tar and Global Zip togethre.

And it's quite odd that the file would change size like that, possibly a bug or something :shrug: I don't use scripts to make backups as you end up with either many files, lots of lag, or things that just doont' work properly wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: Gizmo] #177967 02/07/2007 8:38 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
I must not be describing my problem clearly, sorry.

1. I did a backup using the Control Panel / Database tools / Backup all tables.

2. I have 488K posts and a file footprint in classic of 300 megabytes

3. The backup generated by UBB.T7 was like 51 .sql files with a total size of about 5 meg.

I am saying there is no way my 488K posts are represented in those 51 .sql files totaling 5 meg.

If my entire board should be represented in those 51 files, then there is a bug as described above.


Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: luket] #177968 02/07/2007 8:50 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
Well, keep in mind that this isn't classic; posts aren't stored in files which repeat the same data over and over only with posts included; so it is actually possible.

Let me run a test for an example, brb


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: Gizmo] #177969 02/07/2007 8:52 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
please wink

*waits patiently*




Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: Gizmo] #177970 02/07/2007 8:53 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
Ok, a good example is this, I have probably 1gb of stuff in my database, my backup of my database's size is 37mb.

Let me check just mymain site though


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: Gizmo] #177971 02/07/2007 8:56 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
In the 7.0.x versions there is a bug in the backup where it's not backing up some of the tables on some servers. This got a bit of an overhaul for 7.1 to fix this.

Re: Not sure I understand how to backup my boards. [Re: Gizmo] #177972 02/07/2007 8:57 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
Code
[root@server blah]# mysqldump -uuser -ppass db > db.sql
Enter password: 
[root@server blah]# ls -hal
total 56M
drwxr-xr-x   2 root root 4.0K Feb  7 17:54 .
drwxr-x---  11 root root 4.0K Feb  7 17:54 ..
-rw-r--r--   1 root root  55M Feb  7 17:55 ubb.sql
[root@server blah]# tar -cvpzf db.tgz ubb.sql 
ubb.sql
[root@server blah]# ls -hal
total 67M
drwxr-xr-x   2 root root 4.0K Feb  7 17:55 .
drwxr-x---  11 root root 4.0K Feb  7 17:54 ..
-rw-r--r--   1 root root  12M Feb  7 17:56 db.tgz
-rw-r--r--   1 root root  55M Feb  7 17:55 ubb.sql

Well my 58mb database has shrank to 12mb with the compression; my UBB.Classic files where over 800mb though, as an example to how text compresses down when it's just text.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: Rick] #177973 02/07/2007 9:00 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
Ah, good to know...

By the way.. I *think* all of my forums were backed up to the same .sql file .. I watched as it changed sizes as though it was being overwritten by each forum.


Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: Rick] #177974 02/07/2007 9:01 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
Originally Posted by Rick
In the 7.0.x versions there is a bug in the backup where it's not backing up some of the tables on some servers. This got a bit of an overhaul for 7.1 to fix this.
bad boy, bad bad boy


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: Gizmo] #177999 02/08/2007 1:23 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
BTW, and FWIW; I'm running Windows Server 2003 and MySQL 4.1.12-nt.


Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: luket] #178009 02/08/2007 5:24 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
ahh so you won't have any of the nifty command line tools I mention, because you're not running a command line wink hehe


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: Gizmo] #178014 02/08/2007 6:47 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
Yeah, MySQL ships ( even on Windows tongue ) with a command shell, so we're all good there.


Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: luket] #178015 02/08/2007 6:51 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
Also, and more importantly...

[Linked Image] <--- this 'tongue sticking out' emote is all wrong!
It should be like "Haha! neener neener!" .. but is instead more like "I feel ill"


Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: luket] #178016 02/08/2007 6:55 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
I still like this one!
[Linked Image from game-master.net]


Member since November 2004
Gold Member since Feb 2008
Re: Not sure I understand how to backup my boards. [Re: luket] #178017 02/08/2007 7:43 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
well, when I post most commands it's for the linux cli vs the MySQL cli wink... Though I'm sure most of the things could probably be done through cmd im not entirely sure of the proper queries lol


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Not sure I understand how to backup my boards. [Re: luket] #178021 02/08/2007 8:28 PM
Joined: Aug 2006
Posts: 1,640
jgeoff Offline
Pooh-Bah
Offline
Pooh-Bah
Joined: Aug 2006
Posts: 1,640
Originally Posted by luket
I still like this one!
[Linked Image from game-master.net]


I kept a couple of the new ones, but use all my old Classic smilies on my new board. [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net]

And I REALLY miss the :/ one on this board! [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net] [Linked Image from gangsterbb.net]


GangsterBB.NET (Ver. 7.6.1.1)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (iPhone); No IE, ever!
Re: Not sure I understand how to backup my boards. [Re: jgeoff] #178028 02/08/2007 10:38 PM
Joined: Jun 2006
Posts: 15,860
Likes: 1
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,860
Likes: 1
I vote for inclusion of :/


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Subscriptions Question
by Ruben - 01/14/2020 12:11 PM
Page won't load after 7.7.3 Update
by Jim0421 - 01/08/2020 11:11 AM
Ubb 7.7.3 winkey emoji shortcut issue
by Ruben - 01/07/2020 4:04 PM
testing winkey emoji shortcut
by Ruben - 01/06/2020 2:36 PM
Very strange problem
by Baldeagle - 01/05/2020 1:22 PM
Who's Online Now
0 members (), 56 guests, and 363 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20200106)