473,326 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Postgre to MySQL problem

142 100+
Hi

The code below I took from a postgre file and convert it with a program to a mysql. Once i tried to import it to mysql it gave me an error and when i past in a php file to upload it trough a php file it stats I have loaded the information into the DB but i don't see any tables in the DB.

Here is the code as it comes from my plain *.txt file. Any suggestions?

CREATE TABLE categories (
record int(11) auto_increment NOT NULL,
category varchar(100),
description text,
picture varchar(100),
`type` varchar(1)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE subcategories (
record int(11) auto_increment NOT NULL,
subcategory varchar(100),
description text,
categoryid int(11),
picture varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE images (
record int(11) auto_increment NOT NULL,
title varchar(100),
description text,
subcategoryid int(11),
`type` varchar(1),
picture varchar(100),
thumbnail varchar(100),
`position` int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE posters (
record int(11) auto_increment NOT NULL,
title varchar(100),
description text,
`type` varchar(1),
picture varchar(100),
`position` int(11),
thumbnail varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE bannerads (
record int(11) auto_increment NOT NULL,
description text,
hyperlink varchar(50),
email varchar(30),
adtype varchar(10),
picture varchar(100),
thumbnail varchar(100),
loaded bigint
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE payments (
record int(11) auto_increment NOT NULL,
fullname varchar(100),
address text,
city varchar(50),
postalcode varchar(8),
email varchar(100),
contactnum varchar(15),
product varchar(10),
productid int(11),
prsize varchar(20),
prframe varchar(20),
price varchar(10),
trsuc int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE users (
record int(11) auto_increment NOT NULL,
surname varchar(50),
firstname varchar(50),
username varchar(20),
`password` text,
confirm text,
registerdate bigint,
active varchar(1),
avatarid int(11),
signature text,
url text,
email varchar(100),
showemail varchar(1),
isadmin varchar(1),
avatar varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE avatars (
record int(11) auto_increment NOT NULL,
image varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE forums (
record int(11) auto_increment NOT NULL,
name varchar(100),
description text,
lastdate bigint,
lastposter int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE posts (
record int(11) auto_increment NOT NULL,
forumid int(11),
userid int(11),
subject text,
date bigint,
replies int(11),
message text,
parent int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE smilies (
record int(11) auto_increment NOT NULL,
image varchar(100),
code varchar(10),
emotion varchar(20)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE basket (
record int(11) auto_increment NOT NULL,
price double precision,
product varchar(10),
size varchar(20),
frame varchar(20),
pic int(11),
qty int(11),
userid varchar(6),
sel int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE orders (
record int(11) auto_increment NOT NULL,
userid varchar(6),
referencenr varchar(20),
date bigint,
paid varchar(1),
countryid int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE addresses (
record int(11) auto_increment NOT NULL,
listid int(11),
email varchar(50)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE lists (
record int(11) auto_increment NOT NULL,
name varchar(50)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE newsletteritems (
record int(11) auto_increment NOT NULL,
newsletterid int(11),
heading varchar(100),
bgcolor int(11),
item text,
image varchar(60),
columnno int(11),
rowno int(11),
pos int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE newsletters (
record int(11) auto_increment NOT NULL,
date bigint,
heading varchar(30)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE medialogon (
record int(11) auto_increment NOT NULL,
username varchar(50),
`password` varchar(50),
publication_name varchar(50),
city varchar(50),
country varchar(50),
firstname varchar(50),
surname varchar(50),
email varchar(50),
active varchar(1),
confirmhash varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE calendars (
record int(11) auto_increment NOT NULL,
title varchar(100),
image varchar(100),
`position` int(11),
price double precision,
thumbnail varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE calendarimages (
record int(11) auto_increment NOT NULL,
title varchar(100),
calendarid int(11),
image varchar(100),
`position` int(11),
thumbnail varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE whatsnew (
record int(11) auto_increment NOT NULL,
title varchar(100),
description text,
date bigint,
link text
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE capitalsound (
record int(11) auto_increment NOT NULL,
mpic varchar(100),
subpic1 varchar(100),
subpic2 varchar(100),
subpic3 varchar(100),
capsound varchar(100),
brianemm varchar(100),
lshow varchar(100),
tpic1 varchar(100),
tpic2 varchar(100),
tpic3 varchar(100),
tpic4 varchar(100),
tpic5 varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE capitalsub (
record int(11) auto_increment NOT NULL,
category varchar(100),
pic varchar(100)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE shopcats (
record int(11) auto_increment NOT NULL,
name varchar(50),
description text,
parent int(11)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE shopimages (
record int(11) auto_increment NOT NULL,
title varchar(100),
description text,
catid int(11),
picture varchar(100),
`position` int(11),
thumbnail varchar(100),
price double precision
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE article (
record int(11) auto_increment NOT NULL,
date bigint,
title text,
article text,
thumbnail text
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE newsletter (
record int(11) auto_increment NOT NULL,
date bigint,
title varchar(100),
article text
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE classcats (
record int(11) auto_increment NOT NULL,
parent int(11),
description text,
name varchar(50)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE classmodel (
record int(11) auto_increment NOT NULL,
title varchar(100),
description text,
catid int(11),
picture varchar(100),
`position` int(11),
thumbnail varchar(100),
price double precision,
contactperson varchar(50),
email varchar(50)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE orderitems (
record int(11) auto_increment NOT NULL,
price double precision,
product varchar(10),
size varchar(20),
frame varchar(20),
pic int(11),
qty int(11),
orderid varchar(6)
, PRIMARY KEY(`record`)
) TYPE=MyISAM;

CREATE TABLE phpbb_auth_access (
group_id int(11) DEFAULT 0 NOT NULL,
forum_id smallint DEFAULT 0,
auth_view smallint DEFAULT 0,
auth_read smallint DEFAULT 0,
auth_post smallint DEFAULT 0,
auth_reply smallint DEFAULT 0,
auth_edit smallint DEFAULT 0,
auth_delete smallint DEFAULT 0,
auth_sticky smallint DEFAULT 0,
auth_announce smallint DEFAULT 0,
auth_vote smallint DEFAULT 0,
auth_pollcreate smallint DEFAULT 0,
auth_attachments smallint DEFAULT 0,
auth_mod smallint DEFAULT 0
) TYPE=MyISAM;
Nov 16 '06 #1
1 1712
webandwe
142 100+
Hi

The coding for the mysql was to long, i put it on a html page and uploaded to this link:

http://www.websitedesignlab.co.za/msql.html

Kind Regards
Wevbandwe
Nov 16 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Jason Tesser | last post by:
I am looking into using PostgreSQL on the backend here. I work for a Bible College. We are putting together a new software package. The database would be on a LInux box but our domain is M$ so we...
38
by: Kilmer C. de Souza | last post by:
Hi, I am a new user of PostgreSQL and there are some questions about its performance in a scenario with a high requisition rate Lets picture an imaginary scenario: In my system (Debian...
4
by: Brandon | last post by:
Is there a call redirector available that redirects the calls to the PHP MySql API (mysql_connect etc.) to a Postgre database? This would be very usefull since a lot of PHP Scripts are coded for...
1
exoskeleton
by: exoskeleton | last post by:
Hi guys...need help here ... My problem is about pagination like <<PREV 1,2,3,4,5,6 NEXT>> Does LIMIT Function applicable in PostgreSQL? $SQL="SELECT * FROM TABLE1 LIMIT 0,5"; the sql above...
1
by: nilart | last post by:
Hi, I have an installer application (Installshield) which installs postgre DB programmatically on windows: I have a requirement where postgre DB is expected work after upgrading OS from windows XP...
2
by: dvelst | last post by:
Hi All, I have the following query which was based on a working query in MySQL: (don't be afraid of the size of the query you see below, later on I will concentrate on part of this query) ...
1
by: RRahul | last post by:
Hi, I am a database professional but have never used Postgre. My client was exploring the posiblity of using Postgre instead of Mysql and wnated to know the comments from the community. I waned...
0
Shashi Sadasivan
by: Shashi Sadasivan | last post by:
I have been working on this project using Ms Sql server, and been using the strongly typed datasets. Now due to major changes happening (which was never supposed to occour) the windows seerver will...
4
by: lion cave | last post by:
Hi, I have a problem regarding on making function in postgre. I am newbie for this. My problem is that i want to make a function in postgre that accepts the name of the table. In the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.