Skip to main content
Answer

how does one delete the DB and setup as new?

  • August 21, 2013
  • 3 replies
  • 31 views

ImAMacGuy
Forum|alt.badge.img+23

So how does one delete the mysql db and start over w/o wiping the system?

Best answer by ImAMacGuy

I'm an idiot :) It's on my test server, and I just finished an 8hr copy of my Distribution point, only to realize I shouldnt have imported my old DB. I don't really want to wipe teh whole system and redo the whole copy again... sooooo I figure redoing the DB would be the next best thing.

-- DELETE ALL RECIPE
drop schema <database_name>; drop user <a_user_name>; drop user <another_user_name>;
FLUSH PRIVILEGES;

3 replies

iJake
Forum|alt.badge.img+21
  • Contributor
  • August 21, 2013

Just go into your MySQL and do a drop on the jamfsoftware database. Might I ask why you are wanting to do this?


ImAMacGuy
Forum|alt.badge.img+23
  • Author
  • Esteemed Contributor
  • Answer
  • August 21, 2013

I'm an idiot :) It's on my test server, and I just finished an 8hr copy of my Distribution point, only to realize I shouldnt have imported my old DB. I don't really want to wipe teh whole system and redo the whole copy again... sooooo I figure redoing the DB would be the next best thing.

-- DELETE ALL RECIPE
drop schema <database_name>; drop user <a_user_name>; drop user <another_user_name>;
FLUSH PRIVILEGES;


iJake
Forum|alt.badge.img+21
  • Contributor
  • August 21, 2013

It will definitely start your JSS all over again.