Error 1046 No Database Selected In Mysql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies mysql create database of this site About Us Learn more about Stack Overflow the company
Mysql Error 1064
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users sql error 1046 no database selected Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a error 1046 (3d000): no database selected minute: Sign up phpMyadmin database import error #1046 - No database selected up vote 6 down vote favorite 2 I have an sql file that i exported from phpmyadmin on another computer. I tried to import the file on this computer and I get this error: Error SQL query: -- -- Database: `phplogin` -- -- -------------------------------------------------------- -- -- Table structure for table
#1046 - No Database Selected Import
`people` -- CREATE TABLE IF NOT EXISTS `people` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 25 ) NOT NULL , `age` INT( 11 ) NOT NULL , `testvar` VARCHAR( 5 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =3; MySQL said: #1046 - No database selected mysql database import phpmyadmin share|improve this question edited Dec 23 '14 at 16:00 default locale 6,47692947 asked Jul 30 '11 at 1:31 user780483 71181527 add a comment| 2 Answers 2 active oldest votes up vote 29 down vote The error is because you either didn't select a database on the left side to import to, and/or you didn't create the empty database first. Create a database in phpMyAdmin called "phplogin", select it on the left side, and then run the import. share|improve this answer answered Aug 3 '11 at 0:17 Clowerweb 841912 3 Any idea how to do this in a phpMyAdmin configuration that only logs into a specific database? (Thus there is no DB to select on the left, only
Du kan ändra inställningen nedan. Learn more You're viewing YouTube in Swedish. You can change this no database selected mysql php preference below. Stäng Ja, behåll den Ångra Stäng Det här videoklippet no database selected mysql workbench import är inte tillgängligt. VisningsköKöVisningsköKö Ta bort allaKoppla från Läser in ... Visningskö Kö __count__/__total__ Ta reda
Error 1046 (3d000) No Database Selected Grant
på varförStäng Fix #1046 - No database selected itcs program PrenumereraPrenumerantSäg upp269269 Läser in ... Läser in ... Arbetar ... Lägg till i Vill du titta på http://stackoverflow.com/questions/6880511/phpmyadmin-database-import-error-1046-no-database-selected det här igen senare? Logga in om du vill lägga till videoklippet i en spellista. Logga in Dela Mer Rapportera Vill du rapportera videoklippet? Logga in om du vill rapportera olämpligt innehåll. Logga in 22 746 visningar 73 Gillar du videoklippet? Logga in och gör din röst hörd. Logga in 74 7 Gillar du https://www.youtube.com/watch?v=ZciWnmcf7fU inte videoklippet? Logga in och gör din röst hörd. Logga in 8 Läser in ... Läser in ... Läser in ... Rankning kan göras när videoklippet har hyrts. Funktionen är inte tillgänglig just nu. Försök igen senare. Publicerades den 24 apr. 2015how to fix ERROR : #1046 - No database selected MySQL said: Documentation#1046 - No database selected Kategori Spel Licens Standardlicens för YouTube Visa mer Visa mindre Läser in ... Annons Automatisk uppspelning När automatisk uppspelning är aktiverad spelas ett föreslaget videoklipp upp automatiskt. Kommer härnäst MySQL Tutorial for Beginners - 1 - Creating a Database and Adding Tables to it - Längd: 8:50. primetubervideos 652 205 visningar 8:50 1046 Error in SQL In phpMyAdmin[Solved] - Längd: 1:34. Zaroon bin hadi 254 visningar 1:34 IMPORTAR EXPORTAR BASE DATOS SQL PHPMYADMIN - Längd: 8:00. APRENDIZ WEBMASTER 7 940 visningar 8:00 How to Fix No Database Selected Problem in MySQL - Längd: 1:54. Codescoder Program 758 visningar 1:54 SERVIDOR WEB CON XA
"#1046: No database selected" error when trying to import a .sql file in phpMyAdmin. Solution #1: Before importing In phpMyAdmin, http://wisercoder.com/how-to-fix-the-1046-no-database-selected-error-in-phpmyadmin/ click on the Export tab from the home page of phpMyAdmin, without selecting any database. phpMyAdmin will then include instructions to create and select the database when you import it. http://forum.wampserver.com/read.php?2,121899,121960 This solution does not apply to most shared hosts, since they won't allow you to create a database from phpMyAdmin. Solution #2: The alternative fix Unlike solution #1, this one no database 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 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 no database selected 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 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
- MySQL said: #1046 - No database selected Posted by: IrvC (---.hfc.comcastbusiness.net)Date: February 21, 2014 04:27PMI am trying to import the database that I exported from our live site to WAMP using phpMyAdmin. I browse for the .sql file that the export created and click GO. I tried leaving SQL compatibility mode as NONE, and also selected MYSQL40 and MYSQL323 for compatbility mode.I am getting error #1046 - No Database Selected.Any clues?IrvWindows 7WAMP ver. 2.4 (just downloaded this week)Edited 1 time(s). Last edit at 02/21/2014 04:46PM by IrvC.Options:Reply•QuoteRe: Import error - MySQL said: #1046 - No database selected Posted by: RiggsFolly (---.as13285.net)Date: February 23, 2014 03:43PMLook at your .sql file from your database dump. It probably does not contain a 'USE xxx;' statement.So add a USE databasename;To the top of your .sql file where 'databasename' is a database you have previously created using phpmyadmin.---------------------------------------------------------------------------------------------(Windows 7 Pro 32bit) (Wampserver 3.0.6RC2 32bit) - Apache 2.4.18 - PHP 5.6.15 - MySQL 5.7.10