Trivana News – Upload WordPress step by step to the hosting server using FileZilla, Once you are satisfied with the look of your WordPress site on your local PC, the result of a customized website, design, content / articles that you write. Surely you are intending to publish it online. Still less if you do not already have a selection of the best web hosting server. Make sure you have the facility server and the MySQL database support PHP scripts.
Furthermore, if you already have a web hosting, it is very inconvenient time to upload files to the server hosting if we do not know what the right way to do it. Any file that you upload? how to upload to the server hosting? if one of our file upload?
Much less effective to upload files one by one, the question if the files that we have there are thousands, how long we have to wait? here we will explain briefly how to upload to the server hosting in this case as an example of application WordPress.
Upload wordpress step by step to the hosting server using FileZilla
1. Create a database through MySQL Database in Cpanel
If you have not created a database on the server, please make first. Creating a MySql database can be done in cPanel> MySQL Databases. There can be obtained:
- Database name, for example: ‘cerita35_wordpress’
- Username database, for example: ‘cerita35_admin’
- Password database, for example: ‘b4l1b0’
2. Backup database Local Computer
Prepare wordpress database application that you have created while offline. Backup your database, if using phpMyAdmin, please access phpMyAdmin from your Web browser (http: // localhost / phpmyadmin)
Choose your wordpress database that you want to upload from the drop down menu “database”. Once the database is selected and displays the table-tablenya, click on the “export” and choose select all and check the box “Add Drop Table” Do not replace the others unless you know what you are doing. Check “Save as file” press the “go” at the bottom right of the browser. The browser will issue a confirmation to the local computer store.
3. Import database through phpmyadmin in cpanel
Once finished creating the database and the user (step 1) and export the database on your local computer (step 2). Please open the menu phpMyAdmin in cPanel Select a database with the name (_wordpress) that you created in the first step.
Once the database is selected, click on the “import” and browse the database backup file and “Go” to import. For details, you can see in the article how to upload-MySQL-database.
4. Upload file
Before you upload the WordPress files to the server via FTP, preferably compressed in a Zip file format before all of the files and directories WordPress installation on your local computer. Use normal compression (standard) to zip the files and directories WordPress.
Upload a Zip file using FTP / FileZilla to speed up the upload process and avoid failure. If you want to make the web application as the main WordPress please upload WordPress zip file in the directory / public_html WordPress so that applications can be accessed via http://yourdomain.com/.
Once the upload is complete, login to cPanel> File Manager, find the file you uploaded (in a public_html directory), right click on the file and extract.
5. Setting file wp-config.php
Until step 4, if you try to access your Web site may be found a mistake / error messages. This is because the wp-config.php file from your local server does not contain information relating to your hosting account details. Wp-config.php file stores information about the database name, userDB, and the password created on hosting accounts ,. You need to change the details in it as follows:
Go to cPanel> File Manager you. Search for wp-config.php file in the root directory of your wordpress. Right-click on the file and click ‘Edit Code‘, change the line of code below in the information that we created in step 1:[PHP] // ** MySQL settings – You can get this information from your web host ** //
/ ** The name of the database for WordPress * /
define ( ‘DB_NAME’, ‘wordpress284’); change to define ( ‘DB_NAME’, ‘cerita35_wordpress’);
/ ** MySQL database username * /
define ( ‘DB_USER’, ‘root’); change to define ( ‘DB_USER’, ‘cerita35_admin’);
/ ** MySQL database password * /
define ( ‘DB_PASSWORD’ “); change to define ( ‘DB_PASSWORD’, ‘b4l1b0’);
/ ** MySQL hostname * /
define ( ‘DB_HOST’, ‘localhost’); no changes
Once finished changing the configuration, click the Save Changes button.
6. Edit the MySQL Database Server Online
This last step is the most important. We have to edit the database, which in this example is database “cerita35_wordpress'” in order to connect with our WordPress files. We just need to change the URL, which in this example of ‘http: // localhost / wordpress284 / become’ http://www.yourdomainname.com ‘.
If this step is not done then your site will not be displayed for WordPress files to the database is like two lovebirds that can not be separated. Steps to edit the database:
Run phpMyAdmin in Control Panel. Click the name of your database, in this example “cerita35_wordpress'”. Select and click on wp_options table. In the display that appears click [Browse]. On the table there are 2 things to edit:
a. Edit entry “siteurl” in the column “OPTION_NAME”. Click edit or pen for editing images. Replace ‘option_value with http://www.yourdomainname.com (adjust with the path where the files wordpress and your domain name).
b. Edit entry “Home” in the same column. If you do not find it, click on the arrow at the bottom of the table. How to edit it together with siteurl entry.
7. Access your domain name through the browser, and enjoy the results.