Re: MYSQLDUMP uses database name in the SQL statements?????!!!!!!!!!!!

2006-06-08 Thread Kishore Jalleda
On 6/8/06, murthy gandikota <[EMAIL PROTECTED]> wrote: I've checked the dump file I created with mysqldump on a database sfg, and it has statements like the following: DROP VIEW IF EXISTS `advAPI`; CREATE ALGORITHM=UNDEFINED VIEW `sfg`.`advAPI` AS select `sfg`.`advertiser`.`advertiserid` AS `ad

MYSQLDUMP uses database name in the SQL statements?????!!!!!!!!!!!

2006-06-08 Thread murthy gandikota
I've checked the dump file I created with mysqldump on a database sfg, and it has statements like the following: DROP VIEW IF EXISTS `advAPI`; CREATE ALGORITHM=UNDEFINED VIEW `sfg`.`advAPI` AS select `sfg`.`advertiser`.`advertiserid` AS `advertiserid`,count(`sfg`.`cust`.`custid`) AS `api` from