Jump to content


Finding My Table Creation Code

  • Please log in to reply
3 replies to this topic

#1 MoFish

  • Members
  • PipPipPip
  • Advanced Member
  • 210 posts

Posted 26 April 2006 - 06:38 PM

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.

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,

Thanks MoFish

#2 Guest_askjames01_*

  • Guests

Posted 26 April 2006 - 07:27 PM

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.

#3 kenrbnsn

  • Staff Alumni
  • Advanced Member
  • 8,235 posts
  • LocationHillsborough, NJ, USA

Posted 26 April 2006 - 07:29 PM

phpMyAdmin works fine under Windows, as well.


#4 Roberto

  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationLondon, England

Posted 26 April 2006 - 07:30 PM

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]
Mad Mouse Media Web Design
t: (+34) 610 837 558
e: rob@madmousemedia.co.uk
w: www.madmousemedia.co.uk
w: www.madmouseart.com *************************************

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users