Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.

Get Started Now!

How to Insert Database Using Command in Local XAMPP Server

XAMPP

To insert data into a database using command in local XAMPP, you can follow these steps:

  1. Start the XAMPP control panel and ensure that Apache and MySQL services are running.

2. Open your web browser and visit http://localhost/phpmyadmin. This will open the phpMyAdmin interface.

3. Create a new database or Select the database where you want to insert the data from the left-hand side panel.

4. Open command prompt and changing directory like- C:\xampp\mysql\bin in your command prompt

5. Next write mysql -u root YourDatabaseName< C:\YourSqlFile.sql and press enter.

These are general steps, Ensure that your XAMPP server is running during these steps.

Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x