How to include functions and procedures when importing a MySql database from another server using mysqldump?

Question

I am moving my application to AWS. I have a mysqldump file of my database from the original server that includes table, views, functions and procedures. When I try to import the file into the RDS, only the tables and views are imported. I get an error about needing super privileges and the functions and procedures are not imported. I followed the instructions found in the article: https://repost.aws/knowledge-center/rds-mysql-functions. I set the log_bin_trust_function_creators=1 and I am now able to create new function and procedures but I still get the same error trying to import them.

I have tried using the command line and My SQL Workbench and get the same error.

How can get a complete database import. I verified that everything is included in the mysqldump file by importing it back into a new database on the same existing server and everything is there.

I have tried using the command line and My SQL Workbench and get the same error.

How can get a complete database import.  I verified that everything is included in the mysqldump file by importing it back into a new database on the same existing server and everything is there.

Accepted Answer

I don't have experience with this, but is this something the [Schema Conversion Tool](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html) would recreate for you? Just a thought.

Answer

Afraid you have to do this manually

Make sure to create any stored procedures, triggers, functions, or events manually in your Amazon RDS database. If you have any of these objects in the database that you are copying, exclude them when you run mysqldump. To do so, include the following arguments with your mysqldump command: --routines=0 --triggers=0 --events=0.

How to include functions and procedures when importing a MySql database from another server using mysqldump?

相關內容