If you are getting all comments sent to moderation when they should not, it's probably your spam words list in Administration Panel->Options -> Discussion. It probably has either a single character, OR a blank line OR extra whitespace. Take those out.
Right click in the Spam Words box, Select All then Copy and paste it into Notepad to check it.
With spam plugins adding to that list, it's not easy to check for odd data, and it's easy to miss multiple blank lines. This way makes it easier.
Check it carefully :)
If a WordPress WXR file, an XML file exported from WordPress, is too large to import, there are several things you might try to overcome that limit.
1. Always have the header
including all info like category, tags, etc to just before the first <item>
2. Always have the footer
3. In between, add the posts start with <item> end with </item> and check to see whether the XML file you're creating is less than or equal to 2MB. You'll get the hang of it.
4. As always, before importing the new XML's, backup the database of the blog you are importing the XML files to and might as well export XML file of that blog as well for good measure.
To import links (also called blogroll) from another WordPress blog is very easy. This assumes you have an 'old' blog where the links currently are stored, and a new blog where you want to import the links.
Visit http://oldblog.com/wp-links-opml.php. Then use SAVE AS to save the output, then use Administration > Tools > Import > Blogroll to import the file you saved.
Use Administration > Tools > Import > Blogroll at your new blog, and enter http://www.oldblog.com/wp-links-opml.php in the Specify an OPML URL: field.
WordPress requires access to a MySQL database database to store information. So you need a database.
You can create a new database if:
It is not essential to create a new database for each WordPress installation.
Symptoms: You cannot seem to login after using the right username and password, into your admin account. You get an error message like:
You are not authorized to view this page
You might not have permission to view this
directory or page using the credentials you
supplied. If you believe you should be able
to view this directory or page, please try
to contact the Web site by using any e-mail
address or phone number that may be listed
on the personal.fredsmith.com home page.
You can click Search to look for information
on the Internet. HTTP Error 403 - Forbidden''
Solution: If your account is hosted on a Windows server, it could be a problem with the Directory Indexes. The default configuration of the server is to load index.htm, index.html, default.htm, default.html, default.asp files.
WordPress is done in PHP so the default page is index.php. Now, this is not part of the default configuration so we need to add it. To do this, you need to click on Web Options in the Control Panel. Then scroll down to the Directory Indexes section to add index.php to the Directory Indexes.
If necessary, contact your web host for support in this matter.