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..
0 comments:
Post a Comment
PHP Training Mumbai, PHP MySQL Training Mumbai, PHP Course Mumbai, PHP Institute Mumbai