db-wipe is a console application that simplifies database management, offering tools for data deletion and restoration.
It efficiently clears or restores your database with minimal hassle.
-
Effortless Data Deletion: Removing data from your database is a breeze with
db-wipe. For added convenience and safety, you can use the-doption to create a backup before wiping the data, but this step is optional. -
Seamless Restoration: Easily restore your database with
db-wipe -r, ensuring you have thedatabase-name.bk.sqldump file ready.
db-wipe is specifically designed for use with MySQL databases, utilizing mysqldump for creating backups before data deletion.
This ensures a safe and efficient way to manage your MySQL database tasks.
- MySQL Compatible:
db-wipeis tailor-made for managing MySQL databases.
It harnesses the power of mysqldump to back up your data safely before any deletion occurs.
To use db-wipe with a MySQL database, ensure you have mysqldump installed and accessible in your system's PATH.
This will allow db-wipe to automatically create backups when using the -d option.
To use db-wipe, you must configure your database connection in a .env file located at the root of your project.
You should specify the connection details using a single entry in the file:
DATABASE_URL=mysql://username:password@hostname:port/db_nameReplace username, password, hostname, port, and db_name with your actual database credentials and connection details.
This setup allows db-wipe to correctly connect to and manage your database.
To delete your database:
./db-wipe
If no options are provided, you will be prompted to choose whether to create a dump of the database contents.
To create a dump before deletion:
./db-wipe -d
To restore your database:
./db-wipe -r
Ensure you have the dump file named database-name.bk.sql in the current directory for restoration.
Binary distributions are not provided, so you will need to build the application in your own environment. Follow these steps to build:
- Clone the repository:
git clone <repository-url>- Move to the project's root path:
cd sqcr- Build the project using
cargo build:
cargo build --releaseThis command compiles the project in release mode, creating an optimized executable binary.
After building, the executable file can be found in the target/release directory within your project folder.