检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Can I Delete the RDS for MySQL Backup Policy? Sorry, you cannot delete the RDS for MySQL backup policy. Once the backup policy is enabled, it cannot be disabled. You can change the backup retention days and backup cycle on the RDS console.
Failed to Delete a Table with a Foreign Key Scenario When an RDS for MySQL table with a foreign key is deleted, the following error message will be displayed, which is irrelevant to user permissions: ERROR 1451 (23000): Cannot delete or update parent row: a foreign key constraint
Locate the read replica to be deleted and click More > Delete in the Operation column. In the displayed dialog box, enter delete, select Yes for Confirm, select I have read this warning and understand the risks., and click Yes to deliver the request.
If you use delete from mysql.user to delete an account, you also need to run the flush privileges command to delete related data from the memory. Then, the account can no longer log in to the instance.
Solution set session foreign_key_checks=off; drop table table_name; To delete the table, set foreign_key_checks to off. Parent Topic: SQL Issues
You can use mysqldump to migrate data, or delete the DB instance and create a new one. Parent Topic: Version Upgrade
Locate the target parameter template to be deleted and choose More > Delete in the Operation column. In the displayed dialog box, click Yes. Parent Topic: Managing Parameter Templates
Possible Causes After the DELETE operation is performed, the background purge thread clears all records marked with a delete mark.
If you delete the frozen DB instance, the existing automated backups will also be deleted. You need to manually delete the existing manual backups. After all the backups are removed, the backup space will no longer be billed. Parent Topic: Backup and Restoration
RDS does not delete or perform any operations on any user data. If this problem occurs, check if there have been any misoperations and restore the data from backup files, if necessary.
Unsubscribing from a Yearly/Monthly Instance Scenarios To delete a DB instance billed on the yearly/monthly basis, you need to unsubscribe the order.
Deleting a Manual Backup Scenarios You can delete manual backups to free up backup storage. Constraints Deleted manual backups cannot be recovered. Manual backups that are being created cannot be deleted. Procedure Click in the upper left corner and select a region.
Then, click Delete in the Operation column. In the displayed dialog box, click OK to delete the task record. Click Delete in the Operation column. In the displayed dialog box, click OK to delete the task record.
To delete data of an entire table, run DROP or TRUNCATE. To delete part of table data, run DELETE and OPTIMIZE TABLE. If binlog files occupy too much space, clear local binlogs.
In the Mapping Rule area, locate the target rule and click Delete in the Operation column. Parent Topic: MySQL Memory Acceleration
On the displayed page, locate the target username and choose More > Delete in the Operation column. In the displayed dialog box, click OK.
On the Databases page, locate the target database and click Delete in the Operation column. In the displayed dialog box, click OK.
Solution To delete a user, run the drop command. Parent Topic: SQL Issues
If the multi-proxy function is enabled, you can delete the proxy. Billing After a database proxy is deleted, it is no longer billed. Procedure Click in the upper left corner and select a region.
To delete the DB instance, choose More > Delete in the Operation column. Ensure that the DB instance has been removed from the list. You are billed one hour after the resource usage is calculated, so a bill may still be generated after the pay-per-use resource is deleted.
