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: 2575 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

Previous Topic

Index

Next Topic

Hop to:

Latest Posts

[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM

[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM

Shout Box

May
Su	M	Tu	W	Th	F	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

(Views)Popular Topics

Known public proxy servers	1689885
Integrated Index Page (IIP) 5.3.1	555705
Finished-[6.5.2] Games Arcade Deluxe v1.9	501236
Integrated Index Page (IIP) 5.1.1	415112
TLD Bv2.1 Released - Threads Links Directory	396822
[6.0x] Who's Online 4.0.0 [Finished]	389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5	330423
Q & A	298663
Slash UBB	266936
[6.3.x] [beta] Hit Hack 2.0	227970

Forum Stats

13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM