Is There A Way To Synchronize/update A Db On My Computer?

[Monte]

I have 5.21 and want to know if I can synchronize/update a backup mysql DB with the newer DB? So, the new data is on a live forum but the old data, the one I need to update, is on my computer. Or is there a way to update/merge/synchronize the databases locally?

😮

Thanks!

[peterlaursen]

With SQLyog ENTERPRISE you have the DATA SYNC tool.

this article explains:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

please read and try to understand.

[Monte]

Thank you PL. I think I've read it before but I'll do it again!

[Monte]

I have a question. When this dialog appears what do I put in for the localhost, username, info? [The box on the lefthand side.] Is it my computer password, user, etc.? I've tried my desktop logon, etc. and have not been able to connect. I get an error that I can't connect: Error # 2203 to localhost 10061. I'm a newbie to databases. 😮

peterlaursen wrote on Feb 3 2007, 10:48 PM:

With SQLyog ENTERPRISE you have the DATA SYNC tool.

this article explains:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

please read and try to understand.

[peterlaursen]

The same details should work.  If you saved the connection details in the Connection Mananger just choose from the dropdown.

[Monte]

peterlaursen wrote on Feb 4 2007, 09:19 PM:

The same details should work.  If you saved the connection details in the Connection Mananger just choose from the dropdown.

I tried it but it didn't work. BTW, this is what I have for the DB path: C:August 9 Testvbulletin.sql Is that ok? Thanks.

[peterlaursen]

Quote:

This is what I have for the DB path: C:August 9 Testvbulletin.sql

You should not use a FILE PATH to the database.  To access a MySQL database you will need to use a client and enter

* host

* user

* password

* port

.. basically!  

But I am not sure I understand. Could you possibly post some screenshots of what works and what does not? You can fake details. You can also create a ticket?

[Monte]

Nothing works so far but here's what I have.

[attachment=598:SYSyog_s_settings.JPG]

For the target on the right I didn't show you the connection. Also, could you explain “To access a MySQL database you will need to use a client and enter” please? It's the DB is on my computer. Will I need anything else? Thanks again!

On Edit: What's the PW I should use for the local settings? My Desktop login?

peterlaursen wrote on Feb 4 2007, 11:13 PM:

You should not use a FILE PATH to the database.  To access a MySQL database you will need to use a client and enter

* host

* user

* password

* port

.. basically!  

But I am not sure I understand. Could you possibly post some screenshots of what works and what does not? You can fake details. You can also create a ticket?

[peterlaursen]

User name cannot be name of database! It must be a user with that database

When doing a DATA sync you have two independent MySQL logon's at the same time 

[Monte]

peterlaursen wrote on Feb 5 2007, 12:40 AM:

User name cannot be name of database! It must be a user with that database

When doing a DATA sync you have two independent MySQL logon's at the same time 

[Newbie question] So what name should be put in there?

[peterlaursen]

How should I be able to tell which users exist on that server?  It is not my server – it is yours :huh:

If there is a user 'Monte' (and he has the privileges needed for the job) you can use him!

Or maybe you can use a a privileged user like 'root' or 'admin' …

[Monte]

peterlaursen wrote on Feb 5 2007, 12:49 AM:

How should I be able to tell which users exist on that server?  It is not my server – it is yours :huh:

If there is a user 'Monte' (and he has the privileges needed for the job) you can use him!

Or maybe you can use a aprivileged user like 'root' or 'admin' …

Well I wouldn't expect you to know the actually name. 😆 I'll try a couple of things and get back if I have any problems. Thanks.

[Monte]

peterlaursen wrote on Feb 5 2007, 12:49 AM:

How should I be able to tell which users exist on that server?  It is not my server – it is yours :huh:

If there is a user 'Monte' (and he has the privileges needed for the job) you can use him!

Or maybe you can use a a privileged user like 'root' or 'admin' …

Peter,

Am I supposed to have a mySQL client on my computer to do this?

[peterlaursen]

SQLyog/SJA is the client.  All what is needed to connect to the servers (whether running on localhost or elsewhere) is compiled into the SQLyog***.exe and sja.exe executables.

Did I understand the question right?

[Monte]

peterlaursen wrote on Feb 21 2007, 12:42 AM:

SQLyog/SJA is the client.  All what is needed to connect to the servers (whether running on localhost or elsewhere) is compiled into the SQLyog***.exe and sja.exe executables.

Did I understand the question right?

You did. But it still didn't work. I'll get back to you.

[peterlaursen]

Quote:

it still didn't work

Please explain the problem in detail and what you have been doing till now.

[Monte]

peterlaursen wrote on Feb 21 2007, 03:21 AM:

Please explain the problem in detail and what you have been doing till now.

What happened is I backed up my forum's data to my computer in August before I erased the board; V-Bulletin. For some reason – probably due to my own ignorance – I couldn't restore the data. So I rebuilt the forum manually by re-adding all the forums. Then members started posting again, therefore I have new data. Now, I have the old back up from August on my computer and want to merge it into the new data. [BTW, I also have current backups of my forum as of today, etc.] All's I want to do is merge the two DBs. 😮

One more thing. Is it possible to restore the old DB – for testing, etc. – to a test forum I have at a different URL?

Thank you!

[Monte]

Peter,

On Edit:

Here's a sample of the error messages I'm getting.

Sync started at Sun Feb 25 16:26:43 2007

`post` 55 55 0 0 `posthash` 1 1 WARNING: No primary key found in table `posthash`. This might result in error.

`usertextfield` 10 10 0 0 `usertitle` 3 3 0 0 `vbfields` 309 309 WARNING: No primary key found in table `vbfields`. This might result in error.Error No. 1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[peterlaursen]

“Now, I have the old back up from August on my computer and want to merge it into the new data.”  That can be very tricky with such Forums.  I do not know V-bulletin in detail but I know this (IP Board) and phpbb2.  With both you will need to add post through the PHP interface of the application.  I do not think that V-bulletin is different.

What goes wrong is 

1) All 'counters' (no. of posts per member, last post per memebr, last visit of a memebr, number of posts in a topic etc. etc. etc.) will garble.  Whether you will be able to fix that manually I can't tell.

2) If there are autoincrement PK is in some tables (and I'd be surprised if there is not) you will have values having the same PK in both 'editions'  If you sync or import, the old values will be overwritten by the new ones.  And plain import will fail due to 'dublicate PK'.

SJA datasync is not a magician that can change the rules of the game!  

Did you ever read this:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

To merge the two 'editions' of your Forums will take quite a lot of understanding of SQL, but most of all quite a lot of understanding of V-bulletin – and probably a lot of editing of the SQL files in a test editor.  I think you should absolutely have fixed the problem before letting members post again.

BTW:

1) the error message “No primary key found in table `posthash`” tells that there is no primary key in the table.

2) “Error No. 1064You have an error in your SQL syntax;”  not possible to tell what happens here – we will need some sample data to reporduce with.

[Monte]

peterlaursen wrote on Feb 25 2007, 09:14 PM:

Did you ever read this:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

I'll take a look at it again.

Quote:

1) the error message “No primary key found in table `posthash`” tells that there is no primary key in the table.

2) “Error No. 1064You have an error in your SQL syntax;”  not possible to tell what happens here – we will need some sample data to reporduce with.

If/When I get more error messages I'll post them.

Thanks again!

[Author]

Posts