0

I have a WordPress blog on an Apache server with database in MySQL, I can get a SQL dump of the database which is around 4GB in size how do I properly import that data into a NoSQL table store from Alibaba Cloud

Deepak Kamat
  • 107

1 Answers1

0

Besides the obvious question: Why would you want to do this?

There are no tools per se that will do this for you automatically. You will need to hand create your own tools based upon the tables, column types, etc.

You will probably find that your NoSQL database will be much larger than the traditional RDS (SQL) database that you copied from. The data layout and structure do not make for a clean "copy and paste" to NoSQL. RDS makes heavy use of references to other tables that do not easily move to NoSQL. NoSQL uses a document type of structure.

If your goal is to use a NoSQL database to replace MySQL, this is not practical today. You would need to modify WordPress. After these extensive changes you would not be able to automatically update WordPress with new updates or releases.

One area that might make sense is extracting the blog post (articles) and putting those into NoSQL.

John Hanley
  • 5,164