Osclass forums
Support forums => Installation / Update help => Topic started by: gaissa on March 19, 2016, 01:00:17 pm
-
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 :D 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.
-
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?
-
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
-
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 ...
-
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