Net2FTP and phpMyAdmin

[heymrdj]

I need to set up a mysql database for Net2FTP. Thing is I know squat about it :classic2:. Can anyone tell me how to get this


#
# Table structure for table `net2ftp_logAccess`
#

CREATE TABLE net2ftp_logAccess (
date date NOT NULL default '0000-00-00',
time time NOT NULL default '00:00:00',
remote_addr text NOT NULL,
remote_port text NOT NULL,
http_user_agent text NOT NULL,
page text NOT NULL,
ftpserver text NOT NULL,
username text NOT NULL,
state text NOT NULL,
manage text NOT NULL,
directory text NOT NULL,
file text NOT NULL,
http_referer text NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `net2ftp_logError`
#

CREATE TABLE net2ftp_logError (
date date NOT NULL default '0000-00-00',
time time NOT NULL default '00:00:00',
ftpserver text NOT NULL,
username text NOT NULL,
message text NOT NULL,
cause text NOT NULL,
drilldown text NOT NULL,
state text NOT NULL,
manage text NOT NULL,
directory text NOT NULL,
debug1 text NOT NULL,
debug2 text NOT NULL,
debug3 text NOT NULL,
debug4 text NOT NULL,
debug5 text NOT NULL,
remote_addr text NOT NULL,
remote_port text NOT NULL,
http_user_agent text NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `net2ftp_logLogin`
#

CREATE TABLE net2ftp_logLogin (
date date NOT NULL default '0000-00-00',
time time NOT NULL default '00:00:00',
ftpserver text NOT NULL,
username text NOT NULL,
remote_addr text NOT NULL,
remote_port text NOT NULL,
http_user_agent text NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `net2ftp_logConsumptionFtpserver`
#

CREATE TABLE net2ftp_logConsumptionFtpserver (
date date NOT NULL default '0000-00-00',
ftpserver varchar(255) NOT NULL default '0',
dataTransfer int(10) unsigned default '0',
executionTime mediumint(8) unsigned default '0',
PRIMARY KEY (date,ftpserver)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `net2ftp_logConsumptionIpaddress`
#

CREATE TABLE net2ftp_logConsumptionIpaddress (
date date NOT NULL default '0000-00-00',
ipaddress varchar(15) NOT NULL default '0',
dataTransfer int(10) unsigned default '0',
executionTime mediumint(8) unsigned default '0',
PRIMARY KEY (date,ipaddress)
) TYPE=MyISAM;


into a mysql datbase. I know its noobish but I honestly can't figure it out. More about this can be seen here. http://www.net2ftp.com/homepage/installation.html

[felguard]

Make a database, then go to phpmyadmin and enter that in the query.

[heymrdj]

Hehe, worked like a charm, thx alot man. Now I can execute custom MySql. I learn a little more each day ;)

[felguard]

No prob, glad to be of help.