Jump to content

Archived

This topic is now archived and is closed to further replies.

MoFish

Finding My Table Creation Code

Recommended Posts

hello, im wanting to shift my website over to another web-server.
the actuall content im not worryed about, actually im looknig forward to a fresh start.

is there anyway I can generate my current tables SQL creation code (like below)? or do i need to manually go through them all typing them all out.

[code]
CREATE TABLE comment (
uname varchar(20) NOT NULL default '',
ucomment longtext NOT NULL,
ip varchar(20) NOT NULL default '',
time varchar(50) NOT NULL default '',
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
[/code]

Thanks MoFish

Share this post


Link to post
Share on other sites
Guest askjames01
are you migrating under linux or windows server?

If you are using linux then you can use PHPADMIN.

or if you are under windows then surely there is a tool for creating table
automatically without bothering you for retyping those codes.
Just look for that tool in it.

Share this post


Link to post
Share on other sites
phpMyAdmin works fine under Windows, as well.

Ken

Share this post


Link to post
Share on other sites
phpMyAdmin and do this for you and works on both Linux and Windows - [a href=\"http://www.phpmyadmin.net\" target=\"_blank\"]http://www.phpmyadmin.net[/a]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.