![]() All the 3 methods work fine, just test it out yourself and stick with the one you are most comfortable with.īefore you go trigger happy with importing SQL files, you might want to check what is inside it first. Well, everyone has their own preferences – Some prefer to not install anything and just push SQL files in the command line, while a few like to use the Workbench to manage multiple databases at the same time. That’s all for this project, and here is a small section on some extras and links that may be useful to you. This is a small extra for you guys who are curious – We can also export a database using mysqldump -u USER -p DATABASE > PATH/FILE.SQL. Yep, it’s that simple, just run the command mysql -u USER -p DATABASE mysql -u root -p test SEARCH FOR “SYSTEM ENVIRONMENT”Ī3) COMMAND-LINE EXPORT D:\http\>mysqldump -u root -p test > d:\http\test.sql We will use the command line to import SQL files, without the hassle of installing any extra tools.Ī1) IMPORT COMMAND EXAMPLE D:\http\>mysql -u root -p test This first method is just as mentioned in the introduction.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |