mysql_commands.txt

# Dump and Load

sudo mysqldump --no-create-info npt > dump_file.sql                                                                                   courdier@iccluster045a
sudo mysql npt < dump_file.sql

# Remove tables or all rows in table

USE npt;

SELECT * FROM sessions;
SELECT * FROM records;

DELETE FROM records;
DELETE FROM sessions;

DROP TABLE records;
DROP TABLE sessions;

UPDATE `records` SET part_id=1 WHERE session_id=1;
INSERT INTO `session_parts` VALUES (1,'default',1,'', 1);