LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 04-19-2011, 05:27 PM   #1
CSmed
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, 06:42 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Debian, Mageia, and whatever VMs I happen to be playing with
Posts: 12,625
Blog Entries: 16

Rep: Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245Reputation: 3245
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:

http://bytes.com/topic/mysql/answers...w-i-ruin-error
 
Old 04-26-2011, 02:23 AM   #3
CSmed
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.
 
  


Reply


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 07:19 AM
Importing a csv file into a mysql database kaplan71 Linux - Server 13 09-18-2009 06:13 PM
importing wikipedia database dumb mauran Linux - Server 1 08-14-2007 02:41 PM
Problem importing database back to MySql shubb Programming 3 11-29-2005 01:36 PM
MySQL: Importing a database from an XML file concoran General 0 09-08-2003 02:58 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 03:17 AM.

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