|
|
|
|
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: 69
Joined: January 2001
|
|
|
Forums63
Topics37,575
Posts293,931
Members13,824
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
