mySQL table or better new database

[mcibor]

I have a large database, which is used only in part. Therefore I want to place the records that are not so needed in another place.

The question is:

Would it be better to place those records in a new database, or just another table will be enough to take weight from the mysql?

Which way would be faster?

Thanks for any help!

[dmorison]

Just using another table will be fine. Tables are just files on disk to MySQL; the quantity of data has no impact on performance until you come to query it.

[mcibor]

Thanks!

Tell me just. How can I move one record from one table to another, that has the same structure?

[freeflight2]

INSERT INTO Table_other SELECT * FROM Original_Table WHERE row=id_of_a_row_you_want_to_copy

once that succeeds you can delete the row from the original table

[coopster]

Every once in awhile you may want to then OPTIMIZE [dev.mysql.com] that table.