• Home
  • Archive
  • Tools
  • Contact Us
  • Forum

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
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 :

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.

Advertisement

---

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
Facebook Twitter Google+ Pinterest

About Abhishek Ghosh

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

Follow the Author of this article :

13.7K+ Followers 18.7K+ Followers 2.5K+ Followers 1.5K Followers

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 Google+ or Twitter to join the conversation right now!

If you want to Advertise on our Article or want Business Partnership, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

You can subscribe to our Free Once a Day, Regular Newsletter by clicking the subscribe button below.

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

Search this website...

 

 

Popular Articles

All articles of this Website are fully Free to read. Here are some, which possibly you'll like to read! Do not hesitate to contact us for any concern.

Contact Us

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

Recent Posts

  • Example of Using IBM Watson For Text Analysis with Google Docs April 20, 2018
  • Arduino WiFi Control of LED From Web Browser April 19, 2018
  • Fix Problems & Issues of Yoast SEO WordPress Plugin April 19, 2018
  • Extra Battery, Inverter For Car For DIY Electronics Car Automation April 18, 2018
  • Blink AC Bulb With Arduino Relay Module April 17, 2018

About This Article

Title: How to Export WordPress MySQL Database on Rackspace Deployment
April 15, 2014
Author: Abhishek Ghosh
Subjects: Cloud Computing, Computer and Internet, WordPress and SEO
Is Part Of:

TheCustomizeWindows, April 15, 2014, Vol.1(01),
p.1–39075 [IoT Ready Journal]

Source:The Customize Windows
ISSN: 0019-5847 ;
E-ISSN: 0019-5847 ;
Publisher: jima.in

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

Read Cookie Policy

Contents are copyright protected and reproduction demands our permission.


PC users can consult Corrine Chorney for Security.

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

web analysis

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

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