[CalEvans]

Luc_40 wrote on Jan 9 2006, 06:37 PM:

CalEvans, please help me as soon as you can …

[post=”8399″]<{POST_SNAPBACK}>[/post]

My First question is why define the constraint if it's optional. If the value can be null the the contrstrint is optional. It's ok to have these in oyur modle but you may not want to bother defining it in your physical schema.

If you feel you must have it (i.e. for cascading delete purposes) then your update clause needs to be NO ACTION

i.e.

Alter table bird add Foreign Key (father_id) references bird (vogel_id) on delete cascade on update no action;

I've not tried this but I believe it's what you are looking for.

Let me knof if this doesn't work and I'll try again.

=C=

[CalEvans]

psl86 wrote on Jan 6 2006, 08:58 PM:

Im making this site using PHP

http://www.metbootlegs.com/newsite/index.php

And some of the shows have different versions and I would like too copy all the info in SQLyog so that I dont have to add all the info again for the show (like for example venue, city and so on).

Anyone`?

[post=”8386″]<{POST_SNAPBACK}>[/post]

Hi,

If I am understanding you correctly then you are asking for functionality that does not exist in SQLYog.

SQLYog is primarily a query tool. The majority of the users I know use it for working on databases, fixing problems, data mining, etc. Not for data entry. Therefore features like carrying data from one record to a new blank record. (i.e. FoxPro has this feature and it's pretty cool) SQLYog is not for this. It can be used for volume data entry but by-in-large it's not.

You would be better off investing your efforts in building a PHP data entry page that did this. (isn't terribly hard, I can think of at least 2 ways to do it right now)

IMHO, etc.

=C=

[CalEvans]

billmaltby wrote on Nov 16 2005, 05:02 PM:

Sometimes, if I minimise my SQLyog window (windows 2003 server) with an open connection and then restore it, the whole window is grey.  <_< It seems that SQLyog is not refreshing the window (all the SQLyog icons and menus are still displayed) but not the databases and tables Any ideas? Bill

[post=”7901″]<{POST_SNAPBACK}>[/post]

Bill,

What version fo SQLYog? We've got 2 licenses here both running on XP Pro and don't have that problem. I think both of ours are 4.1

=C=

[CalEvans]

peterlaursen wrote on Oct 31 2005, 05:34 AM:

Foreign Keys/relationships:

When will webyog finally present a sqlyog version that supports management of foreighn key/relationships for myisam? Most used table engine for mysql is MyISAM. Current Mysql dbms version provides foreign key support for a while now. It is a must.

[post=”7747″]<{POST_SNAPBACK}>[/post]

Unless things have changed in MySQL 5.0 MyISAM does not support foreign key constraints. Yes, they are necessary that's why I never yse MyISAM tables for anything other than trival tables.

Next time do a little research before blaming SQLYog. SQLyog can't support a feature that does not exist in MySQL.

=C=

[CalEvans]

peterlaursen wrote on Sep 12 2005, 03:42 PM:

field-delimiter should be ; (semicolon) –  not , (komma),

First pic: komma used

Second pic: semicolon used

[post=”7131″]<{POST_SNAPBACK}>[/post]

No, if that were so then the file format would be known as Semicolon Seperated Values instead of Comma Seperated Values.

I use SQLYog to export data to Excel weekly withough issue as long as you tell Excel to import a CSV. I also use the copy to clipboard and paste into an excel spreadsheet and it works perfectly every time with a comma. The comma has been the field seperator default for many years and while you have found a condition where Microsoft accepts a non-standard seperator, it's no reason for the rest of us to change it.

Also, SQLog gives you the option to change this to whatever you wish. So there's really no need to change the program.

=C=

[CalEvans]

larsen wrote on Sep 8 2005, 03:17 PM:

Hello,

sometimes I can use ESC to close a window. Some windows don´t support this, e.g. the “export as sql dump” window).

Could you change this, so that all windows can be closed by ESC (not reasonable for  main window)?

Lars

[post=”7099″]<{POST_SNAPBACK}>[/post]

I second this request.

=C=

[CalEvans]

blackhawkchile wrote on Aug 27 2005, 08:50 PM:

how can i export the tables like excel book??,  i can do it like a csv but not one field in one field in excel i only get the csv with all information in ONE row !!.. 🙁

You can either right click on the result set and select “Copy to clipboard”. This will bring up a dialog that allows you to export it to a CSV but jsut to the clipbard. Swap to Excell and paste and it should imort properly.

Or you can export it to a CSV. Excell's import feature will import it into a workssheet with each value in a seperate column. I'm using Excell from Office 2003 but I'm pretty sure most previosu versions do tis also.

blackhawkchile wrote on Aug 27 2005, 08:50 PM:

how can i do search in the program ?… for example.. i want to look only the people with  age “x” in the db…

The proper way to search any given table using SLYog is to write a SQL command that returns only the rows you are interested in. There is no functionality in the program to use something like the “Find” command to searc a result set and I hope there never is.

HTH,

=C=

[CalEvans]

Since SQLYog connects to MySQL and does not intefer with the operation of any of the parts of WAMP, you should be able ot install WAMP, fire up MySQL and then install and use SQLYog connecting to the MySQL server as localhost.

=C=

[CalEvans]

First,

SQLYog/MySQL are nothing like Access. Prepare yourself for the change. You won't be able to do most of the things you can do in Access…and that's on purpose.

Now, to change the text you want to change in the record you want you need 4 pieces of information. #1 the table name you want to change #2 the primary Key of the record you want to change, #3 the name of the primary key and the name of the field that holds the text you want to change.

Now, with that information you can craft a simple update statement to make the change.

It will look something like this:

UPDATE tableName set fieldToChange=”New Text” where primaryKeyName=primaryKeyValue;

That's all there is to it.

Pretty simple.

Or if you want a crutch, load the MySQL ODBC drivers and link to your MySQL table using Access. You will still get about 75% of the functionality you are used to.

(But if it were me, I'd toss that piece of crap and learn proper SQL syntax….but that's just me)

HTH,

=C=

[CalEvans]

Ritesh wrote on Jul 12 2005, 01:49 PM:

Are you connecting to the same MySQL server?

While I've not tried to duplicate his problem, I can see it in my mind. The drop down lists all show database@server. If you are using ssh then the server is always localhost, regardless of what server you are really connecting to. therefore I could be connecting via ssh to Bert and Ernie but when i go to select the schemas to compare, they will ALL show @localhost.

=C=

[CalEvans]

IMHO,

If you are dumping from one version of mysql and importing into another, I would use sqlyog instead of mysqldump. (Which sounds like what you are doing but I felt the need to state the obvious)

Run record counts on all your tables before and after you do either the copy or the dump/restore and compare them. I've never done the copy to a different host but I've used dump/restore with much larger phpBB installs that you are describing and it worked without a problem.

=C=

[CalEvans]

2 things

1: In Linux/Unix, it's called cron.

2: This is a bad idea. If you need a database that is fully replicated, setup a master->slave relationship between 2 databases. This is a much safer way to make sure you have a backup.

=C=

[CalEvans]

Generally no.

If you find your site slowing down and you think it might be mysql related then you can either 1) tune Mysql or 2) Tune your queries/database. The second is by far the easier.

i.e. do you have the proper indexes built to support your queries? If you table is growing but you don't have the proper indexes, it would lead to things slowing down as you are doing full tablescans.

=C=

[CalEvans]

By definition, SQLYog is a client. Therefore the behavior you describe is normal. In moving database between 2 servers using a client, the client has to bring all the data down to itself and then send it to the target server.

Yes, it would be possible to create some kind of server piece that would do this but since we already have one (mysqldump) it would seem to be impractical to create another. Also, as someone who manages web servers for a living, I would not allow it to be installed on any servers. Too much of a security risk.

The easiest way to do what you are talking about is to ssh into one of the boxes and issue the proper mysqldump command.

Ok, now that I've thought it through, if SQLYog knew your ssh credentials (which it does in the case of a tunnel) this would be possible without having to install a server piece. (which means it's must more likely to be doable) the same code that builds the tunnel could also simply issue a mysqldump over ssh. Assuming perfect conditions (and the stars are aligned) this would work.

IMHO,

=C=

[CalEvans]

I've not experienced this problem. The only time it hangs for long periods of time is when I uncheck that box on one of my large (100,000+ rows) tables with 3 memo fields. (I know…bad design). Since it's hauling this data over the net, it takes a while and the background processing seems to not work in this situation.

Could it be that it's not hung in your case but simply trying to suck all the data in and build the grid?

=C=

[Author]

Posts