Creating tables for mysql

Profane · Post by **Profane** » Thu Apr 21, 2005 6:09 pm

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

Profane · Post by **Profane** » Thu Apr 21, 2005 6:16 pm

[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]

Profane · Post by **Profane** » Thu Apr 21, 2005 6:17 pm

Uhh, why cant u edit your posts? I tryed to edit it so i can disable smilies, shit...

Post by **Edge100x** » Thu Apr 21, 2005 6:24 pm

The edit function was abused by some posters when it was available, so we had to disable it. Ditto with the email and PM functions.

Nick|NFo · Post by **Nick|NFo** » Fri Apr 22, 2005 2:03 pm

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

Supernuker · Post by **Supernuker** » Fri Apr 22, 2005 2:17 pm

Hey Nick, you guys should add a auto-installer for that, it would be nice.

Profane · Post by **Profane** » Sun Apr 24, 2005 8:53 pm

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 · Post by **ReV|Donatello** » Sun Apr 24, 2005 9:15 pm

yea that would be cool and helpfull

Profane · Post by **Profane** » Tue Apr 26, 2005 6:28 pm

Uhh, so can someone install phpadmin for me, or uhh set it up, I already have it on the server, i just need it set up...

Profane · Post by **Profane** » Fri Apr 29, 2005 11:17 pm

Any Help!!??

bOoya · Post by **bOoya** » Fri Apr 29, 2005 11:35 pm

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.

Profane · Post by **Profane** » Wed May 04, 2005 5:17 pm

Well i went to the web help link, and filled out the form. They have yet to respond, its been a week.

Profane · Post by **Profane** » Wed May 04, 2005 5:41 pm

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!?!?

bOoya · Post by **bOoya** » Wed May 04, 2005 5:56 pm

website FTP password.

Profane · Post by **Profane** » Wed May 04, 2005 6:02 pm

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.

Server rentals :: NFOservers.com

Creating tables for mysql

Creating tables for mysql

Re: Creating tables for mysql

Re

Re

Bump

Re

re

Re

Re