Need to get our old database from the 1.3.2.4 version imported into a 1.5 install of Magento. The database size in phpmyadmin is about 160MB and phpmyadmin only supports 50MB so you have to either split it up or use shell.
The site is hosted at [login to view URL] with their most advanced magento host solution.
The reason why we dont want to do this ourselves is the change in database structure with new tables and changes made in the way Magento organizes and uses its database. We have made a new install with Magento 1.5 in our server and also made an export/import of the database from magento admin panel. It gave an error stating:
"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'synonym_for' in 'field list'" when trying to access admin panel. An error not uncommon as we have found out.
Needless to say, if you want to bid on this you need to be familiar with the procedures and the structures/changes so this can be fixed smoothly and as fast as possible. We want this done quickly since the old magento install seems to have problems with some payment solutions we want to use.
Other fixes wanted if possible (state in your bid if you can fix some of these also incuded in your offer or if you only want to do the main task mentioned above):
- the database had a backup done some weeks ago and when imported it was done with latin encoding making the nordic characters (its a norwegian webshop) scrambled. This is a problem only in item descriptions, names etc. We only use international characters for SKU and so on
- we have one database that was used for some days with sales/customers not included in the database used today, we would want to include the sales/customers from this that does not exist in the other and merge them if easily possible.
Also state what kind of access you need, and also if you have any questions about the task or want to take a look at the database in advance or other details before you make an offer, please do so and well answer as soon as possible.
We have a team of magento experts & developers who can quickly and efficiently complete your task. In fact we just finished another job yesterday that is nearly identical to what you want done. Our Magento database expert will migrate your data into the new 1.5.x.x site.
We can also collate the data from your other databases as well so that all orders & customers are contained in the new Magento database.
We should be able to rectify your nordic encoding issue as well although we cannot guarantee this until we see the actual database.
As for what access & credentials we will need:
SSH (shell) access.
FTP access would also be useful but not necessary.
Lastly we will need a usernames and passwords to access all of the databases in question.
Hi, I've done this before - you can't actually export/import for the upgrade you have to break it up. I'lld need ssh access, phpmyadmin access and ftp access (encryption key needs to be the same across both). My also includes the other two issues you have as well.