If you accidentally delete the entire Mysql database.... menu

User Tag List

Results 1 to 5 of 5
  1. #1
    tbdcarakias's Avatar Member
    Reputation
    4
    Join Date
    Jul 2009
    Posts
    76
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    If you accidentally delete the entire Mysql database....

    Is there a way to get it back?

    Can someone just make a dump of theirs and you restore yours via the dump?

    If so... would someone mind doing that for me?

    edit: By 'entire mysql database' I literally mean just the one titled mysql.. not realmd, not mangos, etc.. just 'mysql'.
    Last edited by tbdcarakias; 01-05-2010 at 11:03 PM.

    If you accidentally delete the entire Mysql database....
  2. #2
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    If your able to backup your databases you currently have and then reinstall the SQL server. The MySQL table stores all the data about users who can connect to your DB, their permissions and logs etc, so basically somebody elses would probably not work well with yours and end up with a ton of errors.

  3. #3
    Ground Zero's Avatar ★ Elder ★
    Reputation
    1132
    Join Date
    Aug 2008
    Posts
    3,504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you mean MySQL.bat then just restore it from Recycle bin.
    If you don't have it check Hellgawds compile thread and download the MySQL server.
    If you deleted the content of your DB just reinstall it from where ever you got it from.

  4. #4
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Ground Zero View Post
    If you mean MySQL.bat then just restore it from Recycle bin.
    If you don't have it check Hellgawds compile thread and download the MySQL server.
    If you deleted the content of your DB just reinstall it from where ever you got it from.
    If you read the post you would of seen that he said the MySQL database and for future reference not all SQL servers have a MySQL.bat file, some run from services/windows.

  5. #5
    tbdcarakias's Avatar Member
    Reputation
    4
    Join Date
    Jul 2009
    Posts
    76
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks guys, when I try to backup my other databases by SQL dumps, I get an error about missing files or something such as mysql.tables.

    Another user was kind enough to share a dump of their mysql database, but that just gave me a different error. They recommended I uninstall/reinstall mysql. I'll do that.

    Thanks for the replies everyone.

Similar Threads

  1. Replies: 6
    Last Post: 02-23-2016, 08:50 AM
  2. How do the Chinese mail the entire WoW server? Can you help me do it?
    By krzysiek in forum World of Warcraft General
    Replies: 16
    Last Post: 03-26-2010, 03:34 AM
  3. How do the Chinese mail the entire WoW server? Can you help me do it?
    By krzysiek in forum World of Warcraft Bots and Programs
    Replies: 0
    Last Post: 03-22-2010, 07:24 AM
  4. If you manage to NOT laugh the entire video
    By SpikeeeN in forum Community Chat
    Replies: 22
    Last Post: 07-30-2008, 10:01 AM
All times are GMT -5. The time now is 06:46 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search