SQL, Web Development Weddo Enna

[FoXm3D!A]

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

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​

 

[FoXm3D!A]

bump

gm thanks bn

 

[1118lakmalkumara]

rep dennako mokakkda free host eka machan

 

[FoXm3D!A]

rep dennako mokakkda free host eka machan

baaaaaaaaaaaaaaaaa GM

Heliohost.org

and

Serversfree.com​

 

[kellsupun]

gm thanks bn

very very g.m

 

[The_Killer]

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.

--
-- 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 */;

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.

 

[pramix2011]

free server ake awlak wenna athi ban

 

[FoXm3D!A]

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.

--
-- 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 */;

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.

ela balamu try karala

 

[FoXm3D!A]

bump

thanks

free server ake awlak wenna athi ban

ane manda bn epa wenawa

 

[davidfrost]

Thanks Machan!

 

[nrjayasinghe]

උඩට

 

[kolavari]

Free hosting kohomath awulne bro..eke mysql nadda danne na? 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 un dan hena sawutthui ban..unge server wala dan site 1000 ganan host karala inne...thawa un daanna ida na wena hoda ekak balapan ban..

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