Dynadot Aftermarket: discover domain gems worth investing in. Visit our aftermarket.

MySql Help

SpaceshipSpaceship
SpaceshipSpaceship
SpaceshipSpaceship
Watch

Xerox

Account Closed
Impact
0
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','[URL={THUMBURL}][IMG]{IMAGEURL}[/IMG][/URL]','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
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?
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
Try:

/*!40101 SET CHARACTER SET 'latin1' */;
 
0
Close
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
#
 
0
Close
DomainEasy: flexible LTO options. Close more domain deals with financing.

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

Filters for activity feeds
Your news feed, Latest activity, and the activity tab on profiles now have filter buttons: All, Posts, Quick replies, and Other. Your...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back