http://premium.wpmudev.org/forums/tags/database WPMU DEV - The WordPress Experts -- Tag: database - Recent Posts en-US Fri, 10 Feb 2012 11:35:53 +0000 http://bbpress.org/?v=1.0.2 q http://premium.wpmudev.org/forums/search.php http://premium.wpmudev.org/forums/topic/how-to-backup-multiple-databases#post-164053 Tue, 20 Dec 2011 21:13:29 +0000 nickd32 164053@http://premium.wpmudev.org/forums/ <blockquote><p>Any one had issues with yatsik's script. We've set it up and it created a backup of the db's but there is no content, they are all empty. Any ideas or recommendation on backing up multiDB's?</p></blockquote> <p>Having a similar issue now. I think it's related to having the PHP "exec" function turned on/off. It needs to be on for that script to run.</p> <p>Here's an FAQ I found about it -- this relates to BackupBuddy, but the PHP exec stuff is helpful.<br /> <a href="http://ithemes.com/codex/page/BackupBuddy:_Frequent_Support_Issues#Compatibility_Mode" target="_blank">http://ithemes.com/codex/page/BackupBuddy:_Frequent_Support_Issues#Compatibility_Mode</a> </p> http://premium.wpmudev.org/forums/topic/how-to-set-more-memory-for-mysql-database#post-155735 Sat, 26 Nov 2011 00:22:04 +0000 elitaderera 155735@http://premium.wpmudev.org/forums/ <p>Ok Thank you everyone I fixed it<br /> and I have a dedicated server. </p> http://premium.wpmudev.org/forums/topic/how-to-set-more-memory-for-mysql-database#post-155553 Fri, 25 Nov 2011 13:48:27 +0000 rozani 155553@http://premium.wpmudev.org/forums/ <p>Hi smartsites,</p> <p>What hosting do you used? Do you use shared hosting, vps or dedicated server? </p> http://premium.wpmudev.org/forums/topic/how-to-set-more-memory-for-mysql-database#post-155548 Fri, 25 Nov 2011 13:03:40 +0000 edskeizer 155548@http://premium.wpmudev.org/forums/ <p>If you have DirectAdmin control panel, maybe this link can help you:<br /> <a href="http://help.directadmin.com/item.php?id=44" target="_blank">http://help.directadmin.com/item.php?id=44</a></p> <p>You still need SSH access to your server, though. </p> http://premium.wpmudev.org/forums/topic/how-to-set-more-memory-for-mysql-database#post-155544 Fri, 25 Nov 2011 12:49:28 +0000 Phil 155544@http://premium.wpmudev.org/forums/ <p>Your control panel is unlikely to provide that option - you will need command line access to your server in order to change the memory limit.</p> <p>If you haven't got that, you will need to ask your hosting company to change it for you.</p> <p>Thanks </p> http://premium.wpmudev.org/forums/topic/how-to-set-more-memory-for-mysql-database#post-155510 Fri, 25 Nov 2011 12:12:53 +0000 elitaderera 155510@http://premium.wpmudev.org/forums/ <blockquote><p> give more memory for MySQL database in control-panel for website,</p></blockquote> <p>Sorry I Mean Online on my website controlpanel not on windows 2008, I am using wordpress multisite. </p> http://premium.wpmudev.org/forums/topic/how-to-set-more-memory-for-mysql-database#post-155475 Fri, 25 Nov 2011 11:07:54 +0000 Phil 155475@http://premium.wpmudev.org/forums/ <p>Hiya!</p> <p>You'll need to know how to play with MySQL on the command line for this, but this page gives you some pointers:<br /> <a href="http://serverfault.com/questions/42789/how-to-increase-memory-usage-in-mysql-server-to-improve-speed" target="_blank">http://serverfault.com/questions/42789/how-to-increase-memory-usage-in-mysql-server-to-improve-speed</a></p> <p>Thanks,<br /> Phil </p> http://premium.wpmudev.org/forums/topic/how-to-set-more-memory-for-mysql-database#post-155445 Fri, 25 Nov 2011 04:42:11 +0000 elitaderera 155445@http://premium.wpmudev.org/forums/ <p>I dont know if anyone here knows but how do you give more memory for MySQL database in control-panel for website, mine is 11.61MB and I need to set more for it because of certain plugins and errors.</p> <p> [attachments are only viewable by logged in members] </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151758 Fri, 11 Nov 2011 09:56:35 +0000 Phil 151758@http://premium.wpmudev.org/forums/ <p>Not sure what would cause that but it sounds like it's gonna be okay to just get rid of it.</p> <p>Phil </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151556 Thu, 10 Nov 2011 17:20:14 +0000 marikamitsos 151556@http://premium.wpmudev.org/forums/ <p>Yes I do and yes it works just fine.<br /> By the name of it (ms_posts) I guess it must have to do with getting the global (multisite) posts.<br /> What is it that causes it to return a value of -0 ? </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151550 Thu, 10 Nov 2011 16:55:21 +0000 Phil 151550@http://premium.wpmudev.org/forums/ <p>Okay, that looks like the wp_posts table. Do you already have a wp_posts table in your database and are all your posts functioning as expected?</p> <p>Thanks </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151514 Thu, 10 Nov 2011 15:40:13 +0000 marikamitsos 151514@http://premium.wpmudev.org/forums/ <p>About backing it up.<br /> I can't. It won't export because its value is -0<br /> By the looks of it is there a value you think I could change so as to manually repair it? </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151510 Thu, 10 Nov 2011 15:37:05 +0000 marikamitsos 151510@http://premium.wpmudev.org/forums/ <p>Please have a look Phil. (If that helps any....)</p> <p> [attachments are only viewable by logged in members] </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151506 Thu, 10 Nov 2011 15:33:50 +0000 Phil 151506@http://premium.wpmudev.org/forums/ <p>No idea I'm afraid - do you know if anything is actually using it? You could back it up, delete it and see if that actually makes an impact...?</p> <p>Phil </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151500 Thu, 10 Nov 2011 15:31:12 +0000 marikamitsos 151500@http://premium.wpmudev.org/forums/ <p>Thanks Phil,</p> <blockquote><p>Have you tried repairing the table?</p></blockquote> <p>Yes but no luck.<br /> Any ideas of what kind of a table that is and if there is another way to repair the table? </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151485 Thu, 10 Nov 2011 15:10:43 +0000 Phil 151485@http://premium.wpmudev.org/forums/ <p>Hiya,</p> <p>I've just checked and none of our plugins use a database table with that name I'm afraid.</p> <p>Have you tried repairing the table?</p> <p>Phil </p> http://premium.wpmudev.org/forums/topic/database-tables-problem#post-151463 Thu, 10 Nov 2011 14:02:42 +0000 marikamitsos 151463@http://premium.wpmudev.org/forums/ <p>Going through my database I found that at some point a table was created that has a count of -0<br /> I guess it has to do with the multisite posts<br /> Please have a look:<br /> [attachments are only viewable by logged in members]<br /> 1. Do you have any idea which wpmudev plugin might have created this?<br /> 2. Could some one tell me if and how to fix that? I guess there could be a way to change that to at least 0</p> <p>Thanks </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-117229 Thu, 28 Jul 2011 16:25:58 +0000 ClvrTv 117229@http://premium.wpmudev.org/forums/ <p>thanks! :) </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-117202 Thu, 28 Jul 2011 15:41:54 +0000 Andrey 117202@http://premium.wpmudev.org/forums/ <p>Hi Andrew,</p> <p>We fixed the problem, please update the plugin. </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-117153 Thu, 28 Jul 2011 14:02:24 +0000 Andrey 117153@http://premium.wpmudev.org/forums/ <p>Hi Andrew,</p> <p>Thanks,<br /> I think it's bug.<br /> I will look and fix it soon. </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-117120 Thu, 28 Jul 2011 12:33:45 +0000 Phil 117120@http://premium.wpmudev.org/forums/ <p>Ah I see what you're referring to know. I've looked at the code and it does indeed appear to create the tables for every site regardless of activation.</p> <p>I'll check with the developer why that is...</p> <p>Phil </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-117102 Thu, 28 Jul 2011 11:34:52 +0000 ClvrTv 117102@http://premium.wpmudev.org/forums/ <p>The 7 tables are not a problem on a single site - or per every site that it's activated on. But it is a problem when it creates all 7 tables per site - for EVERY site - in a multisite installation without consideration to which site(s) it's actually active on or not. </p> <p>It should only create and use the tables per site that it's active on. In a multisite installation - not even a very large one - this plugin adds massive amounts of tables to the overall database. In my case it created 2000 tables when I only wanted it active on 1 single site (which only needed the 7). The subject in this topic was not hyperbole. Nevermind what it would do on a large multisite environment. </p> <p>Does that make sense? Did you misunderstand what I was saying? I don't understand why you'd create tables for sites that a plugin is not even activated on. </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-117064 Thu, 28 Jul 2011 10:29:11 +0000 Phil 117064@http://premium.wpmudev.org/forums/ <p>Hiya!</p> <p>Yep, the plugin does require those 7 tables. I know it's a lot but as you found out, it's very good at cleaning up after itself.</p> <p>Phil </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-117000 Thu, 28 Jul 2011 07:55:40 +0000 ClvrTv 117000@http://premium.wpmudev.org/forums/ <p>Ok, in all fairness I just discovered that at least the delete hook was pretty well thought out and all tables were removed when I deleted the plugin from the network admin.</p> <p>However, I still think it shouldn't create tables for every site in the network when it is only activated on one site :) </p> http://premium.wpmudev.org/forums/topic/ack-e-newsletter-created-over-2000-tables-in-my-database#post-116997 Thu, 28 Jul 2011 07:42:48 +0000 ClvrTv 116997@http://premium.wpmudev.org/forums/ <p>I consider this a bug and a dangerous one. I was excited to check out the e-Newsletter plugin until I discovered that it created 7 tables for every single site (currently around 300) in our network when I only activated it on 1 site!</p> <p>I did NOT Network Activate it. I simply installed it and then went to a single site and activated it locally to that site only. This is not good at all. Now I'm faced with cleaning up a bunch of tables manually. I don't want all that extra junk in there - I try to keep things as tightly optimized as I can. </p> <p>I only discovered it right away because I was going to do a manual import into the raw tables of existing email lists since there is not (yet) an import function. </p> <p>Can you provide a way to clean up those tables from all the sites the plugin is not active on? And fix it so that a local activation does not trigger table creation for every site in the network? </p> <p>Thanks!<br /> Andrew </p> http://premium.wpmudev.org/forums/topic/scalability-hosting-and-caching#post-112533 Wed, 13 Jul 2011 04:40:46 +0000 foodfriendfinder 112533@http://premium.wpmudev.org/forums/ <p>fastpipe ...you have alot of traffic ...good you upgraded...8 gigs ram would be minimum.....also maybe look into litespeed server <a href="http://www.litespeedtech.com/" target="_blank">http://www.litespeedtech.com/</a> as it might help if your server load starts getting high...pro version is $32/ month </p> http://premium.wpmudev.org/forums/topic/scalability-hosting-and-caching#post-112431 Tue, 12 Jul 2011 21:10:27 +0000 FastPipe Media, Inc. 112431@http://premium.wpmudev.org/forums/ <p>Thanks Aaron. I was actually the first one to comment on that post and am glad you reminded me about it.</p> <p>I just today completed a deal to upgrade our server to newer quad-core Xeon processors, twice as much RAM, and using a pair of 120GB SSDs instead of old-style hard drives. In addition, I think I'll switch our operating system from FreeBSD, which we've had for years, to Ubuntu Linux (the one or host offers), which will give us a lot more software caching options.</p> <p>Looks like I'll be migrating in the next week or so... </p> http://premium.wpmudev.org/forums/topic/scalability-hosting-and-caching#post-112429 Tue, 12 Jul 2011 20:49:26 +0000 Aaron 112429@http://premium.wpmudev.org/forums/ <p>This might interest you:<br /> <a href="http://wpmu.org/scaling-wordpress-wpmu-buddypress-like-edublogs/" target="_blank">http://wpmu.org/scaling-wordpress-wpmu-buddypress-like-edublogs/</a></p> <p>You will definitely need to use multidb for database scaling, it allows you to split it up over different servers, as well as utilize mysql clustering. </p> http://premium.wpmudev.org/forums/topic/wpmu-power-tools#post-109383 Fri, 01 Jul 2011 13:37:06 +0000 n2rga 109383@http://premium.wpmudev.org/forums/ <p>Wow Excellent Thank you</p> <p>Now to find out if the script is good for 3.x to copy users from one blog to another </p> http://premium.wpmudev.org/forums/topic/wpmu-power-tools#post-109320 Fri, 01 Jul 2011 07:10:18 +0000 Ovidiu 109320@http://premium.wpmudev.org/forums/ <p>hm, that link was working a few weeks ago...<br /> here is the latest version I have and use: <a href="http://pastebin.com/6aqEMf47" target="_blank">http://pastebin.com/6aqEMf47</a> </p>