Back To Programming / Scripting / Coding Forum

MySQL database program

  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 15th, 2004, 6:08 pm

i wasnt sure where else to put this...

does anyone know of a program which can edit a MySQL database offline? sort fo like MS Access, but for MySQL?
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post March 15th, 2004, 6:08 pm

  • Axe
  • Genius
  • Genius
  • User avatar
  • Joined: Jan 07, 2004
  • Posts: 5744
  • Loc: Sub-level 28
  • Status: Offline

Post March 15th, 2004, 6:18 pm

Not really... because it's always stored "online"...

About your only option is having phpMyAdmin export a .sql file with drop commands...

Then you can edit the .sql file and re-upload it, but this can be a lot of hassle if you edit it off-line regularly.
  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 15th, 2004, 7:52 pm

ok, trying to convinc my friends to convert our site at http://www.animenobaka.com over to a dynamic site...

and i dont praticularly care for PHPMyAdmin... i just want a way to edit the database without using a browser...
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post March 15th, 2004, 8:11 pm

Notepad.

I'm not aware of any good offline editors. Even so, you still have to execute the queries on the live database to update it. Basically, you're limited to editing the queries and importing them.

Not sure why you don't like phpMyAdmin - it offers the best of both worlds - Gui for novices and command line for the experienced. I've found it extremely easy to use.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Cae
  • Expert
  • Expert
  • User avatar
  • Joined: Feb 25, 2004
  • Posts: 734
  • Status: Offline

Post March 15th, 2004, 8:26 pm

i just dont like having to use a browser to edit the database... i dont know why, doing anything besides browsing in a browser just doesnt feel right to me...
  • rjstephens
  • Professor
  • Professor
  • User avatar
  • Joined: Jul 28, 2003
  • Posts: 774
  • Loc: Brisbane, Australia
  • Status: Offline

Post March 16th, 2004, 5:06 am

if i remember correctly there is a prog that comes with the windows version of mysql for managing a db. However, I haven't actually used it.

Page 1 of 1

Post Information

  • Total Posts in this topic: 6 posts
  • Users browsing this forum: No registered users and 171 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.