I am trying to import database file through cmd because its size is too big.
I have tried following command,
/opt/lampp/bin $ mysql.exe -u root -p db_name <~ filename.sql
but it gives
mysql Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (x86_64) using readline 6.3 Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
and open help of mysql command.
I cant get the problem. Please help
Use the following cmd, make sure of the sql file path is correct, as well as you do not have any spaces after -:
spawn mysql -u dbUser -h hName -pdbPass dbName < db_schema.sql
python error thrown does not seem to be an SQL error. Your py code must be having errors.Use the full path of the SQL file filename.sql
1.Log into the mysql terminal and create database say dbName (Make sure that this db name corresponds to the db you are importing)
$mysql -u dbUser -p
mysql> create database dbName;
Here dbUser must be replaced with you db user name or 'root'(which is the most probable one used) and dbName must be replaced with your database name.
Also check if the database is created using following command
mysql>show databases;
2.Exit to the terminal and give the command:
mysql>exit
$mysql -u dbUser -p dbName < '/full/path/to/sql_file.sql'
3.Enter the sql prompt and see if the database is there, and also check if all the db is imported.
$mysql -u dbUser -p
mysql> show databases;
mysql> use dbName;
mysql> show tables;
