|
|
Joined: Feb 2002
Posts: 2,286
Veteran
|
Veteran
Joined: Feb 2002
Posts: 2,286 |
Hi, Can anyone help me with this. Should be fairly simple and I have tried select * from w3t_Groups into w3t_Groups_Master without joy. I need to make a backup of w3t_Groups before I start fiddling with it  Thanks.
Fans Focus - Focusing on Fans of Sport (Okay - mainly football (the British variety at the moment - but expanding all the time....)
|
|
|
|
Joined: May 2001
Posts: 550
Code Monkey
|
Code Monkey
Joined: May 2001
Posts: 550 |
<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 />
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
or use phpMyAdmin and do Operations and there is a MOVE, COPY, RENAME, etc command 
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 190
Joined: June 2000
|
|
Forums63
Topics37,571
Posts293,923
Members13,848
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|