Need to get our old database from the 18.104.22.168 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 [url removed, login to view] 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.