• 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 » How to Export WordPress MySQL Database on Rackspace Deployment

By Abhishek Ghosh April 15, 2014 7:07 am Updated on October 10, 2014

How to Export WordPress MySQL Database on Rackspace Deployment

Advertisement

How to Export WordPress MySQL Database on Rackspace Deployment Where You Have Only Command Line Option and Ports are Blocked for Security? We talked about Rackspace Deployment, when it was available to us for evaluation, if you go for such setup with minimum 3 server and one load balancer configuration, you will find it quite difficult to perform the database migration without making the website offline. If you are running WordPress on a Single Server in the way we described in the Full step by step guide to Install WordPress on Ubuntu 13.10 on Rackspace or use Database as a Service, you will definitely understand the issue with exporting database in easy way.

 

No Proper Guide Exits to Export WordPress MySQL Database on Rackspace Deployment for the New Users

 

Database management is a super specialty and actually the guides the typical websites write about to export WordPress MySQL Database in these ways :

  1. Using some plugin to import
  2. Using PHPMyAdmin to import
  3. Using Command Line on “normal” server

These will invariably fail. The commands like :

Advertisement

---

Vim
1
mysqldump -u username -p databasename > backup.sql

will actually never get realized on such setup as we will login on the MySQL database server as root user. The database created in the Deployment has an user and password – you actually know it from the dashboard. This method on How to Export WordPress MySQL Database on Rackspace Deployment is actually for avoiding the downtime. All are written in official MySQL website. We are making it simple as most lacks the idea of MySQL Database management.

 

Commands How to Export WordPress MySQL Database on Rackspace Deployment

 

You can take the SQL backup of your existing WordPress in the way you like. You can :

  1. Use WordPress Plugin
  2. Use PHPMyAdmin
  3. Use Commandline

 

How to Export WordPress MySQL Database on Rackspace Deployment

Follow our SQL Commands to Clean WordPress Database to clean the WordPress database first before exporting. It will decrease the chance of having errors. We are avoiding the terminologies.

You probably have saved the Private Key on your Mac or Linux PC (or may be Windows PC, its too unsafe to work with).

If you have saved the Private Key properly, you will be able to login to the MySQL server by doing simple SSH. Before that, you will keep your MySQL database backup either as SQL or tar ball in some publicly accessible folder on the old FTP Server so that you can simply wget it from this MySQL server.

Suppose, I kept the MySQL backup on https://thecustomizewindows.com/my-backup.sql location, I can SSH on the MySQL server, I will be on /root by default. I can wget it :

Vim
1
wget https://thecustomizewindows.com/my-backup.sql

The trick is on MySQL part. You need no username password anymore to execute this my-backup.sql dump on the existing database. You will not remove the already created database but only execute this dump. It is more simple than you can think of. Actually you need to refer to MySQL Forum or Guides not WordPress Forums or Guides. WordPress associated peoples will not know the core tricks of managing database server or tweaking UNIX / Linux Server. They know only somethings about PHP and the PHPMyAdmin interface. PHP is never considered as a superior scripting language, BTW.

You have wget-ed the my-backup.sql MySQL dump while in /root. Do not forget to delete the https://thecustomizewindows.com/my-backup.sql thing. Else people will download it! Type :

Vim
1
2
3
4
5
6
7
8
9
10
11
mysql
# you are logged in to mysql server
# mysql server is a software and your physical (I mean cloud) server is where you are
# confusion happens as root is also a mysql user
# whose password unfortunately
# might not match or your keyboard mapping
# will prevent you to rightly type the password
# So --> we will run sql commands as owner of the Server where
# your mysql server software is running
# mysql obviously will take your commands
# its your server. 2 cents

You can run query to list the databases :

Vim
1
show databases;

It will give an output in a kind of artistic way :

Vim
1
2
3
4
5
6
7
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| your-database      |
+--------------------+

your-database is what your Deployment is using ==> easiest way to get that info is opening the Master FTP server’s wp-config.php file. The user will not be root but your username on Rackspace (by default).

Now select the database :

Vim
1
use your-database;

The semi-colon is important. If you mess-up, you can type c to get rid from -> thing. When mysql> is present, it indicates you are doing the right. Appearance of -> means you have done something which we do not need here. Not everyone knows about MySQL. These descriptions might bore the advanced users.

Its not that bad, actually you can see the Tables too now :

Vim
1
show tables;

Your known wp_posts, wp_postmeta etc. will show up. Again, make sure that you are using the right database :

Vim
1
use your-database;

Just execute the backup like we do for running bash scripts :

mysql> \. file_name

Reference :

Vim
1
https://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html

It looks great to see the scrolling output! Yes, done. What is more? !

Tagged With export wordpress database windows , php myadmin default password , show database; , wordpress mysql export

This Article Has Been Shared 384 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 How to Export WordPress MySQL Database on Rackspace Deployment

  • Repairing WordPress Database : Using Cloud Database Server

    Repairing WordPress Database is easy by using Cloud Database Server like from The Rackspace Cloud which provides MySQL database server with PHPmyAdmin software.

  • Scalable MySQL Database for WordPress with Rackspace Cloud

    Scalable MySQL Database for WordPress is very easy to create as Rackspace allows Cloud Database,so does Amazon. Here is a guide for high performance WordPress.

  • Using https URL of Rackspace Cloud Files for WordPress

    Using https URL of Rackspace Cloud Files for WordPress needs some extra steps for more secured delivery of Static Content of your SSL enabled WordPress site.

  • Making WordPress to Load Faster on Rackspace Cloud Sites

    Making WordPress to Load Faster on Rackspace Cloud Sites needs WP Super Cache,CDN Sync Tool, HyperDB, .htaccess tricks and tweaks to make buggy plugins working.

  • Move WordPress Administration to Different Server or Sub-Domain

    Move WordPress Administration to different server and allocate a Sub-Domain for better security and higher performance tweaks of the front end.

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

  • What Online Casinos Have No Deposit Bonus in Australia March 30, 2023
  • Four Foolproof Tips To Never Run Out Of Blog Ideas For Your Website March 28, 2023
  • The Interactive Entertainment Serving as a Tech Proving Ground March 28, 2023
  • 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

About This Article

Cite this article as: Abhishek Ghosh, "How to Export WordPress MySQL Database on Rackspace Deployment," in The Customize Windows, April 15, 2014, March 31, 2023, https://thecustomizewindows.com/2014/04/how-to-export-wordpress-mysql-database-on-rackspace-deployment/.

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