http://bbpress.org/forums/ bbPress Support Forums Tag: backup en Fri, 09 Jan 2009 01:33:04 +0000 http://bbpress.org/forums/topic/automated-backup-plugin#post-17171 Thu, 10 Jul 2008 07:50:42 +0000 chrishajer 17171@http://bbpress.org/forums/ <p>It's great that you have shell access. You can backup all the files with something like rsync, and you can use a shell script to backup the database tables you want. Since there are no wildcards in mysqldump, you will need to explicitly name all the tables in your installation; just separate them with spaces.</p> <p>You can put something like this into a bash script and run it daily (or whenever) from cron:</p> <pre><code>mysqldump --add-drop-table -h host -u user -p password dbname \ ( bb_forums \ bb_meta \ bb_posts \ bb_tagged \ bb_tags \ bb_terms \ bb_term_relationships \ bb_term_taxonomy \ bb_topics \ bb_topicmeta \ bb_users \ bb_usermeta ) | bzip2 -c | bbpress.bak.sql.bz2</code></pre> <p>&nbsp;</p> <p>You would have to consider putting the password into the script and hiding that from prying eyes. Alternatively, you could create a user with limited privileges and no password, and use that in the backup script.</p> <p>You should also verify the table prefix, and that those are all your bbPress tables. I think there are different tables for different bbPress versions.</p> <p>Good luck. </p> http://bbpress.org/forums/topic/automated-backup-plugin#post-17148 Wed, 09 Jul 2008 16:24:13 +0000 ashes999 17148@http://bbpress.org/forums/ <p>Yeah, I have shell access...</p> <p>I had a shell script before to back up my whole schema; but I just want to back up the bbpress schema now, not the wordpress schema. </p> http://bbpress.org/forums/topic/automated-backup-plugin#post-17144 Wed, 09 Jul 2008 14:17:38 +0000 chrishajer 17144@http://bbpress.org/forums/ <p>Do you have access to a shell at your host? If so, you can do it pretty easily. If not, I don't know of an automatic backup plugin for bbPress. </p> http://bbpress.org/forums/topic/automated-backup-plugin#post-17142 Wed, 09 Jul 2008 13:27:51 +0000 ashes999 17142@http://bbpress.org/forums/ <p>Wordpress has a great plugin called wp-backup that allows you to schedule a nightly backup of your database. Is there something similar for bbPress? If not, how should I back up my data regularly? </p> http://bbpress.org/forums/topic/can%c2%b4t-acces-the-admin-panel#post-13606 Sun, 03 Feb 2008 12:53:35 +0000 JohnConners 13606@http://bbpress.org/forums/ <p>Have a look in your mysql database with phpmyadmin at the bb_usersmeta table for your user (whatever ID that is, which you can get from the bb_users table). If you find the row that has the meta_key column of bb_capabilities, you'll probably find the meta_value is:</p> <p><code>a:1:{s:6:&quot;member&quot;;b:1;}</code></p> <p>If you change that to:</p> <p><code>a:1:{s:9:&quot;keymaster&quot;;b:1;}</code></p> <p>You'll find you're an admin and can see the admin panel. </p> http://bbpress.org/forums/topic/can%c2%b4t-acces-the-admin-panel#post-13603 Sun, 03 Feb 2008 11:02:00 +0000 EgonvomBerg 13603@http://bbpress.org/forums/ <p>no I didn´t delete the bbpress data. only the wpdata.<br /> I reinstalled all, but still no admin panel.<br /> Users can still register and posting are still there and possible to make.</p> <p>is there no other way? </p> http://bbpress.org/forums/topic/can%c2%b4t-acces-the-admin-panel#post-13557 Fri, 01 Feb 2008 15:18:16 +0000 _ck_ 13557@http://bbpress.org/forums/ <p>Check with your host to see how often they do backups for you.</p> <p>Some premium hosts do daily and weekly backups which would save you. </p> http://bbpress.org/forums/topic/can%c2%b4t-acces-the-admin-panel#post-13554 Fri, 01 Feb 2008 14:49:18 +0000 chrishajer 13554@http://bbpress.org/forums/ <p>If the posts are indexed and cached by Google, you could retrieve them all and re-enter them... </p> http://bbpress.org/forums/topic/can%c2%b4t-acces-the-admin-panel#post-13553 Fri, 01 Feb 2008 14:49:12 +0000 agentmaximus 13553@http://bbpress.org/forums/ <p>Last resort is to build a time machine or ask your webhost. If you ask nicely they may retrieve a backup for you ... ? </p> http://bbpress.org/forums/topic/can%c2%b4t-acces-the-admin-panel#post-13539 Fri, 01 Feb 2008 13:38:36 +0000 sambauers 13539@http://bbpress.org/forums/ <p>You have deleted all your data without a backup. Seems to me there is no solution. </p> http://bbpress.org/forums/topic/can%c2%b4t-acces-the-admin-panel#post-13535 Fri, 01 Feb 2008 13:11:33 +0000 EgonvomBerg 13535@http://bbpress.org/forums/ <p>I have the problem that I can´t acces the admin panel since I deleted the Wordpress"files" WordPress database and my bbPress installation was in the same database.<br /> don´t have a backup.<br /> but did a fresh reinstall in the nower bbpress database. </p> <p>does anyone know how to solve that problem? </p> http://bbpress.org/forums/topic/posts-lost-#post-12761 Tue, 18 Dec 2007 20:25:05 +0000 chrishajer 12761@http://bbpress.org/forums/ <p>If they're not in the database and you don't have a good backup, the only possibility I can think of is the binlog for MySQL. That's probably not possible on a shared host. </p> <p>You might want to turn off Akismet in your config for now, to see if that's what caused the problem. </p> http://bbpress.org/forums/topic/posts-lost-#post-12730 Mon, 17 Dec 2007 19:35:21 +0000 r4zv4n 12730@http://bbpress.org/forums/ <p>Unfortunately, not only they aren't in the DB, but I don't have a usable backup either (the last full backup I have is from about two weeks ago and the daily backup has the same thing as.. what i see).</p> <p>Another weird thing is that some days ago, in my Akismet spam list I found some posts from way back (that weren't spam, but.. why check them if they were already "accepted" ?).</p> <p>So I suspect that something might have triggered a full check and it automagically deleted what it considered spam or something..</p> <p>So, I lost about a month and some of posts :( </p> http://bbpress.org/forums/topic/posts-lost-#post-12723 Mon, 17 Dec 2007 16:04:56 +0000 chrishajer 12723@http://bbpress.org/forums/ <p>You need direct access to the database with something like phpMyAdmin. If the posts are still in the database, you will be able to get them back. If they're not there, you might have access to something like binary logs for MySQL, but that's a long shot. </p> <p>Any idea why the middle ones are gone? I mean, how did that happen?</p> <p>Do you have any database backups that you can recreate from? </p> http://bbpress.org/forums/topic/posts-lost-#post-12712 Mon, 17 Dec 2007 09:14:55 +0000 r4zv4n 12712@http://bbpress.org/forums/ <p>This morning when I logged in, I noticed a big chunk of the posts on my forum were gone. I still have posts from the beginning and some recent ones, but a large batch of posts from the middle was lost :(</p> <p>Any ideas on why or how I could get them back ? </p> http://bbpress.org/forums/topic/user-id-999999999#post-6078 Wed, 28 Mar 2007 20:16:15 +0000 cweb 6078@http://bbpress.org/forums/ <p>Ok this worked for me, here's how I actually <strong>reset the auto_increment</strong> counter.</p> <p>NOTE: If you've already integrated WP and bbpress and/or if you've already had a bunch of new users register, this wont be so easy for you. If however, you've performed a <strong>fresh installation and conversion</strong> then this will be simple.</p> <p>1. make sure one of my existing users in the normal ID range is a Key_Master (this is very important). For me, I made one of my users with ID =5 the Key Master.<br /> 2. login with the new Key Master, and delete all the users who are registered with a number =&gt; 999999999. For me this wasn't a problem because "admin" was the only user, I haven't had any new user registrations. If you do have new users in the 1000000000 range you'll need to reset their ID's (I'm not a MySQL guy so I dunno how)<br /> 3. Once all users in the ugly high number range are deleted, you can run the command to reset the counter on your *_users table, for me it was:</p> <p><code>ALTER TABLE bb_users AUTO_INCREMENT = 400</code></p> <p>I just added a few new users and they indeed started at ID 400.</p> <p>BTW, here's the code in the phpbbtobbpress.php converter that sets this very high ID:</p> <pre><code>//Let&#39;s clean up the trash. //Your admin user will be given the biggest possible ID (I tried the biggest BIGINT but it didn&#39;t work inside bbPress) //If you have more than 999999999 users on your forum, you may have problems... ;-) @mysql_query (&quot;UPDATE &quot; . $bbpress_tables[&#39;users&#39;] . &quot; SET ID=999999999 WHERE ID=1&quot;); @mysql_query (&quot;UPDATE &quot; . $bbpress_tables[&#39;usermeta&#39;] . &quot; SET user_id=999999999 WHERE user_id=1&quot;); @mysql_query(&quot;TRUNCATE TABLE &quot; . $bbpress_tables[&#39;forums&#39;]);</code></pre> http://bbpress.org/forums/topic/user-id-999999999#post-6076 Wed, 28 Mar 2007 19:42:46 +0000 cweb 6076@http://bbpress.org/forums/ <p>I'll confirm that I have this problem as well, from a phpbb to bbpress conversion. I actually tried to reset the auto_increment like chrishajer said:</p> <p>ALTER TABLE bb_users AUTO_INCREMENT = 400</p> <p>Since my original ID's stopped at around 350.</p> <p>It didn't work though, still incrementing in the billions. MySQL documentation says:</p> <blockquote><p>"You cannot reset the counter to a value less than or equal to any that have already been used." </p></blockquote> <p><a href="http://dev.mysql.com/doc/refman/5.0/en/alter-table.html">http://dev.mysql.com/doc/refman/5.0/en/alter-table.html</a></p> <p>So to me that reads I need to delete the admin user 999999999 first, am I correct? </p> http://bbpress.org/forums/topic/user-id-999999999#post-5521 Wed, 14 Mar 2007 15:06:23 +0000 chrishajer 5521@http://bbpress.org/forums/ <p>So, it sounds like this is related to the conversion from phpBB. At least that narrows it down.</p> <p>In phpMyAdmin, select the table (be that bb_users or wp_users) and then select the "operations" tab up top. On that page, near the bottom are "Table options:" and in there is a field that says [ xxx ] auto_increment where the xxx is the next auto_increment value that will be used. That's where you would change it.</p> <p>You should first figure out what that value should be, and you should also fix the other high numbered users. But that's where you reset it with phpMyAdmin. *** Perform at your own risk. ***</p> <p>You can also just do it with SQL:</p> <p><code>ALTER TABLE &#39;wp_users&#39; AUTO_INCREMENT =whatever-number</code></p> <p>The wp_users tablename might be bb_users or something else in your install. Also, the table name should be backticked, but you can't do that in a block of code that's already backticked here :D </p> http://bbpress.org/forums/topic/user-id-999999999#post-5519 Wed, 14 Mar 2007 14:14:02 +0000 wittmania 5519@http://bbpress.org/forums/ <p>Can anyone enlighten me/us as to how to reset that auto increment using phpmyadmin or something similar? I doubt it is causing any real problems, but it still is kind of ugly. </p> http://bbpress.org/forums/topic/user-id-999999999#post-5517 Wed, 14 Mar 2007 14:00:56 +0000 flaerpen 5517@http://bbpress.org/forums/ <p>I have exactly the same "problem". It all started after converting my phpBB to bbPress so I think thats the problem. </p> http://bbpress.org/forums/topic/user-id-999999999#post-5516 Wed, 14 Mar 2007 13:53:51 +0000 wittmania 5516@http://bbpress.org/forums/ <p>I did run the conversion, but it didn't work very well because I ended up with duplicate IDs, and therefore posts from phpbb were attributed to the wrong authors in cases where their IDs conflicted.</p> <p>Now that you mention it, I wonder if the phpbb importer makes a change so that all new registrations would start at 999999999 just so there couldn't possibly be any conflicts. I don't know enough about mysql to know if that's the case (or if it is, how to "fix" it), but if I were the one building the importer, I would probably add a feature like that, though I think a number around one billion might be a bit of overkill! </p> http://bbpress.org/forums/topic/user-id-999999999#post-5514 Wed, 14 Mar 2007 12:57:07 +0000 ebotunes 5514@http://bbpress.org/forums/ <p>this has happened to me as well. Two new users have registered and have IDs 99999999 and 1000000000. They appear to be spam though so I was very worried that they'd somehow managed to hack their user id from the front end??? Highly unlikely though.</p> <p>I am wondering if the conversion from phpBB to bbpress has anything to do with it? ( <a href="http://bbpress.org/forums/topic/47?replies=12" rel="nofollow">http://bbpress.org/forums/topic/47?replies=12</a> )</p> <p>Did you use this wittmania? I did, and these are the first users to register since the migration. I will investigate a bit further over the next few days when i get the chance.... </p> http://bbpress.org/forums/topic/user-id-999999999#post-5446 Mon, 12 Mar 2007 22:29:18 +0000 wittmania 5446@http://bbpress.org/forums/ <p>I looked at the tables in another WP install and fixed this one so that it matched. We'll see if I run into any trouble... </p> http://bbpress.org/forums/topic/user-id-999999999#post-5445 Mon, 12 Mar 2007 22:15:45 +0000 Trent 5445@http://bbpress.org/forums/ <p>I wish I could help you on that one.....you don't remember what you changed? Do you have a backup?</p> <p>Trent </p> http://bbpress.org/forums/topic/user-id-999999999#post-5440 Mon, 12 Mar 2007 21:02:39 +0000 wittmania 5440@http://bbpress.org/forums/ <p>OK... so I do have access to phpMyAdmin, which may not be such a good thing.</p> <p>Somehow I got some things crossed up so I am now getting these messages from within the wp_users table:</p> <p>!!! PRIMARY and INDEX keys should not both be set for column <code>ID</code></p> <p>!!!More than one INDEX key was created for column <code>ID</code></p> <p>!!!UNIQUE and INDEX keys should not both be set for column <code>user_login</code></p> <p>Here is the raw text of the indexes from that page:</p> <p> Indexes:<br /> Keyname Type Cardinality Action Field<br /> PRIMARY PRIMARY 5 Edit Drop ID<br /> user_login UNIQUE 5 Edit Drop user_login<br /> user_login_key INDEX None Edit Drop user_login<br /> ID_2 INDEX None Edit Drop ID<br /> ID_3 INDEX None Edit Drop ID<br /> ID_4 INDEX None Edit Drop ID</p> <p>This is a longshot, but can you tell what I messed up, and how I should fix it? Sorry. I really appreciate the help.</p> <p>While I wait for a response I will be banging my head against my desk for not backing up the DB before I started messing around with it. :( </p> http://bbpress.org/forums/topic/user-id-999999999#post-5439 Mon, 12 Mar 2007 20:45:13 +0000 chrishajer 5439@http://bbpress.org/forums/ <p>If you have access to phpMyAdmin, you can reset the auto_increment field to start over at 6 or wherever you are right now. I've never seen this one either, but somehow the auto_increment appears to have gotten messed up. </p> http://bbpress.org/forums/topic/user-id-999999999#post-5435 Mon, 12 Mar 2007 20:22:19 +0000 Trent 5435@http://bbpress.org/forums/ <p>When you are integrated with bbPress, it uses the wp_user table for users. It shouldn't have done anything to your WP install just integrating with bbPress. That is strange. I don't think I have ever seen this one. Even with both integration plugins, registering in either program I can't replicate this. Anyone else seeing this as well?</p> <p>Trent </p> http://bbpress.org/forums/topic/user-id-999999999#post-5429 Mon, 12 Mar 2007 18:28:00 +0000 wittmania 5429@http://bbpress.org/forums/ <p>I have recently integrated a bbpress install with an existing wordpress blog/site. The WP blog had three users prior to the integration, and all three made it over to the bbpress install with no problems. However, today a new user registered on the WP side and her ID defaulted to 999999999.</p> <p>I proceeded to register a "dummy" user, just to see what happened. The next registration ticked up to user ID <a href="http://trac.bbpress.org/ticket/1000000000">#1000000000</a>. While I doubt that this will lead to any serious problems, it seems silly to me to have user IDs starting around ONE BILLION, when even 1,000 would be plenty high enough for my <a href="http://www.lne97.com">lil' ol' site</a>. Having McDonald's-esque "XX billions served" sized numbers seems to fly in the face of the "Code is poetry" mantra.</p> <p>Any ideas as to what's going on here? </p>