×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Can't drop my database

Can't drop my database

Can't drop my database

(OP)
Hello,
We had a crash because during a replication the network broke away. Now all MySQL tables are displayed in NAVICAT. However, if I want to access it, I'm told "table does not exist". This affects all DBs present on the host and all tables in them. Actually, I do not need the tables any more, because I want to copy them from the backup. They can all be deleted. But if I want to delete it, comes the message that they do not exist. If I want to create a new table with an existing name, the message "Table already exists" appears. The databases can not be deleted (Error 41). New databases can be created.

What do you think if I delete in the directory data the subdirectory praxis1 (that is the concerning DB)? Maybe then I can create the DB praxis1 again?

Greeting Norbert

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close