By expatme on

i would like to re install my database for a multisite installation....what do i need to clear in the folders for the primary site?

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

nothing. the first site remains and your multisites use that code base.

expatme’s picture

expatme commented

what about the rubbish left behind by the first site, i need to clear the first site

ie for re-installation

vm’s picture

vm commented

Drop all tables from the database and delete all files from server.

or

delete the database and delete all files from server.

expatme’s picture

expatme commented

hmmmm, i still have the other sites in the same codebase !!!

vm’s picture

vm commented

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.

expatme’s picture

expatme commented

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

vm’s picture

vm commented

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

expatme’s picture

expatme commented

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

vm’s picture

vm commented

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.

expatme’s picture

expatme commented

* 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.