Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 04-19-2011, 06:27 PM   #1
LQ Newbie
Registered: Apr 2011
Posts: 2

Rep: Reputation: 0
importing database to server

I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:
#1044 - Access denied for user ' '@'%' to database ' '
I have been trying for hours to upload my site from the localhost to another server without any luck... I'm using phpmyadmin to import it.
Thank you!
Old 04-19-2011, 07:42 PM   #2
LQ Guru
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Debian, Mageia, and whatever VMs I happen to be playing with
Posts: 14,190
Blog Entries: 24

Rep: Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847Reputation: 3847
There are lots of unanswered question here. Just off the top of my head . . .

1. Is the import file an *.sql file or some other type of file?

2. Do you have shell access to the server?

3. What database program was this created in?

4. What database program are you trying to import it into?

5. Do you have root access to the database program on the Linux box (Note: that is not the same as root access to the OS).

If this a mysql error, this might help:
Old 04-26-2011, 03:23 AM   #3
LQ Newbie
Registered: Apr 2011
Posts: 2

Original Poster
Rep: Reputation: 0
Thank you for replying. Yes, the import file is .sql. I'm using phpmyadmin to export it and to import it. To be honest I'm not very experienced so I don't know if I have shell access to the server. I thought it was related with the permissions so I changed them with the command chmod 777 just for the sql dump file but after that I got the same error. I also checked that the privileges were all granted for the user in phpmyadmin. I don't know what else to do. I'll really appreciate your help.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
importing database in postgres gnurich Programming 1 01-16-2010 08:19 AM
Importing a csv file into a mysql database kaplan71 Linux - Server 13 09-18-2009 07:13 PM
importing wikipedia database dumb mauran Linux - Server 1 08-14-2007 03:41 PM
Problem importing database back to MySql shubb Programming 3 11-29-2005 02:36 PM
MySQL: Importing a database from an XML file concoran General 0 09-08-2003 03:58 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:19 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration