Tuesday, May 9, 2023

Mysql import from a SQL file by command line way

Mysql import from a SQL file by command line way:

Open command line and login to your mysql database by typing below command:

mysql -u root -p password then press enter.

mysql > source path_of_your_sql_file.sql Eg: if your file in D drive then path will be D:\mysql.sql

Then press enter all your tables will be imported soon.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Wordpress debug log function

Wordpress error log code: if ( ! function_exists ( 'write_log' ) ) { function write_log ( $data ) { if ( defined ( '...

  • Suomen Kieli (Kello)
    In Finnish, telling time follows a specific structure, and understanding it can help you get the hang of the language. Here’s a guide with e...
  • Suomen Kieli (Vuorokausi)
    Suomen Kieli (Vuorokausi): 1. Aamu (Morning): This refers to early morning, usually around 6:00 AM to 9:00 AM . 2. Aamupäivä (Before noon)...
  • Suomen Kieli (Taalla, Tuolla, Siella)
    In Finnish, location-based words like "täällä," "tuolla," and "siellä" help describe where something is rela...