Web Site ekak host karana hati step by step [Part 5]

delmar

Well-known member
  • Oct 29, 2007
    27,269
    3,861
    113
    හැමතැනම
    Web Site ekak host karana hati step by step [Part 5] - Database - MySQL

    Related Posts : Part I | Part II | Part III | Part IV |


    Machanla,
    Tika dawasakata passé onna ayemath mee thread ekata aluth lesson ekak daannawa.


    Ada mama kiyala denna yanne web site ekaka wadagathma deyak gana.

    Eeka thamai

    Databases


    Web site walata ena users lage data save karaganna, eewa update karanna, Elakiri eka wage forum wala wada karanna, databases use karanawa.
    Elakiri eka eekata hodata example ekak.
    Elakiri eke oyala chat karanawa hada deyakma database wala save wenawa kiwwoth oyala wiswaasa karanawada?
    Ow.aththatama hama deyakma save wenawa.

    Elakiri eke use karala thiyana vBulletin wagema, Joomla, Wordpress wage hama ekakatama Database use karanawa.

    Ithin web site wala Database walata use karanne MySQL kiyana database jaathiyai.MySQL kiyanne open source Database system ekak.


    Mama kalin kiwwa wage Joomla, vBulletin wage script install karanna kalin oyala ee script eka run wenna mySQL database ekak create karanna oona.

    Eeka create karanne oyalage cPanel eke “Database” kiyana section eke thiyana “phpmyadmin” kiyana link eken.


    Eeta passé mee wage page ekak enawa.
    27ypf7n.jpg

    Meeka thamai phpMyAdmin Home Page eka.

    Ithin Yaaluwane api mulinma balamu aluthen Database ekak create karana widiya.


    Database ekak create karanna harima leesie.
    phpMyAdmin home page eke thiyanawa “ MySQL Localhost” kiyana heading eka yatathee “Create New database” kiyala.
    Eeken database ekata name ekak deela “Create” kiyana button eka press karanna.
    9i4n40.jpg

    Dan oyalage Database eka create wuna.

    33etx7a.jpg

    Eta passé page eken kiyanawa database ekata table add karaganna kiyala.

    But, oyala script ekak use karanna mee database eka haduwanam table add karanna oone na.ee script eken automatic table create karana nisai.

    Ehema nathnam table name eka enter karala “Number of fields “kiyana ekata oyalata create karaganna oona fileds gaana deela “Go” karanna.
    Eeta passé enne e fields walata data enter karannai.
    j9u7u8.jpg

    [ ee step eke godak advanced eewa tikak thiynawa.Ithin eewa okkoma gana dammoth Beginners lata theerenne nathi nisa eewa gana Basic ekak witharak daannam.Wadi wisthara oona aya mata PM ekak daanna.]


    Eeke “Field” kiyana ekata Field name eka denna.
    Type kiyana eken ahanne e field ekata enter karana data type ekai
    “INT” – Numbers
    “VARCHAR” – Variable Characters
    Ithuru tika oyala dannawane.
    “Length” eken e field eke length eka denna.
    Ithuru eewa tikanam godak wadagath na.
    Eewa gana dana ganna oonenam mata PM ekak daanna.
    Eeta passé oyata e edit karapu data database ekata save karaganna pahala thiyana “Go” button eka click karanna.

    Anthimatama mama kiyala dennam wena site ekakin hari m oyalage computer eke “localhost” ekenhari create karagaththa database ekak methanata add karanne kohomada kiyala.

    Mulinma oyalage phpMyAdmin home page ekata yanna.
    Eeke toolbar eke thiyana “Import” kiyana tab eka click karanna.
    Eeta passé oyala Text file eka widiyata hari MYSQL type ekata download karagaththa db eka select karala “Go” karnna.


    Yaaluwane, mama mee oyalata kiyala dunne phpMyAdmin walin 10% witharai.Thawa godak deewal thiyanawa.
    Oyalata oona thawa deewal thiyanawanam mata PM ekak daanna. Mama kiyala dennam



    mee thread eka daanna mata idea eka deepu tigooota mama mee welawe thank you kiyala kiyanawa.

    Hodai kiyala hithenawanam rep ekak deela comment ekak daala yanna.
     
    Last edited:

    delmar

    Well-known member
  • Oct 29, 2007
    27,269
    3,861
    113
    හැමතැනම
    meke data base ekak creat karanna thanak naaaa neeeee dila........

    Mulinma oya cPanel ekata log wenna(cPanel eka kiyanne web site eke control panel eka)..
    eeke "Databases" kiyana section eka yatathee thiyanawa."MySQL Database wizard" kiyana eka use karala hada ganna.
    eeke 1st step ekata datasabe name ekak denna.
    eeta passe e database ekata username & password denna.
    eeta passe "ALL PRIVILEGES" kiyana cheack box eka select karanna.
    next karanna.
    dan database eka created!!!
     

    mcwolfe

    Well-known member
  • Jul 24, 2011
    6,919
    838
    113
    උබ ගොඩක් මහන්සි වෙලා බන්. රෙප්+ දෙන්නම ඕන