Thursday, 3 December 2015

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

01:14


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..

Written by

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.

0 comments:

Post a Comment

PHP Training Mumbai, PHP MySQL Training Mumbai, PHP Course Mumbai, PHP Institute Mumbai

 

© 2013 PHP TRAINING IN MUMBAI BY OM SIR . All rights resevered. Designed by OM SIR

Back To Top