Forum Replies Created
-
AuthorPosts
-
gvvelev
MemberDear Shadow,
Our website provides service that requires our customers to upload files. The site needs to be fully synchronized (uploaded files & mySQL) with a backup server. Thats why I am looking for a file synchronization program that can transfer files between two ftp servers. I found one (WS_FTP PRO) but its last version is buggy and doesnt work properly.
Regards,
George Velev
MemberDear Shadow,
I don't have 3 weeks to develop file synchronization program.
I don't need a mySQL synchronization program either because it is even easier to develop. It is a matter of few days to write the nessesary php code.
I am interested only SQLyog's scheduled synchronization. If it doesn't work I won't buy the program.
The other features I would use I found in phpMyAdmin which is free
Regards,
George Velev
MemberOk. my question is answered in the sales page. I''ll get a free in-line upgrade. 🙄
MemberOK. I foud out what the problem was. It is a minor bug.
Let me explain what I did this morning from the beginning.
1. I chose SQLyog from the Start menu of Windows XP
2. From the drop-down “saved connections” I chose the destination mysql server
3. I pressed “connect”. SQLyog connected successfully to the destination mysql server.
4. from the “file” menu I chose “connect”
5. From the drop-down “saved connections” I chose the source mysql server
6. I pressed “connect” and SQLyog connected successfully to the source mysql server.
7. From the “tools” menu I chose “Database synchronization wizard”
8. the window “Welcome to SQLyog Database synchronization wizard” sprang out
9. I chose “Start a new synchronization session”
10. the window where I can choose the source and destination database springs out
11. the drop-down “Source – copy from” displayed the source server and its parameters are below,
the drop-down “Target – copy from” displayed the source server and the parameters of my localhost server (I mean the computer I am working on)
12. I pressed “next” and completed the steps to the end. I have synchronized the source database and the database on my localhost.
I had made a synchronization between the source mysql server and my localhost on another database before I tried to synchronize the source and target servers.
So – to recapitulate
The window “provide details for source and target databases” displays the last connected mysql server in both “source copy-from” and “target – copy from” drop-downs, but the parameters listed below the drop-downs are the parameters of the last synchronized mysql servers.
I am sorry I cannot provide you a screenshot of that window – host name, username and password, as well as database name are confidential.
I hope this will help to do the nessesary corrections to the source code of SQLyog. I continue testing with scheduled synchronization.
I have a question but it is not about bugs so I will post it in another section.
Regards,
George Velev
MemberTable countries
Source database
mysql> show fields from `countries`;
+
+
+
+
+
+
+| Field | Type | Null | Key | Default | Extra |
+
+
+
+
+
+
+| Country_ID | int(11) | | PRI | NULL | auto_increment |
| Country | varchar(30) | | | | |
| VAT | float | | | 0 | |
| Active | int(11) | | | 1 | |
| dpd | int(11) | | | 0 | |
| fedex | int(11) | | | 0 | |
+
+
+
+
+
+
+6 rows in set (0.00 sec)
mysql>
Target database
mysql> show fields from `countries`;
+
+
+
+
+
+
+| Field | Type | Null | Key | Default | Extra |
+
+
+
+
+
+
+| Country_ID | int(11) | | PRI | NULL | auto_increment |
| Country | varchar(30) | | | | |
| VAT | float | | | 0 | |
| Active | int(11) | | | 1 | |
| dpd | int(11) | | | 0 | |
| fedex | int(11) | | | 0 | |
+
+
+
+
+
+
+6 rows in set (0.00 sec)
mysql>
Table settings ( I've changed the names of the fields to make the table structure no more confidential). Neither field is called 'NAME' (I mean the table doesnt have a column 'NAME')
mysql> show fields from settings;
+
+
+
+
+
+
+| Field | Type | Null | Key | Default | Extra |
+
+
+
+
+
+
+| setting1 | int(11) | | | 0 | |
| setting2 | int(11) | | | 0 | |
| setting3 | int(11) | | | 0 | |
| setting4 | int(11) | | | 0 | |
| setting5 | int(11) | | | 0 | |
| setting6 | int(11) | | | 5 | |
| Admin | int(11) | | PRI | NULL | auto_increment |
| setting7 | int(11) | | | 0 | |
| setting8 | int(11) | | | 6 | |
+
+
+
+
+
+
+9 rows in set (0.00 sec)
mysql>
destination table
mysql> show fields from settings;
+
+
+
+
+
+
+| Field | Type | Null | Key | Default | Extra |
+
+
+
+
+
+
+| setting1 | int(11) | | | 0 | |
| setting2 | int(11) | | | 0 | |
| setting3 | int(11) | | | 0 | |
| setting4 | int(11) | | | 0 | |
| setting5 | int(11) | | | 0 | |
| setting6 | int(11) | | | 5 | |
| Admin | int(11) | | PRI | NULL | auto_increment |
| setting7 | int(11) | | | 0 | |
| setting8 | int(11) | | | 6 | |
+
+
+
+
+
+
+9 rows in set (0.00 sec)
mysql>
I am going to try what you advise me in your last post.
Member…one more thing.
I would like to clarify that both servers are remote servers.
George
MemberHi,
You have misunderstood me.
All tables except two were synchronized BEFORE I emptied the destination database.
After I had reported my bug I tried the following:
I ran Tools->export data as batch scripts
and exported only the structure of the tables in the source database in an .sql file
then I ran this .sql file on the destination database. Thus all tables on source and destination database have the same structure.
Then I ran Tools->Database synchronization wizard and told it to do a one-way synchronization, expecting that the wizard would simply copy all the data from source to destination.
But it did not inserted, updated or deleted anything and said that
Field count not equal for '`countries`' table
Column NAME mismatch for '`settings`' table
which obviously isnt true because the table structure had already been copied.
And when I log in to mysql server and ran a SELECT query it returns an empty set on either table.
SQLyog' main window also says the tables are empty.
create statements:
drop table if exists `countries`;
CREATE TABLE `countries` (
`Country_ID` int(11) NOT NULL auto_increment,
`Country` varchar(30) NOT NULL default '',
`VAT` float NOT NULL default '0',
`Active` int(11) NOT NULL default '1',
`dpd` int(11) NOT NULL default '0',
`fedex` int(11) NOT NULL default '0',
PRIMARY KEY (`Country_ID`)
) TYPE=MyISAM;
I'm sorry I cannot post the CREATE statement of the 'settings' table because I would uncover a business secret.
Both servers have Mysql 4.0.20 running.
Source is running on FreeBSD 4.9
Destination is running on FreeBSD 4.10
I hope there is a solution. SQLyog looks very cool!
Regards,
George Velev
-
AuthorPosts
