NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Programming
Reload this Page MySql Help

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.

Advanced Search


Closed Thread
 
LinkBack Thread Tools
Old 12-22-2005, 01:10 PM THREAD STARTER               #1 (permalink)
Account Suspended
 
Xerox's Avatar
Join Date: Nov 2005
Posts: 47
Xerox is an unknown quantity at this point
 

MySql Help

Hello.
I am installing a script taht requires me to import the sql file to PhpMyAdmin

here is the file
Code:
# MySQL-Front 3.2  (Build 2.16)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET '' */;


# Host: localhost    Database: image
# ------------------------------------------------------
# Server version 4.0.20a-nt

#
# Table structure for table coppon
#

CREATE TABLE `coppon` (
  `id` int(10) NOT NULL auto_increment,
  `coppon` varchar(100) NOT NULL default '',
  `used` tinyint(1) NOT NULL default '0',
  `uid` int(10) NOT NULL default '0',
  `credits` int(10) NOT NULL default '0',
  `ip` varchar(100) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Table structure for table groups
#

CREATE TABLE `groups` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `bandwidth` int(6) default NULL,
  `sizelimit` int(10) default NULL,
  `filetype` varchar(255) default NULL,
  `credits` int(6) default NULL,
  `common` tinyint(1) default '0',
  `applet` tinyint(1) default '0',
  `thumb` tinyint(1) default NULL,
  `fee` varchar(20) default '0',
  `maxfiles` int(10) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table groups
#

INSERT INTO `groups` VALUES (1,'basic',500000,800000,'gif,jpeg,jpg,png,bmp,tif',20,1,1,1,'0',10);
INSERT INTO `groups` VALUES (2,'Golden',5000000,555555,'jpg,png,tiff,tif,gif,bmp',200,1,1,1,'5.00',100);
INSERT INTO `groups` VALUES (5,'Super',1111111111,6000000,'jpg,zip,gif,png,tif,tiff,png',500,1,1,1,'10',100);

#
# Table structure for table images
#

CREATE TABLE `images` (
  `id` int(10) NOT NULL auto_increment,
  `file` varchar(250) NOT NULL default '',
  `name` varchar(250) NOT NULL default '',
  `uid` int(10) default '0',
  `width` int(10) NOT NULL default '0',
  `height` int(10) NOT NULL default '0',
  `size` int(10) NOT NULL default '0',
  `ip` varchar(20) default NULL,
  `extra` varchar(250) NOT NULL default '',
  `time` int(12) NOT NULL default '0',
  `views` int(10) default '0',
  `bandwidth` int(10) default '0',
  `lastview` int(11) default NULL,
  `server_id` int(11) default NULL,
  `deleted` tinyint(1) default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table images
#

#
# Table structure for table links
#

CREATE TABLE `links` (
  `id` tinyint(6) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `code` mediumtext NOT NULL,
  `filetype` mediumtext NOT NULL,
  `enable` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table links
#

INSERT INTO `links` VALUES (1,'Auction/Website Code','<img src=\"{IMAGEURL}\" alt=\"Free Image Hosting at\" />','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (2,'Clickable Auction/Website Code','<a href=\"{IMAGEURL}\" target=\"_blank\"><img src=\"{THUMBURL}\" alt=\"Free Image Hosting at\" /></a>','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (3,'Clickable Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (4,'Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (6,'Direct Linking Code','{IMAGEURL}','jpg,bmp,jpeg,png,tiff,gif,zip,tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (7,'Direct Thumb Linking Code','{THUMBURL}','jpg,jpeg,png,tiff,gif,bmp',1);
INSERT INTO `links` VALUES (8,'Show your image to your friends','{ADSURL}','jpg,jpeg,tiff,png,bmp,gif,zip,tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (9,'Show your Flash!','<embed src=\"{IMAGEURL}\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"{WIDTH}\" height=\"{HEIGHT}\"></embed>   ','swf',1);

#
# Table structure for table payment
#

CREATE TABLE `payment` (
  `pay_id` int(11) unsigned NOT NULL auto_increment,
  `txn_id` varchar(100) default NULL,
  `uid` int(11) default NULL,
  `descr` varchar(255) default NULL,
  `fee` int(11) default NULL,
  `credits` int(11) default NULL,
  `date` int(11) default NULL,
  PRIMARY KEY  (`pay_id`)
) TYPE=MyISAM;

#
# Dumping data for table payment
#

#
# Table structure for table server
#

CREATE TABLE `server` (
  `server_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `domain` varchar(255) default NULL,
  `webspace` int(11) default NULL,
  `hosted` int(11) default NULL,
  `ftp` varchar(255) default NULL,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `path` text,
  `enabled` tinyint(1) default '0',
  PRIMARY KEY  (`server_id`)
) TYPE=MyISAM;

#
# Dumping data for table server
#

INSERT INTO `server` VALUES (1,'127.0.0.1/server','127.0.0.1/server',24978907,156,'','','','',1);

#
# Table structure for table setting
#

CREATE TABLE `setting` (
  `filetype` varchar(250) NOT NULL default '',
  `sizelimit` int(10) default NULL,
  `maxbandwidthbyday` varchar(25) NOT NULL default '0',
  `adminemail` varchar(100) NOT NULL default '',
  `credit` tinyint(6) default NULL,
  `maxfiles` int(10) default '1',
  `applet` tinyint(1) default '1',
  `common` tinyint(1) default '1',
  `t_width` int(11) default '100',
  `t_height` int(11) default '100',
  `thumb` tinyint(1) default '0',
  `validate` tinyint(1) default '0',
  `pagenum` tinyint(4) default '10',
  `showmode` tinyint(1) NOT NULL default '0',
  `banip` mediumtext,
  `sitename` varchar(200) default NULL,
  `server` varchar(11) default '0',
  `minviews` int(11) default NULL,
  `deldays` int(6) default NULL,
  `admin` varchar(32) default NULL,
  `pass` varchar(255) default NULL,
  `sandbox` tinyint(4) default '1',
  `paypal_address` varchar(255) default NULL,
  `email_links` mediumtext,
  `email_reg` mediumtext,
  `email_purchase` mediumtext,
  `email_getpassword` mediumtext
) TYPE=MyISAM;

#
# Dumping data for table setting
#

INSERT INTO `setting` VALUES ('jpg,zip,tif,bmp,jpeg,gif,png,swf,tiff',6000000,122220000,'',1,10,1,1,150,150,1,1,10,1,'','site','0',1,30,'admin','123',1,'changeme@emailcom','{linkcode}','    \r\nEmail:{username}\r\nPassword:{password}\r\n\r\nYou need to actvate your Account first:\r\n<a href=\"{validate_url}\">Acivate Account</a>\r\nor Paste below url in your browser:\r\n{validate_url}','\r\n{process_details}','Email:{username}\r\nPassword:{password}');

#
# Table structure for table tmpuser
#

CREATE TABLE `tmpuser` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `sess` varchar(32) default NULL,
  `type` int(1) default '0',
  `gid` int(6) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table tmpuser
#

#
# Table structure for table users
#

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `email` varchar(30) default NULL,
  `pics` int(10) default '0',
  `bandwidth` int(10) default '0',
  `webspace` int(10) default '0',
  `credits` int(10) default '0',
  `gid` tinyint(4) default NULL,
  `status` tinyint(4) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table users
#

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
and i am getting this error
????: NamePros.com http://www.namepros.com/programming/150422-mysql-help.html
????: NamePros.com http://www.namepros.com/showthread.php?t=150422
Code:
  SQL query:

/*!40101 SET CHARACTER SET '' */

MySQL said: Documentation
#1115 - Unknown character set: ''
Can anyone help me?

Ok i have removed the line and it worked.
Will this make a error im my Script?
Xerox is offline  
Old 12-22-2005, 05:09 PM   #2 (permalink)
mch
NamePros Regular
Join Date: Nov 2005
Location: EU
Posts: 248
mch is on a distinguished road
 
Try:

/*!40101 SET CHARACTER SET 'latin1' */;
mch is offline  
Old 12-22-2005, 10:53 PM   #3 (permalink)
jdk
Senior Member
 
jdk's Avatar
Join Date: Jul 2004
Location: Florida
Posts: 1,492
jdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond reputejdk has a reputation beyond repute
 
Try this:

Code:
# Host: localhost    Database: image
# ------------------------------------------------------
# Server version 4.0.20a-nt

#
# Table structure for table coppon
#

CREATE TABLE `coppon` (
  `id` int(10) NOT NULL auto_increment,
  `coppon` varchar(100) NOT NULL default '',
  `used` tinyint(1) NOT NULL default '0',
  `uid` int(10) NOT NULL default '0',
  `credits` int(10) NOT NULL default '0',
  `ip` varchar(100) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Table structure for table groups
#

CREATE TABLE `groups` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `bandwidth` int(6) default NULL,
  `sizelimit` int(10) default NULL,
  `filetype` varchar(255) default NULL,
  `credits` int(6) default NULL,
  `common` tinyint(1) default '0',
  `applet` tinyint(1) default '0',
  `thumb` tinyint(1) default NULL,
  `fee` varchar(20) default '0',
  `maxfiles` int(10) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table groups
#

INSERT INTO `groups` VALUES (1,'basic',500000,800000,'gif,jpeg,jpg,png,bmp,tif  ',20,1,1,1,'0',10);
INSERT INTO `groups` VALUES (2,'Golden',5000000,555555,'jpg,png,tiff,tif,gif,b  mp',200,1,1,1,'5.00',100);
INSERT INTO `groups` VALUES (5,'Super',1111111111,6000000,'jpg,zip,gif,png,tif  ,tiff,png',500,1,1,1,'10',100);

#
# Table structure for table images
#

CREATE TABLE `images` (
  `id` int(10) NOT NULL auto_increment,
  `file` varchar(250) NOT NULL default '',
  `name` varchar(250) NOT NULL default '',
  `uid` int(10) default '0',
  `width` int(10) NOT NULL default '0',
  `height` int(10) NOT NULL default '0',
  `size` int(10) NOT NULL default '0',
  `ip` varchar(20) default NULL,
  `extra` varchar(250) NOT NULL default '',
  `time` int(12) NOT NULL default '0',
  `views` int(10) default '0',
  `bandwidth` int(10) default '0',
  `lastview` int(11) default NULL,
  `server_id` int(11) default NULL,
  `deleted` tinyint(1) default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table images
#

#
# Table structure for table links
#

CREATE TABLE `links` (
  `id` tinyint(6) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `code` mediumtext NOT NULL,
  `filetype` mediumtext NOT NULL,
  `enable` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table links
#

INSERT INTO `links` VALUES (1,'Auction/Website Code','<img src=\"{IMAGEURL}\" alt=\"Free Image Hosting at\" />','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (2,'Clickable Auction/Website Code','<a href=\"{IMAGEURL}\" target=\"_blank\"><img src=\"{THUMBURL}\" alt=\"Free Image Hosting at\" /></a>','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (3,'Clickable Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (4,'Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (6,'Direct Linking Code','{IMAGEURL}','jpg,bmp,jpeg,png,tiff,gif,zip,  tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (7,'Direct Thumb Linking Code','{THUMBURL}','jpg,jpeg,png,tiff,gif,bmp',1);  
INSERT INTO `links` VALUES (8,'Show your image to your friends','{ADSURL}','jpg,jpeg,tiff,png,bmp,gif,zip  ,tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (9,'Show your Flash!','<embed src=\"{IMAGEURL}\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"{WIDTH}\" height=\"{HEIGHT}\"></embed>   ','swf',1);

#
# Table structure for table payment
#

CREATE TABLE `payment` (
  `pay_id` int(11) unsigned NOT NULL auto_increment,
  `txn_id` varchar(100) default NULL,
  `uid` int(11) default NULL,
  `descr` varchar(255) default NULL,
  `fee` int(11) default NULL,
  `credits` int(11) default NULL,
  `date` int(11) default NULL,
  PRIMARY KEY  (`pay_id`)
) TYPE=MyISAM;

#
# Dumping data for table payment
#

#
# Table structure for table server
#

CREATE TABLE `server` (
  `server_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `domain` varchar(255) default NULL,
  `webspace` int(11) default NULL,
  `hosted` int(11) default NULL,
  `ftp` varchar(255) default NULL,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `path` text,
  `enabled` tinyint(1) default '0',
  PRIMARY KEY  (`server_id`)
) TYPE=MyISAM;

#
# Dumping data for table server
#

INSERT INTO `server` VALUES (1,'127.0.0.1/server','127.0.0.1/server',24978907,156,'','','','',1);

#
# Table structure for table setting
#

CREATE TABLE `setting` (
  `filetype` varchar(250) NOT NULL default '',
  `sizelimit` int(10) default NULL,
  `maxbandwidthbyday` varchar(25) NOT NULL default '0',
  `adminemail` varchar(100) NOT NULL default '',
  `credit` tinyint(6) default NULL,
  `maxfiles` int(10) default '1',
  `applet` tinyint(1) default '1',
  `common` tinyint(1) default '1',
  `t_width` int(11) default '100',
  `t_height` int(11) default '100',
  `thumb` tinyint(1) default '0',
  `validate` tinyint(1) default '0',
  `pagenum` tinyint(4) default '10',
  `showmode` tinyint(1) NOT NULL default '0',
  `banip` mediumtext,
  `sitename` varchar(200) default NULL,
  `server` varchar(11) default '0',
  `minviews` int(11) default NULL,
  `deldays` int(6) default NULL,
  `admin` varchar(32) default NULL,
  `pass` varchar(255) default NULL,
  `sandbox` tinyint(4) default '1',
  `paypal_address` varchar(255) default NULL,
  `email_links` mediumtext,
  `email_reg` mediumtext,
  `email_purchase` mediumtext,
  `email_getpassword` mediumtext
) TYPE=MyISAM;

#
# Dumping data for table setting
#

INSERT INTO `setting` VALUES ('jpg,zip,tif,bmp,jpeg,gif,png,swf,tiff',6000000,1  22220000,'',1,10,1,1,150,150,1,1,10,1,'','site','0  ',1,30,'admin','123',1,'changeme@emailcom','{linkc  ode}','    \r\nEmail:{username}\r\nPassword:{password}\r\n\r\  nYou need to actvate your Account first:\r\n<a href=\"{validate_url}\">Acivate Account</a>\r\nor Paste below url in your browser:\r\n{validate_url}','\r\n{process_details}  ','Email:{username}\r\nPassword:{password}');

#
# Table structure for table tmpuser
#

CREATE TABLE `tmpuser` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `sess` varchar(32) default NULL,
  `type` int(1) default '0',
  `gid` int(6) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table tmpuser
#

#
# Table structure for table users
#

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `email` varchar(30) default NULL,
  `pics` int(10) default '0',
  `bandwidth` int(10) default '0',
  `webspace` int(10) default '0',
  `credits` int(10) default '0',
  `gid` tinyint(4) default NULL,
  `status` tinyint(4) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table users
#
__________________
All offers are valid for 12 hours unless otherwise stated.
jdk is offline  
Closed Thread

« PHP help-weird characters problem | mod rewrite with subdomains »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Great Scripts for Sale With Resale Rights! Zeeble Scripts For Sale 20 01-04-2006 02:39 AM
MySQL Tips shahid_146 Webmaster Tutorials 4 10-18-2005 01:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows deadserious Webmaster Tutorials 35 09-21-2005 10:46 PM
HOW TO: Use shell to control MySQL. abdulmueid Webmaster Tutorials 16 08-27-2005 09:17 AM
Tutorial: Getting Started With MySQL (The Basics) deadserious Webmaster Tutorials 3 04-18-2004 02:17 PM

Liquid Web Smart Servers  
All times are GMT -7. The time now is 06:35 AM.

Contact Us - NamePros.com - Privacy Statement - Top
Managed Web Hosting by Liquid Web
Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger