This script is designed to continuously insert dummy data into a MySQL database table named users. It also includes functionality to create the database and table if they do not already exist, as well as logging the insertion process and counting the number of records in the table.
- MySQL server installed and running
- MySQL user credentials with permission to create databases and tables
Before running the script, ensure to update the following variables in the script according to your MySQL database configuration:
DB_HOST: The hostname or IP address of the MySQL server.DB_USER: The username used to connect to the MySQL server.DB_PASSWORD: The password for the MySQL user.DB_NAME: The name of the database where theuserstable will be created.LOG_FILE: The path to the log file where insertion process and errors will be logged.
- Make sure the script file has execute permissions:
chmod +x mysql_insert_script.sh
- Run the script:
./mysql_insert_script.sh
The script will continuously insert dummy data into the users table every 2 seconds, with each batch inserting 5 records. It will also create the database and table if they do not already exist.
- Database Creation: If the specified database does not exist, the script creates it.
- Table Creation: The script creates a table named
userswith columnsid,name,email, andage. - Data Insertion: Dummy user data is generated and inserted into the
userstable in batches of 5 records every 2 seconds. - Logging: The script logs the insertion process and any errors encountered during insertion to the specified log file.
- Record Counting: The script counts the total number of records in the
userstable and logs the count along with the insertion process.
- MySQL: The script relies on MySQL server for database operations.
- Faker: A Python library used to generate fake data.
Make sure to install the Faker library before running the script:
pip install faker
This script is released under the MIT License.