Finding My Table Creation Code

[MoFish]

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

[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.

[kenrbnsn]

phpMyAdmin works fine under Windows, as well.

Ken

[Roberto]

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]