Permission to insert on database

[Wisdom_Mcr]

I have been workin on my website n changin database and i backed it up yesterday (luckily) to a .sql file

Today i find a older version so i dropped the tables in phpMyAdmin and tried 2 import my backup from file...when i tried i get the message that i dont have permission to insert into databse (unluckily)

If admin could mayb email me then i can email them a copy of the file and they import it 4 me? would that work?

Any help is appreciated



Wisdom_Mcr
Web: http://wisdommcr.pcriot.com
Blog: http://wisdommcr.wordpress.com
Email: wisdom.mcr@gmail.com

 

[Synkc]

Try creating the database manually through the database creation wizard in your cPanel; then remove any "Create Database" commands from your .sql file.
Now you should be able to restore the remaining data from the file.

 

[Wisdom_Mcr]

Thats not the problem, i already have the database created the SQL is just trying to create the tables and populate them, not create the actual databae.

The first table in the SQL is created but then i get errors when values are being added to it.

Without being able to even use my own controlpanel to add stuff (coz i cant log in without it checking username n pass from database) now i am a bit lost. I cant even manually insert in phpMyAdmin which i have tried and i get same error as when u try to import SQL.

Regards




Wisdom_Mcr

Web: http://wisdommcr.pcriot.com
Blog: http://wisdommcr.wordpress.com
Email: wisdom.mcr@gmail.com
Edit:
After a little bit of fiddling with the code i have managed to get the tables created and populated now.

Thanks anyway guys




Wisdom_Mcr

Web: http://wisdommcr.pcriot.com
Blog: http://wisdommcr.wordpress.com
Email: wisdom.mcr@gmail.com

 

[Lancer]

Did you check to see if the use on that database has insert permissions?