[peterlaursen]

On my system max_allowed_packet was 1 M as installed. I don't know how to interpret that value, but hasd a porblem with restoring backups. I raised the value to 10 M and subsequently 100 M and can't feel any performance degradance or other “backends” ….

[peterlaursen]

Is this an answer to your question ?

http://www.webyog.com/forums/index.php?act…ct=ST&f=3&t=864

(see post by Ritesh at the bottom)

[peterlaursen]

And it's OK with 4.1.3 too 🙂

[peterlaursen]

real nice … and it's still free (although not THAT functional yet …)

everything seems OK with Mysql 4.0.20 running on WinXP.

When will you buy the MySQL company ? 😉

The only problem is that ISP's seem very conservative about allowing use of anything else than PHPadmin …

[peterlaursen]

of course I messed it up!

Before the change the sql should look like:

SELECT [mp3_files].[Album], [mp3_files].[Artist], [mp3_filer].[Genre]

FROM [music].mp3_filer

WHERE [mp3_filer].[Artist] Is Not Null And [mp3_filer].[Album] Is Not Null

GROUP BY [Album], [Genre], [Artist]

ORDER BY [Albuml], [Genre], [Artist];

After the change it must me:

SELECT [mp3_files].[Album], [mp3_files].[Artist], [mp3_filer].[Genre]

FROM [musik].mp3_filer

WHERE [mp3_filer].[Artist] Is Not Null And [mp3_filer].[Album] Is Not Null

GROUP BY [Album], [Genre], [Artist];

[peterlaursen]

“group by” .. and “order by”

oh I found out myself .. problems with a combination of the “group by” .. and “order by” .. clause

It wasn't perfectly true what I wrote, actually Access could connect, but not execcute sql that it could before the change in my.ini . But I noticed it could do a “select *”. Esperimenting with omiting parts of the sql I found this solution

Before the change the sql should look like:

SELECT [mp3_filea].[Album], [mp3_files].[Artist], [mp3_filer].[Genre]

FROM [music].mp3_filer

WHERE [mp3_filer].[Artis] Is Not Null And [mp3_filer].[Album] Is Not Null

GROUP BY [Album], [Genre], [Artist]

ORDER BY [Albuml], [Genre], [Artist];

After the change it must me:

SELECT [mp3_filer].[Genre], [mp3_filer].[Artist], [mp3_filer].[Album]

FROM [musik].mp3_filer

WHERE [mp3_filer].[Artist] Is Not Null And [mp3_filer].[Album] Is Not Null

GROUP BY [genre], [Artist], [album];

(the point is to have an album-artist-genre combination listed only once no matter how many tracks there are og no matter whether track no.s are available!)

It can be quite tricky to write sql that is accepted and interpreted identically by Access, NyODBC and MySQL ….

But thanks for viewing 😆

[peterlaursen]

I don't think you'll need a command.

MySQL doesn't care from where in the world a request comes.

If the user is recognized she'll be let in … and allowed to perfom operations according to the user configuration.

But of course your OS, networking hardware (such as routers) and software should be configured for that!

However you can configure the MySQL server to enable/disable networking.

In the latter case the server will only accept clients running on “localhost”

The easiest way to do that is to use MySQLadministrator from http://www.mysql.com.

But try to describe more in detail what is your situation and problem ?

[peterlaursen]

You can use DBDesigner 4.

http://www.fabforce.net/dbdesigner4/

Start clearing the program's browser window by choosing file .. new ..

Then Database .. reverse engineering .. connect to the host … chose your base ….

The Fabforce company was aquired by MySQL recently.

There isn't much idea in doing that work once again 😉

[peterlaursen]

Compability

I tried it with MySQL 5.0 and all functions that I use seem to be OK.

[peterlaursen]

you write: ” I can load it into MS Access no problem.”

then export it from Access into MySQL (first create an empty database using sqlyog)

[peterlaursen]

That works! no “bad handshake”.

However the problem with certain features of SQLyog 3.64 that makes it crash still persists. Most important the “alter table” function does make it crash, but I experienced the problem with a few other functions as well.

Is that recognized as a bug/problem ?

My workaround is to use MySQLControlCenter for that operation right now.

[peterlaursen]

correction:

should have been “create an empty database” not “create an empty table”

sorry for that!

[peterlaursen]

my personal experience is that

exporting from Access2000 to mysql

works bettter than

importing from Access2000 to mysql using sqlyoug

I don't know if it is a problem with sqlyog og with the ODBC-driver!

try these steps

1) use sqlyog to create an empty table in mysql

2) export the tables from Access

3) if needed you can alter mysql tables (field lengths etc) afterwards

I don't know if that solves your problem but give it a try!

And remember to answer back …

[peterlaursen]

compare the word “yoga” 🙄

[peterlaursen]

Try the opposite way around.

Create empty table(s) in the database that your ODBC-thread works with.

From Access choose file .. export .. ODBC-database..your MySQL database. Afterwards you can adjust field names, field length and type if necessary using SQLYOG.

It has always worked for me with Access2000 and every version of MySQL and SQLYOG, that i've tried.

[Author]

Posts