How do I manage my mysql database in Mandrake 10?
 

Hi

I've got a mysql database I want to add to the mysql service. How do I manage mysql (something with a gui preferrably)

I'm Using Mandrake 10

Could you clarify that a bit. Sounds like you want to 'add' to the MySQL service. Do you mean create a new table or database?

First you need to find where the mysql binary file is:
as root:
updatedb ; locate mysql | more

Then you run that binary, and you should get something like
mysql>
and thats where you type your commands
Not sure about a GUI for it. Probably one exists, but why don't you learn MySQL the normal way? It's easy enough.

Like BluePyre, I'm not quite sure I inderstand your question. But if you have an existing backup of a MySQL database (a file named something.sql), Then you can create and add that database with the following commands:

mysqladmin -p create newDBname
mysql -p newDBname < something.sql

You will be prompted for your password after each command (that's what the -p flag does). You can check that this worked by listing the tables from your database with this command:

mysqlshow -p newDBname

While I haven't used any GUI for MySQL, phpMyAdmin is quite highly recommended in the press and on this forum.

Enjoy!
--- Cerbere

[edit] How rude of me! I forgot to welcome you to LQ.org . . . So, Welcome! [/edit]