Hi Matt,
The error you are getting is very particular to "information_schema"
database.
Information_schema does NOT actually have tables, they are views:
"|INFORMATION_SCHEMA| is the information database, the place that stores
information about all the other databases that the MySQL server
If you look at the options for mysqldump more closely, you will see
that you can specify the version of the server which will be importing
the result file. These cause MySQL to taylor the SQL syntax according
to the target platform.
- michael dykman
On Wed, Sep 2, 2009 at 11:03 AM, Matt Neimeye
My local windows machine has mysql 5.1.33 installed on it. One of my
Mac OSX dev servers has some 4.1 flavor of MySQL on it.
When I try to do something like the following: mysqldump -h devserver
-u me -p somedb > dump.sql
I get the following:
mysqldump: Error: 'Table 'information_schema.files' d