[Ritesh]

Can you send me a backup of your database?

[Ritesh]

Both the features are planned for SQLyog Max.

[Ritesh]

Can you tell me the version of your Source and Target MySQL servers?

[Ritesh]

You are selecting the wrong DSN.

You have to create a File or System DSN to the Excel worksheet using Control Panel->Administrative Tools->Data Sources (ODBC) and then select the DSN in SQLyog ODBC Import Wizard.

HTH

[Ritesh]

Will be fixed in SQLyog 3.7.

[Ritesh]

Thanks for the info 🙂

[Ritesh]

Check the following link:

Max_Allowed_Packet

[Ritesh]

my.cnf is a MySQL configuration file. SQLyog never uses it.

From the MySQL Docs:

Quote:

There are two option files with the same function: `C:my.cnf', and the `my.ini' file in the Windows directory. (This directory typically is named something like `C:WINDOWS' or `C:WinNT'. You can determine its exact location from the value of the WINDIR environment variable.)

[Ritesh]

You can schedule Data Synchronization using SQLyog Job Agent.

HTH

[Ritesh]

Hmmm….

Thanks for the feature request.

[Ritesh]

Thanks for the info.

[Ritesh]

Create a new user using Tools->User Manager->Add User . Keep all the privileges unchecked as of now.

Using Tools->User Manager->Manage Permissions provide all privileges to the specified database.

HTH

[Ritesh]

Thanks for the info.

I will work on it and revert back soon.

[Ritesh]

We were able to import the database without any problem using the ODBC Import Wizard. We have Office XP and SQLyog 3.64.

Is SQLyog crashing when you are importing empty table(s)?

Which version of MySQL are you using?

[Ritesh]

Quote:

mysql.users table to %, that that will be enough?

Yes 🙂

[Author]

Posts