Execute a query on foodmart_mysql.sql file in ubuntu and python

Question

I am trying to execute a query on the foodmart database in command line on Ubuntu, or better in python, if possible:

http://pentaho.dlpage.phi-integration.com/mondrian/mysql-foodmart-database

I tried mysql -uroot -p <foodmart_mysql.sql and I got ERROR 1046 (3D000) at line 22: No database selected. I searched for this error and I found that I need to check for 'USE databsenameor something like this in thesqlfile and make sure that it is not there. However, there is not anyUSE` command in the file.

I appreciate any help or comment.

Thanks, Afshin

Vijunav Vastivch · Accepted Answer · 2019-01-18 05:54:40Z

1

It seems like you are going to Restore some .sql file.

Here's the code in your command line:

mysql -u UsernameHere -p YourPasswordHere dbnamehere < "D:\sample.sql"

Before that locate the directory of your mysql first something like:

cd C:\Program Files (x86)\MySQL\MySQL Server 6.0\bin

Make sure that this directory the mysql.exe is located.

then input the code above.

Good luck

edited Jan 18, 2019 at 5:54

answered Jan 18, 2019 at 5:20

Vijunav Vastivch

4,2111 gold badge18 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Afshin Oroojlooy Over a year ago

Thanks for the comment. My question is what is dbnamehere? Also, I am using Ubuntu.

Vijunav Vastivch Over a year ago

It is your database name from your mysql server. you have to create a database name first before you execute restore. Even you are using ubuntu. the Script is all the same. Your problem from above is you don't have a database created from your mysql server. That is why its returns you an error.

Afshin Oroojlooy Over a year ago

I created a db by CREATE DATABASE temp; and then entered mysql -uUsernameHere -pYourPasswordHere temp < foodmart_mysql.sqland did not get the error, but nothing happened. So, how can I see the list of the tables, or execute some queries?

Vijunav Vastivch Over a year ago

run show databases then use yourDBnameCreated then show tables.

vvr02 · Accepted Answer · 2019-01-21 03:58:06Z

0

You have not mentioned the database name in the command. Use this command

mysql -u root database_name < foodmart_mysql.sql -p

answered Jan 21, 2019 at 3:58

vvr02

6112 gold badges12 silver badges22 bronze badges

1 Comment

Afshin Oroojlooy Over a year ago

Thanks for the reply. My problem was I did not had any databese. Using CREATE DATABASE temp;, I created one and now I am trying to figure out running queries in python by sqlite, which is almost done.

Collectives™ on Stack Overflow

Execute a query on foodmart_mysql.sql file in ubuntu and python

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related