I have 1TB size mysql database for production . Now i want to migrate this database on new mysql RDS instance . Please suggest me which backup policy should i apply here like Mysqldump,XtraBackup . ?

  • Depends on database complexity. Maybe simple structure backup + SELECT INTO OUTFILE/LOAD DATA INFILE will be the best solution. – Akina Jun 16 at 15:57
  • Can we restore Xtrabackup backup of Mysql to newly launched rds mysql instance ? – Uday Raj Gupta Jun 16 at 16:12
  • Please consult with your RDS support. – Akina Jun 16 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.