to run a single file you can run in mysql
.\ filename
or you outside of mysql you can run
mysql < filename
I have a directory of sql files so I'm trying to run them all at once by using a wildcard
*.sql
but it doesn't work.
Any ideas?
Add a comment
|
6 Answers
Assuming you're using bash:
cat *.sql | mysql
4 Comments
Jay Dave
Awsome...worked: ) i used: cat data*.sql | mysql -u root -p dbName
Stan James
This will only work if all files end with semicolons after commands. Otherwise you'll get a SQL syntax error.
light24bulbs
@StanJames Yep, I'm having the same problem! Is there any way to fix that you can think of? I suppose the other solution is to use a bash loop
Saorikido
To specify a location: cat *.sql | mysql --host=yourDatabaseIP --user=xxxxx --password=xxxxx -p databaseName.
for %S in (*.sql) do mysql -u user_name database_name < %S
or
mysql -u user_name -p password database_name < file.sql
1 Comment
Subrat Pattnaik
This works for me. The current version of mysql does not allow spaces between -u and username. The same applies for password as well.
For Windows:
FOR %%A IN ("*.sql") DO "D:\mysql\Install\MySQL Server 5.5\bin\mysql" --user=scooby --password=pwd123 databasename < %%A >output.tab
1 Comment
0BLU
When running this in
cmd (not powershell) I get an error %%A was unexpected at this time.bash:
mysql < <(cat *.sql)
answered Mar 16, 2010 at 22:19
Ignacio Vazquez-Abrams
804k160 gold badges1.4k silver badges1.4k bronze badges
2 Comments
makstaks
i think someone marked this down because running this command gets an error "syntax error near unexpected token `('"
Ignacio Vazquez-Abrams
That's because process substitution needs
bash. Not sh, not dash, but bash proper. tldp.org/LDP/abs/html/process-sub.htmlbash:
for sql_file in `ls /path/to/directory/*.sql`; do mysql -uUSER -pPASSWORD DATABASE < $sql_file ; done
Comments
cat *.sql | mysql -u root -p "database name"
you can change root with your username and if you have password you can add your password behind -p
i hope this help
