Loading sql file from sql file in mysql

Question

I have a master sql file that I called in the mysql command prompt:

 mysql>source /tmp/folder/masterFile.sql

In the masterFile.sql, I have some source files:

source players.sql
source teams.sql

The problem is that it gives me this error message saying that it can find the file.

ERROR:
Failed to open file 'players.sql \* to create players table *\', error: 2

The masterFile.sql and the other files are in the same directory.

It looks like you have comments in your masterfile.sql but you mixed up the comment syntax, using \* *\ where you should have used /* */. — Bill Karwin
– Bill Karwin, Commented Aug 2, 2019 at 18:43

manish apte · Accepted Answer · 2019-08-02 18:36:53Z

1

Note-1: It is better to use the full path of the SQL file file.sql.

Note-2: Use -R and --triggers to keep the routines and triggers of original database. They are not copied by default.

Note-3 You may have to create the (empty) database from mysql if it doesn't exist already and the exported SQL don't contain CREATE DATABASE (exported with --no-create-db or -n option), before you can import it.

answered Aug 2, 2019 at 18:36

manish apte

522 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Loading sql file from sql file in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related