Updating A Mysql Database. Newbie Here!

[Monte]

I have a MySQL DB from a previous date and need to reinstall it. The problem is, I need to “update” that DB with a newer DB. Is there a way I can do that? The ISP Host is Apache and my Forum is V-Bulletin. [Yes I have asked V-Bulletin but have not gotten very good answers. <_< ] Thank you.

[peterlaursen]

I am not quite sure I understand! Is it the MySQL server that shall be updated? Now as we are at an ISP I do not think that is the case!

Or do you want to import a V-Bulletin database from an older version of V-Bulletin to a more recent V-bulletin version?

“I have a MySQL DB from a previous date”. Is that a SQL dump (created by the 'mysqldump' program. by phpMyAdmin or by SQLyog – that does in principle not matter!) ?

If you want to import a V-Bulletin database from an older version of V-Bulletin to a more recent V-bulletin version that may not be so simple if V-bulletin has changed their database schema in between! Actually you should import that DUMP into the same version as where it was created and run the V-bulletin update script(s), export again and now you should be able to import to the same V-bulletin version.

Attempting to apply the changes to the database manually or to edit the DUMP script can be very-very-very tricky!

The OS (Linux or whatever) and the webserver (Apache or whatever) is not the problem. MySQL databases are completely the same! But the problem is that V-Bulletin may have changed the database Schema between versions. If they cannot give you a SQL update script and if you cannot figure out the changes yourself, you will have to import to the version where it was created an follow their upgrade procedure – that means execute the update.php script or whatever they do.

Now I do not know if the old V-Bulletin verson is available to you at all? If so you can install it on you local. But you will of course need a webserver (preferably Apache) configured with PHP too. If you never set up this before then .. well .. at least it is a good exercise!

But please first explain more in detail what is to be “update”d. Did I get it right?

[Monte]

Quote:

I am not quite sure I understand! Is it the MySQL server that shall be updated? Now as we are at an ISP I do not think that is the case!

It's my Database on the ISP's Server.

Quote:

Or do you want to import a V-Bulletin database from an older version of V-Bulletin to a more recent V-bulletin version?

No it's the newest version 3.6 onto 3.6.

Quote:

“I have a MySQL DB from a previous date”. Is that a SQL dump (created by the 'mysqldump' program. by phpMyAdmin or by SQLyog – that does in principle not matter!) ?

I backed it up onto my computer straight from the VB Control Panel. It's a .SQL file. That's all I know about it.

What I mean by update is to copy/move only the newer data from the more recent DB and add it to the old DB.

[peterlaursen]

“copy/move only the newer data from the more recent DB and add it to the old DB”

SQLyog Enterprise DATA SYNC should do that trick! Even the TRIAL will do (though you will need to import one table per job with the trial – it is restricted to that).

You will then need to import your .SQL file to another database (at the same server or another server – does not matter), and sync the databases as a one-way sync from 'most-recent' to 'old-one'.

Please read this article:

http://webyog.com/articles/Using_SQLyog_En…L_Databases.pdf

.. and understand how the DATA SYNC tool uses the Primary Key of a table. And understand how the sync works without a PK if you do not have such in every table! But with a one-way sync as you'll need here there should be very little chance of any problems.

However always DO BACKUP when you are 'playing around' with such tool that you do not know in detail yet how functons !!!

[Monte]

Thanks I'll try it!

peterlaursen wrote on Aug 31 2006, 05:47 PM:

“copy/move only the newer data from the more recent DB and add it to the old DB”

SQLyog Enterprise DATA SYNC should do that trick! Even the TRIAL will do (though you will need to import one table per job with the trial – it is restricted to that).

You will then need to import your .SQL file to another database (at the same server or another server – does not matter), and sync the databases as a one-way sync from 'most-recent' to 'old-one'.

Please read this article:

http://webyog.com/articles/Using_SQLyog_En…L_Databases.pdf

.. and understand how the DATA SYNC tool uses the Primary Key of a table. And understand how the sync works without a PK if you do not have such in every table! But with a one-way sync as you'll need here there should be very little chance of any problems.

However always DO BACKUP when you are 'playing around' with such tool that you do not know in detail yet how functons !!!

[Author]

Posts