rainer23
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: MySQL database growing real big within short timeThanks vtxyzzy, I installed delete-revision.1.3.1, revision-control.2.0 but somehow this did not delete the past revision entries in the database, wp_posts remained at 120 MB. Only by doing a query directly in MySQL it worked for me. Of course entering SQL statements one should be aware of the risk.
Forum: Fixing WordPress
In reply to: MySQL database growing real big within short timeThanks vtxyzzy, it is wp_posts.
Problem was that each time a post is corrected the revision is saved in the database. When you make this e.g. 5 times per post, the whole post is saved 5 times in the database.I have 3300 posts and at wp_posts it said 121 MB. Since I made regular database backups I noticed that the database jumped from August 2010 with 16 MB to 120 MB six months later.
So I went to phpMyAdmin and entered DELETE FROM wp_posts WHERE post_type = “revision”; . This deleted all those saved revision files from my database. Then checked again the size, it has 21 MB now what is quite acceptable.
Forum: Fixing WordPress
In reply to: Slow queries( SQL_CALC_FOUND_ROWS) bringing down siteAfter all those years isnt there meanwhile a plugin doing this job of clearing the database cache of unwanted entries?
Forum: Fixing WordPress
In reply to: WordPress Database – is 300mb too big?I noticed that the size of my database jumped from 16 MB to 120 MB in the last 6 six months. It took 18 months to come to 16 MB and then within 6 months jumped to 120 MB. The number of posts per day always remained the same, now there are 3300 posts and 1000 comments. The patch from http://core.trac.wordpress.org/ticket/10964 and “W3 Total Cache”, does this clear the cache of my 120 MB database?
Not sure if the developers of wordpress did not put those patches already in 3.0.4.? Thanks for any information!Forum: Installing WordPress
In reply to: Upgrading to 3.0.4 by replacing new filesThanks Lonnylot, it’s much easier to just replace 4 files 🙂
Forum: Installing WordPress
In reply to: Upgrading to 3.0.4 by replacing new filesThanks, is it still the same, version.php in wp-includes?
Forum: Installing WordPress
In reply to: Upgrading to 3.0.4 by replacing new filesThanks Rich ‘elfin’ Pedley, is there something more?
Forum: Installing WordPress
In reply to: Upgrade from 3.0.2 to 3.0.3 with just the four changed filesThanks daymobrew, thanks for giving a note!
Forum: Installing WordPress
In reply to: Upgrade from 3.0.2 to 3.0.3 with just the four changed filesThat would be great, did you try it?
Forum: Your WordPress
In reply to: Lifestyle Coach site – got their in the end.Great design, looks good!
Forum: Fixing WordPress
In reply to: How to restore my old version of wordpress?Thanks infocms, just asked because G-Lock Double Opt-in Manager is my newsletter plugin and for our blog important that this works. Anyway upgrade done, no errors.
Forum: Fixing WordPress
In reply to: How to restore my old version of wordpress?A new upgrade also upgrades the database. What exactly causes a plugin to not work anymore is rather difficult to answer. Only thing you can try is to install 3.0.1 and see if the changes make this plugin run again.
Not sure if the database is also changed back by doing this? At any case, finally there must be an upgrade of this plugin available. Just one question, is it G-Lock Double Opt-in Manager? Which plugin is it actualy?Forum: Your WordPress
In reply to: A Wickedly Awesome WordPress Site. Do you agree?Wonderful, awesome webdesign! At general/settings/Site address (URL) and WordPress address (URL), write: http://www.bayarea-web.com. Looks better like http://bayarea-web.com/
Forum: Your WordPress
In reply to: My Photography WebsiteThanks, awesome webdesign! Comes close to my favourite webdesign at http://www.nps.edu/
Impressive slightshow, dropdown menue, clearly laid out navigation.Forum: Installing WordPress
In reply to: after upgrading 2.9.2 to 3.01 my database is deadLooks like not all files were uploaded, re-check if 100% all files are uploaded. Did you deactivate the plugins? Can you go back to the previous version 2.9.2?