8 {{ upvoteCount | shortNum }}
8 {{ upvoteCount | shortNum }}

URGENT HELP PLEASE

by atikbabu
6 replies
Hello,
I can't import sql database back up. It shows all the time that 'can't import sql says your [db_email] is already exists.'
When i go to delete this previous database there is no option and also tried by sql command ----> DROP Database my data base name;
But it's not happening.
Please reply here. I am waiting for your kind reply eagerly.If the problem is not solved i gonna be mad.
Thanks.
#urgent
  • Profile picture of the author mlab
    atikbabu,

    All IT problems are solvable..so no need to get mad!

    It is difficult to troubleshoot via a forum.
    Too many questions back and forth, you know?

    Starting with

    What host are you using?
    Is it shared hosting?
    How exactly did you export the sql from the original site?
    Are you trying to import into a db on the same server as the original db?
    Where are you moving from - and to?
    {{ DiscussionBoard.errors[6561553].message }}
  • Profile picture of the author Mr Bill
    Try renaming the db to a slightly different name and see if you can import it that way. At least you'll know if it's broken or not.
    {{ DiscussionBoard.errors[6563557].message }}
  • Profile picture of the author purpleviolet
    I think Bill gave a valuable suggestion . Instead of bangng heads wat went wrong, its better to change the name and see if its not broken..
    {{ DiscussionBoard.errors[6580176].message }}
  • Profile picture of the author SteveSRS
    DROP Database my data base name;
    should be
    DROP dbname;

    nothing more.
    Also you could add: DROP IF EXISTS 'dbname' in your sql file before every 'create' statement.

    I would suggest using phpmyadmin that is a lot easier to handle such things
    Signature
    {{ DiscussionBoard.errors[6580263].message }}
  • Profile picture of the author jaasmit
    Try to create a new database in the same host or if possible try that in a different host. Make sure that user name and password were given correctly.
    {{ DiscussionBoard.errors[6612650].message }}
  • Profile picture of the author jaasmit
    You do not need to delete that database you can just create a new one and try to do the thing that you wanted to do with the previous one.
    {{ DiscussionBoard.errors[6612683].message }}

Trending Topics