Forum Replies Created
-
AuthorPosts
-
February 3, 2007 at 11:13 pm in reply to: Error Message When Importing To V-bulletin. The Import Goes For About #23225MonteMember
It's 5.21. I'll upgrade it and see what happens. Thanks.
peterlaursen wrote on Jan 10 2007, 08:54 PM:Program version, please ?!If not 5.22 then first try an upgrade and repeat!
If problem persists and if there is a dump file in the installation directory, please attach it here.
We will need to know the EXACT program version if we shall be able to use these dump file(s)!
MonteMemberSorry it took me so long to get back. I have V-Bulletin, SQLyog 5.21. Thanks. I'm having another another problem on it but I'll start a new thread; deals with an error message.
peterlaursen wrote on Jan 10 2007, 09:00 PM:@MontePlease explain the problem more in detail, and please inform about the program version and connection method!
But most likely this is a server/remote network configuration/resource issue. The remote host simply only 'absorbs' the data in that rate. Wioth my personal (cheap) ISP I sometimes have to accept transfer reate of around 10 kbit/sec. There are 200/ (or 2000?) more users on the same server …
MonteMemberI'm having the same problem too.
MonteMemberThanks 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 !!!
MonteMemberQuote: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.
-
AuthorPosts