How to clear the drupal install of an multisite installation

ok, then figure out which tables are from the first site: more often than not these are the ones without a prefix, unless you set a prefix on that install also.

checkmark them and drop them.

Though now you are getting into territory I've never been, so make sure you do your backups.

oh sorry, i have separate db

Posted by expatme on January 6, 2009 at 1:30am

oh sorry, i have separate db for each site, what about the junk cache used by the first site, where are they stored?

=-=

Posted by VM on January 6, 2009 at 2:23am

drupal cache is in the database, there are cache tables there.

there has to be some onsite

Posted by expatme on January 6, 2009 at 2:24am

there has to be some onsite cache surely for css, and js

=-=

Posted by VM on January 6, 2009 at 2:29am

if you had css aggregation enabled. the files it aggregates them to is in your sites/default/files folder alongw with anything else that was aggregated ie: javascript, if you had that module. As well as any files that were uploaded with the 1st site, user pictures so on so forth.

* user warning: You

Posted by expatme on January 7, 2009 at 3:36am

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\menu.inc on line 315.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\menu.inc on line 315.