Rocket 88

websites

24/7 Sales & Support (480) 624-2500

Importing a database for your WordPress site

April 5th, 2014

wordpress-loveThere is no question that WordPress has become one of the most popular systems for creating sites on the web, and the info graphic below illustrates how relevant it has become in the web design community. One of the reasons we love it so much is how simple it is to create your own site, and keep it relevant by regularly updating it without any coding knowledge at all, but if you change hosts and have already put a lot of time and effort into creating your site you want to preserve that work by importing your database properly.

WordPress sometimes gets confused as blogging software, but it is far more than that. In reality it is a comprehensive CMS (Content Management System) that allows you to create anything from a Professional Photography site (like my own at gatesman.com), to an online store, or to promote any type of business or club, announce your wedding, or as a memorial.

And the good news is that Rocket 88 Web offers the most robust hosting for serving up your WordPress site fast. I can say this from experience as I’ve hosted my site on other servers that had a lot of good things to offer, but simply did not match the speed I get from Rocket 88 Web. And nothing kills an audience faster than waiting for a page to load.

If you currently host a WordPress site somewhere else and are looking for a faster host, you’ve come to the right place. And it’s simple to do. There are plenty of resources on the web to help you through the transition, but there is one step that usually gets overlooked when trying to import your current database which could cause the database to issue an error like this:

#1044 –  Access denied for user ‘MY_USER’ to database ‘MY_DATABASE_NAME’

This happens when the database export created with phpMyAdmin has two lines in it that prevent an import to a database with a different name. Unfortunately you cannot create a database with a custom name within your Rocket 88 Web account, but you can alter the import file using a text editor or program like Dreamweaver. First, open the file you want to import and toward the top, find these lines:

CREATE DATABASE MY_DATABASE_NAME DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
USE MY_DATABASE_NAME;

All you need to do (once you have made a backup, of course, is delete those three lines, save the file and import that one.

WordPress Trends Infographic

Leave a Reply