How to Autoplay Vimeo Video in WordPress

Recently we had a client that wanted to embed autoplay vimeo video in wordpress. When we searched for the code to make the video work we found all kinds of directions on the internet followed by lots of forum posts saying; just do this and just do that. After which there were even more forum posts saying that none of the options work.

This left us scratching our heads and with no other choice but to go through the vimeo site and try to find answers to how an autoplay vimeo video can be inserted. After 15-20 minutes we came across a paragraph that explains the process in text only with no pictures and no how to video! Not the best directions for people who are visual, non-technical or not use to navigating around the vimeo website. So to help out anyone trying to do this very simple process in wordpress or on any other website we decided to write some very simple directions.

Here are step by step directions on how to autoplay vimeo video in wordpress

Embed a vimeo autoplay video in wordpress using the vimeo website.

1. Lets start by going to vimeo.com and selecting any old video to start.
2. Here is the video we used for the example. http://vimeo.com/41261299
3. Next when the page opens you will see a video on the page. On the right you will see a button that says share.
   
4. Click on the share button and you will then see the following page.
   
5. Next on the bottom of the video on the right you will see text that says customize embed options. You will want to click on this link which will bring up the following additional embed vimeo video options.
   
6. Now on the bottom right you will see the autoplay and looping options you are looking for. Just check the options you want and changes to the vimeo video embed code will be made in the top right box which will now look like this.

   <iframe src="http://player.vimeo.com/video/41261299?autoplay=1" width="500" height="281" frameborder="0" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>

7. Copy the code in the box and paste into your wordpress page using the html option and you are good to go.
8. You are now done.

If you want to Autoplay Vimeo Videos in WordPress that you already have on your site all you need to do is add the following after the url in the embed code.

<iframe src="http://player.vimeo.com/video/41261299?autoplay=1" width="500" height="281" frameborder="0" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>

If you have any questions or are still confused about how to autoplay vimeo video in wordpress feel free to give us a call or email us using the wordpress design shop contact form.

What should a WordPress Product Site Theme Look and function Like?

When building a wordpress product site for your new venture you should keep the following rules in mind:

1. You should make sure your wordpress product site makes it easy for the customer to know what your product is and how it benefits them in as little as 4-6 Seconds.
2. Your wordpress product site and theme should have colors and text that are easy to read and do not distract from the product descriptions and benefits.
3. Your site navigation structure should make it easy for the consumer to move around the site and keep track of their activity.
4. Your wordpress product site should be SEO friendly and contain images, descriptions, and links all related to your product category and benefit.
5. You should keep as few steps as possible in the checkout process.
6. Have a FAQ on your site that explains any concerns that typically arise in your business
7. Have contact information readily available on your site, including directions to your physical store if you have one.
8. Have any coupons and deals easy to find on your site and navigation
9. Make sure that your wordpress product theme is easy to manage for you and your employees
10. Make a check list of all the features you want on your site and try to get as many features as possible in your initial wordpress site build.
11. Have Social Sharing systems for products and information like, Pinterest, Twitter, Facebook, Linked IN, Etc.
12. Make sure that your shipping is straight forward and easy to manage, include FEDX and UPS if required.
13. Make sure that your wordpress product site and theme load fast
14. Optimize all images to reduce size

So you have all the rules down and want to know what a wordpress product site looks like.

Here are some wordpress product site examples.

So what systems are normally used when selling products in wordpress.

Ready to start the development of your first wordpress product site. Give us a call or email today.

No Such Thing as Unlimited WordPress Hosting

Unlimited wordpress hosting is just a marketing term and nothing you should get excited about.

Last month I was reading an article about how cellphone companies are using the term unlimited very loosely. You would think that unlimited means unlimited…Right? I was working on my wordpress website and thought wow…that is so sad that companies were misleading people like that. I then just put it out of my mind and went about working on my wordpress website with not much of a bother.

A couple of days went by and all of a sudden I got an email from my hosting company telling me that they ran a report and my couple of sites that get many thousands of visitors were taking up to much CPU. Mind you I am on a wordpress hosting platform that says the following:

Unlimited WordPress Hosting

Our hosting  provides you with unlimited disk space for your wordpress website hosting needs. The way we can give you generous amounts of disk space is easily explained. The average cost of hard drives, keep getting lower and lower. So, in turn, we want to pass these saving along to you. This way we are sure you have enough storage space for your website files.

Bandwidth is the amount of data that you are able to transfer between your website account and the visitors of your website. Unlimited bandwidth offering allows you to never worry about exceeding your bandwidth limitations!

* Please note that I have been a customer of this company for over 6 years and through 2 change of owners,

Needless to say I was a little upset and responded that I have a pro hosting account that says unlimited domains, cpanels, and disk space. I am curious how I can be having a CPU issue with my wordpress sites if I have unlimited everything.

Shortly after that I received another email that said yes I have an unlimited account but CPU is not unlimited and sites are not allowed to exceed the average CPU for more than a couple of days and I would need to upgrade from my $11.95 a month account to a $65.00 a month dedicated account for wordpress.

For all you computer science people out there, you may be scratching you head like I was! How can I have unlimited wordpress hosting with domains, unlimited disk, and unlimited traffic without taking up more CPU?

So, Yes just like the cellphone companies…all wordpress hosting sites tell the same lie called unlimited even with wordpress hosting.

If you get very much traffic with your wordpress site you are better off getting a VPS solution for your site or follow the following tips for reducing your wordpress CPU.

• Optimize the wordpress database.
• Uninstall/disable any unnecessary plugins on the site.
• Limit wordpress related posts plug-ins
• Reduce Image Sizes
• Minify CSS files
• Installing a caching plugin. There are several options for this such as, WP Super Cache, W3 Total Cache, Hyper Cache Extended, DB Cache Cache Reloaded, and so on.
• Outsource Theme’s Images to amazon S3 or even Flickr

Remember next time you are out to get a new wordpress hosting plan that there is no such thing as “unlimited wordpress hosting.”

Don’t Buy Jigoshop Unless You are a Programmer

You searched the web and found an Amazing wordpress ecommerce plug-in called Jigoshop and now believe that your prayers have been answered.

Well that is what I thought for one of my clients!

Top Reasons to stay away from Jigoshop unless you are a programmer or plan to pay for one.

1. Jigoshop does not work well with most themes. In my experience I was only able to get the pages that used shortcodes to work in the theme without CSS programming. It would mess up the headers, messages were overlapped and so on.
2. Jigoshop does not have good support. After your purchase jigoshop they do not help you with issues really much at all and keep trying to get you to buy premium support to really get any help. I don’t know about you but when I buy a product I expect it to work and not need premium support right out of the gate to do the most basic things
3. Jigoshop does not offer an easy way to change button colors and such. My client wanted to change some of the default colors in the system and we had to go to the actual cart style sheet and then un-minify it and then re upload it to be able to find any of the css easily. This caused hours of work for the most basic changes.
4. The cart is not really free unless you need only the most basic features. When you first find the jigoshop cart you may say to yourself wow what great features and best of all it is free. Well, it is not really free almost every additional feature cost major money. Add UPS, FEDX, and a few other extensions and you are at a 150.00 before you know it. Add a bunch of extensions and you could be at $500 before you know it.
5. Simple Free Shipping for an individual product? – Shipping is one of the most needed features of any shopping cart. Ever want to sell one product and offer free shipping  on it. Yes, well same here and no can’t find a simple way to do this either.
6. Several Jigoshop Extensions have no error codes. We spent hours trying to get just one of the shipping modules to work. We filled in all the information and everything but no luck. Even better no error codes either. We had to try things over and over again in the dark until luckily we found what the issue was.

What do you get with jigoshop according to the site?

Jigoshop Features that are actually extra. (Cost more money anywhere from 5.00 to 50.00 each)

• Table Rate Shipping
• Product Accessories
• Paypal Express Checkout
• Product Inquiry form
• Product Importer
• Paypoint.net
• PayU
• FEDx Shipping
• UPS shipping
• Export Product to CSV
• USPS Shipping
• 2Checkout
• Worldpay
• Authorize.net
• Payfast
• Inspire Commerce
• Canada Post Shipping
• Google Product Feed
• Affiliate Pro
• Stripe Payment Gateway
• Mediaburst SMS
• Buddypress Extension
• Mailchimp Extension
• Paypal Pro
• Simple Seo Meta Tags
• Upsells Cross Sells
• HTML Emails
• Sage Pay
• Campaign Monitor
• Support

As you can see, it can get very expensive if you don’t know what you want exactly.

If you are ready for an ecomnerce solution or are in the middle of a jigoshop install and are stuck give us a call for options and way to get what you want.

WordPress Design Shop is your wordpress ecommerce support specialists.

WordPress Restaurant Theme Special

Announcing our WordPress Restaurant theme special.

Do you have a restaurant, bakery, store and need a new website with full ecommerce support?

WordPress Design Shop has taken the Gusteau wordpress them and modified it to work with the Jigoshop ecommerce system.

This is what you get with our WordPress Restaurant theme special.

WordPress Restaurant Theme

Gusteau is an original and unique theme for restaurants, pubs and bars, combines pure elegance with timeless design and superb technical qualities. Gusteau theme offers an excellent system for administration menu cards (food menu, drink menu) and photo galleries. The theme is highly optimized for search engines and has excellent SEO options like adding your own keywords and meta descriptions for each page, post or menu item.

• Full localization support (contains .po/.mo files)
• Unlimited colors via color picker for your WordPress Restaurant Theme
• Custom background image uploader
• SEO optimized (custom meta keyword and meta description for each page, post or menu item)
• Unique menu cards system
• Photo galleries
• AJAX Reservation form with real time validation (also as widget)
• AJAX Contact form with real time validation
• WordPress 3.0+ Ready (Menus & Featured Images)
• GPanel 2.2 (Intuitive simple theme options)
• Page Templates (Reservation, Contact, Full Width)
• 11 Widget areas for your WordPress Restaurant Theme
• 8 Custom widgets (About box, Contact box, Featured box, Recent news, Opening hours, Reservation form, Testimonial, Tweets)
• Well organised Homepage PSD File (layered)
• Extensive documentation

WordPress Restaurant Shopping Cart

• Easy to Manage Shopping Cart System
• Multiple Payment Gateways
• Real Time Shipping Options
• Easy Tax Manager
• Coupons
• Re-Orders
• WordPress Restaurant theme product categories
• and more

WordPress Restaurant Theme Setup

• WordPress Design Shop Installs wordpress
• Sets up base navigation
• Sets up plug-ins
• Sets up base store
• and trains you on how to use everything.

If you have always wanted a wordpress restaurant theme system but were un able to find a site that works or a shopping cart that is easy to use contact wordpress design shop today and find out about our wordpress restaurant theme special.

WordPress Business Websites Save You Money

Are wordpress business websites right for your small business? In short..the answer is YES and here is why.

Top 5 Reasons to use wordpress when building Business Websites

WordPress Business Websites – Why it is right for you!

• WordPress is easy to manage – Many content management systems used for small businesses and large alike require many people to manage. When I worked in Fortune 500 we had at least 5 people dedicated in some way to our customer facing company website. At the average price of $100,000 dollars a person that is $500,000 dollars a year dedicated in some way or another to management the site. A typical wordpress site for a business runs about 1,000 dollars to 10,000 if there are a lot of custom graphics involved, and maybe some social features.  Hosting for the site also requires no special hardware, network setup, or security features to work. The content of the entire site can be managed by 1 virtual assistant. That is a savings of over $498,000 a year!

• WordPress Business Websites are easy to redesign. – As many of you know deciding on a company design for your website can take a long time. In many large businesses the design may be complete for a year and then a new CEO comes in wants to change the site again. In a typical website (non wordpress) CMS for businesses something as simple as changing the site layout can cost $100,000 dollars or more and cause major programming issues as well. WordPress uses a simple theming system that makes it easy to setup a totally new design for usually less than a $1000 dollars. And even better your in house designers that maybe do your product graphics etc. can be taught in a couple of hours how to create a new design that can easily be converted to wordpress and installed over your existing content.

• WordPress Business Websites are easy to extend. – Have you ever worked on your business website and thought, “man it would be great if we had this feature” only to hear it costs to much money, will take too much time, or is not compatible with our CMS. With wordpress all of the systems are easily extending with plug-ins. If you want a social network, there is a plug-in for that. If you want a gallery, there is a plug-in for that. Want a shopping system, there are plug-ins for that as well. There are millions of developers and business creating extensions to make your web presence sing. Best of all, they all work with your existing site, content, and features. There are many extensions that are free and even more at a low cost.

• Constant Updates – WordPress is one of the most updated platforms on the internet. I can’t count the number of times I have installed a super expensive system in some company and a few months later the system is out of date. Then to add insult to injury the software company that wrote the software doesn’t plan an update for a year or more. A year or more are! With wordpress there are over 800 million users on the internet so there are updates all the time. Even better the code is so simple to work with that a decent php developer can make updates and enhancement for you. No more waiting for that billion dollar development company to update their stuff.

• The Core is free for your business wordpress website. – What free? Yes, the core systems for wordpress and even the social components called buddypress are free. No more paying thousands and thousands of dollars year after year to just use the base features of your cms system. If you can’t find what you need in the core you only pay a few hundred dollars for plug-ins etc.

If you are ready to take your business website to the next level contact wordpress design shop for a free consultation.

WordPress Business Websites that reduce the cost of representing your business to the world.

WordPress Template Setup

Should you do your own wordpress template setup?

I cant count the number of times that I have had someone call and say I purchased a wordpress template but cannot get it to work.

WordPress is a very easy to use platform when you know what you are doing but is not as easy as many of the template developers make things look.  When you go to a template site remember they are visually designed to sell you a wordpress template and to make it look totally awesome.

So, can you do your own wordpress template setup after you have made the purchase? The simple answer is yes but there are several things that you need to ask yourself and if possible the template developers before you actually make the purchase.

Top questions to ask yourself before you purchase and try to do your own template setup.

• Do I know anything about reading code in wordpress
• Do I have access to someone to create images for the template or can I do them myself.
•  Am I going to use the wordpress template the way the mock-up design works
• If I am unable to complete the wordpress template setup do I have access to a developer to help me.
• Am I going to have image slides, content slides, video slides, or all three if there is a slider in the theme.
• Do I want the slides to link to different places in my blog other that a post or a page
• Will I use featured slides
• Do I want to use different fonts or colors
• I am going to use many different side bars and page templates,  like blog and full width etc.
• Do I want a theme that uses widgets for special content on the home page etc or am I ok with one that uses featured post etc.

You then use the answers to these questions to go shopping for your them so the setup process will be much easier.

A typical WordPress Template Setup statement will look like this from your answers.

I am looking for a wordpress theme that has a slideshow on the home page that can be configured for any type of content (videos,Posts,Images,Featured content) and can have slides link to anyplace I like. I wan’t a theme with multiple color and font options that are easy to change. I would like the home page to be configured with widgets instead of featured posts. I would like full, blog, home, contact, and page templates with separate side bars for each template.

If you are stuck with your wordpress template setup; contact wordpress design shop to save you lots of time and headache when configuring your new theme.

WordPress template setup help!

Emergency WordPress Support – California, Texas, New York, USA

Do you need Emergency WordPress Support?

Here at wordpress design shop we have received several emails from people having all kinds of wordpress issues? Because of the number of emails we have decided to start offering the help you need at rates that will not break the bank. Emergency support is one of the most needed services for most site owners. Did you know that almost 75% of site owners have at least 1 major outage when they use wordpress as their content management system?

The most common emergency wordpress support issues are:

• WordPress template is broken after update
• WordPress site has been hacked
• I have been locked out of my wordpress site
• Plug-in is no longer working
• Out of memory issues with wordpress
• Need wordpress theme help
• I just have a wordpress emergency
• WordPress shopping cart issues
• WordPress image issues

If you are sitting there needing support for your wordpress site just use the button to the right to email us and we will get back to you ASAP.

What are you waiting for? Don’t waste your time trying to find a solution on your own. Most wordpress website owners spend 500 dollars worth of time on a hundred dollar problem. Typical problems with most sites can me fixed in as little as 30 minutes. Even a complete loss of site can be restored in 1 hour.

WordPress Design Shop is your emergency wordpress support headquarters.

Legal WordPress Websites – California, Texas, New York, Florida – USA

Are you ready for an easy to manage Legal WordPress Website for your Law Firm.

WordPress makes it easy to extend your Law Firms or private practice reach. You can easily add article directories, resource directed at your niche, and much more. WordPress is one of the easiest platforms to use for running a business or Legal  website.

What comes with a Legal or Law Firm Website?

• You get help picking a domain name for your wordpress site
• You get help setting up your hosting
• You get wordpress installation
• You a Design that meets your law firms needs
• You get base navigation structure setup
• You get any custom images you need at our cost
• You get Base WordPress SEO training
• You get Base site use training
• You get SEO Plugins, Contact Forms, Site Map and other plug-ins installed
• Suggestions on How to Write Your Copy
• If you need a shopping cart we will tell you were to get the software and then set it up for you
• and much more.

If you are ready to reduce your web related costs and enjoy the ease of management that comes with a wordpress design shop custom Legal or Law firm sites, contact us today.

WordPress Legal Websites and Law Firm Practice Sites Quote.

Wordpess design shop is your resource fro Legal, Law Firm, and Private Practice Websites…

Backing Up WordPress

If you have ever had your wordpress site compromised you know how much time it can take to get your site back up and running. Backing up wordpress is one of the best ways to restore you site from a hack, failure, or any other wordpress related issue.

Backup WordPress using cPanel at your hosting company.

cPanel is a popular control panel used by many web host. The backup feature can be used to backup your MySql database. Do not generate a full backup, as these are strictly for archival purposes and cannot be restored via cPanel. Look for ‘Download a MySQL Database Backup’ and click the name of the database. A *.gz file will be downloaded to your local drive.

There is no need to unzip this file to restore it. Using the same cPanel program, browse to the gz file and upload it. Once the upload is complete, the bottom of the browser will indicate dump complete. If you are uploading to a new host, you will need to recreate the database user along with the matching password. If you change the password, make the corresponding change in the wp-config.php file.

Using phpMyAdmin

phpMyAdmin is the name of the program used to manipulate your database.

Information below has been tried and tested using phpMyAdmin versions 2.5.3, 2.5.7-pl1, and 2.6.1-pl3 running on Unix.

Detailed options are listed below, though in most cases you will be fine with the default export options.

Backup Process with phpMyAdmin

1. Log into phpMyAdmin on your server
2. From the main login screen, select ‘Databases’(You may not need to do this step)

   

3. Now click the name of your database – or your WordPress database if you have several databases.(Your screen may look slightly different, depending on the version.)

   

4. The next screen will show you all the tables inside your WordPress database.
   Ignore those, and click the ‘Export’ tab on the top set of tabs.

   

5. Look at the left box at the top of the Export section. All the tables in the database you selected are in that box.

   

   • If you have other programs that use the database, then choose only those tables that correspond to your wordpress install. They will be the ones with that start with "wp_" or whatever ‘table_prefix’ you specified in your ‘wp-config.php’ file.
   • If you only have your WordPress blog installed, leave it as is (or click ‘Select All’ if you changed the selection)
   • Ensure that the SQL radio button is selected.

   

6. The SQL sectionTick the following boxes:
   • ‘Structure’
   • ‘Add DROP TABLE / VIEW / PROCEDURE / FUNCTION’
   • ‘Add IF NOT EXISTS’
   • ‘Add AUTO_INCREMENT’ and
   • ‘Enclose table and field names with backquotes’
7. The DATA section

   It doesn’t matter too much what you check here. So long as you check the DATA box itself, the Complete inserts and Extended Inserts are mostly cosmetic changes to the output style, though Extended Inserts can help if you are having issues with the file size.

   

   

8. Tick the ‘Save as file’ option, and leave the template name as is.

   

9. Now click ‘Go’ and you should be prompted for a file to download. Save the file to your computer.
   Depending on the database size, this may take a few moments.
10. You have now backed up your database.

    If you wanted, you could download a backup in each of the compression formats. Your choice. For example: None and "zipped":

    Remember – you have NOT backed up the files and folders – such as images – but all your posts and comments are now safe.

Using Straight MySQL Commands

phpMyAdmin can not handle large databases so using straight MySQL code will help.

1. Change your directory to the directory you want to dump things to:

user@linux:~> cd files/blog

2. Use mysqldump to dump all database tables. To dump only certain tables from the database, give their names at the place shown by (tablename tablename tablename), and omit the parentheses ( ) in any case. (For help, try: man mysqldump.):

user@linux:~/files/blog> mysqldump --add-drop-table -h mysqlhostserver
 -u mysqlusername -p databasename (tablename tablename tablename) | bzip2
 -c > blog.bak.sql.bz2

Enter password: (enter your mysql password)
user@linux~/files/blog>

Example:
mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp | bzip2 –c 

> blog.bak.sql.bz2

Enter password: my-password
user@linux~/files/blog>

The bzip2 -c after the | (pipe) means the backup is compressed on the fly, and the > blog.bak.sql.bz2 sends the bzipoutput to a file named blog.bak.sql.bz2. It does in one line the same thing that these two commands do:

mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp > blog.bak.sql
bzip2 blog.bak.sql

Despite bzip2 being able to compress most files more effectively than the older compression algorithms (.Z, .zip, .gz), it isconsiderably slower (compression and decompression). If you have a large database to dump, gzip is a faster option to use.

mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp | gzip 

> blog.bak.sql.gz

Using MySQL Workbench

MySQL Workbench (formerly known as MySQL Administrator) is a program for performing administrative operations, such as configuring your MySQL server, monitoring its status and performance, starting and stopping it, managing users and connections, performing backups, restoring backups and a number of other administrative tasks.

You can perform most of those tasks using a command line interface such as that provided by mysqladmin or mysql, but MySQL Workbench is advantageous in the following respects:

• Its graphical user interface makes it more intuitive to use.
• It provides a better overview of the settings that are crucial for the performance, reliability, and security of your MySQL servers.
• It displays performance indicators graphically, thus making it easier to determine and tune server settings.
• It is available for Linux, Windows and MacOS X, and allows a remote client to backup the database across platforms. As long as you have access to the MySQL databases on the remote server, you can backup your data to wherever you have write access.
• There is no limit to the size of the database to be backed up as there is with phpMyAdmin.

Note: The instruction below was written for older version (MySQL Administrator).

Backing Up the Database

This assumes you have already installed MySQL Admin and set it up so that you can login to the MySQL Database Server either locally or remotely. Refer to the documentation that comes with the installation package of MySQL Admin for your platform for installation instructions.

1. Open the MySQL Admin client and login as you had previously set up to do.
2. From the icon menu on the left hand side of the client window select Backup.
3. If you have not already created a Backup Project, do this now by clicking on the "New Project" button at the lower part of the window and type in a name for the Backup Project where prompted.
4. Select one or more databases that you want to Backup (in the MySQL Admin client these are called a "Schema" (pl. "Schemata")). Add them to the Backup Content window on the right using the right-pointing arrow button.
5. When you have selected the Schema(ta), you can save the Backup Project. Or you may simply choose to Backup Now using the button on the lower right of the window.
6. A dialogue will come up asking you where to put the Backup. Enter the pathname or browse to the location using the dialogue.
7. Assuming all is correct (and you have write permissions in the directory to which you are writing the Backup), the backup will complete shortly.

Restoring From a Backup

1. Open the MySQL Admin client and login as you had previously set up to do.
2. From the icon menu on the left hand side of the client window select Restore.
3. Click the "Open Backup File" button on the lower right of the window.
4. Type in or browse to the Schema(ta) backup file and select. Click "Open".
5. The Target Schema(ta) will most likely be the "Original Location", or you may choose an alternate location using the drop-down menu.
6. Click the "Start Restore" button on the lower right of the window. The database restore will commence.

Austin Matzko maintains a WordPress plugin originally created by Skippy called WordPress Database Backup (WP-DB-Backup). It was bundled with WordPress 2.0 but is no longer included with WordPress 2.1.

Installation

1. Search "WP-DB-Backup" on Administration > Plugins Panel > Add New.
2. Activate the plugin.
3. The plugin will attempt to create a directory /wp-content/backup-*/ inside your WordPress directory. You may need to make /wp-content writable (at least temporarily) for it to create this directory.

Backing up

1. Navigate to Administration > Tools > Backup Panel
2. Select any tables, in addition to the core WordPress tables, that should be backed-up.
3. Select the Backup Options; the backup can be saved on the server, downloaded, or emailed.
4. Finally, click on the Backup button to actually perform the backup. You can also schedule regular backups.

Restoring the Data

The file created is a standard SQL file. If you want information about how to upload that file, look at Restoring Your Database From Backup.

Backing up wordpress is one of the best ways to restore from a wordpress failure.