SA-MP Forums

SA-MP Forums (https://forum.sa-mp.com/index.php)
-   Tools and Files (https://forum.sa-mp.com/forumdisplay.php?f=82)
-   -   [Tool/Web/Other] MySQL DB Manager - Easily manage your MySQL databases with this remote application (https://forum.sa-mp.com/showthread.php?t=360857)

fiki574 19/07/2012 08:13 AM

MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
MySQL DB Manager v1.0

Released on 19th July 2012.


__________________________________________________ __________________________________________________

INTRO
This application allows you to easily control your MySQL databases/tables remotely and directly from your computer! No need of connecting to your hoster, then logging in, then finding correct DB/table, etc.! Reason that I created this app is that I wanted to see my C# skills since I went to learn C++, so I gave a try at C#, and also wanted to do something usefull for this community since I was not available pretty much time (here on SAMP)! Although this app indeed does execute same functions like you would have to do in "SQL Command" at your DB hoster, I think it will be helpfull for someone in some cases! Furthermore in this post, you'll be taken through explanations on how-to do something and how to easily manage your MySQL stuff! The application itself is pretty much colorfull and explanatory, so when and if you do something wrong/right, it will say that you did something wrong/right in nice, corresponding colors!

__________________________________________________ __________________________________________________

PICTURES:
Take a look on the app!

http://img18.imageshack.us/img18/5453/dbmgr1.png

http://img442.imageshack.us/img442/8467/dbmgr2.png

__________________________________________________ _______________________________________________

APP COMMANDS:
There are several application commands that will make your managing easier!

help - display help message and commands list
clear - clear whole application
disconnect - disconnect from current connection, choose new connection
reconnect - reconnect to connection that you are/were already connected to
close - close application
credits - self explanatory :P
info - application info such as app version, release date, creation date, update date, etc.
coninfo - connection info (displays host, DB, etc. that you are currently connected to)
mysql - prepare app for executing MySQL commands (NOTE: you must use this before executing command itself, otherwise nothing will happen)!

Also, when executing MySQL commands, you can, but dont have to put the semi-colon ( " ; ")!

__________________________________________________ _______________________________________________

BUGS:
Well, there is currently a bug/glitch, which is: if you put spaces pretty much times in everything (spaces in host, spaces in port, spaces in username, spaces in password, spaces in database), application will still (somehow) connect even though you havent defined ANYTHING from host to database! So, dont abuse that and it'll be good! ;)

Report more bugs, if you find any!

__________________________________________________ _______________________________________________

DOWNLOAD:

Mediafire (v1.0, application + MySQL.Data.dll) (recommended)

Mediafire (v1.0, source)

Mirrors not allowed!!

__________________________________________________ _______________________________________________

Regards,
Fiki! :)

P.S. I know that thread is a bit small, but eh... quality > quantity :P

Glint 19/07/2012 08:16 AM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
Pretty interesting idea, i say good job :).

Ballu Miaa 19/07/2012 08:17 AM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
Wow. Never seen something like this, Great work Fiki. Thanks for the release!

EDIT: Rep+6 Added!

fiki574 19/07/2012 08:18 AM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
Quote:

Originally Posted by Lexi' (Post 1996703)
Pretty interesting idea, i say good job :).

Thanks!

Quote:

Originally Posted by Ballu Miaa (Post 1996705)
Wow. Never seen something like this, Great work Fiki. Thanks for the release!

Thank you! :)

nGen.SoNNy 19/07/2012 10:16 PM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
Nice app:) I will use it to edit my clans:))

R@f 20/07/2012 12:30 PM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
Nice work but I prefer using MySQL Workbench for managing my databases. But for a small and light tool, it's good ;)

Niko_boy 20/07/2012 12:43 PM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
pretty sueful release but is it same as we do in "cmd" comamnd prompt stuff cause it looks like but making things easy

fiki574 20/07/2012 05:14 PM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
Quote:

Originally Posted by Anonym2009 (Post 1998056)
Nice app:) I will use it to edit my clans:))

Thanks! :)

Quote:

Originally Posted by R@f (Post 1999091)
Nice work but I prefer using MySQL Workbench for managing my databases. But for a small and light tool, it's good ;)

Well yea, its not advanced and big as that! Anyways, thank you!

Quote:

Originally Posted by Niko_boy (Post 1999122)
pretty sueful release but is it same as we do in "cmd" comamnd prompt stuff cause it looks like but making things easy

Its easier, yes, but from "cmd" you cant execute MySQL commands (or can you?)! Also, tnx! :D

ca2k 21/07/2012 12:11 PM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
Why is this better than HeidiSQL or any of the other programs which I believe are created and updated by groups of developers? You don't have any UI either. Don't take this is as an insult but I think you should invest your time into something else, you remind of another user on SA-MP forums who had great potential but just wrong directions.

e: nevermind, didn't read the intro.

Lorenc_ 21/07/2012 12:16 PM

Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application
 
If this were like phpmyadmin, but an application I'd be amused.. This doesn't really have much and is basic lol.


All times are GMT. The time now is 10:43 AM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.