How to download the SQL database in hosting?

advertisements

I'm new to website hosting.
I had successfully uploaded the files, now I want to upload database, can anybody help me to upload database from my localhost to my hosting website.


Use following step:

  1. Go to cpanel.
  2. create database by going to database option in cpanel.
  3. assign db user to that database.
  4. now go to that phpmyadmin.
  5. export local db.
  6. now import on live db.
  7. Set home url and site url in option table.

work is done.