| Author |
 Topic Search  Topic Options
|
ctscott 
Senior Member
Joined: 27 May 2003
Location: United States
Status: Offline
Points: 246
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: MySQL Administration
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.
|
|
|
 |
ctscott
Senior Member
Joined: 27 May 2003
Location: United States
Status: Offline
Points: 246
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 February 2006 at 9:43pm |
|
Found MySQL Administrator. Seems to work but it ain't no EM.
|
|
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
ctscott
Senior Member
Joined: 27 May 2003
Location: United States
Status: Offline
Points: 246
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
ctscott
Senior Member
Joined: 27 May 2003
Location: United States
Status: Offline
Points: 246
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
ctscott
Senior Member
Joined: 27 May 2003
Location: United States
Status: Offline
Points: 246
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
