Move a table from one database to another - MySQL

The reason for my lack of posting is directly related to the workload that I currenly have. A big project that I love working on had me consumed for the past 2 weeks, but within that time, I've learned a ton of new things and I'll be posting more about this in the coming days.

One of the first things I had to do for a project was move a few tables form different database together, into one database. It’s a simple enough command:

RENAME TABLE database1.table1 TO database2.table1;

Simple as that... Only catch is that both databases must be on the same filesystem.

If you need more details, read up on the MySQL documentation here.

Reply

The content of this field is kept private and will not be shown publicly.