Jump to content
crv82

X Tau Nak Upload Database Kat Hosting

Recommended Posts

salam...

sy dah upload sume file kat hosting utk website saya ni...

so sy nak tanyer ni....kalu yg database tu camner ek?

sy gune easyphp...mysql....jadi camner nk buat ye?kena install kat hosting tu ker?pastu camner lak ngan tables yg dah ader tu?kalu install mesti jd database baru kan?seblum ni sy try copy jer file easyphp tu,xjd.

so camner yer?leh tlg bgtau caranya x? :lol: tq

Share this post


Link to post
Share on other sites

bro.. ade gune phpmyadmin tak? kalau ade.. buka..

masuk kat databse yg nak digunakan.. click kat export/mysql..

export data kepada mysql format.. ada byk option tapi amik mysql format..

and die akan save as namafileygandaberi.sql.. icon mcm txt file.

pastu kat host anda... buka phpmyadmin..

create database yg nama same mcm database anda di localhost..

import data.. browse dan cari namafileygandaberi.sql anda

sumer table dan data2 akan diimport kedalam database baru anda..

Sekian.. Selamat Hari Raya

Edited by lipas

Share this post


Link to post
Share on other sites

errr..alamak pas,ko ckp laju sgt laa

ok,dah msuk phpmyadmin....then masuk table kan pastu export.

kat export tu amik sql.

pastu bile klik go die kuar ni

-- phpMyAdmin SQL Dump

-- version 2.6.1

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Oct 17, 2007 at 03:03 PM

-- Server version: 4.1.9

-- PHP Version: 4.3.10

--

-- Database: `yik`

--

-- --------------------------------------------------------

--

-- Table structure for table `takwim1`

--

-- Creation: Sep 20, 2007 at 08:56 AM

-- Last update: Sep 25, 2007 at 02:52 PM

--

CREATE TABLE `takwim1` (

`news` varchar(100) default NULL,

`tarikh` varchar(10) default NULL

) TYPE=MyISAM;

--

-- Dumping data for table `takwim1`

--

INSERT INTO `takwim1` VALUES ('Peperiksaan PMRU', '19-9-2007');

INSERT INTO `takwim1` VALUES ('Peperiksaan PMR', '1-10-2007');

INSERT INTO `takwim1` VALUES ('Peperiksaan SPM', '1-11-2007');

nak tanyer,bile kuar camni,then mane nak tau file.sql tu save katner?

pastu kat hosting tu kena install easyphp ker?

btul2 blurr nii....tlg ye pas terang detail skit....tq:)

Share this post


Link to post
Share on other sites

Copy pastu paste kat Notepad atau apa apa text editor dan save sebagai *.sql. * tu gantikan dengan nama apa pun. Sebelum tu pastikan hosting kau support PHP dan MySQL. Kau tak boleh nya nak install easyPHP kat hosting tu, melainkan ada root access.

Kalau host kau support PHP & MySQL aku jamin dia ada install phpMyAdmin. Buka page tu dan pilih import. Pastu upload file SQL tadi tu.

Share this post


Link to post
Share on other sites

-- phpMyAdmin SQL Dump

-- version 2.6.1

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Oct 17, 2007 at 03:03 PM

-- Server version: 4.1.9

-- PHP Version: 4.3.10

--

-- Database: `yik`

--

-- --------------------------------------------------------

--

-- Table structure for table `takwim1`

--

-- Creation: Sep 20, 2007 at 08:56 AM

-- Last update: Sep 25, 2007 at 02:52 PM

--

CREATE TABLE `takwim1` (

`news` varchar(100) default NULL,

`tarikh` varchar(10) default NULL

) TYPE=MyISAM;

--

-- Dumping data for table `takwim1`

--

INSERT INTO `takwim1` VALUES ('Peperiksaan PMRU', '19-9-2007');

INSERT INTO `takwim1` VALUES ('Peperiksaan PMR', '1-10-2007');

INSERT INTO `takwim1` VALUES ('Peperiksaan SPM', '1-11-2007');

eh die tak save .sql plak.. sori..

ko copy sumer kat atas tu.. save dlm .txt file...

pastu ko sambung dari line 5 post pertama aku.. huhu.. semoga berjaya

Share this post


Link to post
Share on other sites

Copy pastu paste kat Notepad atau apa apa text editor dan save sebagai *.sql. * tu gantikan dengan nama apa pun. Sebelum tu pastikan hosting kau support PHP dan MySQL. Kau tak boleh nya nak install easyPHP kat hosting tu, melainkan ada root access.

Kalau host kau support PHP & MySQL aku jamin dia ada install phpMyAdmin. Buka page tu dan pilih import. Pastu upload file SQL tadi tu.

err...camner nk tau hosting tu support ke x?sy try cari phpMyAdmin tu tp xder laa.die x support kut..... :unsure:

Copy pastu paste kat Notepad atau apa apa text editor dan save sebagai *.sql. * tu gantikan dengan nama apa pun. Sebelum tu pastikan hosting kau support PHP dan MySQL. Kau tak boleh nya nak install easyPHP kat hosting tu, melainkan ada root access.

Kalau host kau support PHP & MySQL aku jamin dia ada install phpMyAdmin. Buka page tu dan pilih import. Pastu upload file SQL tadi tu.

err...camner nk tau hosting tu support ke x?sy try cari phpMyAdmin tu tp xder laa.die x support kut..... :unsure:

Share this post


Link to post
Share on other sites

err...camner nk tau hosting tu support ke x?sy try cari phpMyAdmin tu tp xder laa.die x support kut..... :unsure:

Guna la phpinfo() tengok MySQL ada ke tidak. B)

Share this post


Link to post
Share on other sites

err..td google pastu jumpe ni sini

pastu die kuar...php version 5.2.1.....

so makne nyer die support la ekk?? :blush:

Itu maknanya dia support PHP. Cuba tengok version MySQL pula.

tapi kan kalu die support mane nak cari phpMyAdmin tu ekk? :unsure:

Biasanya phpMyAdmin ni dah pre-installed oleh host provider kau. Cuba je tengok kat Cpanel. B)

Share this post


Link to post
Share on other sites

Itu maknanya dia support PHP. Cuba tengok version MySQL pula.

naper nk tau version mysql tu?utk aper?

Biasanya phpMyAdmin ni dah pre-installed oleh host provider kau. Cuba je tengok kat Cpanel.

err...control panel 2 katner ?kat notebook ni ker?

Share this post


Link to post
Share on other sites

naper nk tau version mysql tu?utk aper?

err...control panel 2 katner ?kat notebook ni ker?

At least kalau ada muncul version apa, maknanya ada la MySQL.

Mana aku tau mana control panel tu. Bergantung pada host provider kau. B)

Share this post


Link to post
Share on other sites

naper nk tau version mysql tu?utk aper?

err...control panel 2 katner ?kat notebook ni ker?

cpanel 2 kre server website ko r..

*katekn name website ko www.abc.com.... so ko taip je r url www.abc.com/cpanel

pastu msukkn r username n password

kt c 2 blh upload file tp gne ftp pn blh..

cme kt c panel ni da ade phpmyadmin...

so ko blh import je database yg ko da eksport td...

Share this post


Link to post
Share on other sites

cpanel 2 kre server website ko r..

*katekn name website ko www.abc.com.... so ko taip je r url www.abc.com/cpanel

pastu msukkn r username n password

saya dah try wat tp xdapat laa.die kuar page cannot be found....yg masukkan username ngan password tu nak masukkan kat maner?

gudsp336,ader cara lain lagi tak? :rolleyes:

Share this post


Link to post
Share on other sites

saya dah try wat tp xdapat laa.die kuar page cannot be found....yg masukkan username ngan password tu nak masukkan kat maner?

gudsp336,ader cara lain lagi tak? :rolleyes:

xleh? hmmm... bsenye kalo taip www.abc.com/cpanel ...

die akn automatik trus jd url ni http://www.abc.com:2082 ..

ble da blh access die trus kuar tuk msukkn username n password

Share this post


Link to post
Share on other sites

so,camner yer...adr jalan lain lagi tak? :unsure:

aku xsure r...

mgkn konye web hosting xgne cpanel..

cbe bce maklumat yg die bg..

gne ftp blh gak..

cnth software ftp: ftp now

Share this post


Link to post
Share on other sites

Aku rasa soalan paling penting, hosting tu ada Cpanel atau tidak?

aku sokong pendapat shidi tu.

website ko tu hosting kat mana?

lain hosting, lain bentuk cpanelnya.

aku punya cpanel pun lain.

PowerRootTongkatAli_GS punya cpanel lain sikit.

Share this post


Link to post
Share on other sites

try guna program ftp plak.

ko punya URL apa ek?

PowerRootTongkatAli_GS ,sy dah try ftp tp xleh access lak..die ckp mcm ni

'window cannot access this folder.make sure you type the file name correctly and that u hav permission to access the folder'

url sy sini

:unsure:

eh,silap.... url saye yg ni

Share this post


Link to post
Share on other sites

PowerRootTongkatAli_GS ,sy dah try ftp tp xleh access lak..die ckp mcm ni

'window cannot access this folder.make sure you type the file name correctly and that u hav permission to access the folder'

url sy sini

:unsure:

eh,silap.... url saye yg ni

Oho.... website kau kira sub-domain kelantan.gov.my. Macam tu cuba ftp ftp.kelantan.gov.my atau try buka cpanel kelantan.gov.my/cpanel B)

EDIT: nampaknya directory Cpanel aku bagi tu tak wujud. So cara lain tinggal, kau try ftp atau ssh atau telnet B)

Edited by SHiDi

Share this post


Link to post
Share on other sites

dah try ftp tp xleh access...

telnet plak kuar mcm ni....

Microsoft Telnet> o kelantan.gov.my

Connecting To kelantan.gov.my...Could not open connection to the host, on port 23.

A connection attempt failed because the connected party did not properly respond after a

period of time, or established connection failed because connected host has failed to res

pond.

mcm xde jln lain dah niii..... :unsure:

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...