Java implements how to back up the table AA of database An on server a to database B on server b and change the name of the table to bb,. The database is mysql.

now there is database An on a server, in which there is a table aa, that needs to back up the data in this table aa to database B of server b, and the name of the table should be changed from bb, database to mysql, framework to springmvc, data source Druid, database connection using springaop switch. How can this function be realized?

Mar.20,2021

databus canal you can search for information

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e516f9-4514e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e516f9-4514e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?