mysql cmd promt import data.sql
Posted
by
udhaya
on Server Fault
See other posts from Server Fault
or by udhaya
Published on 2010-02-25T10:44:36Z
Indexed on
2011/01/13
4:55 UTC
Read the original article
Hit count: 423
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
->
->
->
->
© Server Fault or respective owner