Advertisement:

Author Topic: Error in importing Database  (Read 3001 times)

Offline CuTe_MaN

  • Jr. Member
  • **
  • Posts: 106
  • Gender: Male
  • www.samasyria.net
Error in importing Database
« on: November 20, 2006, 06:55:38 AM »
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:

Code: [Select]
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: 'rsaboun_uaeuclub@66.152.166.16' for table 'smf_attachments'



so any body can help if finding the solution ????

thx

CuTe_MaN

Offline Elmacik

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,285
  • Gender: Male
  • = Human Draft =
    • IT Store
Re: Error in importing Database
« Reply #1 on: November 20, 2006, 07:14:47 AM »
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

Offline dirtylaundry

  • Semi-Newbie
  • *
  • Posts: 94
Re: Error in importing Database
« Reply #2 on: April 06, 2007, 10:42:28 PM »
how do you delete table structures from a .gz file?

Offline metallica48423

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,842
  • Gender: Male
  • Professional Multislacker!
    • Zentendo
Re: Error in importing Database
« Reply #3 on: April 06, 2007, 10:59:31 PM »
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

Quote
Microsoft 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
     

Offline Elmacik

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,285
  • Gender: Male
  • = Human Draft =
    • IT Store
Re: Error in importing Database
« Reply #4 on: April 07, 2007, 01:56:27 AM »
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

Offline xenovanis

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,988
  • Gender: Female
Re: Error in importing Database
« Reply #5 on: April 07, 2007, 08:09:50 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."

Offline Elmacik

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,285
  • Gender: Male
  • = Human Draft =
    • IT Store
Re: Error in importing Database
« Reply #6 on: April 07, 2007, 08:29:13 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

Offline CuTe_MaN

  • Jr. Member
  • **
  • Posts: 106
  • Gender: Male
  • www.samasyria.net
Re: Error in importing Database
« Reply #7 on: April 08, 2007, 02:54:44 AM »
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