Online Reservation System:
Software, database & hosting

Error 1044 when importing a SQL dump into the database

Question: 

Searching …

 

Unfortunately nothing found on "".

Premium support for Bitpalace web hosting customers only!

 from Saint Vincent and the Grenadines: +49 30 32 70 18 92, Fax (in Germany) +49 30 32 70 18 91

service@bitpalast.net 

Skype: bitpalast

One moment please … your browser is loading the page.

 

 

Symptom

You are trying to import a database dump into your database here. The import aborts with the error message: "#1044 - User 'loginname'@'localhost' has no access permission for database ''".

 

Cause

Your database dump file has a "USE" statement followed by the name of the database on the old server where you created the dump. At the beginning of the import, the database is therefore instructed to use the database with the name . However, since the database is not named here, the system cannot access it and responds with the access error.

 

Solution

The USE statement must be removed from the dump so that the dump can be imported into a new database of any name. Edit your database dump file with a text editor. Remove the line "USE " and save the modified file. Now start the import again.

 

Overview of frequently asked questions 

 

 

 


 

  from Saint Vincent and the Grenadines: +49 30 32 70 18 92 •  GmbH, Sensburger Allee 27, D-14055 Berlin (Germany)
Your purchase is tax-free, because you order from a non-EU country. © 2024  GmbH. All rights reserved. and the logo are registered trademarks of GmbH. For photo credits see imprint.

Imprint Privacy policy Sitemap