News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Error in importing Database

Started by CuTe_MaN, November 20, 2006, 06:55:38 AM

Previous topic - Next topic

CuTe_MaN

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

Elmacik

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.
Home of Elmacik

dirtylaundry

how do you delete table structures from a .gz file?

metallica48423

if you don't know, you're best off asking your host to give you that permission. :)

Its easy to accidentally delete too much
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Elmacik

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.
Home of Elmacik

xenovanis

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.
"Insanity: doing the same thing over and over again and expecting different results."

Elmacik

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 :)
Home of Elmacik

CuTe_MaN

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

Advertisement: