mysqldump warning or actual error?

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' doesn't exist'
when trying to dump tablespaces

It looks like it creates the export fine but I've been ssh-ing into
the dev box and doing it locally there "just in case"

Should I be worried? Is there some option that would supress that
(that i didn't see in mysqldump --help)? Is it truely harmless?

Thanks

Matt

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysqldump warning or actual error?

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 Neimeyer wrote:
> 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' doesn't exist'
> when trying to dump tablespaces
>
> It looks like it creates the export fine but I've been ssh-ing into
> the dev box and doing it locally there "just in case"
>
> Should I be worried? Is there some option that would supress that
> (that i didn't see in mysqldump --help)? Is it truely harmless?
>
> Thanks
>
> Matt
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
- michael dykman
- mdykman@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

Howard Aiken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysqldump warning or actual error?

--------------050309030201070000070804
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
maintains. Inside |INFORMATION_SCHEMA| there are several read-only
tables. They are actually views, not base tables, so there are no files
associated with them. "

http://dev.mysql.com/doc/refman/5.1/en/information-schema.ht ml

Therefore mysqldump generates error trying to dump tables that does not
exist.

Regards,

Mikhail Berman

Matt Neimeyer wrote:
> 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' doesn't exist'
> when trying to dump tablespaces
>
> It looks like it creates the export fine but I've been ssh-ing into
> the dev box and doing it locally there "just in case"
>
> Should I be worried? Is there some option that would supress that
> (that i didn't see in mysqldump --help)? Is it truely harmless?
>
> Thanks
>
> Matt
>
>

--------------050309030201070000070804--