Hi!
I am not a tech person and trying to export our SQL database as back up. But I couldn’t fin any good way how to do it the way it could be deployed instantly, if needed (aka 1 click deployment or something very close to this).
Is that possible to do so? Here is an example from exported SQL file:
– Dumping structure for table essentialmode.addon_account_data
CREATE TABLE IF NOT EXISTS addon_account_data (
id int(11) NOT NULL AUTO_INCREMENT,
account_name varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
money double NOT NULL,
owner varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- Dumping data for table essentialmode.addon_account_data: ~7 rows (approximately)
/*!40000 ALTER TABLE `addon_account_data` DISABLE KEYS */;
INSERT INTO `addon_account_data` (`id`, `account_name`, `money`, `owner`) VALUES
(1, 'society_cardealer', 0, NULL),
(2, 'society_mecano', 0, NULL),
(3, 'society_police', 0, NULL),
(4, 'society_taxi', 516, NULL),
(5, 'society_carthief', 0, NULL),
(8, 'property_black_money', 0, 'steam:110000xxxxxx'),
(9, 'caution', 0, 'steam:1100001xxxxxxxxx');
/*!40000 ALTER TABLE `addon_account_data` ENABLE KEYS */;
I am not sure, how it will behave when deployed back. Did anyone do this right? Help a newbie, please 