How to Fix a Broken WordPress Database

1. Log in to the cPanel interface offered by your Web-hosting provider. The cPanel interface is one of the most ubiquitous management interfaces for Web-hosting customers, so chances are this is what your provider uses. If your provider uses an alternative to cPanel, contact customer support and ask how to access your site administrative options.
2. Connect to your database using the PHPmyAdmin interface. PHPmyAdmin is a standard administrator interface for managing databases graphically, and it is offered by a majority of hosting providers. If your provider does not offer PHPmyAdmin, contact them for a recommended alternative.

3. Select your WordPress database from the left column of the PHPmyAdmin interface. You will need to know which one of the databases is your WordPress database, but typically, a WordPress database will contain the initials 'wp' somewhere in the name. If you have any doubts, the WordPress database name for your site is contained within the 'wp-config.php' file, which by default is found in the base directory of your WordPress installation.
4. Look in the main window of the PHPmyAdmin interface, just below the list of tables, for a link that reads 'Check tables having overhead.' Click this link and then select the 'Repair table' option from the 'With selected' drop-down menu just to the left.
5. Verify to ensure that the message, 'Your SQL query has been executed successfully' is returned after you repair the tables. Also, check to see if your WordPress blog is functioning as expected after this repair.

How to Directly Upload a Picture to Your Wordpress Blog From the iPhone

Upload from Blog
1. Log into your WordPress blog on the computer.
2. Connect your iPhone to the computer. Disregard iTunes if it launches.

3. Click 'Add New' under Posts or Pages in your blog's left sidebar to create a fresh entry. Alternatively, select 'Posts' or 'Pages' to select an existing entry that you can now update with a picture.
4. Click the 'Add an Image' icon in the main 'Add New Post (or Page)' pane. The icon looks like a partially shaded rectangle, right next to the 'Upload/Insert' label that's immediately above the message box.
5. Click the 'From Computer' tab, followed by 'Select Files.' Navigate to your iPhone's name and then click on it to view the images within your device.
6. Click on your desired image. Edit the picture, its description and URL link, as needed. Specify the picture's alignment and size, and then click 'Insert into Post' or 'Use as Featured Image.' Your picture uploads directly from your iPhone to your blog entry as specified.
Upload from iPhone
7. Tap 'App Store' on your home screen and then 'Search' for the 'WordPress' app by Automattic. Install the free app on your device.
8. Tap the 'WordPress' app. Select either 'Add blog hosted at WordPress.com' or 'Add self-hosted WordPress blog,' whichever is applicable. Enter your username, password and your blog's URL. Then tap 'Save' on the upper right.
9. Tap 'Quick Photo' on the bottom of the blog index that opens up. Your 'Camera' app launches for you to snap a shot. If you are unhappy with the picture, tap 'Retake;' otherwise, tap 'Use.' Type a post message to accompany your picture and then tap 'Publish' on the upper right. Your picture uploads directly to the blog from your iPhone
10. Upload an existing iPhone picture instead. Tap on your blog's name, followed by 'Posts' or 'Pages' at the bottom. Select a past blog entry that you'd like to update with a picture, or tap the 'New Entry' icon on the upper right to create a new post.
11. Tap 'Photo' on the lower right and select 'Add Photo from Library.' Choose an image from your iPhone's 'Camera Roll' or photo albums. Set the image's size and then tap the 'Pen' icon to the left to add an accompanying message. Tap 'Publish' on the upper right to upload both picture and message directly from your iPhone to your WordPress blog.

How to Import Large Wordpress XML Files to WordPress

1. Open a new Notepad file.
2. Cut and paste the following code into the Notepad:#set max upload file sizephp_value upload_max_filesize 00M#set max post sizephp_value post_max_size 00M

3. Change the '00' in the code to how much you need to accommodate your file size. For example, if you have a 20 MB file, change the 00 to read 25 or 30.
4. Save the Notepad as a file named '.htaccess.' Click 'File,' then click 'Save.' Type '.htaccess' into the file name box. Click 'Save.'
5. Upload the '.htaccess' file that you just created to the root directory of your server, using your FTP program. The procedure for uploading a file differs from program to program, but in general you would drag a file within the FTP program from your local computer to the root directory on the server.
6. Retry importing your XML file.

How to Upload Files to WordPress With an FTP

1. Download and install a free FTP client if you don't already have one. These small programs connect to your Web host and allow you to transfer files back and forth from your computer. Check out FileZilla, Cyberduck, WinSCP or gFTP, for just a few free examples.
2. Launch the client and start a new connection. Look for a 'New Connection...' option in the File menu. Many clients have a connection window that automatically pops up when you open the program. The window has blank boxes in which you enter login information.

3. Enter the username and password you set up with your Web hosting provider. You'll also enter 'Host Name,' which is usually your domain name, but some Web hosts may use a different FTP address. Check with your hosting company if you're not sure. Click 'Enter,' 'Connect' or similarly named button to log in; whichever the FTP client requests.
4. Wait until you see files in the window; this means you've successfully logged in. If you don't see your WordPress folders, double-click the 'Public' folder to see all your public files. When you set up your website, you may have put your WordPress files in a folder called 'blog' or something similar. If so, double-click to open that file.
5. Open the WordPress folder you want to upload to. In most cases, you'll be uploading to the 'wp-content' folder. Your plugins, themes and uploads are housed in separate folders there. Put your files in the right folders or you won't see them when you get back to your WordPress Dashboard.
6. Upload the files using the 'Put' button or drag and drop files from your computer to the server if your client supports that feature. When all your files are uploaded, click the disconnect icon or close the FTP program to end the session.

WordPress: How to Alternate Row Colors

1. Open the 'header.php' file of your WordPress theme and look for '
' between your
and
tags. Add this code above the wp_head() function:
If your theme includes a
tag referencing the jQuery library, remove the entire
tag. WordPress comes with jQuery already installed.
2. Find the
and
tags between your
tags. This set of
tags does not include the 'src' attribute because it contains code embedded into the 'header.php' file. If your theme does not have these tags, add them. Add this code between the
tags like this:
jQuery(document).ready(function() {jQuery('.alternate:even tr').addClass('alt');});
Every other
tag in a table with a class name of 'alternate' gets the 'alt' class name. You can switch 'even' to 'odd' if desired.

3. Open the 'style.css' file of your WordPress theme and add this CSS code:.alternate .alt {background: color;}Change 'color' to the name of a color or its hexadecimal value. This CSS code sets a background color to every tag with a class name of 'alt' if that tag is nested within another tag given a class name of 'alternate.'

How to Create New Categories in WordPress

1. Go to wordpress.com.
2. Log in.

3. Go to 'Dashboard.'
4. Click on the 'Manage' tab.
5. Click on the 'Categories' tab.
6. Click on the '(add new)' link next to 'Categories' or fill in the new category information at the bottom of the page.

How to Update the OpenHook WordPress Plugin

1. Log into your WordPress account.
2. Click 'Updates' to open a list of plugins that need updating.

3. Click the check box next to 'Thesis OpenHook' and then click 'Update Plugins.' When the update is finished, you will see a 'Plugin updated successfully' message.

How to Publish to WordPress From Gmail

1. Log into your website's WordPress dashboard.
2. Click on the 'Settings' button on the menu that is on the left side of the screen. Select the 'Writing' link.

3. Click the 'Post via e-mail' link. You will be presented with three random strings. Choose one of the strings and highlight it with your cursor. Press the 'Ctrl' and 'C' keys simultaneously to copy the string.
4. Open a new browser tab. Type www.gmail.com in the address bar and press the 'Enter' key.
5. Click on the 'Create an account' button on the right side of the screen.
6. Fill in all of the information that is requested. Look for the 'Desired Login Name' section and place your cursor in the box. Right-click in the box and select 'Paste.' Click the 'I accept. Create my account' button to accept the terms of service.
7. Return to your website's WordPress tab. Enter your new Gmail web address and password. Enter 'pop.gmail.com' in the 'Mail Server' box and enter '995' in the 'Port' box. Click the 'Save Changes' button at the bottom of the page.
8. Send an email to the newly created Gmail account. This will automatically create a post on your website.
9. Type 'http://example.com/installdir/wp-mail.php' into your browser and hit the 'Enter' key right after you send an email to your Gmail account for manual browser activation. Repeat this step each time that you post to WordPress via email.

How to Stop a Missed Schedule on WordPress

1. Log into your WordPress blog.
2. Click 'Plugins' in the menu on the left side of the screen, then click 'Add New.'

3. Type 'missed schedule fix' in the search box, then press 'Enter.'
4. Click the 'Install Now' link under the 'WP Missed Schedule Fix Future Posts Scheduled Failed' plugin.
5. Click 'OK' to confirm the installation, then click 'Activate Now.' The plugin automatically activates and scans your WordPress database every 5 minutes, correctly re-posting posts that failed to schedule on your blog.

How Do I Enable RSS for My Wordpress Blog?

1. Log into your WordPress blog's admin page.
2. Click the 'Settings' menu and select 'Reading.'

3. Enter a numerical value greater than zero in the field next to 'Syndication Feeds Show the Most Recent.'
4. Type 'UTF-8' in the 'Encoding for Pages and Feeds' field, if there is a different value in it.
5. Click 'Save Changes.'

How to Archive a WordPress Blog to HTML Static Files

1. Log in to your WordPress administration area. Click 'Plugins' from the main menu bar on the left and then click 'Add New.' Type 'Really Static' into the text box in the center of the screen and then click the 'Search Plugins' button.
2. Locate 'Really Static' in the search results and then click 'Install Now' followed by 'Activate Plugin' after the installation is complete.

3. Log in to your FTP account for the WordPress site and navigate to http://yourbloglocation/static, replacing yourbloglocation with your own WordPress URL. This is where all your static HTML files are located. You can now either download them or pass out their links to anyone you wish to access the static portion of your site. Every time you update your blog, the static files will be automatically updated; if you want an archive of your blog as it is now you'll have to download the files before making any updates.

How to Change the Primary Domain in WordPress

1. Type the address of your WordPress blog in a Web browser, adding 'wp-admin' to the end to view the login page. Type your user name and password to proceed to the Dashboard.
2. Click 'Settings' on the left side of the page.

3. Type the new domain of your WordPress blog in the 'WordPress address (URL)' field.
4. Type the location of your WordPress system files in the 'Site address' field. Unless you have manually moved the system files to a new folder, the contents of the 'Site address' field should be the same as in the 'WordPress address (URL)' field.
5. Click the 'Save Changes' button.

How to Hide the Sidebar Title in WordPress

1. Log in to the WordPress dashboard and navigate to 'Appearance.' Click 'Widgets' under 'Appearance' and locate the sidebar you wish to edit. Click on the sidebar's name to expand it and view its widgets. Expand a widget by clicking on it to see its options. If the widget has a 'title' option, you can delete the title and click 'Save' on the widget to remove its title.
2. Click the 'Editor' link under 'Appearance' and select the sidebar.php file from under the 'Templates' header on the right side. Find the sidebar title -- usually wrapped in '
' or '
' tags -- and add the 'style' attribute within the first tag. Set the value of 'style' to 'display: none' to hide the header. Your sidebar title code will look similar to this:
Sidebar Title
Save the file by clicking the blue button at the bottom of the screen.

3. Select the functions.php file from the list under 'Templates' on the right side of the 'Edit Themes' screen. Locate the sidebar registration code, which starts with this line:if (function_esixts'register_sidebar')) {On the line that begins with 'before_title,' add the 'style' attribute to the HTML tag and make its value 'display: none'. The resulting code will look like this:'before_title' => '
',Save the file to finish editing.

How to Make a WordPress Website

1. Log into your hosting account. Click 'Hosting.'
2. Under the Hosting section, find 'Applications.' Click 'WordPress' found under 'Content Management Systems' or 'Blogs.' Click 'Install.'

3. Select the domain you want to use for the WordPress account and type the appropriate information in the fields, including a database name, user name, password and folder location where the WordPress files will be stored. Type an administrator name and password to use with the WordPress account.
4. Click 'Install.' Wait for the WordPress installation to complete.
5. Visit your domain, such as www.mysite.com. Click 'Login' in the bottom right of your new WordPress site.
6. Enter the administrator user name and password you created during installation.
7. Click on 'Appearance' after logging in. Click 'Themes.'
8. Search for a new theme for your WordPress site if you don't like the current theme. Click 'Activate' underneath a new theme.
9. Visit your domain again to see your new WordPress site. If you are satisfied with the new theme, you have successfully installed and created a WordPress site. Repeat Steps 6 and 7 if you want to test additional themes.

How to Teach an Online Course using WordPress

1. Develop your content for the course. You can follow the instructions in my related article, How to Develop a Training Course (link in Resources below) or follow your own template for curriculum design. It is important to create the entire course in a word processing program first. The entire course will consist of reading assignments, links to Websites, discussion questions, detailed instructions for assignments and instructions for the instructor on how and when to post various components of the course.
2. Open a new blog on WordPress.com (link in resources below) or other free blog hosting site. Create the first page of the blog. This will be the landing page for your students so include the course description here as well as instructions about how to access the remainder of the course. The content on this page is considered to be static, it should not change after the course starts.

3. When you are on the editing site for this first page there are some things to remember to do:
1.Password protect the page. This is to make sure that no-one can access the site without your permission (and without paying tuition).
2.Turn off the comments part of the page. You do not want students to comment here. You want to contain the comments in specific pages set up for discussion.
3.Post your photo and contact information on this first page, which is usually called the Home page of the blog.
4. Start a new page for the content of the first section of the class. Title this page something like 'Section One.' This is where you will post the content information you created in your course template in Step One. It should include a description of the session, the purpose, the objective and the deliverables which includes the activities and assessments. This is also a static page, so disable the comments section and password protect the page as well. You can set either the same password as for the home page or a different one. See tips below to determine which way will work best for you.
5. Start a new, again static, page so you can post any reading material or lectures you have created for the course. You can title this page Course Notes or Course Links if you post links to Websites you want the students to visit for the session. Turn off the comments on this page as well, as you are simply presenting material for the students to access. WordPress allows you to set a hierarchy for presenting the pages, so set this page with the previous page (Section One) as its parent page. That way this page will not show up on the top menu bar, but it will appear under the Section One page in the list of pages in one of the side columns. (see tips below)
6. Set up your discussion question pages. Use one new page for each discussion question and leave the comments area open. This is where the action of the class will be. Set each discussion page with the appropriate Section page as its parent so it only appears in the list of pages under the appropriate section. Title each page with the number of the Discussion Question (DQ1, DQ2, etc.) Your students will be able to easily navigate the different areas of the course this way. Set a password for every page, using the same one as the parent page. This will allow students to move around in each section without having to re-enter passwords.
7. Set up one final page, this one without a parent page so it will appear in the top menu bar. Title this one Introductions or Intros and Chat. This is another discussion thread but one that can be accessed anytime during the course, so be sure to use the same password as on the home page. Post a note asking students to introduce themselves and let them know that this is the area where they can chat with their classmates about any off-topic subjects just as if they were meeting in the hall before class. Post your own short introduction on this page so students can get to know you.
8. Now, you are ready to teach your class. Set your tuition, advertise the course, and wait for the students to come. (If you build it, they will come!)

How to Change the Password in Your WordPress Blogs

1. Navigate to the login page for your WordPress website by appending '/wp-admin' to the domain name in your Web browser, such as 'www.example.com/wp-admin.' Enter your user name and password to proceed to the Dashboard page.
2. Click 'Users' on the left side of the page.

3. Click your user name (usually 'admin').
4. Scroll down to the 'New Password' section, and type the new password that you would like to use. Type the password a second time in the field below to confirm that you entered it correctly.
5. Click 'Update Profile.'

How to Reformat Pages in a WordPress Blog

1. Sign in to WordPress. Scroll down the Dashboard until you reach the Appearance pane, then click 'Editor.'
2. Choose 'Stylesheet.css' from the list of theme files that runs down the right side of the screen, if it isn't open by default.

3. Scroll through the stylesheet until you locate the div that corresponds with pages. The specific name for this div varies depending on the theme, but is usually some variant of post-content or simply content. Make formatting changes as necessary and click 'Save.'
4. Open the blog in a new Web browser window or tab to verify the changes meet your expectations. Log out of the'Dashboard.

How to Set Anchor Text in WordPress

1. Log in to your WordPress account by typing the name of your site in a browser window and entering '/wp-admin' at the end of the address. For example, if your website is 'www.site.com,' you would enter 'http://www.site.com/wp-admin.' A login page for your site automatically appears.
2. Click the 'Posts' or 'Pages' link on the left side to access the content where you want to set anchor text. Both of these options are present all the time. Hover your mouse over the desired title, and then click the 'Edit' link that appears underneath.

3. Enter the content you want to appear as the link in the text box that displays. Click and drag your mouse over the entry to highlight it.
4. Click the 'Visual' tab on top of the text box, and then click the 'chain link' icon to bring up the dialog window. Enter the desired address in the 'URL' text field, and then type a link name in the 'Title' field to provide the description that appears when a visitor hovers her mouse over the link. Alternately, click the arrow next to the 'Or link to existing content' entry to link to existing content on your WordPress site.
5. Click the 'Add Link' button followed by the 'Preview Changes' button to test your anchor text. When you are ready, click the 'Update' button to publish your work.

How to customize Wordpress Easily

1. You installed Wordpress. What next? Find a template! Head over to wordpress.org/extend/themes/ and take a look. You have lots of templates there that can be customized later without you having and design/coding experience.So choose a template for your blog. Then upload it. That's the first step. Now, let's go further with step 2.
2. Let's put some Wordpress plugins (can be found at wordpress.org/extend/plugins/). But which ones are the best for your site?First, install some SEO (search engine optimization) plugins that can help you get more visitors from the search engines (Google, Yahoo, Live.) You have some lists of SEO plugins in the resources section below on this page.Tip: Don't over-obsess with plugins. I know they can be great enhancers of your blog but focus 80% of your time on what truly matters...the content. Content is what gets readers.

3. After playing around with themes and plugins you will want to customize them to suit your needs. Fortunately that's easy to do.If you know CSS customizing your Wordpress themes will be a breeze. So I recommend you learn some basic CSS (you have a great tutorial on w3schools.com.)Also if you know how to code in PHP that would be great in order to customize plugins.But wait, wait...I lied to you a little. These days most of the plugins and themes can be customized easily in Wordpress alone. But for even enhanced functionality knowing CSS and PHP is great but not mandatory.
4. Here's a great tip if you need help in customizing a theme or plugin on your blog: Ask the theme owner! I was surprised when I found that most owners respond very fast when I ask for help regarding their creations.But please...if the answer is available using simple Google search then the chances for you getting a response are smaller. So first do a search on your problem before asking for an advice.
5. Don't add some customizations that aren't needed or won't benefit your visitors nor you (like adding a custom admin login page, what's the point in that?.) Before adding a new functionality to your blog ask yourself: Is this going to help my visitors or is only going to make me look cooler? The pros are doing the first thing while the noobs are more doing the second so...you decide.

How to Add a Lightbox Effect to WordPress

1. Log into your WordPress dashboard. Click 'Plugins.'
2. Click 'Add New.' Type 'Lightbox' into the box and click 'Search.'

3. Click on 'Install Now' next to 'Simple Lightbox.' Click on 'Activate Plugin.'
4. Click 'Settings' beneath 'Simple Lightbox.' Check the box next to 'Enable Lightbox Functionality.'
5. Review the options pane to select the options you want for the lightbox. For example, if you want the lightbox to appear on archive pages with images, select 'Enable on Archive Pages.' If you want to enable it on pages, select 'Enable on Pages.'

How to Have Autostart Music Play When They Enter Your WordPress Blog

1. Click the 'Plugins' section on the left side of the WordPress dashboard to expand it and then click 'Add New.'
2. Enter 'WPaudio MP3 Player' in the search box and press 'Enter.'

3. Click 'Install Now' under 'WPaudio MP3 Player' on the result page. Answer the prompt by clicking 'OK' and then click 'Activate Plugin' to finish the installation.
4. Open the 'Settings' menu on the left side of the dashboard and click 'WPaudio.'
5. Click the 'Convert all MP3 links' check box if you would like the WPaudio plugin to display a sound player every time you like to an MP3 file. This setting is retroactive for your previous WordPress posts.
6. Remove the check from the 'Allow WPaudio notification' box if you do not want the creator of the plugin to be informed when you use it to play an MP3 file.
7. Click the 'Save Changes' button.
8. Create a new WordPress post, or open the 'Posts' menu and click 'Edit' under the name of the post that you want to play music in.
9. Place the cursor at the location where you would like the embedded sound player to appear in your post.
10. Type '[wpaudio URL='http://website.com/song.mp3' text='Song Name' autoplay='1']' in the line of text, where 'website.com' is the location of the MP3 file and 'song.mp3' is the file name. You can enter anything you like after 'text=,' such as the name of the artist, album and song.
11. Save or update the post. Visitors who view the post will see the embedded audio player, and the player will begin playing the recording automatically. If the post is currently on the front page of your website and you have not defined a custom excerpt for the post, visitors will also hear the recording when viewing the front page of your website.

How to Make a Facebook Connect for WordPress

Register Facebook Application
1. Create a new application on the Facebook Developers site (note that you will have to verify your Facebook account to do this, if you have not already done so). Enter your blog name for the site name and your blog URL for the site URL. Set the locale, then click 'Create app.'
2. Enter the text in the Security Check box on the next screen to proceed with the registration.

3. Note the app name, app URL, app ID and app secret provided.
Install Plugin
4. Sign into the WordPress dashboard as the 'admin' user.
5. Download and install a plugin that will create a Facebook Connect.
6. Click Plugins in the vertical menu on the left. Locate the plugin you installed and click 'Activate' under its name.
7. Navigate to the setup options for the plugin you installed. For example, click Simple Facebook Connect under Settings.
8. Copy and paste the values for the app name, app URL, app ID and app secret into the appropriate setup fields for the plugin. Configure the remaining plugin options according to the amount of functionality you want to provide through Facebook Connect.

How to Have Two WordPress Posts on the Same Page

Change Settings for All Pages
1. Log in to your WordPress admin area. Click 'General' from the menu bar at the left side of the screen, then click 'Reading.' This section controls various settings relating to how your visitors read the content of your site.
2. Navigate to the 'Blog pages show at most' option. In the text box next to it, replace whatever number is currently listed with the number '2' (without quotes). This will show two blog posts in all archive and index pages, assuming there are two or more posts to display. Navigation links will also appear, allowing your visitors to browse through older posts, two at a time. Click 'Save Changes' when you're done.

3. You can display these posts in full, or just a snippet. By default, full posts are displayed, so if this is what you want, you don't have to take any further action. If you want excerpts, go to each of your posts and access the HTML editing mode. Type '
' (without quotes) where you want the excerpt to end. On your blog, a 'More...' link will appear, offering the reader the opportunity to read the full post.
Change Settings for Individual Pages
4. Log into WordPress, then click 'Plugins,' followed by 'Add New.'
5. Type 'cbnet Different Posts Per Page' (without quotes) in the Search box and press 'Enter.' Find the plugin from the search results list, and then click 'Install Now,' located just beneath it. When the plugin has installed, click 'Activate Plugin.'
6. Click 'DiffPostsPerPage,' which appears under the 'Settings' menu. When the options screen loads up, you'll be able to customize the pages as you please. Check the box of the page you want to edit, then type '2' (without quotes) in the relevant column. Click 'Save All' when done.

How to Change the Title in a WordPress Template

1. Open your browser and visit the main WordPress website (see References).
2. Type your WordPress username into the 'Username' box, your password into the 'Password' box and click 'Log In' to sign into your account.

3. Click 'My Blog,' followed by 'Dashboard' from the top of the screen.
4. Click 'Posts' from the 'Posts' box on the left side of the screen.
5. Click the 'Edit' button beneath the listing for the post you want to edit. Change the title of the post by changing the information in the 'Title' box on screen. Click 'Update' to finish changing the title of your WordPress post.

How to Update WordPress 3.0

1. Back up the WordPress database that manages your website. A common method is to log in to your Web host account, access the cPanel and click the 'Download a MySQL Database Backup' link to obtain the gzip (gz) file. The backup process saves all of your posts in the event you need to go back to a previous Wordpress version.
2. Log in to your WordPress account and click the 'Plugins' link on the left. Click the 'Plugin' box to check all of your currently installed plugins, click the 'Bulk Actions' arrow, select the 'Deactivate' option and then click the 'Apply' button. Deactivating your plugins is an optional step, but it helps prevent any unnecessary problems during the WordPress 3.0 upgrade.

3. Click the 'Dashboard' link on the left and then click the heading that reads 'WordPress 3.x' is available! Please update now.' Alternately, click the 'Updates' link under the 'Dashboard' heading on the left.
4. Click the 'Update Automatically' button that displays. This action prompts a script to run and when finished, displays a message that your WordPress 3.x version was installed successfully.