Error 1305 when importing sql dump into mySQL Workbench

Q: How do I import a dump into MySQL workbench?

Load a MySQL dump from MySQL WorkbenchConnect to your MySQL database. Click Server on the main tool bar. Select Data Import. You should see a link to the default dump folder, typically your Documents folder in a subfolder titled dumps .

Q: What is Dumpfile in MySQL?

INTO DUMPFILE is a SELECT clause which writes the resultset into a single unformatted row, without any separators, in a file. The results will not be returned to the client. file_path can be an absolute path, or a relative path starting from the data directory.

Q: How do you load data into Workbench?

Importing CSV file using MySQL Workbench The following are steps that you want to import data into a table: Open table to which the data is loaded. Review the data, click Apply button. MySQL workbench will display a dialog “Apply SQL Script to Database”, click Apply button to insert data into the table.

Tags:

sql

database

mysql

mysql-workbench

I am importing a sql dump file into MySQL workbench and keep getting the error below. Does this mean the rest of the file/records did not import or only the xxx.getRates portion did not? Will I be missing records from it? Does anyone know what might be causing this?

01:29:31 Restoring D:\Projects\CustomerName\Customer Files\xxx-2016-Oct-03.sql Running: mysql.exe --defaults-file="c:\users\admini~1\appdata\local\temp\2\tmpru2fjn.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=xxx < "D:\Projects\CustomerName\Customer Files\xxx-2016-Oct-03.sql

ERROR 1305 (42000) at line 33522: FUNCTION xxx.getRates does not exist

Operation failed with exitcode 1 01:34:29 Import of D:\Projects\CustomerName\Customer Files\xxx-2016-Oct-03.sql has finished with 1 errors

447

asked Jan 12 '17 01:01

walison1307

1 Answers

When using mysqldump, you must explicitly ask for Stored routines to be dumped. The option is --routines if you are running it manually. If you are running it through some app (Workbench), then look for its mechanism:

[ ] Dump Stored Procedures and Functions
[ ] Dump Events
[ ] Dump Triggers

199

answered Oct 11 '22 22:10

Rick James

Related questions
                            
                                MySql Connector EF6
                            
                                Python MySQLdb - Error 1045: Access denied for user
                            
                                Can't truncate MySQL table, while being able to delete all the records
                            
                                MySQL error - Invalid datetime format: 1292 Incorrect datetime value: '' for column
                            
                                Liquibase create indexes with functions
                            
                                Why mysql max_allowed_packet reset to 1m automatically
                            
                                How to use JOIN in Yii2 Active Record for relational model?
                            
                                Flyway on production database - Migration Checksum mismatch
                            
                                Select batch of rows sqlalchemy mysql
                            
                                In MySQL, how do I select a result where the result contains every value I test for?
                            
                                SQL SELECT TOP statement not working
                            
                                How do you make a primary key with Valentina Studio?
                            
                                select max, group by and display other column that's not in group by clause
                            
                                Execute multiple SQL commands at once on R
                            
                                Knex truncate table with foreign key constraints
                            
                                Laravel query returns question mark instead of variable value
                            
                                SQL - speed up query
                            
                                Where to save a single value on server
                            
                                ActiveRecord joins condition satisfy all relations
                            
                                SQL - Get last message from each conversation

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With