Go Back   Computer Forums > General Computing > Server Administration
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 02-17-2005, 10:20 PM   #1
In Runtime
 
Satori's Avatar
 
Join Date: Jan 2005
Posts: 268
Send a message via AIM to Satori Send a message via MSN to Satori Send a message via Yahoo to Satori
Default Default MySQL Databases.

Fooling around with MySQL the other day, I managed to delete every database on the server. Not really a problem, considering I didn't really use it for much anyway. I've come to a point, now, where I need to use it.

Apparently, what I'm trying to do requires the default 'mysql' database that MySQL comes with. Since I deleted that, I'm wondering if there's anyway I can restore. Nothing special or anything, it just has to be the database MySQL ships with.

I've tried unemerging and emerging MySQL (I'm on Gentoo, by the way), but that hasn't helped. Any thing you guys could offer would be appreciated.
__________________

__________________
Awesomeindustries.net
Satori is offline   Reply With Quote
Old 02-18-2005, 05:02 AM   #2
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 7,999
Default Re: Default MySQL Databases.

you need the MYSQL database that come standard with MySql because it contains a users table, without this table the database doesn't know if the user you specify has any privelages on the database, this prevents you from restoring it.

If you can install the database on another machine there is hope however...

tables are stored as flat files in /var/lib/mysql/mysql
(the last mysql is the database name)...
you could try copying them from another machine
__________________

root is offline   Reply With Quote
Old 02-18-2005, 10:28 AM   #3
In Runtime
 
Satori's Avatar
 
Join Date: Jan 2005
Posts: 268
Send a message via AIM to Satori Send a message via MSN to Satori Send a message via Yahoo to Satori
Default Re: Default MySQL Databases.

I figured it out not to long after I posted this thread. MySQL includes a tool called 'mysql_install_db' that does exactly this. It reinstalls the default databases and tables'.

Pretty nifty.
__________________
Awesomeindustries.net
Satori is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 06:11 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0