How to execute large MySql data-insert script file using command line in Windows 7?

mysql windows-7 unicode command-line run-script
Nam G VU picture Nam G VU · Jul 18, 2011 · Viewed 24.2k times · Source

I'm new to MySQL so please guide me through how to do this via command line; I've tried but I get NO logging in the console output and the character set is not utf-8

Please help.

Answer

Jacob picture Jacob · Jul 18, 2011 
mysql -e "source /path-to-backup/backup-file.sql" db_name

or 

mysql db_name < backup-file.sql

You probably need -u username -p, too in your command.

mysqldump doc

Related questions

Can't connect to MySQL server on 'localhost' (10061) after Installation

I installed MySQL using mysql-installer-5.5.20.0.msi on Windows 7. From the cmd window, I run "mysqlshow -u root -p". It asked for a password, then returned this error: "Can't connect to MySQL server on 'localhost' (10061)" This is a bad indication of …

Read More
WampServer - mysqld.exe can't start because MSVCR120.dll is missing

I've tried to run wampserver on my local side, but mysql server doesn't run. when I try to install service, it give me error. I searched the answer all day and found some answers on here and there. but any …

Read More
Resetting ROOT password in MySQL 5.6

I have been following these instructions for resetting root password for local installation of MySQL 5.6 on Windows 7 laptop. I stopped the service, created init-file, and ran the following command (as Administrator): "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="…

Read More