Hello everybody.
I'm trying to create a backup of mysql database:
mysqldump --all-databases --routines --master-data=2 all_databases_`date
+'%y%m%d-%H%M'`.sql
It looks like backup has been created but I've got this Warning:
Warning: mysqldump: ignoring option '--databases' due to invalid value
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'
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
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