Import multiple large sql dump mysql

Question

I want to import several .sql files into database using source command (mysql command line). But when I get this error:

source E:\Progs\Backups\DBs\file01.sql

ERROR:
Unknown command '\P'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'sourc
e E:\Progs' at line 1
....

I used source command to import large files hundreds times but now I can not understand what I'm doing wrong. This is my system(I'm using XAMPP (Basis Package) version 1.7.3 :

Windows 7x64
MySQL 5.1.41 (Community Server) with PBXT engine 1.0.09-rc

Any help would be appreciated. Thanks!

Edit:
I tried this one, but same error:

source 'E:\Progs\Backups\DBs\file01.sql'

Charles · Accepted Answer · 2012-06-04 06:13:52Z

1

MySQL sees the \P in E:\Progs as a command. Because that command does not exist, it complains.

Forward slashes are understood in many cases. Try:

source E:/Progs/Backups/DBs/file01.sql

answered Jun 4, 2012 at 6:13

Charles

51.5k13 gold badges107 silver badges146 bronze badges

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

2 Comments

Hassan Khodadadeh Over a year ago

Do you know any way to import 1000 file at once?

Charles Over a year ago

It may be safe to concatenate the files together. The only times I've ever needed to do something similar, I wrote a quick shell script to go through all of the files and import them directly. I'm pretty sure something similar could be done in a batch file, though you may have more luck with PowerShell.

Collectives™ on Stack Overflow

Import multiple large sql dump mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related