Help With Wordpress

Wish I could help, but unfortunately not. My problem was something else - fortunately the backup had worked (despite information to the contrary to my host provider). I think there's a very active Wordpress support community that should be able to help.

I have come to the conclusion that there is very little that Martijn does not know.

In fact, I have been actively propagating that very fact for many a decade now!

I will tell you one thing for sure: next time are completely sure you deleted your comments, profile, or entire websites off the net, well, don't be so sure.

Can.i.has.Bregt.God,pls?

Did you try my suggestions?
One of them really should work.

If not, I think the only option left is the "push until it moves" approach, which is risky.
It basically requires you to back up the mysql database for your site only (you should really be able to do that through whatever interface your provider has made available to you. Unfortunately interfaces differ massively between providers so I can't really give you any more detailed pointers here).

Once done, copy the mysql backup file locally.
Then copy everything from the root of your wordpress site to your desktop.

Once done (and that may take quite a while), copy everything to the root of the new site, create the required mysql database (it should have the same name as the one from the old site) and import the old mysql database into it (again, the interface your provider has provided to you should offer that functionality).

That should start the new site on the new server.

But it's a very hardhanded and rough approach with much potential for failure (in the sense of breaking links and posts on the site).

My God... I'm such an asshole! Martijn I apologize for not replying.

Some of the stuff you mentioned above is a little over my head so I'm going to hand this over to the guy who I'm sharing the account with to see if he can make any fixes. He's a computer wiz so I'm sure he'll be able to figure out the problem. I'll also forward him your advice just in case he can't find the problem. If all else fails I might just let Bregt or you have a peek around my account.

Thanks for all of your help and time! I really appreciate it!

-Erik-

You're our computer expert Erik. I wouldn't be able to help you

I bit the bullet and spent the money on the extra space. While you have far more data, I must contend with the sounds clips. It seemed the right thing to do.
Tom

You slacker!

No, it's not hosted at wordpress, it's standalone. I don't really understand it myself either but my hosting package entitles me to 25 300mb sql databases, and I use one of those for Wordpress (it's theoretically possible to split it across more than one but that's far beyond my capability). Quite why I can have 25 300Mb databases but not one larger one I have no idea.

I have actually worked out why I am using 300Mb - given the images are not held within the database, this seemed hard to believe. But it's because my two "list of reviews" pages (one indexed by title, one by composer) have been set to "keep old versions", every time I've added a review to the pages, a further archive copy has been generated and stored in the database, and those two pages are pretty big.

I've deleted all the archive copies - which made up over 200Mb - but this has revealed an extremely frustrating new issue, which is that MySQL (which is what I'm forced to use by my host) does not ever "release space" (I don't know the technical term) - when you delete something from the database, it just reserves whatever space it was using for future use. So even though I've deleted over 200Mb from it, the database size is still 300.3Mb and so still won't let me add anything to it. There is no easy way around this.

I've asked the host provider for technical support but they've told me they can't help because the problem's with an open source application I'm using and nothing to do with them.

Aaargh!

Sounds like the host is not much of a provider.

I just read his review for Gears of War

Glad you worked it out James. I've been relatively happy with Wordpress especially given the fact that I can now offer audio clips.
Tom

I'm a word press fan having used them for the past seven years and having a modicum of trouble with them. There are a large amount of themes that are free and as long as you don't require audio or video capability you get gigs of space for free as well. You're allowed to put up photos at no additional cost as well. I ended up purchasing the book word press for dummies and I found it to be extremely helpful. I could help you along the way if you wish.
Tom