List:General Discussion« Previous MessageNext Message »
From:Roger Baklund Date:January 14 2004 3:01am
Subject:Re: Importing a dumpfile
View as plain text  
* Matthew Stuart
> Right having just got to grips with the mysqldump command, I would like
> to be able to know how to import the database back in to MySQL should
> anything happen to my PC.

Good thinking. :)

> Does mysqlimport have to be done in the command line window like
> mysqldump, and if so, how?

Yes, but... you usually don't use mysqlimport to load a dumped database...
unless you used the 'fields-terminated-by' and so on for mysqldump?
mysqldump willl normally create SQL statements in the dump file. The
mysqlimport utility is used to import data from text files:

<URL: >

To import a dump file, you simply feed it to the standard client from the
comand line:

mysql mydb < dumpfile.sql

or use the "source" command from within the standard client:

mysql> source dumpfile.sql;

You may need to provide user name, password and/or host name when starting
the client, but I guess you are beyond that... :)

> It's just that I tried to import stating
> terminated, enclosed, escaped, etc and by the time I had come to list
> the db name to import in to and the path to the file I wish to import,
> the window wouldn't let me type anymore. Why? Did it get as bored as I
> did?

Yes, bad window... ;)

Was this a OS command line window or the mysql client window? I think
w95/w98 has a limited line buffer, you can just enter 180 or 255 characters
or something. I don't know, maybe you can have a longer line if you put it
in a batch file.

It could have been using the mysql client and LOAD DATA? The mysql client
also has a limited line buffer, but you can press enter every now and then,
i.e. split your input on multiple lines.

But I don't think you need LOAD DATA or mysqlimport.


Importing a dumpfileMatthew Stuart14 Jan
  • Re: Importing a dumpfileDaniel Kasak14 Jan
  • Re: Importing a dumpfileDouglas Sims14 Jan
  • Re: Importing a dumpfileRoger Baklund14 Jan
    • why: mysqldump and mysqlimport?EP14 Jan
      • Re: why: mysqldump and mysqlimport?Dan Nelson14 Jan
      • Re: why: mysqldump and mysqlimport?Tobias Asplund14 Jan
      • Re: why: mysqldump and mysqlimport?Daniel Kasak14 Jan