nickkomissarenko

This is simple step-by step guidance
If you use Cpanel as web hosting management tool

• Export Local Database
  Login to your original web site local phpMyAdmin, select the database from the dropdown. Click on the Export tab:
  Under the Export field, make sure all tables are selected
  Under the Structure field, tick “Add DROP TABLE / DROP VIEW”
  Tick “Save as File”
  Then click Go and it will prompt you to download a SQL file
• Find and Replace All original URLs with new ones
  Open the database SQL file with a text editor. Find and replace all local URLs with your domain URL (eg. replace all “http://localhost:8888/mysite” with “http://www.yourdomain.com”).
• Import The Database to new web site.
  Login to your new server cPanel, go to MySQL Databases, create a new database and assign a user. Now go to phpMyAdmin, select the database (the one that was just created) from the dropdown, click on the Import tab, browse the SQL file and click Go.
• Upload the entire WordPress folder to your server. Connect by FTP and copy all content from public_html form original server to new, It is better create archive file through Cpanel/File manager, than download it, upload it on new and extract, take just a few minutes instead of copying hundreds small files to and from
• Change The wp-config.php Setting
  On your new server, open the wp-config.php file. Change the database details to reflect your server settings.

  / ** MySQL settings - You can get this info from your web host ** //
  /** The name of the database for WordPress */
  define('DB_NAME', '<strong>accountname_wrdp1</strong>');
  
  /** MySQL database username */
  define('DB_USER', '<strong>accountname_wrdp1</strong>');
  
  /** MySQL database password */
  define('DB_PASSWORD', '<strong>password</strong>');
  
  /** MySQL hostname */
  define('DB_HOST', 'localhost');

Almost done. Good luck.