[peterlaursen]

Quote:

I have a LAN where with MySQL set up on one machine (the test server), and DWMX and SQLyog on another.

I cannot connect using localhost or the testing server IP address.

SQLyog and MySQL are on different computers so of course “localhost” won't work from SQLyog. The test server ip however should work.

What is the error message you are getting ??

Since DremWeaver connects you should have user/pw/port correct, if you use same connection parameters. There could be a user_limit of “1” (and other special settings with MySQL) so that SQLyog can't connect when DW does, but that is very unusual.

Does the user you try to connect with from SQLyog have the privilege to access MySQL from remote? If server is a windows machine have you tried then to install SQLyog here and see it that works ?

[peterlaursen]

hhmmm

as long as you build indexes based on one column only that could be done too. But how would you then define an unique index built from more columns ?

[peterlaursen]

But of course I meant “SQLyog development” and not “MySQL development” :huh:

[peterlaursen]

It is no secret than next release (4.2) will support all that stuff. Has been written here several times

It will only be a few days and you'll find a roadmap on this page for the next steps in MySQL development. That is no secret either.

When then?? Not so many weeks for a fully functional Beta, I guess 😀

[peterlaursen]

Quote:

Trying to use backup wizard in 4.07 version

The “backup wizard” will NOT backup to a MySQL database to another MySQL database, but to a text-file containing SQL-statements.

Shall I understand you so that you “backed up” or “dumped” your remote database to a textfile and tried to import that on your local and had an error?

Quote:

had an error

Which error ?

Quote:

changing some of the settings

Very much looks like you have told your server that it is part of a replication chain. Have you being changing the MySQL configuration file ?

I am sorry but I still don't understand.

[peterlaursen]

You don't need a PK to use Scheduled Backup with SQLyog.

The Backup Feature and the Sync Feature are different things.

From http://www.webyog.com you will actually find links to extensive explanations (“White Paper”s) on both.

did I misunderstand you ?

[peterlaursen]

You are exporting from a MySQL server being the slave in a replication chain.

Am I right ?

The replication feature of the MySQL roughly works this way that the Slave Server compares it's own binary log with the one of the master Server. What is in the Master's log and not in it's own is what needs to be done.

Is it “export table as SQL” form SQLyog you are trying to use ?

You are not very informative. The more precise information you give, the more precise answers you'll get, I guess …

[peterlaursen]

You have missed something!

It is in “manage indexes” from table menu or in the context menu of a table.

I don't recall exactly what PhpAdmin does, but if it offers you to create a “unique field” it is terminology mismatch. The right way to express it is that you build a unique index with one column/field.

It looks like below

For some strange reason it is common to speak of “Primary Key” and “Unique index” …

[peterlaursen]

Quite a lot to look at here:

http://lists.gpick.com/pages/File_Rename_Tools.htm

If programs can be started from command-line you could easily build an apporpriate .bat-file.

[peterlaursen]

Control panel … Folder settings .. File types

(translated from Danish .. not sure that terms are exatly like that in English)

You should set your preferred browser as the default application to open .html files. Sounds like it is only for .htm files as of now. If html-filetype is not registered with the system just add it! You might choose to set it for xml, .shtml and .xhtml and more as well

The setting is available from the settings menu of most browsers too.

Very strange that it is opened in Excel. You did not use the export as .CSV option this time? When M$-Office is installed it sets Excel as the default program for .csv-files!

BTW: thanks for your mail!

[peterlaursen]

Please note that I edited a little bit above!

[peterlaursen]

actually there has been a similar request recently. So maybe the save options are not flexible enough for some users.

What you can do by now is exexuting SJA from a windows .bat file and schedule the execution of the batfile insted of SJA itself. A simple example:

Code:

copy newbackup.sql oldbackup.sql
SJA newbackup.xml

thus you'll always have two backups

You can of course expand the example to have 7 like

Code:

delete 7backup.sql
rename 6backup.sql 7backup.sql
rename 5backup.sql 6backup.sql
….
rename newbackup.sql 1backupsql
SJA newbackup.xml

Thus the name 4backup.sql will tell you that this is a backupfile 4 days old if you do backup once a day.

I honestly don't know if the weekday or date can be fetched into a bat file and be used for naming another file. I'll do some research on it if requested!

[peterlaursen]

Quote:

Is it possible to shutdown the mysql daemon from sqlyog

No!

I suggest you get “MySQL Administrator” from http://www.mysql.com. The main scope of this program is administration of the server environment. It will also install an icon in system tray from where to start and stop MySQL server with a single click.

SQLyog and MySQL Administrator are for me to two most basic mySQL tools. There is a little overlapping in functionality, but they basically supplement one another in that way that Administrator is for adminstration of the server environment itself, SQLyog is for administration of the databases and the data. Or at least that is how I use them.

[peterlaursen]

disable ALL (including SELECT) global privileges (from user management .. edit user) for that user to MySQL-DB in SQLyog user management

Use the “manage permission” and not “edit user” to give specific privileges to specific databases (or tables or columns) only.

[peterlaursen]

just for completenes.

Here you have a case with two tables and several changes within each

Code:

/* Alter table in Second database */
alter table `test4`.`roles`,
change `RoleID` `RoleID` int(11) NULL  auto_increment,
change `RoleDescription` `RoleDescription` varchar(50) NULL  ,
change `CostumeDescription` `CostumeDescription` varchar(50) NULL  ,
change `CompanyID` `CompanyID` int(11) NULL  ,
change `ProjectID` `ProjectID` int(11) NULL  ,
change `SectionID` `SectionID` int(11) NULL;

/* Alter table in Second database */
alter table `test4`.`whertogo`,
change `Id` `Id` int(10) unsigned NULL  ,
change `goname` `goname` varchar(60) NULL  ,
change `towncity` `towncity` varchar(50) NULL  ,
change `type` `type` varchar(50) NULL;

[Author]

Posts