Creating tables for mysql
-
- Compulsive poster
- Posts: 71
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Fri Feb 18, 2005 8:26 pm
- Location: Washington - Bonney Lake
- Contact:
Creating tables for mysql
Okay, there is this calendar block thing, it comes with its own administration panel and everything and i want it on my site right. So as im installing I get everything done except the Create tables for it, as i do not know how to do that! It comes with a .sql file and that contatins the tables that need to be created. Here is the contents:
# Table structure for table 'nuke_4ncal'
#
CREATE TABLE nuke_4ncal (
eid bigint(20) NOT NULL auto_increment,
aid varchar(30) NOT NULL,
title varchar(150),
time datetime,
hometext blob,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (eid)
);
#
# Dumping data for table 'nuke_4ncal'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_4ncal_wait'
#
CREATE TABLE nuke_4ncal_wait (
qid bigint(20) NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) NOT NULL,
title varchar(150) NOT NULL,
story blob,
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
topic varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (qid)
);
#
# Dumping data for table 'nuke_4ncal_wait'
#
____________________________________________________________
I've had problems in the past about craeting tables as well, you guys just told me to use phpmyadmin or something, I tryed to install that, and i cant get it to work.... so help me, my email is ajflora007@hotmail.com
the website is teamss.nuclearfallout.net i think the server is seattlestars.nuclearfallout.net
Thanks
# Table structure for table 'nuke_4ncal'
#
CREATE TABLE nuke_4ncal (
eid bigint(20) NOT NULL auto_increment,
aid varchar(30) NOT NULL,
title varchar(150),
time datetime,
hometext blob,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (eid)
);
#
# Dumping data for table 'nuke_4ncal'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_4ncal_wait'
#
CREATE TABLE nuke_4ncal_wait (
qid bigint(20) NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) NOT NULL,
title varchar(150) NOT NULL,
story blob,
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
topic varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (qid)
);
#
# Dumping data for table 'nuke_4ncal_wait'
#
____________________________________________________________
I've had problems in the past about craeting tables as well, you guys just told me to use phpmyadmin or something, I tryed to install that, and i cant get it to work.... so help me, my email is ajflora007@hotmail.com
the website is teamss.nuclearfallout.net i think the server is seattlestars.nuclearfallout.net
Thanks
-
- Compulsive poster
- Posts: 71
- Joined: Fri Feb 18, 2005 8:26 pm
- Location: Washington - Bonney Lake
- Contact:
Re: Creating tables for mysql
[quote="Profane"]Okay, there is this calendar block thing, it comes with its own administration panel and everything and i want it on my site right. So as im installing I get everything done except the Create tables for it, as i do not know how to do that! It comes with a .sql file and that contatins the tables that need to be created. Here is the contents:
# Table structure for table 'nuke_4ncal'
#
CREATE TABLE nuke_4ncal (
eid bigint(20) NOT NULL auto_increment,
aid varchar(30) NOT NULL,
title varchar(150),
time datetime,
hometext blob,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (eid)
);
#
# Dumping data for table 'nuke_4ncal'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_4ncal_wait'
#
CREATE TABLE nuke_4ncal_wait (
qid bigint(20) NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) NOT NULL,
title varchar(150) NOT NULL,
story blob,
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
topic varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (qid)
);
#
# Dumping data for table 'nuke_4ncal_wait'
#
____________________________________________________________
I've had problems in the past about craeting tables as well, you guys just told me to use phpmyadmin or something, I tryed to install that, and i cant get it to work.... so help me, my email is ajflora007@hotmail.com
the website is teamss.nuclearfallout.net i think the server is seattlestars.nuclearfallout.net
Thanks[/quote]
# Table structure for table 'nuke_4ncal'
#
CREATE TABLE nuke_4ncal (
eid bigint(20) NOT NULL auto_increment,
aid varchar(30) NOT NULL,
title varchar(150),
time datetime,
hometext blob,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (eid)
);
#
# Dumping data for table 'nuke_4ncal'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_4ncal_wait'
#
CREATE TABLE nuke_4ncal_wait (
qid bigint(20) NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) NOT NULL,
title varchar(150) NOT NULL,
story blob,
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
topic varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (qid)
);
#
# Dumping data for table 'nuke_4ncal_wait'
#
____________________________________________________________
I've had problems in the past about craeting tables as well, you guys just told me to use phpmyadmin or something, I tryed to install that, and i cant get it to work.... so help me, my email is ajflora007@hotmail.com
the website is teamss.nuclearfallout.net i think the server is seattlestars.nuclearfallout.net
Thanks[/quote]
you need to install the sql file by using phpmyadmin, http://www.phpmyadmin.net
its a free download, install that on your webspace and you can manage your mysql
its a free download, install that on your webspace and you can manage your mysql
-Nick
-
- This is my homepage
- Posts: 314
- Joined: Thu Jan 08, 2004 8:28 pm
-
- Compulsive poster
- Posts: 71
- Joined: Fri Feb 18, 2005 8:26 pm
- Location: Washington - Bonney Lake
- Contact:
Re
Yes, u guys should make a auto installer for that. I have been told to install this phpadminmod thing or what ever, a thousand times. I have tryed a million times. I just can't cause it wont work....
- ReV|Donatello
- This is my homepage
- Posts: 103
- Joined: Thu Nov 11, 2004 4:25 pm
- Location: Upland, California
- Contact:
Sometimes its usefull to use the search feature of these forums.
http://rentalforums.nuclearfallout.net/ ... php?t=1808
Also note that the webspace is provided as a free service to you. There are so many different things that can go wrong when people try to install programs incorrectly that it is logistically impossible for us to provide free in-depth support for the webspace service. If you cannot get something working after exausting all other possible resources, feel free to stop by http://web.nuclearfallout.net and request help.
http://rentalforums.nuclearfallout.net/ ... php?t=1808
Also note that the webspace is provided as a free service to you. There are so many different things that can go wrong when people try to install programs incorrectly that it is logistically impossible for us to provide free in-depth support for the webspace service. If you cannot get something working after exausting all other possible resources, feel free to stop by http://web.nuclearfallout.net and request help.
Last edited by bOoya on Fri Apr 29, 2005 11:40 pm, edited 1 time in total.
-
- Compulsive poster
- Posts: 71
- Joined: Fri Feb 18, 2005 8:26 pm
- Location: Washington - Bonney Lake
- Contact:
Re
Your MySQL account can be accessed from your webspace using the hostname of localhost, database name of (edited out), username of (Edited out), and your current password. It can also be accessed from the game server with the same information but a hostname of mysql.nuclearfallout.net. It is version 4.0.x.
The bolded part is the most stupid thing ever, "And your current password" My current password to what, the Sites Ftp, or the Servers Ftp, Or my sites admin login pass, or the Nuclear Fallout server Control Panel Pass.... whitch is it!?!?
The bolded part is the most stupid thing ever, "And your current password" My current password to what, the Sites Ftp, or the Servers Ftp, Or my sites admin login pass, or the Nuclear Fallout server Control Panel Pass.... whitch is it!?!?
-
- Compulsive poster
- Posts: 71
- Joined: Fri Feb 18, 2005 8:26 pm
- Location: Washington - Bonney Lake
- Contact:
Re
Thank you so much.
I'll let you all know if i get it working, and for any other veiwers reading this, The support team at nuclear fallout is awsome, dont let my frustration fool you. I love these guys.
I'll let you all know if i get it working, and for any other veiwers reading this, The support team at nuclear fallout is awsome, dont let my frustration fool you. I love these guys.