All Questions
Tagged with amazon-rds restore
4 questions with no upvoted or accepted answers
1
vote
0
answers
3k
views
how to dump mysql schema without keys and without constraint ? and keep all of them to alter afterwards
i am using ubuntu 16.04 and want to dump large schema with hounded of tables from AWS rds, remove all keys and foreign key , load data and then add back the keys , is there any automatic tool that ...
- 163
1
vote
2
answers
223
views
Multiple DB restore in sequence
I am restoring several MariaDB databases into a Amazon AWS RDS MariaDB instance from an AWS EC2 machine in the same VPC / region etc.
I am using a shell script like so:
mysql -u root -h hostname....
- 11
0
votes
1
answer
672
views
Unable to perform the 'rds_restore_database' procedure on AWS RDS SQL Server Express
I'm facing the error Maximum supported database size on SQL Server Express edition is: 10 GB. when executing the restore procedure msdb.dbo.rds_restore_database.
The weird thing is the actual database ...
- 101
0
votes
1
answer
152
views
MySQL import silently failing
I'm trying to import a large (30GB) SQL file (generated using mysqldump) into an RDS instance MySQL 5.7 database, from an EC2 instance on the same VPC.
It's importing most without a problem, but ...
- 239