Oscommerce Error 1046 No Database Selected
Contents |
"#1046: No database selected" error when trying to import a .sql file in phpMyAdmin. Solution #1: Before importing In phpMyAdmin, click on the Export tab from the home page of phpMyAdmin, without selecting any #1046 - no database selected import database. phpMyAdmin will then include instructions to create and select the database when you import error 1046 no database selected mysql it. This solution does not apply to most shared hosts, since they won't allow you to create a database from phpMyAdmin. Solution #2: no database selected mysql php The alternative fix Unlike solution #1, this one also works on shared hosts. Create the new database on your server, then write down the name. Open your .sql file with a text editor Insert the following line #1046 - no database selected wordpress right before the first CREATE TABLE instruction in your .sql file: USE your_database_name_here; Save your file, then import it in phpMyAdmin. SQL Tagged database, errors, mysql, phpmyadmin, sql ← How to get an Integer from a Java resultset How to properly validate email addresses in Java → 21 comments on “How to fix the "#1046: No database selected" error in phpMyAdmin” carle November 13, 2013 at 11:34 pm many thanks! save my life! Reply
#1044 - Access Denied For User
Sam June 3, 2014 at 2:08 pm What i get when i export my database is a notepad file format showing mywebname.sql instead of the normal sql file for upload to liveserver….please help as i dont know what could be wrong. Reply Nicolas Bouliane June 3, 2014 at 3:05 pm Upload that file in the import form Reply Manish Atri November 19, 2013 at 7:43 am Thanks a lot Buddy Reply Juanita Alcachofa December 5, 2013 at 6:32 pm Muy bueno, me sirvió. Reply Ivan January 3, 2014 at 11:07 pm Thank you! Solution #2 worked for me! Reply Pizo January 13, 2014 at 10:41 pm Thank you! Reply Mr January 21, 2014 at 11:54 pm Just wanted to add, since your solution led me to the answer : It's all because there is an existing database of the hosting company and they won't allow you to open one yourself, but rather suit yours into theirs. The solution therefore is to 1.export your database in sql format from phpmyadmin localhost 2.open that file with notepad++ 3.edit the first lines to this CREATE DATABASE IF NOT EXISTS hosting_db01 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE hosting_db01; where ‘hosting_db01′ is the name of the hosting database, instead of your database 4.spread the luuuv Good luck - wo
No Database Selectedselect configuration_key
No Database Selected Error In Php
as cfgKey, configuration_value as cfgValue from configuration[TEP mysql error 1046 STOP]Thats the error I got when I tried going to the #1062 - duplicate entry '1' for key 'primary' admin panel after installing ms2.2 fresh. What should I do? Johnson 2003-05-16 08:22:56 UTC PermalinkRaw Message This http://wisercoder.com/how-to-fix-the-1046-no-database-selected-error-in-phpmyadmin/ message was sent from: Installation and Configurationhttp://forums.oscommerce.com/viewtopic.php?p=168249#168249----------------------------------------------------------------open admin/includes/configure.php in a text editor and check the database settings.... Magnus 2003-05-16 08:28:26 UTC PermalinkRaw Message This message was sent from: Installation and Configurationhttp://forums.oscommerce.com/viewtopic.php?p=168253#168253----------------------------------------------------------------All solved now um I get http://osc-installation.oscommerce.narkive.com/wUPGffWX/error-1046-no-database-selected-on-fresh-instal-of-ms2-2 this error / message when I try uploading a csv file (The file that comes with the bloody excel import 1.51)File uploaded.Temporary filename: /tmp/phpSfsW0ZUser filename: Form.csvSize: 344| unavailabl | | | | | | | | | | | |No products_model field in record or incorrect root for category. I cannot import this record!Thats all!It's so screwed, and then no changes are made to product dbase. How the hell do I do it!!!! 2 Replies 14 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation Magnus 2003-05-16 04:53:04 UTC Johnson 2003-05-16 08:22:56 UTC Magnus 2003-05-16 08:28:26 UTC about - legalese Loading...
No http://osc-installation.oscommerce.narkive.com/fOR7wPBo/1046-no-database-selected Database Selectedselect configuration_key as cfgKey, http://stackoverflow.com/questions/4005409/error-1046-no-database-selected-how-to-resolve configuration_value as cfgValue from configuration[TEP STOP]I did copy a configure.php in the /includes/local-directory.I still get the errordamn Jan0815 2003-01-21 13:18:11 no database UTC PermalinkRaw Message This message was sent from: Installation and Configurationhttp://forums.oscommerce.com/viewtopic.php?p=102546#102546----------------------------------------------------------------The entries in your configure.php are not working.Check the db_server, name, password stuff to make sure no database selected they are correct.The error message indicates that the credentials you entered are not accepted.HTH nicotinecrew 2003-01-21 15:26:00 UTC PermalinkRaw Message This message was sent from: Installation and Configurationhttp://forums.oscommerce.com/viewtopic.php?p=102577#102577----------------------------------------------------------------// define our database connectiondefine('DB_SERVER', 'localhost');[color=red]-> this one right ?[/color]define('DB_SERVER_USERNAME', '');define('DB_SERVER_PASSWORD', '');define('DB_DATABASE', '');define('USE_PCONNECT', 'false');define('STORE_SESSIONS', ''); 2 Replies 42 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation nicotinecrew 2003-01-21 11:09:38 UTC Jan0815 2003-01-21 13:18:11 UTC nicotinecrew 2003-01-21 15:26:00 UTC about - legalese Loading...
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error 1046 No database Selected, how to resolve? up vote 137 down vote favorite 22 Error SQL query: -- -- Database: `work` -- -- -------------------------------------------------------- -- -- Table structure for table `administrators` -- CREATE TABLE IF NOT EXISTS `administrators` ( `user_id` varchar( 30 ) NOT NULL , `password` varchar( 30 ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1; MySQL said: #1046 - No database selected need some help here. sql mysql mysql-error-1046 share|improve this question edited Oct 23 '10 at 18:21 OMG Ponies 199k37361417 asked Oct 23 '10 at 18:19 steph 692253 5 In case anyone is interested, you can also specify the database name via the CLI command without editing the import file. mysql -u root -p databasename < import.sql –Sam Dufel Nov 24 '14 at 15:36 what happened to me was: create a schema, filled in the name of the database, then it says "fail, no database selected". reopen workbench, i see database that i have just failed to created. Then I choose the database that i have just created, and open a .sql file and run, with both create database and use database statements, it complains "fail no database selected" again. reopen workbench, the tables are all built. MAC system, workbench 6.3.3 –Tiina Jun 9 at 9:12 add a comment| 13 Answers 13 active oldest votes up vote 217 down vote You need to tell MySQL which database to use: USE database_name; before you create a table. In case the database does not exist, you need to create it as: CREATE DATABASE database_name; followed by: USE database_name; share|improve this answer edited Feb 24 '13 at 0:02