Uh oh... thousands of table created by Batch Create

I used Batch Create to add users from my old website (www.thedigitalartist.com) to my new one (www.thedigitalartist3.com). The txt file was very carefully edited, and I didn't get any error messages while the queue was processing.

However, it only created about 1/3 of the users that were in the file, and, unfortunately, didn't create any of them as BP users.

The main problem is that it created more than 7000 tables in my database. Any thoughts on how I might undo this without scrapping the site and starting again?

  • Andrew

    Hiya,

    1) Sounds like the file may have been too big. How many items (users) were in it?

    2) Sounds like the file wasn't structured properly if the goal was to only create users and not blogs.

    The main problem is that it created more than 7000 tables in my database. Any thoughts on how I might undo this without scrapping the site and starting again?

    You'd have to code a script to go through deleting the blogs/dropping the tables I'm afraid.

    Thanks,
    Andrew

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.