copying a table

You are not logged in. [Log In] ubbDev » Forums » Community Development » HTML, CSS, Programming and MySQL
» MySQL and Server Configuration » copying a table

Topic Options

#285522 - 06/10/05 01:17 PM copying a table
Ian_W Veteran Registered: 02/22/02 Posts: 2570 Loc: England	Hi,<br /><br />Can anyone help me with this. Should be fairly simple and I have tried<br /><br />select * from w3t_Groups into w3t_Groups_Master<br /><br />without joy.<br /><br />I need to make a backup of w3t_Groups before I start fiddling with it <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /><br /><br />Thanks. _________________________ Fans Focus - Focusing on Fans of Sport (Okay - mainly football (the British variety at the moment - but expanding all the time....)
Top

#285523 - 06/10/05 02:29 PM

Re: copying a table [Re: Gorlum]

Anno

Code Monkey

Registered: 05/23/01
Posts: 562
Loc: Austria

Code:

 <br />CREATE TABLE `w3t_Groups_Master` (<br />`G_Name` varchar( 250 ) default NULL ,<br />`G_Id` int( 4 ) unsigned NOT NULL AUTO_INCREMENT ,<br />`G_Disabled` int( 1 ) unsigned default '0',<br />PRIMARY KEY ( `G_Id` )<br />) TYPE = MYISAM ;<br /><br />INSERT INTO `w3t_Groups_Master`<br />SELECT *<br />FROM `w3t_Groups` ;<br /><br />

_________________________
Subforums for UBBThreads
PF-Tek for Simple Minds
Mushrooms
Gobe

Top

#285524 - 06/10/05 03:11 PM Re: copying a table [Re: domain123]
scroungr Old Hand Registered: 10/17/03 Posts: 2409 Loc: Richmond, VA	or use phpMyAdmin and do Operations and there is a MOVE, COPY, RENAME, etc command <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> _________________________ Couchtomatoe - www.couch-tomatoe.cc My abilities are for hire for installs, upgrades, custom themes and custom modifications.
Top