Arch Linux

Carlwill

Member

From: Orlando, FL

Registered: 2008-10-06

Posts: 560

Website

Front End For MySQL?

I am looking for a front end application that will allow me to enter in all my server / workstation data into a MySQL backend running on Arch Linux. I have been told that I need to take all 75 servers we have in our server room and keep a database of the following:

- Make
- Model
- O.S.
- I.P.
- Hostname
- Serial #
- Company Asset #
- Warranty Expiration Date
- Room Location

Does anyone know of a program or easiest way I can enter all this data into a MySQL database and manage it as things change and move around? Right now I am using a spreedsheet from OpenOffice and it's not efficient if you know what I mean. Anyone have any tips / suggestions?

---

./

pyther

Member

Registered: 2008-01-21

Posts: 1,395

Website

Re: Front End For MySQL?

Have you tried openoffice database, it might be easier to use than mysql. In addition, I have no idea what you mean by it is not efficient, what do you want to do with said information?

---

Website - Blog - arch-home
Arch User since March 2005

jt512

Member

Registered: 2009-02-19

Posts: 262

Re: Front End For MySQL?

I am looking for a front end application that will allow me to enter in all my server / workstation data into a MySQL backend running on Arch Linux. I have been told that I need to take all 75 servers we have in our server room and keep a database of the following:

- Make
- Model
- O.S.
- I.P.
- Hostname
- Serial #
- Company Asset #
- Warranty Expiration Date
- Room Location

Does anyone know of a program or easiest way I can enter all this data into a MySQL database and manage it as things change and move around? Right now I am using a spreedsheet from OpenOffice and it's not efficient if you know what I mean. Anyone have any tips / suggestions?

pacman mysql-gui-tools

Rumor

Member

From: Albany, NY

Registered: 2006-07-07

Posts: 638

Re: Front End For MySQL?

It depends on how much "muscle" you want in your interface. If you want something with more oomph, you might look at phpmyadmin or mysql-workbench, both of which are in the community repo.

If you want something a little less intense, Dadabik (http://www.dadabik.org/) offers a straightforward interface that is easy to set up.

---

Smarter than a speeding bullet
My Goodreads profile

Zariel

Member

Registered: 2008-10-07

Posts: 446

Re: Front End For MySQL?

Im just running phpmyadmin, pretty happy with it

briest

Member

From: Katowice, PL

Registered: 2006-05-04

Posts: 468

Re: Front End For MySQL?

Consider using RackTables.