SQL, Web Development Weddo Enna

FoXm3D!A

Well-known member
  • Dec 23, 2012
    2,157
    239
    63
    Matara
    php-mysql-wordpress.jpg


    machanla mama podi wordpress site ekak heduwa localhost eke ai eka online host ekata danna kiyala heduwe eth database import karanna baa mehema error ekak enawa

    attachment.php


    MySQL said:

    #1146 - Table 'foxmedia_cbro.wp_commentmeta' doesn't exist

    ah aluthenma database create karala import karapu gama sql offline yanawa
    itapasse tika welawak yanakan me error enawa phpmyadmin load novi

    Error

    SQL query: Edit Edit

    SET CHARACTER SET 'utf8';

    MySQL said:

    #2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    The server is not responding (or the local server's socket is not correctly configured)

    kohomada machanla me error eka fix karala site eka host ekata daganne
    help me machanla loku udawwak


    me host eka hebei free ekak eth man wena free host ehekata demma ekenam sql elata import una mata wediyen dena ganna one "man meka hostgator host ekak aran danna inne ethakotath me awla ewida"

    localhost eke pana dagena hadala me wage error ekak awama epa wenawa

    danne nethi kastiya ahaka balan yanne nethuwa bump karanna rep dennam
     

    Attachments

    • Capte.JPG
      Capte.JPG
      64.1 KB · Views: 240
    Last edited:
    • Like
    Reactions: kellsupun

    The_Killer

    Well-known member
  • Jan 20, 2014
    11,053
    2,199
    113
    WA, Straya 🇦🇺🦘
    www.elakiri.com
    Hostgator hodai. Danatanam awulak naa. Mulinma DB eke data structure eka localhost walin export karaganna. Eka karanne mehemai.

    Source: http://support.hostgator.com/articles/specialized-help/technical/exporting-a-mysql-database-via-phpmyadmin

    Single table ekak select kara ganna epa. Mulu okkoma tables export karaganna. Eta passe e structure eka web server eke mysql panel eken import kara ganna. Mathaka athuwa menna me sql query tika add karaganna file ekata.

    Untitled.jpg


    Code:
    --
    -- Database: `<db_name>`
    --
    
    [COLOR="DarkRed"]CREATE DATABASE IF NOT EXISTS <db_name>;
    USE <db_name>;
    
    SET FOREIGN_KEY_CHECKS=0;[/COLOR]
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `<table_name>`
    --
    
    
    code
    code
    code
    code
    
    
    <bottom of the mysql dump>
    [COLOR="DarkRed"]SET FOREIGN_KEY_CHECKS=1;[/COLOR]
    
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

    Untitled.jpg


    Oya final file eka web server ekata import karanna kalin nikan blank database ekak hadanna <db_name> eka daala.

    Mama dan test run ekak damma. Mama WP database nam work karanne naa. But mehema karala up kalahama ara oyage 'unknown table' error eka enne naa. Mama passe kiyannam kohomada eka hari yanne kiyala.

    Mama lankawe newei inne. Ithin nidimathai. Udeta comment ekak dannamko. ;)

    Hope this works for you. Fingers crossed. :sorry:

     
    • Like
    Reactions: FoXm3D!A

    FoXm3D!A

    Well-known member
  • Dec 23, 2012
    2,157
    239
    63
    Matara
    Hostgator hodai. Danatanam awulak naa. Mulinma DB eke data structure eka localhost walin export karaganna. Eka karanne mehemai.

    Source: http://support.hostgator.com/articles/specialized-help/technical/exporting-a-mysql-database-via-phpmyadmin

    Single table ekak select kara ganna epa. Mulu okkoma tables export karaganna. Eta passe e structure eka web server eke mysql panel eken import kara ganna. Mathaka athuwa menna me sql query tika add karaganna file ekata.

    Untitled.jpg


    Code:
    --
    -- Database: `<db_name>`
    --
    
    [COLOR="DarkRed"]CREATE DATABASE IF NOT EXISTS <db_name>;
    USE <db_name>;
    
    SET FOREIGN_KEY_CHECKS=0;[/COLOR]
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `<table_name>`
    --
    
    
    code
    code
    code
    code
    
    
    <bottom of the mysql dump>
    [COLOR="DarkRed"]SET FOREIGN_KEY_CHECKS=1;[/COLOR]
    
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

    Untitled.jpg


    Oya final file eka web server ekata import karanna kalin nikan blank database ekak hadanna <db_name> eka daala.

    Mama dan test run ekak damma. Mama WP database nam work karanne naa. But mehema karala up kalahama ara oyage 'unknown table' error eka enne naa. Mama passe kiyannam kohomada eka hari yanne kiyala.

    Mama lankawe newei inne. Ithin nidimathai. Udeta comment ekak dannamko. ;)

    Hope this works for you. Fingers crossed. :sorry:


    ela balamu try karala
     

    kolavari

    Well-known member
  • Aug 11, 2012
    33,746
    1
    25,653
    113
    කැළෑ පොජ්ජේ
    Free hosting kohomath awulne bro..eke mysql nadda danne na? :baffled: mul error eke nam kiyanne table eka naha kiyalane...database eka export karaddi create table statements nathiwada export wela thiyenne kiyla balanna? nattam aye database ekak create karala import karala balanna..

    wena hosting ekakata giyoth nam ohoma wenne na..hostgator shape ithin..eth mala jarawak :sorry: un dan hena sawutthui ban..unge server wala dan site 1000 ganan host karala inne...thawa un daanna ida na :no: wena hoda ekak balapan ban..

    bluehost ehema hodai mama danna tharamin..nattam vps ekak ganna :D mata nam shared hosting allannema na :oo: