Jump to content


Photo

Finding My Table Creation Code


  • Please log in to reply
3 replies to this topic

#1 MoFish

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,
PRIMARY KEY (id)
) TYPE=MyISAM; 

Thanks MoFish

#2 Guest_askjames01_*

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

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.

Ken

#4 Roberto

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