How to import sql database using Terminal?

1,616 Comments / Macbook, Programming / / database, import, phpmyadmin, sql, terminal, using
mysql

Uploading the database to your XAMPP phpmyadmin is faster using Terminal than doing it from phpmyadmin. For this please follow the following steps.

  1. Open the Terminal and cd into the folder where the sql database you need to upload is located.
  2. Login to your mysql using the commond
    mysql -u”Your Username” -p”Your Password”
  3. If the terminal asks for the password, enter the password you entered for localhost.
  4. Create a new database by the following command.
    Create “Your Database Name”. If you have already created the database, then select database using “USE <DatabaseName>”
  5. Give the import command by typing the following:
    source “SQL File name”;

    Your sql should be imported really fast and successfully.

Related Posts

1,616 thoughts on “How to import sql database using Terminal?”

  1. zoritoler imol

    But wanna input on few general things, The website style is perfect, the subject matter is very superb. “To establish oneself in the world, one has to do all one can to appear established.” by Francois de La Rochefoucauld.

    Reply
  516. Elosesper

    A Review of Immunotherapeutic Strategies in Canine Malignant Melanoma emla cream and priligy tablets Patients receiving or who have previously received Gyraxen tamoxifen citrate should have annual gynecological examinations and they should promptly inform their physicians if they experience any abnormal gynecological symptoms, eg, menstrual irregularities, abnormal vaginal bleeding, changes in vaginal discharge, or pelvic pain or pressure

    Reply
  1468. DavidPhact

    balloon казино официальный сайт balloon game Игровой автомат Ballon дарит СЏСЂРєРёРµ эмоции.

    Reply
  1473. JesseMew

    Баллон — это автомат для настоящих любителей.: balloon казино демо – balloon казино официальный сайт

    Reply
  1475. JesseMew

    Автомат Ballon — идеальный СЃРїРѕСЃРѕР± расслабиться.: balloon казино – balloon казино демо

    Reply
  1476. JosephGox

    Казино — это шанс РЅР° финансовую СЃРІРѕР±РѕРґСѓ.: balloon game – balloon игра

    Reply
  1477. JesseMew

    Казино — это место для больших выигрышей.: balloon игра – balloon казино официальный сайт

    Reply
  1478. Martyjef

    Играйте СЃ СѓРјРѕРј, РЅРѕ РЅРµ забывайте Рѕ веселье.: balloon game – balloon казино играть

    Reply
  1482. JosephGox

    Автомат Ballon — идеальный СЃРїРѕСЃРѕР± расслабиться.: balloon игра – balloon казино

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *

Tweet
Share
Share
Pin