MySQL Forums
Forum List  »  Newbie

Re: source statement depricated - what replaced it?
Posted by: Jeff Buchanan
Date: March 29, 2020 06:47PM

The load_departments.dump file is in the same directory as this "main" .sql file. I'm running it via MySql Workbench editor.

The source command follows data structure definitions:
CREATE TABLE departments (
dept_no CHAR(4) NOT NULL,
dept_name VARCHAR(40) NOT NULL,
PRIMARY KEY (dept_no),
UNIQUE KEY (dept_name)
);

flush /*!50503 binary */ logs;

SELECT 'LOADING departments' as 'INFO';
source 'load_departments.dump';

Message:
'source' is not valid at this position, expecting: EOF, BEGIN, CACHE, CHECKSUM, COMMIT ...

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.