[SOLVED] table data

[dink87522]

This is probably a noob question, but how do I extract the data from a MYSQL table? I.e. if I have a table with 1000 rows and columns of data how do I take that from table 1 and put it into table 2 on a new server etc.

[ratcateme]

create a new table to the same specs and then use this

INSERT INTO `tablea`
SELECT *
FROM `tabelb` ;

i would recommended downloading php mysql admin it is really good at doing stuff like that.

 

Scott.

[dink87522]

I just found how to export my database. Thanks.