Resetting Adoptables

[Abronsyth]

If you're site is fully up and running, you hopefully will never have to do this. However, if your site is still a work in progress, such as mine, and you have to completely wipe adoptables, levels, images, and/or owned adoptables, then this may be helpful.

For this we're going to be using PHPMyAdmin for, well, everything. Don't worry, it's not difficult, just time consuming!

1. Access PHPMyAdmin
>>> You can do this by going into your host, website control panel, and either go directly to PHPMyAdmin or go into MySQL databases and get into PHPMyAdmin through there.

2. Deleting Adoptables
>>> First, find the table "prefix_adoptables," then check the box next to all adoptables, or just hit check all, and then delete those.

3. Reset Auto_Increment
>>> If you don't do this, it can seriously mess up adoptable id's and such. So, now your going to go to Operations > Table Options > auto_increment, and replace that number with "1". And hit go!

4. Finish It Up
>>> Now repeat steps two and three for these tables: prefix_levels, prefix_owned_adoptables, prefix_adoptables_conditons, and prefix_filesmap.

Congrats, now you can start uploading images and creating pets on a clean slate

 

[Hall of Famer]

Well actually you also need to do the same for the table prefix_adoptables_conditions.