You can copy data from one MySQL table to another table. To do so both databases need to exist on the same account. If they do not, you will need to create a backup of one and move it. (If both databases have the same name, you will need to also rename one before moving).
Once both are on the same account, in your cPanel, under the heading Databases, click on phpMyAdmin.
- Click the SQL tab at the top. You will see where it says, 'Run SQL query/queries on server "localhost":'
- In
the text box below that, insert the following code, but replace DB1 and
DB2 with the database names. Also, replace TABLE1 with the table name
you are trying to merge.
INSERT INTO DB1.TABLE1 SELECT * FROM DB2.TABLE1
- Click the Go button.
- Repeat for any other tables you want to merge.
