💾 Database Export Command – LiteEco

LiteEco includes a robust database export and migration system, allowing administrators to easily back up, migrate, or convert economy data between storage formats.

---

🧩 Command Overview

/eco database export <argument> [currency]

➤ Description

This command exports player balance data for a specified currency into different file formats or prepares migration data for database imports.

Exported files are saved in the /migration/ directory, with filenames that include the currency name and a timestamp for easy tracking.

---

⚙️ Arguments

Argument	Description
SQL	Exports all data for the selected currency into an .sql file. Useful for importing into MySQL or MariaDB databases.
CSV	Exports all data into a .csv file readable by spreadsheet tools like Excel or Google Sheets. Ideal for manual review and backup.
LEGACY_TO_NEW	Exports all data from the legacy lite_eco table into an .sql file. Designed for migration from old LiteEco table structure to the new schema. No direct database write is performed.
SQL_LITE_FILE	Exports all data into an SQLite-compatible .db file. Useful for converting from MySQL/MariaDB to SQLite.

---

🗂️ Output Files & Structure

All exports are saved inside the /migration/ folder using the following naming pattern:

${fileName}_${currency}_${timestamp}

➤ File Naming Details

Export Type	File Example	Notes
CSV	economy_migration_dollars_20251012_153000.csv	Exported as comma-separated values.
SQL	economy_migration_dollars_20251012_153000.sql	Contains SQL statements for database import.
LEGACY_TO_NEW	economy_migration_dollars_20251012_153000.sql	SQL dump generated from the legacy lite_eco table, prepared for import into the new schema.
SQL_LITE_FILE	economy_migration_sql_lite_dollars_20251012_153000.db	Standalone SQLite database file (e.g. database.db).

---

💡 Usage Examples

Export current balances of the dollars currency to a CSV file:

/eco database export CSV dollars

Export the same data as an SQL file:

/eco database export SQL dollars

Export legacy data from the old lite_eco table into an SQL file:

/eco database export LEGACY_TO_NEW dollars

Export all balances to a SQLite .db file:

/eco database export SQL_LITE_FILE dollars

---

🧠 Notes & Recommendations

• The /migration/ folder is created automatically if it doesn’t exist.
• Timestamps follow the format yyyyMMdd_HHmmss (e.g., 20251012_153000).
• Ensure your server has permission to write to the /migration/ folder.
• LEGACY_TO_NEW is available only for MySQL or MariaDB connections.
  • LEGACY_TO_NEW does not modify or write directly into any database — it only generates an .sql file for manual or controlled import.
• SQL_LITE_FILE is ideal for migrating data from MySQL/MariaDB to a lightweight SQLite database.
• For large databases, exports may take several seconds depending on server performance.

---

✅ Quick Summary

Export Type	Output	Best Use Case
CSV	.csv file	Manual inspection or simple backups
SQL	.sql file	Reimport into MySQL/MariaDB
LEGACY_TO_NEW	.sql file	Migration from legacy lite_eco table to new schema
SQL_LITE_FILE	.db file	Conversion to SQLite

---

This command provides flexibility and safety for administrators handling economy data across multiple platforms or server environments.