[CalEvans]

Why can't I ever remember to post these things?

This is a great idea and a frustration of mine for a while. It would be nice to have a 'Connection Manager' screen that I could pop up, similar to FireFox's 'Bookmark Manager' And allow me to manage my connections. (Folders would be extra nice since most of my connections fall into client groupings)

I second this idea.

=C=

[CalEvans]

QUOTE (peterlaursen @ May 9 2005, 10:09 PM)

I have noticed the each time I'm doing some experimenting with INNODB tables my INNODB data-file (ibdata1) grows.  When I delete some DB and tables the file doesn't shrink.  I simply think it is the way INNOBD behaves with MySQL.  it “claims” diskspace when needed but does not free it when it is not needed. Now the file here with me is about 200 MB and the data in it is just about 30 MB.  Not a real problem but … However is there any way to “shrink” that file except than dumping the DB, deleting the bases, stopping the MySQLserver, deleting the datafile, restarting the server and importing the dumps ?  And could that be implemented with SQLyog ?

QUOTE

I have noticed the each time I'm doing some experimenting with InnoDB tables my InnoDB data-file (ibdata1) grows.  When I delete some DB and tables the file doesn't shrink.  I simply think it is the way InnoDB  behaves with MySQL.  it “claims” disk space when needed but does not free it when it is not needed.

This is not a bug it's a feature. 🙂

You can solve this by turn off the 'autoextend' feature in InnoDB. But I've been working with InnoDB tables for some time now and can say the feature is great. no it doesn't shrink the tables when you are deleting data but when you compare it to Oracle or M$SQL which both just claim the space up front, it's a pretty good option. No major RDBMS that use the table space concept actually release blocks that are not being used. (That I know of)

If you do not specify autoextend then Innodb will allocate the entire table space you specify.

If you are worried about it eating up your entire HD then don't use autoextend and specify only a single table space that is the size you need it. You can always add more as you need them. (Or as they fill up and your app stops working.)

All-in-all, a few GB of disk space is a small price to pay for what InnoDB gives us. (IMHO, etc.)

=C=

[CalEvans]

I second this!

=C=

[CalEvans]

MySQL has rejected the combination of your login and host. You need to change the user settings on the server before you will be able to connect.

=C=

[CalEvans]

Not from within SQLYog. You would need some kind of reporting tool for that. The easiest way I can think of to do it is to copy to clipboard in CSV, paste into Excel (or Open Office) and then print it.

HTH,

=C=

[CalEvans]

Ok, obvious question. Do you have mysql running on your local windows box?

=C=

[CalEvans]

Yes, SQLYog supports ssh but it's beyond the scope of this forum to teach you how to use it.

Once you get connected, you can use it to build a tunnel to the local MySQL on the server.

For a basic list of instructions, try:

http://www.google.com/search?hl=en&q=how+t…G=Google+Search

HTH,

=C=

[CalEvans]

I second this. User management is one of the last remaining weak areas for SQLYog.

=C=

[CalEvans]

From a technical standpoint, yes you can do that.

From a legal standpoint, of course you can't do that.

IANAL! (and I'm paraphrasing here)

MySQL's license states something to the effect that you can use MySQL in a application but you cannot distribute MySQL with your application without a license. If you are serious about your application then you need to contact MySQL and negotiate a distribution license.

HTH,

=C=

[CalEvans]

err…umm…check the '2 Reults' tab in the results pane. It worked for me. (different table and field names, of-course)

=C=

[CalEvans]

IMHO,

(and take it for what it's worth)

I've always found the relationship manger a weak link in SQLYog. Whenever I have to change things, I usually end up copying the tables over to test (create table test.yaddyadda select * from yaddayadda) dropping and recreating the tables with the relationships intact. Then reloading the data.

Occasionally, I have to use

set foreign_key_checks=0;

before reloading the data but I try not to because the errors help me find problems.

This methodology helps me separate syntax errors 9which usually bite me in the ass every time) with data issues.

HTH,

=C=

[CalEvans]

Um…since you are using the root login, you'll need the root password for the server you are connecting to.

=C=

[CalEvans]

1) http://dev.mysql.com/doc/mysql/en/date-and…-functions.html

look for DATE_FORMAT(date,format). If you are asking is there any way to change it in SQLYog? no, because SQLYog does not display dates, it displays the results of a query. MySQL is in charge of the format.

2) No, MySQL is a database engine. As such it is very difficult to do what you want to do. You CAN, with a properly built table, use F8 to enter data in but it is cumbersome. (and it should be) If you need ease of use you'll need to look at designing a front end application to allow you to edit your information.

3) Sorry, can't help you with this one. I only use database products. Access doesn't fall into that category. 😉

HTH,

=C=

[CalEvans]

Sounds like when you are sshing in and connecting you are connecting as whomever@localhost. When you are creating a tunnle, you are connecting as whomever@ip. You need to grant permissions to whomever@%. See if that doesnt' solve the problem.

=C=

[CalEvans]

CTRL-F4 is the Windows standard for close existing window.

=C=

[Author]

Posts