469,927 Members | 1,848 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

read mysql dump file?

I am trying to read a mysql dump file that I was given from a mysql dump
file into my mysql server, I am using the following command at the mysql
command line and get the following error:
mysql> items < c:\bookings\items.mtsql
ERROR:
Unknown command '\b'.
ERROR:
Unknown command '\i'.

Does anyone know what this means?
Thanks,
Daniel Gwynne
Jul 19 '05 #1
6 14193
I assume you are on windows. I see the mysql> prompt. In Linux you would do
this not in a mysql session, but on the command line:
#>mysql dbname < /tmp/StuffFromDump
There must be an equivalent windows form of this. In any case, do it outside
of mysql, on a command line.
dp

I am trying to read a mysql dump file that I was given from a mysql dump
file into my mysql server, I am using the following command at the mysql
command line and get the following error:
mysql> items < c:\bookings\items.mtsql
ERROR:
Unknown command '\b'.
ERROR:
Unknown command '\i'.

Does anyone know what this means?
Thanks,
Daniel Gwynne

Jul 19 '05 #2
I assume you are on windows. I see the mysql> prompt. In Linux you would do
this not in a mysql session, but on the command line:
#>mysql dbname < /tmp/StuffFromDump
There must be an equivalent windows form of this. In any case, do it outside
of mysql, on a command line.
dp

I am trying to read a mysql dump file that I was given from a mysql dump
file into my mysql server, I am using the following command at the mysql
command line and get the following error:
mysql> items < c:\bookings\items.mtsql
ERROR:
Unknown command '\b'.
ERROR:
Unknown command '\i'.

Does anyone know what this means?
Thanks,
Daniel Gwynne

Jul 19 '05 #3
On Sun, 9 Nov 2003 22:48:38 +0000 (UTC), "Daniel Gwynne"
<da*@thingymebob.com> wrote:
I am trying to read a mysql dump file that I was given from a mysql dump
file into my mysql server, I am using the following command at the mysql
command line and get the following error:
mysql> items < c:\bookings\items.mtsql

backslashes are an escape character.

just use the other slash "/' instead and it should work fine.
Chuck Gadd
http://www.csd.net/~cgadd/aqua
Jul 19 '05 #4
On Sun, 9 Nov 2003 22:48:38 +0000 (UTC), "Daniel Gwynne"
<da*@thingymebob.com> wrote:
I am trying to read a mysql dump file that I was given from a mysql dump
file into my mysql server, I am using the following command at the mysql
command line and get the following error:
mysql> items < c:\bookings\items.mtsql

backslashes are an escape character.

just use the other slash "/' instead and it should work fine.
Chuck Gadd
http://www.csd.net/~cgadd/aqua
Jul 19 '05 #5
On Mon, 10 Nov 2003 14:21:32 GMT, "D. Pickering" <dc*****@hps.com>
wrote:
I assume you are on windows. I see the mysql> prompt. In Linux you would do
this not in a mysql session, but on the command line:
#>mysql dbname < /tmp/StuffFromDump
There must be an equivalent windows form of this. In any case, do it outside
of mysql, on a command line.


actually, you can do it from inside mysql client too.

Just do

source /temp/stufffromdump

or on windows

source c:/temp/stufffromdump

source reads a source file and executes the sql commands in the file.

Chuck Gadd
http://www.csd.net/~cgadd/aqua
Jul 19 '05 #6
On Mon, 10 Nov 2003 14:21:32 GMT, "D. Pickering" <dc*****@hps.com>
wrote:
I assume you are on windows. I see the mysql> prompt. In Linux you would do
this not in a mysql session, but on the command line:
#>mysql dbname < /tmp/StuffFromDump
There must be an equivalent windows form of this. In any case, do it outside
of mysql, on a command line.


actually, you can do it from inside mysql client too.

Just do

source /temp/stufffromdump

or on windows

source c:/temp/stufffromdump

source reads a source file and executes the sql commands in the file.

Chuck Gadd
http://www.csd.net/~cgadd/aqua
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Daniel Gwynne | last post: by
4 posts views Thread by Robert Blackwell | last post: by
9 posts views Thread by Shivam | last post: by
1 post views Thread by TYR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.