Mysql import data dump file

Active 4 years, 8 months ago. Viewed 33k times. I am using windows. Improve this question. Julian 3, 2 2 gold badges 30 30 silver badges 48 48 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. After this command you may have to enter your password. Before you begin, make sure that the account has the correct privileges. Or, you may add a new MySQL user account if you prefer. One uses a command line to create a local dump file, which you can copy or transfer to a new system to import.

The other uses a graphical utility to generate the dump file. Was this article helpful? Sofija Simic. Alongside her educational background in teaching and writing, she has had a lifelong passion for information technology. She is committed to unscrambling confusing IT concepts and streamlining intricate software installations. Improve this question. Barbara Dreamer Barbara Dreamer. Add a comment. Active Oldest Votes. Improve this answer. Community Bot 1.

There has to be no space between -p and password — tombom. What if I don't have a password? Then skip password parameter. You can also import an. Nick Chammas Mike S. Besides that I think there is an error in your statement. There should be a space between -u and the username itself. Thakur Amit Thakur Amit 1 1 gold badge 3 3 silver badges 12 12 bronze badges. Sakhri Houssem Sakhri Houssem 1 1 gold badge 12 12 silver badges 29 29 bronze badges.

Denys Horobchenko Denys Horobchenko 3 3 silver badges 8 8 bronze badges. Caleb Santos Caleb Santos 61 3 3 bronze badges. Irwuin Irwuin 3 3 silver badges 7 7 bronze badges. Jarjob Jarjob 1. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 8. Related Hot Network Questions.