Skip to content

How to clear down auction data

Space: VM Last Updated: 2020-02-03T11:13:02.916Z Author: Rachel Goode (Unlicensed) Version: 1 URL: https://vollers.atlassian.net/wiki/spaces/VM/pages/101187585/How+to+clear+down+auction+data

How to cleardown the DB and deal with Hybernate issue (from Chartkaroon)

  1. Take a backup
mysqldump -ueffadmin -p homedepotusa > homedepotusa-010519.sql

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE lot;
TRUNCATE TABLE bid;
TRUNCATE TABLE autobid;
TRUNCATE TABLE lot_image;
TRUNCATE TABLE auction;
TRUNCATE TABLE user_session;
TRUNCATE TABLE password_reset;
TRUNCATE TABLE user_authentication;
TRUNCATE TABLE watch_list;

DELETE FROM user WHERE username not in ('admin', 'alvin', 'allan');

INSERT INTO category( id, name, sort_order, title ) VALUES( '187', 'dummy', '99', 'dummy' );

SET FOREIGN_KEY_CHECKS = 1;

ALTER TABLE lot AUTO_INCREMENT = 180;