Jump to content
TonikCapGajah2013

Panduan: Memindahkan Website Localhost -> Webserver

By TonikCapGajah2013, in Pembangunan Web

Recommended Posts

SHiDi    0

SHiDi
Posted
@cyberfly, kalau web kau ada melibatkan database. Maka perlu dulu buat database. Kalau tak buat, memang tak dapat jalan. Tapi kalau site kau tak melibatkan database, tak buat settings pun tak apa.

Share this post

Link to post
Share on other sites

cyberfly    1

cyberfly
Posted

@cyberfly, kalau web kau ada melibatkan database. Maka perlu dulu buat database. Kalau tak buat, memang tak dapat jalan. Tapi kalau site kau tak melibatkan database, tak buat settings pun tak apa.

maknanya cara aku upload tu dah betul la?

aku dapat error ni bila import database guna Phpmyadmin dalm cPanel X

errorimportdo3.jpg

Agak2 kenapa ya?

aku tak follow betul2 step Powerroot sbb byk yg takde/tak jumpa cari dlm hosting qupis ni.

Share this post

Link to post
Share on other sites

amin007    1

amin007
Posted

maknanya cara aku upload tu dah betul la?

aku dapat error ni bila import database guna Phpmyadmin dalm cPanel X

errorimportdo3.jpg

Agak2 kenapa ya?

aku tak follow betul2 step Powerroot sbb byk yg takde/tak jumpa cari dlm hosting qupis ni.

sepanjang aku pindah dengan phpmyadmin

dari pc opis ke pc rumah ke website

ada kalanya scrip dalam *.sql tu ada yang silap

jadi aku syor ko mungkin kena edit balik *.sql

Share this post

Link to post
Share on other sites

cyberfly    1

cyberfly
Posted (edited)

Cuba ko tengok macamana nak pindah Joomla:

Mungkin ko boleh bandingkan.

http://forum.putera.com/tanya/t54217.html

ok.

hm..dah tgk n try tapi masih lagi error masa import sql....

EDIT:

hm...aku sbenarnya guna sqlyog...then aku dump database aku..so camne ye?

Edited by cyberfly

Share this post

Link to post
Share on other sites

amin007    1

amin007
Posted

hm..dah tgk n try tapi masih lagi error masa import sql....

EDIT:

hm...aku sbenarnya guna sqlyog...then aku dump database aku..so camne ye?

tengok kejap sql ko bentuk macam mana. paste kat sini

pelik ni :D

Share this post

Link to post
Share on other sites

cyberfly    1

cyberfly
Posted (edited)

tengok kejap sql ko bentuk macam mana. paste kat sini

pelik ni :D

amin,ni aku pastekan sql khas untuk ko :P

Spoiler :
/*

SQLyog Enterprise Trial - MySQL GUI v6.16

MySQL - 5.0.45-community-nt : Database - bowling2

************************************************************

*********

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `bowling2`;

USE `bowling2`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (

`adminID` varchar(10) NOT NULL default '',

`adminPass` varchar(10) NOT NULL default '',

PRIMARY KEY (`adminID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `admin` */

insert into `admin`(`adminID`,`adminPass`) values ('admin','admin');

/*Table structure for table `blok` */

DROP TABLE IF EXISTS `blok`;

CREATE TABLE `blok` (

`idBlok` int(3) NOT NULL auto_increment,

`namaBlok` varchar(20) NOT NULL default '',

PRIMARY KEY (`idBlok`)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `blok` */

insert into `blok`(`idBlok`,`namaBlok`) values (1,'Blok 1'),(2,'Blok 2'),(3,'Blok 3'),(4,'Blok 4'),(5,'Blok 5'),(6,'Blok 6');

/*Table structure for table `format` */

DROP TABLE IF EXISTS `format`;

CREATE TABLE `format` (

`idFormat` int(2) NOT NULL auto_increment,

`namaFormat` varchar(30) NOT NULL default '',

PRIMARY KEY (`idFormat`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `format` */

insert into `format`(`idFormat`,`namaFormat`) values (1,'4 Berpasukan'),(2,'Trio'),(3,'Double'),(4,'Single');

/*Table structure for table `format_peserta` */

DROP TABLE IF EXISTS `format_peserta`;

CREATE TABLE `format_peserta` (

`idFormatPeserta` int(10) NOT NULL auto_increment,

`idPeserta` int(10) NOT NULL default '0',

`idFormat` int(10) NOT NULL default '0',

PRIMARY KEY (`idFormatPeserta`)

) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=latin1;

/*Data for the table `format_peserta` */

insert into `format_peserta`(`idFormatPeserta`,`idPeserta`,`idFormat`) values (86,3,3),(87,3,4),(88,4,1),(89,4,2),(90,5,2),(91,5,4),(92,6,

4),(93,7,3),(94,7,4),(95,8,2),(96,8,3),(97,8,4),(98,9,1),(99,

9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(10

5,10,4);

/*Table structure for table `game` */

DROP TABLE IF EXISTS `game`;

CREATE TABLE `game` (

`idGame` int(2) NOT NULL auto_increment,

`jenisGame` varchar(20) NOT NULL default '',

PRIMARY KEY (`idGame`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `game` */

/*Table structure for table `jabatan` */

DROP TABLE IF EXISTS `jabatan`;

CREATE TABLE `jabatan` (

`idJabatan` int(3) NOT NULL auto_increment,

`namaJabatan` varchar(40) NOT NULL default '',

PRIMARY KEY (`idJabatan`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `jabatan` */

insert into `jabatan`(`idJabatan`,`namaJabatan`) values (1,'Unit Perancang Ekonomi Negeri'),(2,'Suruhanjaya Perkhidmatan Negeri'),(3,'Pejabat Pembangunan Air & Negeri Kelanta'),(4,'Pusat Maklumat Negeri');

/*Table structure for table `kategori` */

DROP TABLE IF EXISTS `kategori`;

CREATE TABLE `kategori` (

`idKategori` int(3) NOT NULL auto_increment,

`namaKategori` varchar(20) NOT NULL default '',

PRIMARY KEY (`idKategori`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `kategori` */

insert into `kategori`(`idKategori`,`namaKategori`) values (1,'VVIP'),(2,'VIP'),(3,'PEGAWAI'),(4,'STAFF');

/*Table structure for table `markah` */

DROP TABLE IF EXISTS `markah`;

CREATE TABLE `markah` (

`idMarkah` int(10) NOT NULL auto_increment,

`idPeserta` int(10) NOT NULL default '0',

`idPertandingan` int(10) NOT NULL,

`idFormat` int(10) NOT NULL,

`game1` int(10) default '0',

`game2` int(10) default '0',

`game3` int(10) default '0',

`game4` int(10) default '0',

`game5` int(10) default '0',

`game6` int(10) default '0',

`totalMarkah` int(10) NOT NULL default '0',

PRIMARY KEY (`idMarkah`)

) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

/*Data for the table `markah` */

insert into `markah`(`idMarkah`,`idPeserta`,`idPertandingan`,`idFormat`,`game1`,`game2`,`game3`,`game4`,`game5`,`game6`,`totalMarkah`) values (31,9,2,4,41,21,25,50,100,0,0),(32,4,2,1,21,25,0,0,0,0,0),(3

3,5,2,2,45,21,12,29,0,0,0);

/*Table structure for table `penguna` */

DROP TABLE IF EXISTS `penguna`;

CREATE TABLE `penguna` (

`idPenguna` int(3) NOT NULL auto_increment,

`username` varchar(40) NOT NULL default '',

`Name` varchar(40) NOT NULL default '',

`password_2` varchar(20) NOT NULL default '',

PRIMARY KEY (`idPenguna`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `penguna` */

insert into `penguna`(`idPenguna`,`username`,`Name`,`password_2`) values (4,'adduser','adduser','adduser'),(5,'aku','aku','aku');

/*Table structure for table `pertandingan` */

DROP TABLE IF EXISTS `pertandingan`;

CREATE TABLE `pertandingan` (

`idPertandingan` int(2) NOT NULL auto_increment,

`namaPertandingan` varchar(100) NOT NULL default '',

`tarikhPertandingan` varchar(10) NOT NULL default '',

`bilGame` int(10) NOT NULL,

`status` int(10) NOT NULL default '0',

PRIMARY KEY (`idPertandingan`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `pertandingan` */

insert into `pertandingan`(`idPertandingan`,`namaPertandingan`,`tarikhPertandingan`,`bilGame`,`status`) values (1,'Pertandingan Bowling 2007','23-11-2007',4,0),(2,'Pertandingan Bowling 2008','2-2-2008',5,1);

/*Table structure for table `peserta` */

DROP TABLE IF EXISTS `peserta`;

CREATE TABLE `peserta` (

`idPeserta` int(10) NOT NULL auto_increment,

`namaPeserta` varchar(100) NOT NULL default '',

`namaSamaran` varchar(10) NOT NULL default '',

`noKP` varchar(20) NOT NULL default '',

`idBlok` int(3) NOT NULL default '0',

`idJabatan` int(3) NOT NULL default '0',

`idKategori` int(3) NOT NULL default '0',

PRIMARY KEY (`idPeserta`),

KEY `idPeserta` (`idPeserta`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

/*Data for the table `peserta` */

insert into `peserta`(`idPeserta`,`namaPeserta`,`namaSamaran`,`noKP`,`idBlok`,`idJabatan`,`idKategori`) values (3,'Nor Adilah bt Khairi','adilah','860302-29-5883',6,4,4),(4,'Muhammad Fathur Rahman','fathur','860903-29-5883',6,4,1),(5,'Hafizi b. Hadi','piji','860103-29-5879',5,2,3),(6,'Kamal b. Ahmad','kamal','8801231-29-4563',6,1,1),(8,'Nurul Elanee bt. Osman','Ee','821213-45-7894',6,4,3),(9,'Liana bt. Mat Daud','Yana','841234-21-7894',6,4,3),(10,'Mohd Hisham b. Asri','Hisham','851234-21-4561',6,2,3);

/*Table structure for table `peserta_pertandingan` */

DROP TABLE IF EXISTS `peserta_pertandingan`;

CREATE TABLE `peserta_pertandingan` (

`idPeserta_Pertandingan` int(10) NOT NULL auto_increment,

`idPeserta` int(10) NOT NULL default '0',

`idPertandingan` int(10) NOT NULL default '0',

PRIMARY KEY (`idPeserta_Pertandingan`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `peserta_pertandingan` */

insert into `peserta_pertandingan`(`idPeserta_Pertandingan`,`idPeserta`,`idPertandingan`) values (1,3,2),(2,4,2),(3,5,2),(4,6,1),(5,7,2),(6,8,2),(7,9,2),(8,1

0,2);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

Edited by cyberfly

Share this post

Link to post
Share on other sites

amin007    1

amin007
Posted

aku cuba masuk dalam phpmyadmin

ini antara insert yang gagal masuk

/*Data for the table `format_peserta` */

insert into `format_peserta`(`idFormatPeserta`,`idPeserta`,`idFormat`) values (86,3,3),(87,3,4),(88,4,1),(89,4,2),(90,5,2),(91,5,4),(92,6,
4),(93,7,3),(94,7,4),(95,8,2),(96,8,3),(97,8,4),(98,9,1),(99
,
9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1
0
5,10,4);

/*Data for the table `markah` */
insert into `markah`(`idMarkah`,`idPeserta`,`idPertandingan`,`idFormat`,`game1`,`game2`,`game3`,`game4`,`game5`,`game6`,`totalMarkah`) values (31,9,2,4,41,21,25,50,100,0,0),(32,4,2,1,21,25,0,0,0,0,0),(3
3,5,2,2,45,21,12,29,0,0,0);


/*Data for the table `peserta_pertandingan` */

insert into `peserta_pertandingan`(`idPeserta_Pertandingan`,`idPeserta`,`idPertandingan`) values (1,3,2),(2,4,2),(3,5,2),(4,6,1),(5,7,2),(6,8,2),(7,9,2),(8,1
0,2);
salah satu sebabnya ada \n(enter ke bawah) pada 
9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1
0
5,10,4);

values (31,9,2,4,41,21,25,50,100,0,0),(32,4,2,1,21,25,0,0,0,0,0),(3
3,5,2,2,45,21,12,29,0,0,0);

(1,3,2),(2,4,2),(3,5,2),(4,6,1),(5,7,2),(6,8,2),(7,9,2),(8,1
0,2);

tu pasal gagal masuk

jadi .....

Share this post

Link to post
Share on other sites

cyberfly    1

cyberfly
Posted

so aku kena edit manual camni ke? :

dari :

9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1

0

5,10,4);

kepada :

9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1

05,10,4);

sorry la kalau soalan noob :P

Share this post

Link to post
Share on other sites

amin007    1

amin007
Posted

so aku kena edit manual camni ke? :

dari :

9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1

0

5,10,4);

kepada :

9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1

05,10,4);

sorry la kalau soalan noob :P

salah tu ko kena buat satu baris dalam kurungan

9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1

05,10,4);

kalau nak enter guna macam ni

(100,9,3),

(101,9,4),

(102,10,1),

(103,10,2),

(104,10,3),

(105,10,4);

tulah caranya, tapi leceh sikit kena edit

Share this post

Link to post
Share on other sites

cyberfly    1

cyberfly
Posted

salah tu ko kena buat satu baris dalam kurungan

9,2),(100,9,3),(101,9,4),(102,10,1),(103,10,2),(104,10,3),(1

05,10,4);

kalau nak enter guna macam ni

(100,9,3),

(101,9,4),

(102,10,1),

(103,10,2),

(104,10,3),

(105,10,4);

tulah caranya, tapi leceh sikit kena edit

ok nati aku try mlm ni..tapi mmg leceh la kena edit setiap kali aku dump yg baru :(

Share this post

Link to post
Share on other sites

cyberfly    1

cyberfly
Posted (edited)

aku dah berjaya import database aku.

tapi kenapa aku takleh view website aku lagi?

hm..

ni tempat aku upload.betul tak ni?and perlu ke fail index.html dlm folder SistemBowling2 aku?kalau index.php takleh?

rootzh5.jpg

@Powerroot,step kat bwh ni tuk web biasa (bukan joomla) pn kena buat ke?kalau camtu kena edit setiap page la?

268922jwsdb12.jpg

Edited by cyberfly

Share this post

Link to post
Share on other sites

TonikCapGajah2013    175

TonikCapGajah2013
Posted (edited)

awak buat dalam dreamweaver ker?

tak perlu edit setiap page. satu page sahaja (config.php)

page lain kalau perlu, include aje.

Edited by PowerRootTongkatAli_GS

Share this post

Link to post
Share on other sites

cyberfly    1

cyberfly
Posted

awak buat dalam dreamweaver ker?

tak perlu edit setiap page. satu page sahaja (config.php)

page lain kalau perlu, include aje.

guna dreamweaver.

hm..skrang ni setiap page ada connect tu..so kena buat include la ganti mysql_connect tu...

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...
×
Go To Topic Listing
×
×
  • Create New...