Alexey Svistunov alexey-svistunov

alexey-svistunov / gist:765f9b25f44e10d10bb310d94a3fac6f

Created November 9, 2018 07:30

Delete orders M2

	SET FOREIGN_KEY_CHECKS=0;

	# Clean order history
	TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
	TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
	TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;

	# Clean order infos
	TRUNCATE TABLE `sales_creditmemo`;
	TRUNCATE TABLE `sales_creditmemo_comment`;

alexey-svistunov / mysql-docker.sh

Created February 8, 2018 14:57 — forked from spalladino/mysql-docker.sh

Backup and restore a mysql database from a running Docker mysql container

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE