COPY a table in MySQL

[dragon2309]

Does anyone know the SQL code to be able to copy a table structure over to a new table or an existing table, im a bit stuck.....

dragon2309

 

[dragon2309]

*^^->bump<-^^*

 

[dragon2309]

*^^->bump<-^^*

 

[Xycron]

Try downloading a backup of it then uploading it with a prefix? I'm not to good with MySQL or anything..I've only seen/used it a couple times with simple things....

btw i like how the site and what the forum theme is in your sig.

 

[dragon2309]

oh thanks, thats not the site i was talking about though, and i made that theme for the forum...... the site im talking about was a personal business site that i own/manage.

 

[myinnet]

You can do that in PHPMyAdmin.

 

[dragon2309]

aaah, thanks, yeh, it works in there, i never knew it was that simple, thanks a lot,,,,

 

[Xycron]

Thats what I ment in phpmyadmin, I guess I left that important peice out haha.

 

[dragon2309]

lol, yeh, that would have been nice, lol