Diamond Notes

This might not be quite what you think.  One of the sys admins here at work ran into a small problem when moving some databases from one server to another.  When using mysqlimport to bring in the databases on the new server it (mysqlimport) choked on a table that had a space in the name.  He couldn’t get it to work until he used load data infile and put quotes around the table name: “table name”.  I just checked the man pages for mysqlimport and didn’t see any options that would help.

Now I would recommend that you never use spaces in your table names, but if you do and try to restore a backup keep this in mind!!

Thanks for the tip Justin!!