How to Require Attendees to Agree to a Policy Before Being Allowed to Register

At times you may want potential attendees to agree to a certain policy, certain terms and conditions, or even a refund policy, before allowing them to register for an event. This tutorial will show you how to use the custom registration form questions to create a checkbox for attendees/registrants to select before they can register.

The video is best viewed in high-resolution.


To Get Started:

1) Create a WordPress page and add your policy to it.

You don’t want to add all the policy text to the registration page (although you could if you added it to a Group Description). Instead we’re just going to link to that page from the question on the registration page. That way you can maintain your policy without worrying about the effect on the registration process.

2) Create a custom question which asks the attendees/registrants to agree to the policy
Terms and Conditions Policy Question


Question fields:

  • Question: Title the question something similar to: “I agree to the Policy”
      • Add a hyperlink from the question to the policy page by adding a HTML hyperlink. See first example below.
      • (optional) If you want to have the link to the policy page stand out a little, you can add a <strong> tag to the text

  • Type: Select the type of question you want to display. We recommend a Checkbox so that it requires the attendee to activate and agree to the question.
  • Values: You want the value/answer displayed to the user to be something similar to “Yes” or “Yes, I agree to the Policy” so they know they are specifically agreeing to the question.
    • (Optional) You can let someone answer “no” if you’d prefer.
  • Required: You can decide to force attendees to answer this question before they are allowed to finish the registration form.
  • Admin View Only: No
  • Required Text: The text you want displayed if they do not answer the question


3) Create or add the question to a question group

Question Group Editor

In order for a question to be added to an event, it must be included in a question group. The question can be added to an existing question group or you can create a new question group.
Add group to event

4) Add the question group to an event

Once you’ve added the question to a question group, you’ll need to activate that question group for an event. Update the event to apply the question group.

After updating your event you’ll then see that the question group is now added to the registration page and the text of the  Terms and Conditions Policy is now a hyperlink to the policy page.

Agree to Terms

Posted in | Comments Off on How to Require Attendees to Agree to a Policy Before Being Allowed to Register

How To Select a Website Developer

Selecting a website developer can be difficult, especially if you are not sure how to effectively grade a developers skills and abilities. This guide will help.

 

This article will redirect to https://eventespresso.com/support/how-to-select-a-developer/

Posted in | Comments Off on How To Select a Website Developer

Pre-Release Channel Guide

Terminology:

Throughout this document we refer to “stable” release vs. “pre-release”. There are some add-ons that we currently have on the “stable” release channel that are available to customers that are labelled beta or alpha. Although they are in the “stable” release channel we still consider them to be experimental products. These products include:

Event Espresso 4:

  • EE4 UTF8 Template Variation
  • EE4 4.3.2 for PHP 5.2 Customers

 

Event Espresso 3:

  • Volume Discounting add-on
  • Attendee Batch Import Tool add-on
  • Price Modifier add-on
  • Attendee Reassignment add-on
  • Front-end Event Manager add-on
  • Social Coupons/Voucher (Groupon) Import Tool add-on


What is the pre-release channel?

The pre-release channel is a way for customers to gain access to products that are at an “alpha” or “beta” stage of release.

We’ve created this channel so that we can get feedback from customers on these products/releases and make sure any bugs we’ve missed are caught before we upgrade the code to our stable channel.

The pre-release channel is also a GREAT way for our customers to discover new features that are coming in future releases and to provide feedback on their implementation and understand how they will affect their current usage of the Event Espresso family of products.

What the pre-release channel is not!

The pre-release channel contains products that are close to a stable version but are not recommended for use on a production server.

More than likely, there will be bugs still existing in versions of plugins/add-ons pushed out via this channel and we are grateful for the bug reports that come in for users who do test these version as it helps ensure a far better product once we upgrade the product and release it as a stable version.

Use pre-release add ons on a live production server at your own risk.

How to opt-in and join the pre-release channel

On your user profile, you will see a checkbox under the list of plugins in your downloads area – “Join the Pre Release Channel?”

Pre-Release Toggle

Pre-Release Toggle

When you check this box there will be a popup appear that gives you some instructions that you are agreeing to when you click the “I Agree – Sign Me Up!” button.

pre release channel confirm

Press “I Agree – Sign Me Up!”

After clicking the “I Agree – Sign Me Up” button, the page will reload and you will see a new box below your Download’s box that shows all the pre-release products you have access to.

Congratulations, you are now a part of the pre-release channel!

pre release channel downloads

Pre-release channel downloads

Using pre-release products

Pre-release products work the same as regular stable products when it comes to installing/using them on your server. However, there are a few important things to note:

  • Remember, we HIGHLY advise you only use pre-release channel products on a development or staging server. Do NOT use them on a production server.
  • A good thing to do in testing is to migrate your database from a production server to your staging/development server so you can test with the same data on live. This will more accurately reproduce real world use and you can spot bugs that would appear if the product was on your live server.
  • The document link in the pre-release channel box points to the dedicated forum for that pre-release product and we ask that all bug reports be posted in the appropriate forum. That way we can be sure that our developers get the info they need. Please search through any existing topics in that forum to see if your bug is already posted and then post there if you have new information to report. Post new topics if there isn’t already a report for your issue.
  • We ONLY fix bugs on pre-release versions. Please do not request any new features for pre-release products. When we push out a pre-release product we have put a feature-freeze on that product so we can focus on fixing bugs and getting it to our customers as a stable product.
  • Automatic updates WILL work with pre-release products and there may be times where we release updates to those products before they reach a stable version  Make sure you are using the latest pre-release version of the product when you are testing (you can see notifications on your WordPress plugins page). To enable automatic updates, you need to use your license key found on your user profile. Note: We’ve removed the domain restrictions for pre-release products using your license key. So it is possible to have multiple copies of the pre-release product on multiple domains without experiencing any license key issues. However, if you try to install a stable version of the product on multiple domains you will still experience the normal multiple domains restriction message.

How come I’m not seeing a product I know someone else has access to in the pre-release channel?

The pre-release channel products you have access to are tied to a stable product you have access to. So, for instance, if we have a pre-release version of the Seating Chart Add-on available but you don’t have access to the current stable release of Seating Chart Add-on then you won’t have access to the pre-release version.

Posted in | Comments Off on Pre-Release Channel Guide

Payment Status in EE3

This guide explains the payment statuses in Event Espresso 3.

Incomplete
The default payment status in Event Espresso 3 is Incomplete. While Incomplete is set as the default, all attendee information is recorded when they register, but incomplete registrations do not count against the total number of available spaces. When an IPN message is sent from the payment gateway or the payment status for that attendee is updated manually, the payment status changes from incomplete to Complete. If you have no credit card processing gateway active and are using the Invoice gateway, the status will change to Pending when the user downloads the invoice.

Pending
Pending means the attendee has not yet paid, but they do have a space reserved for them in the event. When a user downloads an invoice, their payment status changes from Incomplete to Pending, reserving a space for them but not indicating that they have paid (since that would need to be recorded manually). The registrations with this status of payment Pending count toward the quantity limits of your event.

Complete
This means a payment notification has been received from the payment gateway, or the attendee has been marked as paid manually from the back-end. The registrations with this status of Complete does count toward the quantity limits of your event.

Posted in | Comments Off on Payment Status in EE3

A Skydiving Business

This use case is based on creating a Sky Diving club, focused on providing new and experienced jumpers the experience of throwing themselves out of a plane from thousands of feet up with nothing but a fancy table cloth strapped to their backs!

The use case will guide you through the steps of setting up a basic site based around sky diving: from setting up the information we will need, changing appropriate settings right through to creating tickets and events. The details outlined here are bare bones, designed to be used as a spring board for a site, and can quite easily be used for many other event types.

Before We Start

To start with we will need to outline exactly how we are going to layout the events for this site. This will make it easier further down the line and can be referred back to.

Skydiving clubs requirements

  • This skydiving club offers two types of jumps Single and Tandem. Single is only available to logged in members as they need to confirm their jump credentials. Tandem is available to the public.
  • They offer two locations for both types of jumps.
  • Each event will only be able to accommodate 5 people (excluding instructors, pilots etc)
  • Each attendee will be given an E-ticket.
  • If a group books the full 5 places in one go they will get a substantial discount.

To fulfill these requirements, we will need certain plugins:

These are all available via the Business Licence.

Basic Settings

I will assume already you have WordPress installed. Head over to the WordPress Settings menu item, and in the General section change the timezone to match your location (by closest city, not UTC time) and then in the Permalinks section change the links to Postname (this isn’t required but helps with SEO and looks a lot better too).

Go to Plugins > Add New and install the Event Espresso core plugin and the add ons and activate them.

Go to Event Espresso General Settings, check the Organization settings and fill out the basics and hit the save options button.

skydiving activate the plugins

skydiving activate the plugins

skydiving general settings

skydiving general settings

skydiving permalink settings

skydiving permalink settings

Preparation

In order to make sure we have everything ready for when we start to create events, we will need to prepare all the aspects of the plugin, venues, tickets, questions, etc.

Venues

As the skydiving club offers two locations we will need to create them. Go to Venue Manager and add a new venue and fill out the details. Do this as many times as you need, we will create two in this example.

Now that we have our two locations we can move on.

skydiving manage venues

skydiving manage venues


Categories

We will set up a single category for now so that we can apply a discount to it. It is easier to set up a category now than try to retro actively do it when you have many events, plus you can use the categories in other ways, such as separating the events into category based listings.

Click the Category menu and Add new category. All we will add here is the Category name. For the example it will be fivepersondiscount.

skydiving categories

skydiving categories


Discounts

Click the Volume Discount menu and enter some discounts. For this example we will use the following:

  • Discount based on: Number of Registrations
  • Discount Threshold: 5 (the max. number of jumpers)
  • Discount amount: 20
  • Discount Type: Percentage
  • Discount Applied Message: Awesome! You saved money!
  • Discounts apply to: fiverpersondiscount

skydiving volume discount

skydiving volume discount


Questions

We will need to get some extra information beyond the basic name and address for each jumper. In this case it will be for things like illnesses and conditions, jump experience and confirming their acceptance of the terms.

The questions I created were

  • Do you have any known illnesses or medical conditions?
    • Required. Yes or No answer via dropdown.
  • Please list illnesses/conditions if appropriate.
    • Not required. Text area for an open ended answer.
  • What is your jump experience?
    • Required. Radio buttons with various choices.
  • Do you hold a jump permit?
    • Required. Yes or No answer via dropdown.
  • Permit number if applicable.
    •  Not required. Text field.
  • Do you agree to the Terms and Conditions?
    • Required. Single checkbox.

Once these are done we will group them in a Question Group allowing us to add them to an event. Go to Questions Groups, Add New Group and then give the group a name (Jump Questions in this example) and select the questions we just made and click the Add Group button.

If you mess up with the order of your questions, don’t fear, you can simply drag and drop the order in the Questions menu or by editing the questions you can set a manual numerical order, where 0 (zero) will come at the top.

skydiving questions

skydiving questions


Ticket

Let’s create a ticket template that we can use for these events and others beyond that.

Make sure you have the Ticket add on activated and then go to the Ticket Templates menu item. For the moment we will only create a basic ticket, nothing too fancy.

Give the ticket a name and add your logo if you have one, add a few details into the ticket description. These can always be edited later.

Payment Settings

Last thing to set up before we tackle the events themselves, Payment!

In this example we will just use PayPal but you could easily set up with any other payment method from the 25+ gateways we have.


The Events!

OK, so now that all the admin type stuff is done we will concentrate on getting the events created. First off lets have a think about how we want the events structured.

The Tandem jumps and Solo jumps will be provided as separate events, enabling the crew to cater for inexperienced customers and experienced customers who may wish to go higher, separately.

We also need to create the events separately for the 2 venues.

So for now we will create 4 events.

Firstly the Beginner Tandem events. Go to the Event Overview and Add Event.

Add a title and description. Registration dates will start a month or so before the event allowing time for people to sign up, but you can make this as long or as short as necessary. The event is a one day affair so the event start date and end date will be the same. Don’t worry about the registration times, leave those blank, but the event times need to be filled out so the customers know when to show up and when they can expect to start their way home.

We only need one pricing option here, but to make sure that any logged in members don’t get the jump for free, make sure you fill out the member price to the same as the standard price.

We will add a $20 surcharge here to cover the costs of insurance (per head).

Select the appropriate venue, in this first one it will be Jake Garn Airport.

We have no need to use a custom email or create a post so we can skip those.

In the right hand options, we need to fill out some information:

  • Attendee limit: 5 – the max people we will allow on the event.
  • Allow group registrations: Yes – we need this to use the volume discount we set up earlier.
  • Max Group Registrants: 5
  • Additional Attendee Registration Info?: Full registration information – we need all their details and question answers.

Skipping down a bit we need to make sure we have our ticket selected.

This isn’t a Member only event so we can leave that for now and make sure the Event Category is selected (fivepersondiscount in this example) so that we can use the volume discount.

Lastly make sure that the Address Information and Jump Questions are selected for both the Primary and Additional Attendees.

Once these are done, click Submit New Event (top right corner of the page).

skydiving create an event overview

skydiving create an event overview


Ok, onto the next. Rather than type everything out again, we will edit the first event by clicking its name in the Event Overview, and click Duplicate Event in the top right corner.

On the Event Overview you will now see two events. Click the one with the higher ID number (2 in this case) to edit it so we can change the details a bit.

The only things that got changed were the Title (to help differentiate it in the list) and the location to the second venue. You could of course change the description, dates, times, prices etc.

Once done, click Update Event.

Now to create the Solo Jump events.

You can again duplicate an event or feel free to start another from scratch.

I have to manually make these?

What about having to manually create these multiple events of the same details throughout the year? We have that covered too, with the Recurring Events Manager add on.

The main differences with these events is that we will select the option on the right Member only event and mark it Yes. This will limit the events to registered and logged in members. We will also turn off the group registration for these as we need to make sure they are all members.

If you need to go back the the questions and question groups to create a new set of questions solely for the solo jumpers, you can even reuse some of the questions made earlier in the new question group. For this example we will just keep the same ones.

So now we have 4 events, 2 open to the public and 2 only available to members.

skydiving four events made

skydiving four events made


Membership

But how does someone become a member? Well that requires a third party membership/registration program such as S2member or the use of the built in WordPress registration system (http://www.yoursite.com/wp-login.php?action=register)

And this is what the registration page would look like (in Twentyeleven theme, no additional styling).

skydiving registration form

skydiving registration form


Multiple Purchases

What if you wanted people to be able to book more than one jump in one purchase? By using the Multiple Event Registration add-on, you can have the flexibility of an add to cart system.


But what about the ticket that the client will receive  Well we did only create a basic ticket with the default settings, so you can create all sorts of wonderful ticket designs. Here is what our basic ticket looks like, a bit plain, but serviceable.

skydiving ticket

skydiving ticket

Posted in | Comments Off on A Skydiving Business

How to Change Languages

This how to will guide you through changing WordPress (single installation) and Event Espresso to use a language other than US English in the WordPress dashboard and front end of site (for visitors).

Volunteers

Both WordPress and Event Espresso are translated by volunteers. As such translations may not be 100% accurate nor 100% complete. If you would like to help translate or validate a translation for Event Espresso, please contact us via this form. You can find out the current translation level of Event Espresso by checking this page.

Setting up WordPress

WordPress’ Own Guide

WordPress has a detailed guide on translating itself, which can be found here, click on your locale for more instructions.

As of WordPress v4.2 you can now select your site language within Settings -> General, scroll to the bottom and change the Site Language option, this will automatically change the language in use for the site.


Translating Event Espresso

Multi-lingual Sites

At this time Event Espresso does not natively support multi languages (more than one language at the same time) though has been shown to work alongside WPML and qTranslate.


Version 3.1.29.2.P and newer

This version and up needs no further action once WordPress has had the language files installed. The plugin will automatically detect the language WordPress is using and serve the language file for Event Espresso if it exists.

If you are running an older version of Event Espresso, then we recommend updating to the current software. We only support the current versions of Event Espresso.

If you cannot upgrade due to customizations to the core then you will need to visit our translations project on GlotPress and download the correct MO and PO files.

The plugin will automatically create a new directory located at wp-content/uploads/espresso and you will need to create a folder there called “languages’ and upload the languages files you got from Github to that folder.

Once the files are uploaded, as long as WordPress has been updated to accept a new language, Event Espresso will follow suit.

Posted in | Comments Off on How to Change Languages

Troubleshooting Checklist for Event Espresso

WordPress is an amazing open source platform. With that strength comes the possibility of many plugins and themes. These can achieve different goals and are written by different people to wildly different standards.

So when problems strike, the first thing that needs to be done is some basic troubleshooting. This is useful not only for issues with Event Espresso, but any other plugins and themes that work with WordPress.

Check the Version Number of Event Espresso

This step is important because the issue you are seeing may be something that was fixed in a recent update of the software. You can check to see which version of Event Espresso is on your website by viewing the WordPress plugins page. The top of this page displays the current version number of Event Espresso 4. If you need help with updating please see this guide.

Check for a Theme Conflict

You can check if the issue is caused by a conflict or a bug within your theme by previewing the default WordPress theme in the Customizer (Twenty Seventeen at the time of writing).

If you cannot preview the default theme using the Customizer, you can use the Theme Test Drive plugin to test the theme without your visitors being aware.

Check for a Plugin Conflict

Deactivate all the plugins you have with the exception Event Espresso and see if the issue is resolved. If not try the theme option as well.

If the issue is resolved, start activating your plugins, one by one, testing for the problem each time. This systematic approach will help you find the plugin that is causing the issue/conflict. Once the plugin is identified we will be able to examine it in more detail or you can simply keep the plugin deactivated.

We maintain a list of known plugin and theme conflicts that you can check here: https://eventespresso.com/wiki/known-third-party-plugin-theme-conflicts/

Activate WP_DEBUG mode

You can make the following edit to your site’s wp-config.php file. This will log all errors, notices, and warnings to a file called debug.log in the wp-content directory. It will also hide the errors from displaying on screen so they do not interrupt page generation.

// Enable WP_DEBUG mode
define( 'WP_DEBUG', true );
if ( WP_DEBUG ) {
        @ini_set( 'display_errors', 0 );
        define( 'WP_DEBUG_LOG', true );
        define( 'WP_DEBUG_DISPLAY', false );
}

Check for a JavaScript Conflict

Some conflicts with Event Espresso can be related to Javascript where there’s a library that is either being loaded incorrectly, or an old version of a library is being forced to load, or something has stopped JavaScript from running. If you use Chrome or Firefox you can use the developer tools Console to pinpoint any JavaScript errors.

Also read here, for more JavaScript troubleshooting.

Specific error messages and their solutions

Nothing in your event queue is an error message that will display on the registration checkout page if there’s a problem with caching or if the session data gets deleted by a plugin like NextGen Gallery.

You can follow this guide to ensure that Event Espresso’s checkout pages are not served from a cache.

If you use the NextGen Gallery plugin there’s a workaround solution posted here.

The maximum number of inputs on this page has been exceeded is an error message that will display on the event editor page when the server’s max_input_vars limit is exceeded. You can contact your host to ask for instructions for how to raise this limit.

Page not found when viewing an events page. This will happen if the site’s rewrite rules were reset too early or too late in a request. This can be fixed by visiting the site’s Settings → Permalinks page, which will flush the rewrite rules at just the right time.

No configuration section has been provided while attempting to save “_Config” is an error message that will display if the “Event Slug” option in Event Espresso > Events > Templates setting is changed to event. The Event Slug setting must not be changed to event. See also: How to change the event slug for Event Espresso events.

Help Us Help You Troubleshoot your Issue

If you have gone through the steps above and your issue is still occurring, then please open a support ticket in our support forums:

https://eventespresso.com/support/forums/

Please include the following information in your support post:

  • Your version of Event Espresso (e.g. Event Espresso 3 or Event Espresso 4)
  • A brief explanation of the issue
  • Also let us know any steps that you have tried to fix the issue

It will also help to include the site URL (website) and/or some screenshots.

How to take Screenshots

Screenshots are helpful in describing an issue when the site URL can’t be shared or a link to the site is not available (e.g. you are working on the site locally on your computer). Here are tips on how to take screenshots on various platforms:

Mac

To take a screenshot of the entire screen, press the following keys: command + shift + 3
To take a screenshot of the a specific area of the screen, press the following keys: command + shift + 4. Then select the area that you would like to capture.

You can then upload your screenshot to WP Media on your site and then share a link in your support post. Another option is to use a screenshot service such as TinyGrab, Cloudup, MonosnapCloudapp, Snipboard, or an equivalent screenshot sharing service. Then you can share a link in your support post.

Windows

To take a screen of the entire screen, press the following key: prtscn
To take a screen of the current window only, press the following key: alt + prtscn

You can then upload your screenshot to WP Media on your site and then share a link in your support post. Another option is to use a screenshot service such as TinyGrab, MonosnapCloudapp, Snipboard, or an equivalent screenshot sharing service. Then you can share a link in your support post.

iOS (iPad, iPhone) 

To take a screen of the entire screen, press the following on your device: power button + home button

You can then email your screenshot to your email address and / or upload it to a service like Dropbox from your device. Then you can share the screenshot to one of the screenshot sharing services mentioned above for Mac or Windows.

Posted in | Comments Off on Troubleshooting Checklist for Event Espresso

Remove the Second Button on the Confirmation Page

The confirmation page for Event Espresso 3 has two buttons that a user can click to proceed onto the payment page. The reason for this is some peoples details can be rather long, especially when registering additional attendees and providing all their data, so having a button near the bottom ensures that a registrant/attendee can continue registration checkout whether they are viewing information at the top of the page or information below the fold of the page.

However, what if your confirmation page is often short or you simply don’t want the additional button at the bottom of the page?

A simple CSS fix can remove it for you.

/* hide second confirmation button */
input#confirm2.btn_event_form_submit {display:none;}

To apply these new styles, just copy and paste them into the them Customizer, your child theme’s stylesheet or into a plugin like My Custom CSS or Reaktiv CSS Builder. Then save changes.

After applying those changes, you can view the registration process as an attendee and see that the registration page doesn’t have the second button.

If you have other changes you want to make to the Event Espresso templates or layouts, please contact us in the support forums.

Posted in | Comments Off on Remove the Second Button on the Confirmation Page

How To Use iCal ICS files with Google Calendar

With version 3.1.29 we have brought you iCal calendar integration for your events. You can enable this via the Template Settings.

Once this is enabled, users can click the iCal icon or link on your events to download the .ICS file.

This file can then be imported directly into your calendar application.

Here is how to do it with Google Calendars, in case you need to add information for your customers.

1) Go to Template settings and make sure the iCal feature is turned on, and save the settings.

Turn on Ical Feature

Turn on Ical Feature

2) In the event list or the individual event registration page, click the iCal icon to download the .ics file.

Download iCal ics File

Download iCal ics File

3) Log into Google Calendars

4) On the right where it says Other calendars, click the arrow icon and select Import Calendar.

Import ics File Into Google Calendar

Import ics File Into Google Calendar

5) Select choose the file and browse for the downloaded .ics file and open it. Then make sure you have the correct Calendar selected (based on your user account) and click Import.

6) The event will now appear on the calendar based on the event start and end dates.

The Final Result

The Final Result

How to troubleshoot the ICS when the dates are invalid

If the dates are resolving to January 1, 1970 it’s likely that PHP can’t tell the difference between a US and European style date format. One example of a potential ambiguous date is the 8th of July. This could be formatted as 7/8 (US) or 8-7 (European). Note the dash.

An example of an invalid date is 22/7. PHP interprets the slash as meaning it’s a US style date, but there isn’t a 22nd month. If a dash or dot is used, PHP will interpret the date as European style.

You can ensure the dates work correctly by selecting a date format that PHP can disambiguate.

Posted in | Comments Off on How To Use iCal ICS files with Google Calendar

How to Backup your WordPress Site

Whenever changes are made to your site, whether it be updating your theme, a plugin or WordPress core, it is highly recommended to backup your website.

There are two parts to backing up your site: 1) the Database and 2) the Files.

For the most part you will only need to back your database up when updating plugins, but it is recommended to do a full backup (database and files) on a regular basis.

How to Manually Backup Your Database

The best way to backup your database is by using phpMyAdmin from your hosts control panel (cPanel, Plesk, etc). This will enable you to get the entire database.


Using the built in WordPress exporter plugin will only back up the core database. If a plugin – like Event Espresso – uses its own database tables they will not be saved using the export function.

To manually backup your database using phpMyAdmin:

1. Log into your webhost’s control panel and log into phpMyAdmin

2. On the the main menu, either select your database from the list on the left or click the Databases link and select your database from the list that appears.


If you have several databases there and you are not sure which one you need to choose, you can find your WordPress database by looking at the wp-config.php file in your WordPress folder or your server root folder.

select your database

Select your database

3. You will now see a long list to the different tables available. This should contain your Event Espresso tables (prefixed by wp_events) and your general WordPress tables.


The prefix wp_ is a standard one but some hosts may use something else.

4. On the menu at the top click Export. This will show a couple of options and all your tables should be listed on the left.

The options are Quick and Custom. If you know something about databases you can click the Custom and tweak as needed, otherwise leave it as Quick. Below that is a dropdown for your export type, make sure it is on SQL (the default).

Then press the “Go” button. A pop-up will appear asking you to save the SQL file to your computer.

export the sql

Export the SQL file

That’s it, the database is now backed up.


Only the posts and comments and settings are backed up, your images and files (themes, plugins) are not backed up by this method.

Restoring Your Database

OK, so the reason you backup the database is so if something goes wrong you can revert back to a recently saved version. Here’s how to do that.

1. Log back into phpMyAdmin through your webhost’s control panel.

2. Select all the tables in your database, and in the drop down menu (With Selected) at the bottom, select “Drop”, then press “Go” in the bottom right of the screen.

This will delete your database! It is necessary in order to restore the previous backup, but if you are concerned, make sure your backup is valid and uncorrupted before doing this. You can also rename the database to something else and create a new blank database with the same name as the original.

3. On the top menu click “Import”. Under the “File” to Import section click the “Choose File” and select the “SQL” file you previously exported and click “OK”.

import sql file

Import the SQL file


4. Click the “Go” button.

5. Grab a coffee/tea/beverage of your choice.


Reference Material:

http://codex.wordpress.org/WordPress_Backups
http://codex.wordpress.org/Backing_Up_Your_Database


Plugins

If you don’t wish to do this manually there are several free and paid for plugins available that can back up your database for you.

http://wordpress.org/extend/plugins/wp-dbmanager/
http://wordpress.org/extend/plugins/backwpup/
http://ithemes.com/purchase/backupbuddy/

Posted in | Comments Off on How to Backup your WordPress Site

Event Espresso