 Need Help With My Database, I cannot transfer my old site's database |
|
|
|
|
  |
 Aug 14 2007, 01:23 PM
Post
#1
|
|
|
Newbie [Level 2]  Group: Members Posts: 30 Joined: 4-August 07 From: Saudi Arabia Member No.: 47,559  |
I Couldn't import my database info via Import from php my admin and i got the .sql file from the php my admin of my old hosting and every time i try to import it give me an error that i don't have the permissions to do....
 What shall i do?? I need Help Please |
 |
 
|
|
Aug 14 2007, 02:23 PM
Post
#2
|
|
|
Newbie [Level 2] Group: Members Posts: 33 Joined: 3-August 07 Member No.: 47,506 |
i get that problem. But for starters mySQL is a foreign language to me. Sorry
.
|
|
|
|
|
Aug 14 2007, 03:17 PM
Post
#3
|
|
|
Super Member Group: Members Posts: 223 Joined: 27-May 07 From: SOME WHERE Member No.: 43,760 |
did you set the right permissions for that database?
I think that might be the problem, when you make the database, you need to asign a username thing to it, and then set its permissions :/ if not, idk sorry |
|
|
|
|
Aug 14 2007, 03:40 PM
Post
#4
|
|
|
Super Member Group: [HOSTED] Posts: 255 Joined: 21-January 07 Member No.: 37,585 |
While saving your sql information from your old site did you save it in the gzip format. Cause if you save it .zip phpmy admin will not be able to import your data.
|
|
|
|
|
Aug 14 2007, 03:56 PM
Post
#5
|
|
|
A clever man learns from his own mistakes, a WISE man learns from those of OTHERS Group: [HOSTED] Posts: 1,028 Joined: 12-April 06 From: Essex, UK Member No.: 21,719 |
First things first, have you created the database using the database tool that is NOT inside PMA?
In the cpanel there is a tool called "MYSQL DATABASES" in there are the tools for you to create the database itself, you cant create any databases within PMA on T17, you need to use the tool i mention. I dont think you need to create a new user to use PMA but bare in mind that to use a script, eg PHP with a username you will need to create this user using the tool i mentioned above. Once thats all been done try getting the raw SQL code from your export and just nav to the database you want to create tables in and paste the code into the SQL box under the SQL tab and that should work. If this is what youre already doing then try checking the permissions for your users in the tool i said above, if there are no users then create one and give it full permissions, you could try a ROOT user if it isnt there already, if it is then give it full permissions and try again. |
|
|
|
 Aug 14 2007, 07:43 PM
Post
#6
|
|
|
Newbie [Level 3] Group: Members Posts: 48 Joined: 11-August 07 Member No.: 47,989 |
It's weird to "don't have permissions" with the database.
I always do this: Export the database in version 4.0 and zip, checking "drop database" (I don't like to make incrementals) Create a database in other hosting, take note of the name of it, the username and the password Choose the database created in mysql and then import the zipped database Hope this steps help you to have your database working in the new site... |
|
|
|
|
Aug 14 2007, 11:41 PM
Post
#7
|
|
|
Privileged Member Group: [HOSTED] Posts: 936 Joined: 14-April 05 From: West Chester, PA Member No.: 5,636 |
Make sure you are exporting the database as a proper version of sql and that you are importing the same version. Also, as others have said make sure the database already exists or else PHPMyAdmin will not let you create it on Trap17. Finally, make sure the database is correct and not corrupt since i have had bad exports before.
|
|
|
|
|
Aug 15 2007, 02:19 AM
Post
#8
|
|
|
Super Member Group: Members Posts: 221 Joined: 6-June 07 Member No.: 44,288 |
QUOTE(shadowx @ Aug 14 2007, 11:56 AM)  First things first, have you created the database using the database tool that is NOT inside PMA? In the cpanel there is a tool called "MYSQL DATABASES" in there are the tools for you to create the database itself, you cant create any databases within PMA on T17, you need to use the tool i mention. I dont think you need to create a new user to use PMA but bare in mind that to use a script, eg PHP with a username you will need to create this user using the tool i mentioned above. Once thats all been done try getting the raw SQL code from your export and just nav to the database you want to create tables in and paste the code into the SQL box under the SQL tab and that should work. If this is what youre already doing then try checking the permissions for your users in the tool i said above, if there are no users then create one and give it full permissions, you could try a ROOT user if it isnt there already, if it is then give it full permissions and try again. Exactly right on! That's what I was going to say. I'm sure that is the problem. |
|
|
|
|
Aug 15 2007, 12:54 PM
Post
#9
|
|
|
Newbie [Level 2] Group: Members Posts: 30 Joined: 4-August 07 From: Saudi Arabia Member No.: 47,559 |
 None of you are giving me useful things........  .........I'm not a noob in web hosting..... And not a noob in using PHPMyAdmin...... All the things you told me to do i already did men......
|