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 -d option 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 the database-name.bk.sql dump 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-wipe is 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:https://username:password@hostname:port/db_name

Replace 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:

1. Clone the repository:

git clone <repository-url>

2. Move to the project's root path:

cd sqcr

3. Build the project using cargo build:

cargo build --release

This 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.

MIT LICENSE

kip2