URGENT HELP PLEASE

by 6 replies
8
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.
#programming #urgent
  • 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?
  • 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.
    • [ 1 ] Thanks
  • 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..
    • [ 1 ] Thanks
  • 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
  • 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.
  • 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.
Join the discussion

Next Topics on Trending Feed

  • 8

    URGENT HELP PLEASE

    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;