[Resolved] gotta be an easier way to work with mysql dbs

jacksonpt

I learned MySQL and PHP from the webmonkey tutorials. I'm currently creating all my dbs using text files with a .dump extension, and "running" them from the command line (files contain SQL commands). Is there a graphical interface that will allow me to create dbs, tables, add/remove records, update data, etc.?

I'm working on Windows 2000 and Apache.

szym9341

Yes...

http://www.phpmyadmin.net/

szym9341

If you use PHPMYADMIN, you can still use your text files to execute creation of tables, etc... Create a database in the program, click on SQL TAB, and browse for your text file... Click "GO" and your tables are all set.

Carello

If you are running the mysql server yourself, you can also use MySQL control panel.

http://www.mysql.com/downloads/mysqlcc.html

It's a GUI for windows.

Shrike

MySQLFront. It's not supported any more so you may have to hunt for it a bit. It can connect to local or remote servers (if it's allowed).

Someone pasted a link on the EL a few days back about a generic DB designer too.

jacksonpt

Thanks for the help everyone. I figured out the MySQLCC, so that makes things much easier. I'm still going to try the other suggestions to see which I like best.