website File uploading and creating database in Capnel (linux hosting panel)

here you will get guidance about website File uploading and   creating database in Capnel (linux hosting panel):

Step 1: first create free account on www.geocities.ws  or  you can use  my account

 My   FTP ACCOUNT DETAILS  is:

HOST=www.geocities.ws

Username=ommaurya

Password=9673736173

step 2: download & install FileZilla FTP  Client software  & open it  

then  you enter your  FTP ACCOUNT DETAILS

for example my  

FTP ACCOUNT DETAILS  is:

HOST=www.geocities.ws

Username=ommaurya

Password=9673736173

then click on Quick connect. then you will see  to site :

(1)Local site

(2)Remote site

her local site is our computer system

& Remote site is  hosting server  computer ..

Suppose you want to upload  a folder simple  which is on Desktop   right click on that simple folder & click on Upload..ok..then it will upload your simple folder from Desktop to Remote site server under  root(/) folder as shown in below image:

now you can open   following link to see what you uploaded...ok 

"www.geocities.ws/ommaurya/simple"

HOW TO CREATE DATABSE  & DATABSE USER &  HOW TO ADD CREATED USER TO THAT CREATED DATABASE?

NOTE: FIRST OF ALL MAKE LOGIN TO YOUR  CPANEL  USING YOUR USERNAME & PASSWORD

STEP 1: AFTER LOGIN GO TO UNDER DATABSE  SECTION & CLICK ON  "MYSQL DATABASES"

STEP 2:  ENTER YOUR DATABASE NAME & CLICK ON  CREATE DATABASE

STEP 3: THEN  ADD NEW USER  JUST SCROLL DOWN THE SAME PAGE &  ENTER YOUR USERNAME & PASSWORD & AGAIN  ENTER TO CONFIRM PASSWORD & CLICK ON CREATE   A  USER.

STEP 4: 

NOW  ADD YOUR USER TO DATABASE SELECT YOUR USERNAME & SELECT YOUR DATBASE NAME  & CLICK ON ADD

STEP  5: AFTER CLICK ON ADD IT WILL ASK  FOR MANAGE USER PRIVILEGES  CHECK  ALL PRIVILEGS  & THEN CLICK ON MAKE CHANGES.

STEP 6: CLICK   ON    GO BACK THEN YOUR WILL SEE BELOW  IMAGE NOW TO IMPORT YOUR DATABASE  .SQL FILE CLICK ON  "phpMyAdmin".

--------------------------------------------------------------------------------------------------------------------------
NOW EXPORT YOUR DATABASE  USING  PhpMyAdmin  :
--------------------------------------------------------------------------------------------------------------------------
STEP  1: select your database   & then  click on Export  for example you want to export your database that name is batch select it & click on Export  :

STEP 2: then select  Format for exporting  for  MYSQL  ALWAYS EXPORT FORMAT IN SQL.

STEP 3: THEN YOU WILL GET  batch.sql  file.

--------------------------------------------------------------------------------------------------------------------------
NOW IMPORTING  YOUR DATABASE  USING  PhpMyAdmin  :

--------------------------------------------------------------------------------------------------------------------------
STEP  1: select your database   &  then  click on Import  for example you want to  Import your  database file batch.sql  file...

Then  click on  Choose File  & browse your  batch.sql file :

then select your  batch.sql   file & click on open 

after that click on   Go  & then you will get  message imported successfully..

Browse More Articles

Tweet

Written by OM MAURYA SIR

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.