import .sql files into mysql from batch file

Question

Hello im creating a batch file to install the wampserver . After that i want to import my name.sql file into the dabase that wampserver created. Im using this command :

mysql --u [bonis] --password=[bonis] ["jdbc:mysql://localhost"] < ["C:\Documents and    Settings\Bonis\Desktop\bpx.sql"]

pause

And telling me this : "The filename, directoryname, or volume label syntax is incorrect."

Any ideas?

8192K · Accepted Answer · 2013-02-25 02:24:06Z

1

Use the following command line: mysql < name.sql

Your sql code in the file has to contain "create database" and "create table" commands, though.

answered Feb 25, 2013 at 2:24

8192K

5,2904 gold badges33 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

import .sql files into mysql from batch file

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