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
`advertiserid`,count(`sfg`.`cust`.`custid`) AS `api` from
(`sfg`.`advertiser` left join `sfg`.`cust` on((`sfg`.`cust`.`advertiserid` =
`sfg`.`advertiser`.`advertiserid`))) where (`sfg`.`cust`.`statusCurrent` in
(20,21,22,23)) group by `sfg`.`advertiser`.`advertiserid`;
Now if I want to import this dumpfile into another database sfgbackup, it
won't work because the sql is referring to sfg database. I think this is the
reason why I'm facing the problems (sorry for multiple threads). Can anyone
confirm my suspicion and suggest a fix? I'm thinking manually changing all
the entries. Is that the only way?
Thanks for your help
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Your problem has to do with a DB rename ...read on ...
The easiest way to rename a database as far I know is
1) shutdown Mysql
2) Go to your data directory,
3) make a recursive copy (with permissions intact) of database "sfg", call
it "sfgtemp"
4) rename the newly copied directory "sfgtemp" to "sfgbackup"
5) restart mysql
6) do some GRANT etc to make sure that the users have proper access to the
new database
sfgdump...
7) now you have a new database sfgdump !!!if thats not what you want then
just repeat your dump and restore on sfgdump freshly instead of sfg
Give this a try and see how it goes
Kishore Jalleda
http://kjalleda.googlepages.com/projects
