aglongo Posted February 14, 2003 Posted February 14, 2003 Hello, I am trying to transfer a MySQL database from one site to my local TCH site. I have the dump and I have tried to run: RESTORE TABLE field1,field2,field3,etc FROM '<Database Path>' I keep getting the error: RESTORE TABLE field1,field2,field3,etc FROM '<Database Path>'Access denied for user: '<real_user>' (Using password: YES) I have tried locally, through PHPMyAdmin, and remotely, through MySQL - Front, with different users, but to no avail. I have check the path several times and the access rights. I am at a loss. Can anyone help? Angelo Quote
rayners Posted February 14, 2003 Posted February 14, 2003 Out of curiousity, how did you create the dump? I've always had phpMyAdmin on any MySQL DB I've used, so it was just a matter of exporting from one, and then running that SQL in the other. Quote
aglongo Posted February 14, 2003 Author Posted February 14, 2003 I used a web backup from Cpanel on the other site. This included the SQL dump as part of it. Thank you Angelo Quote
rayners Posted February 14, 2003 Posted February 14, 2003 Okay, just looking at that right now, in CPanel, under backup, there is an option to Restore an SQL DB. Have you tried that? And if that doesn't work, after my quick perusal of the backup file I just generated from one of my DB's here, you should be able to just run the file through MySQL to restore everything. Quote
aglongo Posted February 14, 2003 Author Posted February 14, 2003 Yeah, I see it. Thank you. I am used to doing this via SQL, so I did not consider another place. When I look at the browse button, it goes to my local box. So, I am trying to figure a way to utilized the local copy in stead of copying it back to the server. Angelo Quote
rayners Posted February 14, 2003 Posted February 14, 2003 Same here. I do everything but create databases with PhpMyAdmin, so I can understand where you're coming from. This was a discovery for me as well. Quote
aglongo Posted February 14, 2003 Author Posted February 14, 2003 Thank you, I was using the DB/Table dump rather than the straight DB dump. Also, I had to upload the new files directly anyway. I appreciate your help. Angelo Quote
TCH-Alan Posted February 15, 2003 Posted February 15, 2003 Good to see that you've sorted it out. I would have suggested to open a support ticket and I would have acutally imported it for you if it was a straight dump back into the database from a .sql file. This is usually for people who have large databases and find that phpMyAdmin times out. Alan Quote
KevinW Posted February 15, 2003 Posted February 15, 2003 Alan, Good info -- glad to know we can do that for our users! -kw Quote
aglongo Posted February 18, 2003 Author Posted February 18, 2003 Actually, I have opened three tickets on the issue and I guess I did not explain it carefully. But thank you for the help. Angelo Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.