Categories: My SQL

MYSQL dump file using command prompt ?

First of all ,go to mysqldump utility folder eq. C:wampbinphpphp5.3.0 using commad prompt and then type following code.

in this example wordpress database has username root without password.


login into command prompt if you are using XAMPP please follow following Step

step 1.  cd  c:xamppmysqbin

Method 1.  mysql -u root -p -h localhost databasename < file.sql


file must save in your c:xamppmysqlbin


Method 2. >mysqldump –opt –user=root –password= wordpress > mydata.sql

Developer Diary

Share
Published by
Developer Diary

Recent Posts

Laravel vs Node Js: Which One Is Good For What?

Introduction In the world of web development, selecting the correct framework is critical. Laravel and…

3 months ago

Docker Cheatsheet: Essential Commands and Explanations

Introduction By enabling containerization, Docker has transformed the way software is built, deployed, and managed.…

8 months ago

Difference between Memcached and REDIS – Secrets of Caching

Introduction Speed and efficiency are critical in the ever-changing world of web development. Effective caching…

8 months ago

How to Revert a Git Commit: A Simple Example

Introduction Git, a popular version control system in software development, enables developers to track changes,…

8 months ago

What is Git Stash and Why Do You Need It

Introduction Are you tired of grappling with tangled changes and unfinished work while using Git?…

8 months ago

Difference between git stash pop and git stash apply

Introduction Version control is essential in software development because it ensures that changes to a…

8 months ago