In previous part 2, we have explored the ways to know database, and learned how to use them in our WordPress development effectively. In this recent post, we would like to know about the transferring process of local WordPress website to the live server without losing anything and with a smooth process.
Once you finish the development process at local server, you will have huge database as well as bulky folders with innumerable files for posts, pages, images, themes, plugins, and so on. Today we are using cPanel to place and manage our website or web application sources to the hosting server. No doubt, cPanel is equipped with all tools and technologies to manage and migrate sources from local to live server manually, but there are various plugins available to do these tasks automatically with adequate security and speed for bulky web sources.
There BackupBuddy and Duplicator plugins used in recent generations or WordPress programmers who used to face such task on daily bases for their patrons. We know we can’t copy past our source files and folders without setting permissions and security variables appropriately. Therefore, use of FTP (File Transfer Protocol) is mandatory for all WordPress developers.
There are various FTP clients available in the market for free or paid such as WS_FTP for windows platforms, Filezilla as firefox or other browser plugins, FireFTP for all platforms, Cyberduck for Mac only, and WinSCP for windows only.
The first and foremost step is to transfer local WordPress database using phpMyAdmin. As we have learn about phpMyAdmin in previous parts, we need to know that here we have to use only its export button located at the top menu bar of cPanel of your local host. Now, select all tables and zipped them to compress. After compression select zip file and push the Go button, located at the bottom of the page to download your database.
Now, turn on FTP client and connect it with your live site, where you will find various directories so you need to select proper directory for you and that would be public_html directory in your domain. The next step would be to select your WordPress files on local server and upload them to the liver server.
Create New Database
For database transfer you need to create MySQL database on the live site first using the cPanel features given especially for MySQL database. Once you push that database button on the cPanel dashboard you will enter in to the database creation wizard where you need to fill up all essential input fields with appropriate information.
Finish Database Transfer
Now, finally you come at the stage of importing you zipped database file saved in previous steps. At very moment, database section on cPanel will help you to import database so go to database section and click on phpMyAdmin where you will find new database with no tables so now click the import tab in the top menu and on the import page select file button and select your zipped database. After selection, you can press Go button at the bottom of the page and start importing process.
In next part, we will finish the transferring process from local to live.