mysql cmd promt import data.sql

Question

i wanna import sql using cmd prompt. first open windows cmd prompt, navigate to xampp/mysql/bin folder & run mysql this error occurs

D:\Program Files\xampp\mysql\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O)

D:\Program Files\xampp\mysql\bin>mysql -u root -p  -h localhost dev1base < dev1b
ase.sql
Enter password:

D:\Program Files\xampp\mysql\bin>
D:\Program Files\xampp\mysql\bin>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 104
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
mysql> -h localhost dev1base < dev1base.sql
    ->
    ->
    ->
    ->

Answer 1

Have you tried passing your password directly in -p paramenter?

mysql -u root -pPASSWORD -h localhost dev1base < dev1base.sql

If your password is blank, just don't put -p in the argument

mysql -u root -h localhost dev1base < dev1base.sql

Looks like you've put -p only, so its just prompting you for the password, and once you've enter mysql command prompt, -h localhost dev1base < dev1base.sql is cannot use anymore,

And for mysql commands, need to end with semicolon ;, thats why you just seeing lots of ->, instead of an error.

Answer 2

Bash script restore database mysql

@echo OFF
REM --- Bash script restore databse mysql -u username -p database_name < file.sql
REM ---- Thiết lập đường dẫn tới thư mục chứa file backup
set backup_dir=C:\AppServ\db_backup
REM ---- Đặt biến file_restore cho tên file cần restore ( VD: Backup_Shop_01072011.sql)
set file_restore=Backup_Shop_01072011.sql
REM ---- Thiết lập đường dẫn tới thư mục cài đặt MySQL Server
set mysql_dir=C:\AppServ\MySQL
REM ---- Thiết lập tên cơ sở dữ liệu cần Restore(VD: Shop)
set dbname=Shop
REM ---- Thiết lập tên tài khoản quản trị database root
set dbuser=root
REM ---- Thiết lập password của tài khoản root database
set dbpass=sa
REM ---- Thực thi câu lệnh Restore
%mysql_dir%\bin\mysql.exe -u %dbuser% --password=%dbpass% %dbname% < %file_restore%