• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here: Home » Repairing WordPress Database : Using Cloud Database Server

By Abhishek Ghosh August 6, 2012 10:52 pm Updated on August 6, 2012

Repairing WordPress Database : Using Cloud Database Server

Advertisement

Repairing WordPress Database is easy by using Cloud Database Server like from The Rackspace Cloud which provides MySQL database server with PHPmyAdmin software. Repairing WordPress Database is needed for various reasons – after getting hacked, after few years of continuous posting 5-6 articles per day and as a optimization process. Consider Repairing WordPress Database when your WordPress database crosses 120 MB with 2400 posts. I did a calculation and found that it is not possible to have a 120 MB database with 2400 posts. The ratio can be lower. If you are Repairing WordPress Database as prophylaxis (i.e. not under being hack), then you can do it in cool head. First, read this article to reduce the wp_commentmeta and wp_comments table size.

 

Mantras for Repairing WordPress Database

 

The first mantra for Repairing WordPress Database is, do not hire anyone unless you have a plant that grows bank notes. WordPress is easy and the way we are describing here for Repairing WordPress Database is far better than the hired people will do for you.

For this example of Repairing WordPress Database, we are using PHPMyAdmin (please search on this website if you are not sure what it is) for accessing MySQL database of WordPress, which is by technology is a Cloud Database and the Service provider is The Rackspace Cloud. You can use MySQL cloud database with PHPMyAdmin of any provider. The major reason to use this Cloud Database is, we can connect it to any server. So, if you are using a poor hardware powered server (most falls in this category), you only know that the database is always is localhost, i.e. database is on the same server. But Cloud Database can connect with FTP content of any server with relative url or IP. Now you have understood, basically for few cents (as most are billed for usage only) to few dollars, you can connect your FTP to test the database in this Repairing WordPress Database process.

Advertisement

---

Second Mantra is, understand the basic structure and mechanism of how WordPress works :

 

  • Only few tables of WordPress stores the core data including your writings, categories etc. Others are for active or even deleted plugins.
  • FTP of WordPress : For backup purpose, all is not needed except the wp-content folder, .htaccess (at root), robots.txt (root), wp-config.php (for Rackspace users only who need the original complex database details to login). This wp-content folder contains the post images, theme images, theme css etc.

 

Third Mantra for Repairing WordPress Database is :

 

Only these MySQL database Tables are default of WordPress :

 

Repairing WordPress Database

Among the default database tables, we need not the circled wp_options for Repairing WordPress Database.

 

The last Mantra for Repairing WordPress Database in this way is, always import table by table in sql format.

 

Steps for Repairing WordPress Database using Rackspace Cloud Database Server

 

If you are a Rackspace Cloud Sites user or just use their database as a service, the method will be the same for Repairing WordPress Database.

 

First step for Repairing WordPress Database

 

In cool head install WordPress freshly on a separate domain or subdomain or subfolder. Its better if it has just an FTP. Simply upload the WordPress files in uncompressed format there. Do not do anything with wp-config-sample.php file. In browser, point to the root of this new WordPress future installation. It will ask whether it will create a config file. Agree and proceed. Enter the database details of the Cloud Database, for our Repairing WordPress Database guide its of Rackspace. Done. Its a new fresh installation.

 

Second step for Repairing WordPress Database

 

Now open your working site’s database via PHPMyAdmin (Which we will repair in this guide for Repairing WordPress Database). For existing Rackspace users , its SSL connection and you have to use two browsers. Even if you are not an existing Rackspace user, open these two databases in two different browsers for Repairing WordPress Database. The reason is – map in your mind – suppose Chrome is my working website’s database, I will be very careful not to delete any table.

 

Third step for Repairing WordPress Database

 

Import these tables in sql format from old database :

 

  •  wp_commentmeta
  • wp_comments
  • wp_links
  • wp_postmeta
  • wp_posts
  • wp_terms
  • wp_term_relationships
  • wp_term_taxonomy
  • wp_usermeta
  • wp_users

 

How to import a table as SQL from PHPMyAdmin for Repairing WordPress Database :

 

Using Cloud Database Server

 

  1. Click Browse Tab, click the name of the Row / Table like wp_users
  2. Click Export.
  3. You can check it to Custom, but do not do anything which you have no idea about.
  4. By default it will be SQL, still check it carefully.
  5. Click GO button and save on your desktop.

 

Forth step for Repairing WordPress Database

 

Now open the new WordPress Installation’s database, where we will be Repairing WordPress Database. Delete one by Table / Row and import it from your desktop (basically that is you original old database tables).

 

Final checking and packing up for Repairing WordPress Database

 

Repairing WordPress

 

As we have not set the permalink structure in this fresh WordPress installation for Repairing WordPress Database (we will not do it),  we will get a fresh WordPress with all posts, categories etc. Normally, this WordPress will run fine. You can install selective plugins (except cache plugins) which you actually be using, you can ask the developer about the table name to import old tables (like tables for Socialize plugin which has data of how many +1 ed this post).

Its better if you can save the default tables for Repairing WordPress Database in a separate folder. If still it creates problem to run here, delete it, replace with fresh one’s.

So, simply you can either connect this database (in case the database provider and ftp server space provider is same) with your FTP by editing the original site’s wp-config.php file or can do the reverse process how we fetched the data here for Repairing WordPress Database.

 

Some important points for Repairing WordPress Database in this method :

 

  • Do not change the permalink
  • Do not create or install any plugin that will create .htaccess file
  • WordPress saves the data as – ?p=5678934 for pages, ?tag=word – in this format. It does not matter where you are installing it. Its the wp_options that changes the things and makes it difficult. This is the reason we avoided to import that table. Otherwise we had to use Search and Replace Plugin, which is a last measure to correct url redirections and path.
  • We used SQL to export and import rows for Repairing WordPress Database as it has least chance to add wrong data or corrupt it. 
  • If you fail for Repairing WordPress Database as you can not import, you have to import as text and run SQL queries.
  • It is obvious that, this method for Repairing WordPress Database can be used for changing domain name, changing server etc.
  • You can simply make this method of Repairing WordPress Database automated by using cron job. 

 

Signature

 

This Article Has Been Shared 564 Times!

Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to Repairing WordPress Database : Using Cloud Database Server

  • Installing TheHostingTool Control Panel on Rackspace Cloud Sites

    Installing TheHostingTool Control Panel on Rackspace Cloud Sites is easy as like Installing any PHP MySQL software like WordPress. Great tool for the Resellers.

  • Self Hosted WordPress on Cloud Server for Dummies

    Self Hosted WordPress is itself a scary phrase to a non-tech person and add Cloud Server on it. Here is Very Easy Guide to under Self Hosted WordPress.

  • Mac Mini Colocation and Private Cloud : Why An Important Approach ?

    Mac Mini Colocation and Private Cloud can offer a high quality redundant hardware with less effort for hardware management and Free OpenStack Cloud Software.

  • Which CDN is Best for Serving Static Contents and Streaming

    Which CDN is Best has one answer – Akamai. Akamai is the global standard and used by IBM to Microsoft. You have to find someone using their infrastructure.

  • Is Cloud Hosting is a Better Option for WordPress ?

    Is Cloud Hosting is Better Option for WordPress ? The right answer is – where and from whom you have heard it ? Secondly why you are thinking for an upgrade ?

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (24.3K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • Is it Good to Run Apache Web server and MySQL Database on Separate Cloud Servers? March 27, 2023
  • Advantages of Cloud Server Over Dedicated Server for Hosting WordPress March 26, 2023
  • Get Audiophile-Grade Music on Your Smartphone March 25, 2023
  • Simple Windows Security and Privacy Checklist for 2023 March 24, 2023
  • 7 Best Artificial Intelligence (AI) Software March 24, 2023

About This Article

Cite this article as: Abhishek Ghosh, "Repairing WordPress Database : Using Cloud Database Server," in The Customize Windows, August 6, 2012, March 28, 2023, https://thecustomizewindows.com/2012/08/repairing-wordpress-database-using-cloud-database-server/.

Source:The Customize Windows, JiMA.in

PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

Copyright © 2023 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT