Mysqladmin - table dump question

[Rhodan]

Edit: Make that MySQL Query editor, not admin!

I'm making two tables - one for class names and one for race names. I find them exceptionally handy when trying to figure out the starting items since I can then show the race name and class name instead of just their ID in a query.

I figured out that right clicking on a table name lets you copy the SQL to create that table, but I can't seem to find anything that lets me also create a list of entries for the table. Would anyone happen to know how?

[Belfedia]

Edit: Make that MySQL Query editor, not admin!

I'm making two tables - one for class names and one for race names. I find them exceptionally handy when trying to figure out the starting items since I can then show the race name and class name instead of just their ID in a query.

I figured out that right clicking on a table name lets you copy the SQL to create that table, but I can't seem to find anything that lets me also create a list of entries for the table. Would anyone happen to know how?

If nobody answer you, try : http://dev.mysql.com/doc/refman/5.0/en/index.html
this is better to search in mysql guide :) But you have many help guide on web.

[Rhodan]

Yeah, I searched through there.

I can dump the tables using mysqldump but the server is in a different room and I'm using MySQL Query Browser remotely. Still can't find that function in the browser... Oh well, I don't need it myself. I just figured I could dump and post here once I'm done in case anyone else wanted to use it.

[John Adams]

If you are not using these already, give them a try:

http://www.mysql.com/products/tools/

Or use the MySQLCC tool that is linked in the Wiki for Windows Server setup. I think you can export with all those tools. And you should be able to dump straight out of mysql> but I have never done this.

[Rhodan]

thats what I'm using - the MySQL query browser.

[John Adams]

Then in the MySQL Admin part, there's a Backup. Can't you just back up one table?

[Rhodan]

Thats it!

I had tunnel vision- kept looking for "export" stuff, not backup....

Quite easy to use too, almost idiot proof.

[John Adams]

Almost...

~runs~



;)

[Rhodan]

Lol, thats why i said "almost" :roll: