I (stupidly) set up approximately 50 wordpress sites using 1 database (i selected the wrong option). The database has grown to 1.3 gig and bluehost is having a fit and temp suspended my account (not unreasonably i guess) - how difficult is it to strip out each database and make separate databases - anyone know how much something like this is likely to cost and how long it might take (approx)? thx dean
Get navicat - http://www.navicat.com/. You can drag and drop each table into a new database. They offer a free 30 day trial, but it should only take a few minutes to separate them all. You can copy them to a new database on the same server, or new databases on different servers.
click export and then select the tables(or one set of prefixes) and export it. Fairly straight forward. Nigel