 Table Duplication, How to do it with phpMyadmin |
|
|
|
|
  |
  Aug 1 2005, 10:13 PM
Post
#1
|
|
|
Member [Level 2]  Group: Members Posts: 86 Joined: 18-July 05 From: Lithuania Member No.: 9,570  |
So how can I dublicate table to the same database
using phpMyadmin? I realy do not want do the almost the same table specially then table has many colums. Or maybe it's inposible  (actualy I don't think so)
|
 |
 
|
|
Aug 1 2005, 10:27 PM
Post
#2
|
|
|
Advanced Member Group: Members Posts: 147 Joined: 2-June 05 From: Klass-World Member No.: 7,802 |
u can't have 2 tables with the same name in the same db.
Not sure what your trying to do. Could you explain it a little clearer? |
|
|
|
|
Aug 1 2005, 10:50 PM
Post
#3
|
|
|
$p4m 0n j00 $h4m3 m3 0nc3 $p4m 0n m3 $h4m3 m3 7\/\/1c3 Group: [HOSTED] Posts: 6,444 Joined: 21-September 04 From: 9r33|\| 399$ 4|\|D 5P4/\/\ Member No.: 1,218  |
you can't its that simple, because all you will be doing in overriding the orignal table so just a create a new table to solve your problem.
|
|
|
|
|
Aug 2 2005, 02:37 AM
Post
#4
|
|
|
Super Member Group: Members Posts: 372 Joined: 14-October 04 Member No.: 1,736 |
Yes you can. First, you select the database that the table is in, then click on the table that you want to copy (you can go to Browse, Structure, or just about any of the others), then click on Operations toward the top. Once you click on it, under Copy Table to, select the database that you want it to be copied to, then type in the table name that the data will be copied to. Once you enter that, if you're wanting to just copy the structure (the column names) select Structure Only. If you want the structure and the data, select Structure and Data, and if you just want the data, select Data Only. If you have an auto incrementing column, you can select Add AUTO_INCREMENT value, then click Go. The data should now be copied to the database and table that you selected. I hope that helped.
|
|
|
|
 Aug 2 2005, 04:52 AM
Post
#5
|
|
|
Member [Level 2] Group: Members Posts: 86 Joined: 18-July 05 From: Lithuania Member No.: 9,570 |
QUOTE(Hamtaro @ Aug 2 2005, 04:37 AM) Yes you can. First, you select the database that the table is in, then click on the table that you want to copy (you can go to Browse, Structure, or just about any of the others), then click on Operations toward the top. Once you click on it, under Copy Table to, select the database that you want it to be copied to, then type in the table name that the data will be copied to. Once you enter that, if you're wanting to just copy the structure (the column names) select Structure Only. If you want the structure and the data, select Structure and Data, and if you just want the data, select Data Only. If you have an auto incrementing column, you can select Add AUTO_INCREMENT value, then click Go. The data should now be copied to the database and table that you selected. I hope that helped.  Thanx Hamatro it's exactly what I was asking for  Thank you for very clear explanation. Trap17 is the first host where I started use ppMyadmin so thats wy I have problem when I need do more specific operations with databases  P.S. Klass & Saint_Michael sorry for my unclear question, but I know that you CAN'T have the same file with the same name in the same place (same table in the same database in may case). |
|
|
|
|
Mar 27 2008, 03:38 PM
Post
#6
|
|
|
Trap Double Mocha Member Group: Members Posts: 2,360 Joined: 21-September 07 Member No.: 50,369 |
Thanks for the MySql info!
Table Dublication Replying to Hamtaro Hi, I was surfing looking for an easy way to copy tables because I have 18 small tables that only vary by name (used by different people). Your explanation save me a lot of time. Thanks. Tiki -reply by Tiki |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 6th September 2008 - 05:35 AM |