MySQL Administration
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18320
Printed Date: 29 March 2026 at 5:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MySQL Administration
Posted By: ctscott
Subject: MySQL Administration
Date Posted: 08 February 2006 at 2:33pm
|
with the coming release of 8.0 i thought i'd fool around with MySQL a little. i've downloaded version 5, and see it running in Component Manager (xp pro). My question: even tho. i'm having trouble logging in, yet i can ping it, what tool(s), like EM for MSSQL, does one use for this. recomendations are more than welcome. ------------- ______________________ http://www.cfbtrivia.com" rel="nofollow - College Football Trivia |
Replies:
Posted By: ctscott
Date Posted: 08 February 2006 at 9:43pm
|
Found MySQL Administrator. Seems to work but it ain't no EM. ------------- ______________________ http://www.cfbtrivia.com" rel="nofollow - College Football Trivia |
Posted By: dpyers
Date Posted: 09 February 2006 at 1:21am
|
you might want to look at phpadmin or yog
------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: WebWiz-Bruce
Date Posted: 09 February 2006 at 12:05pm
|
I purchased a copy of SQLyog, and must say that along with mySQL Administrator, you can do everything you need to within mySQL.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: ctscott
Date Posted: 09 February 2006 at 2:09pm
|
thanks. i'll give yog a try. i got a feeling i'll be wanting the Enterprise version for importing. ------------- ______________________ http://www.cfbtrivia.com" rel="nofollow - College Football Trivia |
Posted By: ctscott
Date Posted: 10 February 2006 at 1:52pm
|
yog i like. the one problem i have is restoring/importing from my desktop to my ISP. before i spring for the Enterprise version, does anyone know if it will do that? there's got to be a way to do it. ------------- ______________________ http://www.cfbtrivia.com" rel="nofollow - College Football Trivia |
Posted By: WebWiz-Bruce
Date Posted: 10 February 2006 at 2:06pm
|
The way I do it, but requires access to the server, is to simply copy the data folder for the database in question from one mySQL intence to another.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: ctscott
Date Posted: 10 February 2006 at 2:21pm
|
i this particular case i don't have access to the data folders, still trying stuff tho. i would think we'd need to sort this one out as i expect others to experience this. ------------- ______________________ http://www.cfbtrivia.com" rel="nofollow - College Football Trivia |
Posted By: ctscott
Date Posted: 10 February 2006 at 2:42pm
|
WOOT! Using yog,
1. on my connected desktop db: export database as sql statements
2. connect to ISP db and import from sql statements
and walla! data, structures et al moved. ------------- ______________________ http://www.cfbtrivia.com" rel="nofollow - College Football Trivia |
Posted By: WebWiz-Bruce
Date Posted: 10 February 2006 at 3:17pm
|
I've not messed around with yog to much as I only use it for reading data in a mySQL database, but it does a good job, which is why I bought a license for it.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: ctscott
Date Posted: 10 February 2006 at 4:44pm
|
since i may use it every now and then i think i'll get the pro version to get rid of the nag screen and help support them a little. it strikes me as a pretty good product. ------------- ______________________ http://www.cfbtrivia.com" rel="nofollow - College Football Trivia |
Posted By: RAVALON
Date Posted: 13 February 2006 at 2:55pm
|
I'am one of the first user to convert this forum to MySQL ----borg know this because i send some advice for future conversion...
I can say you need only MySQL official tools for use MySQL....
MySQL Administration
MySQL Query Browser
MySQL Conversion wizard manager
With this tools you could admin you forum very well...
In the world there are many software for MySQL but the officials are good!
|
Posted By: Yeormom
Date Posted: 24 February 2006 at 2:16pm
| MySQL-Front is very useful. |