{"flag":true,"single":true,"pageTitle":"IMPORT \/ EXPORT mysql database using cmd","post":{"id":301,"user_id":"1","slug":"import-mysql-database-using-cmd-7deu","title":"IMPORT \/ EXPORT mysql database using cmd","body":"

IMPORT:<\/strong><\/p>\r\n

    \r\n
  1. open cmd where file is placed<\/li>\r\n
  2. \r\n
    mysql -u root-p\"rizi\" clynxx_demo < clynxx_demo.sql\r\n\r\n#clynxx_demo  is databse\r\n#root is user\r\n#rizi is password\r\n#clynxx_demo.sql is file to import or need to give full path as D:\/clynxx_demo.sql<\/code><\/pre>\r\n<\/li>\r\n<\/ol>\r\n
    OR<\/p>\r\n
      \r\n
    1. open cmd\r\n
      mysql -u [username] -p [database_name]<\/code><\/pre>\r\n<\/li>\r\n
    2. \r\n
      source C:\\xampp\\htdocs\\SP\\api_bagtheprice\\drm_aux_db.sql<\/code><\/pre>\r\n<\/li>\r\n<\/ol>\r\n
       <\/p>\r\n
      Export MYSQL DATA: <\/strong>export database using following cmd command <\/p>\r\n
      mysqldump -u [username] -p [database_name] > [output_file].sql<\/code><\/pre>","category_id":"23","is_private":"0","created_at":"2025-05-08T01:53:18.000000Z","updated_at":"2026-04-06T02:40:18.000000Z","category":{"id":23,"user_id":"1","name":"DATABASE","slug":"database-j4ss","parent_id":null,"created_at":"2023-05-26T03:25:05.000000Z","updated_at":"2023-05-26T03:25:05.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"IMPORT:  open cmd where file is placed  mysql -u root-p\"rizi\" clynxx_demo < clynxx_demo.sql  #clynxx_demo  is databse #root is user #rizi - IMPORT \/ EXPORT  mysql database using cmd (Updated: April 6, 2026) - Read more about IMPORT \/ EXPORT  mysql database using cmd at my programming site [SITE]","categories":[]}