EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::General Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=613)
-   -   mysql drop / create database (https://www.eqemulator.org/forums/showthread.php?t=3959)

mudman 11-21-2002 06:49 AM

mysql drop / create database
 
in the database tab window

right clicking on a database should have a dropdown window with the drop database , create database etc. today it is missing , somehow locked out on the mysql interface from doing this.

I have seen this problem before with 3.23 but can't remember what fixed it. all i have now is flush hosts , flush ect.

anyone know what causes this? the options arn't even greyed out they just arnt there.

Thanks mudman

Trumpcard 11-21-2002 07:14 AM

Its the new verison of winmysqladmin..

You need to use the command line to do it..


c:\mysql\bin\mysql

mysql>drop database eq;
mysql>create database eq;
etc.

mudman 11-21-2002 09:21 AM

.
 
wierd that was a nice little feature, wonder why it was dropped. i thought i saw it on a previous installation of the same version of mysql though. guess it does not matter

but.. i tried create database in mysql prompt and it did not show up in the database window which worries me. i reinstalled with 3.23 but same deal.

ty

Xan 11-23-2002 09:31 PM

I know im retarded for not knowing how to do this but could you please be a little more detailed? i dont really know much about this MySQL program and using the command prompt to control it.
Thanks

Drizzt40 12-06-2002 11:40 AM

Xan...Just do this.

Go to C:\Mysql\bin\Mysql.exe
(Or wherever you may have installed it,above is the default directory)

To create the EQ database type...

Create Database EQ;

To drop it type....

Drop Database EQ;


All times are GMT -4. The time now is 10:11 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.