Export/import multilingual site+database to a fresh install without losing ads.

[gaissa]

Let's imagine I have a multilingual Osclass -installation. I have added ads in default language en_US. Then I change the language to (for example) sv_SE, and also set it to be the default language. I add new ads but only in sv_SE language and leave the en_US -fields empty. Then:

I take a backup via phpMyAdmin export, make a copy of my installation to another server and I import the .SQL -data + set the the config and .htaccess to match the new server. Everything works fine until I need to re-install or remove the sv_SE -language. If I do that, all the the new ads that were added in sv_SE are deleted. Only the ads with en_US fields are kept. How do one clone/backup a installation at this point?

e: the ads are not deleted completely of course. Only the sv_SE fields like title and description and such and the same for other stuff like categories... How come the ad data gets deleted with the language? Shouldn't it be kept?

e: Ok this is getting funny. Suddenly I can update the core language (PO => MO) and the translation shows immediately. This did not happen before. There might be a problem with my test server. Anyway, the problem with multilingual backup remains the same. Just that I don't really need to delete/re-install my language files anymore... have to check more.

[deniss]

I'm trying to move my whole website from Bluehost to Ehost, I have downloaded all the files and databases, I have set up a test site on my new server, 4 weeks later I'm still trying to access all the listings.
I installed OS on my new server form the lastest ZIP file, I have uploaded all the files i have created a database uploaded the slq DB file. All looks ok but I cannot see my listing 360 of them. I enter a test listing it show ok.  I have done everything I can think of cleared the DB made new one's pointed the config setup to the new DB I have had every error you could think about. Just now I thought I would go back and try the first thing I done " backup the OS website on my old server and import data into my new one, Error message: There was a problem importing data to the database  So I think ok I'll export= backup the new server website and them import the one I just backed up "exported"   error mesage:  There was a problem importing data to the database  how can this be if the backup system does not work how do you get your data back?  I am still running on two servers now which is defeating the reason I was switching servers, COST:  Has any one any idea's how to do this I have tried nearly everything I have seen in forums without success, I see this problem back dates 4 or 5 years with no solutions surly an export and import facility should be part of a standard OSCLASS core. The import plugin is next to useless, you might as well retype all your listing in by hand. Not unless I'm missing something?   

[teseo]

Hi,

Have you tried importing the old database using PhpMyAdmin? I think the Osclass built-in mechanism has some problems when there are quotes embedded in the SQL data...

Regards

[Chris041973]

Hello,

I have just tried to Export and then Import the sql file with phpMyAdmin and received the message below after trying to import the database :

Error

SQL query:

CREATE TABLE `oc_t_admin` (
  `pk_i_id` int(10) UNSIGNED NOT NULL,
  `s_name` varchar(100) NOT NULL,
  `s_username` varchar(40) NOT NULL,
  `s_password` char(60) NOT NULL,
  `s_email` varchar(100) DEFAULT NULL,
  `s_secret` varchar(40) DEFAULT NULL,
  `b_moderator` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8

MySQL said: Documentation
#1050 - Table 'oc_t_admin' already exists

Please what could be wrong ?

Thank you ...

[teseo]

Hi,

To totally replace the newly created Osclass database, you need to Export the old one this way.

On Export page, tick "Custom - display all possible options".

Mark Data creation options / Truncate table before insert

Save .sql

Import

Regards