How to upload existing pictures to Aliyun oss?

used to use the image address stored in Aliyun oss,mysql, but now the outsourcing has closed down, and the Aliyun account does not know. Now you want to move all the saved pictures to your own Aliyun oss. What"s a good idea?

Jan.08,2022

write a script to download the photos stored in the database, upload them to your own Ali cloud, and then record them back to the database. It may take a long time to process the script, and it will also be affected by the speed of the network

.
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-1ea5535-1d4e.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-1ea5535-1d4e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?