Mysqlimport question

[remnant]

I need to migrate my MySQL databases to another server. I've dumped all the databases into a text file using mysqldump -A for all databases but now I don't know how to import it.

All the information on mysqlimport and load data infile I've seen suggests that I need to specify at least one database and / or table but I want to import them all from this text file.

Any help would be greatly appreciated.

Thanks in advance.

[DonChris]

MySQL-manual says:

The most common use of mysqldump is probably for making a backup of entire databases.

shell> mysqldump --opt db_name > backup-file.sql

You can read the dump file back into the server with:

shell> mysql db_name < backup-file.sql

[remnant]

Thanks, that works for the most part, however, when it gets to the mysql database, it errors out on the "db" table.

It says I have a syntax error near "User(User)" which is a key, and the last statement, in the table setup.

I've looked over the dump file and the syntax appears correct to me. I've also tried several different dump features such as complete inserts and extended inserts but have had no success.

At first I was dumping all of the databases and trying to import them back via one dump file, but I've also tried simply dumping the mysql database and this does not work either.

For reference, the current database is 3.23 and I've tried importing to both 4.0 and 3.23 but received the same error.

Is there something special I need to do for this database?

If it isn't clear from the description, the database is actually called mysql and it stores the permissions.

Once again, any assistance is greatly appreciated.

Thanks in advance.