we were on MySQL 5.6 ; and today migrated to Aurora using snapshot.. All database schemas are present in new aurora database ; except tmp !
Migration from MySQL to Aurora; tmp database missing
584 Views Asked by Deepak Singhal At
1
There are 1 best solutions below
Related Questions in AMAZON-WEB-SERVICES
- "Access Denied" - User's Permissions to S3 Bucket
- Cohort analysis with Amazon Redshift / PostgreSQL
- Using Amazon KMS service on Heroku
- can't ssh in after cloning an EC2 instance on Amazon AWS
- Using HDFS with Apache Spark on Amazon EC2
- How can I access Mule ESB Community edition via browser?
- AWS EC2: Migrating from Windows to Linux Server
- AWS ELB Load Balancer: is it possible to set multiple session cookies?
- AWS Flow Framework: Can we run activity worker and activity task on different EC2 instances
- Unable to access files from public s3 bucket with boto
- Cloudfront stream only part of the video
- s3cmd not working as cron-task when echos/dates are added
- How to deploy django 1.8 on Elastic Beanstalk using Docker
- InstanceProfile is required for creating cluster - create python function to install module
- How to fix WordPress HTTPS issues when behind an Amazon Load Balancer?
Related Questions in AMAZON-RDS
- Installing the Kmeans PostgreSQL extension on Amazon RDS
- How do I Start/Stop AWS RDS Instances using Boto?
- AWS RDS: how to monitor data transfer out
- RDS instance storage limit handling
- Connecting to SQL Server on AWS RDS
- AWS RDS on Eclipse
- Using an AWS RDS instance across multiple VPC
- Controlling EC2 and RDS access for third party
- Can dumping and restoring database make it slower?
- Communication between Android and EC2 with RDS
- Is there any way to point ELB URL to RDS?
- Cant create postgres base type (with hstore/pgcrypto extensions) on amazon RDS
- Create user with no privileges in RDS for MySQL fails, error 1396
- How to have multiple RDS read replicas in Magento?
- How to take a backup of data to a local machine from the AWS?
Related Questions in AMAZON-AURORA
- When does Aurora DB consider either a primary or replica instance as failed?
- Why AWS aurora Read replica's slave status shows empty
- Migration from MySQL to Aurora; tmp database missing
- Does mysqlslap measure network performance?
- AWS RDS: transaction level in Aurora replica
- How to incrementally Update Aurora RDS with new code from git?
- Reprocess batches of items over and over again - and the batch might change any time
- Stored Procedures and Events Aurora via CloudFormation
- AWS CloudFormation:Subnet has different VPC Id
- Amazon RDS MySQL/Aurora query sometimes hangs forever. Any 2 cents on the metrics and approaches we can triage it and prevent it from happening?
- AWS RDS to S3 Error. "The XML WAS NOT WELL FORMED"
- Does boto3 support (or have plan to support) Aurora postgresql-compatible db instance creation?
- Get Aurora IP and use it in UserData for another instance in AWS CloudFormation
- Speeding up range queries in Aurora DB
- Adding triggers to call Lambda function from Amazon Aurora is not working
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
In Aurora Cluster, tmp schema is excluded from file as table emulation. Therefore, users can't see any table in tmp schema when 1) users access restored cluster 2) users access reader node
The tmp database is excluded from snapshots, so the recommendation is to not use "tmp" name as a table name or database name in your database.
Anyway if you have such database/schema; you need to export and import them manually using mysqldump utility.. Even that created some issues..
So, the final solution I took was to change tmp schema name to tempo ..