Importing using MySQL WorkBench... error ERROR 1046 (3D000)

Q: How do I fix error code 1046 in MySQL?

Now, we can choose any database. Suppose I am using the database 'business', therefore we can choose with the help of 'use' command. After using database 'business', we can create the above table and we will not get any error.

Q: How do I fix no database selected in MySQL workbench?

If the error arises due to not selecting a database, you can easily overcome it by replacing [database_name] with the correct database name in your server. When creating a table statement from the MySQL workbench, you need to select the database to run before executing the statement.

Q: Why it is showing no database selected error in MySQL?

The error no database selected frequently occurs in MySQL when you perform a statement without selecting a database first. You need to replace [database_name] with the name of a database that exists in your MySQL server.

Tags:

mysql

mysql-error-1046

Scenario: building a RoR enviroment locally for development. Production is on EngineYard / GitHub. All now working ok, except DB isn't importing.

I have a .sql file that i've taken from my prod EY site. Now i need to import it to my MySQL locally. I'm using Workbench (as i'm new to this), but getting error below.

Please help?

08:07:43 Restoring /home/james/Downloads/Futology.sql Running: mysql --defaults-extra-file="/tmp/tmpAVeE58/extraparams.cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "/home/james/Downloads/Futology.sql" ERROR 1046 (3D000) at line 22: No database selected

Operation failed with exitcode 1 08:07:43 Import of /home/james/Downloads/Futology.sql has finished with 1 errors

933

asked Apr 26 '11 07:04

RedCuber

2 Answers

Workbench doesn't know the database (schema) you want to use.

In workbench, when using Data Import/Restore, just below where you choose the file to import, it asks "Default Schema to be Imported To"

Just choose the database (schema) you want it to use from the dropdown titled Default Target Schema. If you don't have a database (schema) already, you can create it with the "New" button.

This is confusing because MySQL generally seems to use the term database but Workbench uses schema. They mean the same thing for most purposes. MySQL 'create schema' and 'create database' - Is there any difference

answered Oct 14 '22 01:10

Brad Hunter

Not used Workbench too much however it's easy enough to do from command line have a look at this (below phpMyAdmin instructions)

The command you're after is: mysql -u #username# -p #database# < #dump_file#

answered Oct 14 '22 02:10

charliequinn

Related questions
                            
                                Row numbering with p:dataTable
                            
                                Hibernate OneToOne lazy loading and cascading
                            
                                MySQL Query to delete rows whose timestamp is older than current timestamp
                            
                                Best way to write arrays to a file? [closed]
                            
                                Problems with creation of database DVWA
                            
                                Python and MySQLdb - Using DROP TABLE IF EXISTS seems to throw exception
                            
                                Checking if mySql datetime is older then 1 day from php now()
                            
                                Laravel: Addition to an existing field data in a column
                            
                                VARCHAR max in laravel 5
                            
                                MySQL fetchall() - how to get data inside a dict rather than inside a tuple
                            
                                What is the difference between longblob and longtext in mysql?
                            
                                Why won't the page refresh with MAMP
                            
                                Primary key id reaching limit of bigint data type
                            
                                Password hash and salting - is this a good method?
                            
                                Generate a random 10 digit number and insert into mysql?
                            
                                Database design - primary key naming conventions
                            
                                how to delete completed orders in woocommerce using a my sql query
                            
                                Can others access my files if I downloaded PHP / MySQL?
                            
                                mysql select dates in 30-day range
                            
                                MAMP "Apache couldn't be started because port is in use." AND "Can’t connect to local MySQL server through /tmp/mysql.sock

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With