Here is a basic guide to create MySQL Database, Create Tables and import any existing SQL backup without using PHPMyAdmin or other web software. There are two types to scaling on Cloud and usually at minimum, we use 2 servers – one application server (database server) and one web server. This is basically a video guide to help the new readers of our website who wants to manage their own servers.
Basic Guide to Work on MySQL CLI : Some Example Tutorials Where This Guide Will Help
All the commands which has been used in this video can be found in How to Export WordPress MySQL Database on Rackspace Deployment.
Obviously, you can use this knowledge to Install WordPress on Rackspace Cloud Server (Ubuntu 14.04 PVHVM) where the web server software Apache2 or Install WordPress on Rackspace Cloud Server where the web server software is Nginx.
What is not shown is the settings of
my.cnf, which actually we talked here on this article in details to Setup Separate Database Server.
If watch this video on YouTube, you will get this kind of List of other videos :
Basic Guide to Work on MySQL CLI : Video
Click the gear icon of YouTube Player to change the resolution to highest and watch the video in full screen. The voice over is not required to understand, you only need to view the commands running !