|
Joined: Jun 2006
Posts: 998 Likes: 25
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 998 Likes: 25 |
My forum http://www.britbike.com/forums/ubbthreads.phpshows below error message, I have no idea how to fix this. i run 7.3.1 Thanks for your input. /Morgan in Sweden UBB Message We encountered a problem. The reason reported was Script: /home/cluster1/data/i/p/a1172648/html/forums/libs/user.inc.php Line#: 445 SQL Error: Table './14462_britbikecom/ubbt_bbfUSERS' is marked as crashed and should be repaired SQL Error #: 145 Query: SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF FROM ubbt_bbfUSERS as t1, ubbt_bbfUSER_PROFILE as t2 WHERE t1.USER_ID = '' AND t1.USER_ID = t2.USER_ID Please click back to return to the previous page.
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
No, it's not bad. Do you have SSH access?
If so, stop MySQL server and run:
myisamchk --silent --force --fast --update-state -O key_buffer=64M -O sort_buffer=64M -O read_buffer=1M -O write_buffer=1M /var/lib/mysql/databasename/ubbt_USERS.MYI
Rob
|
|
|
|
Joined: Jun 2006
Posts: 998 Likes: 25
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 998 Likes: 25 |
No no ssh access only forum admin. you gave me some hope here.. :o)
how can I get this ssh access?
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
Probably you cannot get any access using SSH if it's no dedicated server.
Maybe this will work: 1) Login to your cPanel 2) Go to the MySQL section, and click the "REPAIR" icon next to your database's name
Rob
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
You can try the REPAIR option in SQL
The syntax is, as would be expected, REPAIR TABLE tablename[,tablename1...] [options]. This method only works with MyISAM tables.
So login with phpmyadmin and try this option if the first one doesn't work.
Rob
|
|
|
|
Joined: Jun 2006
Posts: 998 Likes: 25
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 998 Likes: 25 |
ROB, Tried to do this 1) Login to your cPanel 2) Go to the MySQL section, and click the "REPAIR" icon next to your database's name Well I did and go below message Sorry, we had trouble processing your request. An unexpected error occurred. If this continues to happen, please contact Support. I did contact support, sadly I have not that good experience with that "support" due to prior experience. But they might surprize me hope for that. Any other clues from you guys??? Thanks Morgan
|
|
|
|
Joined: Jun 2006
Posts: 998 Likes: 25
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 998 Likes: 25 |
BLOODY H*LL it works............. Maybe the repair button did it after all... Big thanks and be sur I will monitor it for a while
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
You're welcome. I hope it keeps working now. I had the same for a while but i run my server dedicated and i'm running a crontab which checks the quality of my databases once in a while and repairs it on the background. But that's only possible if you run your own server or have SSH acces with root rights...
Goodluck with you fully repaired database. Oh, don't forget to back it up once in a while...
Rob
|
|
|
|
Joined: Jun 2006
Posts: 998 Likes: 25
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 998 Likes: 25 |
It's just that I have no back up and don't know how to... Maybe I should be a user instead...;)
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
hehehe... You have MySQL access, there's a way to backup you complete SQL database with just 5 mouseclicks (Export option) If you can't find it please let us know, i'll give you some more explaination.. Rob
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
You can backup your tables from within the control panel - go to your 'database tools' toward the bottom of the CP, then select the 3rd tab over, you may have to add a folder to back them up to.
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
Oops, forgot that there's a backup function within ubb...
|
|
|
|
Joined: Dec 2003
Posts: 6,629 Likes: 85
|
Joined: Dec 2003
Posts: 6,629 Likes: 85 |
Yes there is but there is not a restore so you would need to know how to restore the backup. I use it myself as a backup to my backup but it looks like it would be a headache to use to restore. Since it makes a separate file for each table.
It would be nice if Rick would add a utility to restore using the backups that ubb makes.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
Yeah, You would wonder why someone one would make a backup routine in a program but no restore command for that program.
|
|
|
|
Joined: Dec 2003
Posts: 6,629 Likes: 85
|
Joined: Dec 2003
Posts: 6,629 Likes: 85 |
Well you know people here will say they don't use the ubb backup because their board is very large and it takes to long, Backup crashes because file is to large(Bla,bla,bla) But I think for people new at least it would be a useful tool until they get their feet wet.
It could be just a simple stand alone script using the config.inc.php file. Which has everything needed. And by the way the backup does not save that file either just the tables.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jun 2006
Posts: 16,367 Likes: 126
|
Joined: Jun 2006
Posts: 16,367 Likes: 126 |
It'd be far more resource intensive to create a backup from within the UBB than say through an sql dump via commandline... (See my sticky for moving a forum in the general forum for a little how to).
|
|
|
|
Joined: Dec 2003
Posts: 6,629 Likes: 85
|
Joined: Dec 2003
Posts: 6,629 Likes: 85 |
Okay giz posted at same time. But I still think of the peeps as Sd says.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
Just had a site move onto my service utilizing a different message board then UBB. He had no backup and lost a few thousand post's and hundreds of users. Lost the entire database.
I had his site online and running with in an hour after he was online. To bad he didn't have his database. I could have restored it in less then 30 minutes.
You see, many of these UBB's are hosted on these rock solid corporations who give away web space for next to nothing with those said unlimited accounts. What happens if they go belly up and close or kick you off for what ever reason?
I see this happening allot in the very near future. Bad for those companies but really good for me. The Mom and Pop web hosting companies offer more in the long run then those secure corporations.
|
|
|
|
Joined: Dec 2003
Posts: 6,629 Likes: 85
|
Joined: Dec 2003
Posts: 6,629 Likes: 85 |
All I can say is you have to live through it to understand the importance of backups. Most people read the FAQ on their host and assume they are already backed up. But the truth is the host only backs up the server(In most cases) So the user may get the site back but all published files are gone.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
Was not me as the host, lol. They are making backups now and I am now hosting them as well.
I do backups but tell the users that they are responsible for their own. Sometimes we need to move sites from one server to another and always backup those sites before we make those changes, we play it safe.
|
|
|
|
Joined: Jun 2006
Posts: 16,367 Likes: 126
|
Joined: Jun 2006
Posts: 16,367 Likes: 126 |
One of my favorite clients went belly up becuase they didn't keep backups, and their webhost went offline and didn't keep backups of their sites... Was horrible to see his community dissapear overnight...
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
Was their web host one of those big corporations giving away web space for next to nothing?
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Well I know that CPANEL allows you to do full backups of all DB and restores.
I agree with Gizmo that command line access would be the fastest, but as some say, new users may not have or even know how to do it from the command line. I would think most host control panels would allow DB backup/restore if they're offering MySQL for users.
|
|
|
|
Joined: Jun 2006
Posts: 16,367 Likes: 126
|
Joined: Jun 2006
Posts: 16,367 Likes: 126 |
Was their web host one of those big corporations giving away web space for next to nothing? In a nutshell, yeh; near unlimited resources, blah blah blah... My main pre-requisite I'd have with any host SSH access... I find it a nessessity...
|
|
|
|
Joined: Jun 2006
Posts: 998 Likes: 25
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 998 Likes: 25 |
My mysql is 900mb and I have used just over half of it. If I do a backup would it be stored on that server or in my host web.com's website server?
How do I use the command line to do this?
I know i need to create a backup but also delete some of the content in the database.
|
|
|
|
Joined: Jun 2006
Posts: 16,367 Likes: 126
|
Joined: Jun 2006
Posts: 16,367 Likes: 126 |
Well, the SQL command is executed from your webhost server, so it'd take the data off of the sql server and dump it to wherever you ran the command from...
This would be done exactly as the migration guide states, just the -h parameter would be wherever your mysql host is (if it differentiates from "localhost").
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
Backup from the command line: mysqldump -Q -u USERNAME -pPASSWORD DATABASENAME > /backup_location/database.sql
Rob
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Here's the reason why there is no restore option within UBB. We couldn't restore the entire table at once due to timeout issues, so we'd need to restore it in chunks. Which means we'd have to drop a table before starting to restore it, or just drop the data from the table.
We can't drop the table because UBB might rely on the table and would no longe work, right in the middle of your restore. If we dropped data, when we got to the USER_ tables we could have the same issue, because as an admin you'd either get logged out when your data was dropped, or you temporarily wouldn't exist at all.
|
|
|
|
Joined: Mar 2009
Posts: 64
journeyman
|
journeyman
Joined: Mar 2009
Posts: 64 |
What is the bast way to backup? Is there a step by step guide on how to properly and safely backup?
My ISP does this but as it was mentioned it is best to backup outside the ISP just in case they go out of business.
Would be nice if a backup file was mailed every day.
|
|
|
|
Joined: Jan 2008
Posts: 222
enthusiast
|
enthusiast
Joined: Jan 2008
Posts: 222 |
Use your Plesk/Cpanel to do so... Don't invent the wheel again.
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
I think for many users who have a UBB the best question would be what is the best way to restore?
|
|
|
|
Joined: Jun 2006
Posts: 16,367 Likes: 126
|
Joined: Jun 2006
Posts: 16,367 Likes: 126 |
Lol if my site backup was emailed every day, i'd have several hundred gb of data in my email... best way to restore is the best way to backup... via the commandline through SSH ... (again, covered in my "how to migrate" posting in the how to forum)
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
Using the built-in backup scripts has a negligible server load. You can use the ubb backups to do a restore, I've done this several times with SSH.
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
I use the UBB backups as well to do a restore, it's quick and no server load however the only way I can do this is via command line. It does not matter how large the file is either. The major problem is that some users on a hosted environment do not have command line access or wouldn't know how to restore this way.
|
|
|
|
Joined: Mar 2009
Posts: 64
journeyman
|
journeyman
Joined: Mar 2009
Posts: 64 |
Use your Plesk/Cpanel to do so... Don't invent the wheel again. All of my hosting accounts have Cpanel but I do not know how to backup UBBthreads from there. Not trying to invent. Just want to use something that is already invented and works
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
phpmyadmin works, for larger boards you'll have to do partial restores - can take a long time but I've done it with success several times.
|
|
|
|
Joined: Mar 2009
Posts: 64
journeyman
|
journeyman
Joined: Mar 2009
Posts: 64 |
Lol if my site backup was emailed every day, i'd have several hundred gb of data in my email... Me too. I have a couple of sites with more than 1 million posts I keep backups, two copies on different hard disks, at the server. Never though my host could go bust and not give me the backup Maybe I need to somehow mirror the server at a different host
|
|
|
|
Joined: Aug 2006
Posts: 1,359
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,359 |
I ftp both my file and sql backup to a different host after creating them daily.
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
Never though my host could go bust and not give me the backup You will see many of those large corporate cut through pricing host's going bust in the next year or two.
|
|
|
2 members (Ruben, SenecaFlyer),
929
guests, and
67
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|