I have moved my forum from one server to another. and I am trying to import my database. but i am getting this error message:
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 195
STR: ===
SQL: # ==========================================================
#
# Database dump of tables in `sabouni_uaeu`
# ӈʣȑ 05, 2006, 12:27:29 am
#
# ==========================================================
#
# Table structure for table `smf_attachments`
#
DROP TABLE IF EXISTS `smf_attachments`;
SQL query:
# ========================================================== # # Database dump of tables in `sabouni_uaeu` # ӈʣȑ 05, 2006, 12:27:29 am # # ========================================================== # # Table structure for table `smf_attachments` # DROP TABLE IF EXISTS `smf_attachments`;
MySQL said:
#1142 - DROP command denied to user: '[email protected]' for table 'smf_attachments'
so any body can help if finding the solution ????
thx
CuTe_MaN
You dont have enough privileges for some commands in your server.
So there are 3 things you can do:
1- Manually delete all the tables in the database if you can.
2- Delete all the table structures from your database backup.
3- Ask your host to give you drop privileges in your database.
Try one of these solutions, then restore your database.
how do you delete table structures from a .gz file?
if you don't know, you're best off asking your host to give you that permission. :)
Its easy to accidentally delete too much
If you had created a new MySQL user for your forum, you might have forgotten to give some privileges to that user. So if you have a main account (like cPanel login account) try to use that when you are restoring.
If you still cant manage to do it, then try one of the solutions above.
Quote from: Elmacik on November 20, 2006, 07:14:47 AM
2- Delete all the table structures from your database backup.
This will give you a hard time if you have any mods installed which alter the tablestructure.
Quote from: xenovanis on April 07, 2007, 08:09:50 AM
Quote from: Elmacik on November 20, 2006, 07:14:47 AM
2- Delete all the table structures from your database backup.
This will give you a hard time if you have any mods installed which alter the tablestructure.
Yes thats absolutely right. The best way would be having the drop privileges.
I have no clue on why a host denies this for a user.
I think only the newly created user doesn't have this privilege by default.
If this is the case, then its very easy to solve this problem from the phpMyAdmin by clicking the "Privileges" button :)
Thanks all for the help
i have solved the problem and it was only a problem in previlages and i fixed it
thx
CuTe_MaN