[PHP-DB] problems with BACKUP TABLE

When try to use BACKUP TABLE, i get an error 'Failed copying .frm file: errno = 2' in the result table. What's the problem? P.S. SELECT VERSION() - 3.23.40 and type of the table is MyISAM (CHECK works fine). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.p

[PHP-DB] Re: SQL Troubles with JOIN, GROUP BY and MAX???

Try something like this: SELECT USERS.Username,FILES.Filename FROM USERS LEFT JOIN FILES USING(Id) WHERE FILES.Filename IS NOT NULL ORDER BY FILES.Stamp DESC LIMIT 1; If Filename declared as NOT NULL then use FILES.Filename!='' MR> I've been racking my brain for too long on this one, can someone