PDA

View Full Version : error 1130 when trying to import database


94SupraTT
Mon 17th Mar '03, 9:31pm
bash-2.05$ mysql -u****** -p***** tidewaterracing_com < /var/www/html/317bacckup.sql


ERROR 1130: Host 'localhost.localdomain' is not allowed to connect to this MySQL server


Why do I get this error when trying to import my database? I am moving servers. I have imported a database on my old server but I am now moving my website to a new webhost.

Steve Machol
Mon 17th Mar '03, 9:47pm
Is there a MySQL server on this server?

94SupraTT
Mon 17th Mar '03, 9:56pm
Is there a MySQL server on this server?

Umm, ok honestly I don't know :( I thought using that command would just direct my dumpfile to the database that I listed. Its the same command I used before but I used it on another server (my old webhost).

Steve Machol
Mon 17th Mar '03, 9:59pm
Well you do need to have MySQL running on that host. You also need to have a db user and database already in place to be able to import the backup. I suggest you ask your host for help with this.

94SupraTT
Mon 17th Mar '03, 10:06pm
Well you do need to have MySQL running on that host. You also need to have a db user and database already in place to be able to import the backup. I suggest you ask your host for help with this.
I actually do have a database user and database up. I just used the *** to edit it out of this post. I didn't want my password posted :D

Steve Machol
Mon 17th Mar '03, 11:26pm
I understand that. However you still need to ask your host for help. Just send them this error you are getting.

94SupraTT
Tue 18th Mar '03, 3:50am
I understand that. However you still need to ask your host for help. Just send them this error you are getting.

Thanks! I'll get with them.