chrometweaks.org

I'm getting a I/O Error in iPage?

Click Here To View All Answers...


My 1st question is: I'm getting a I/O Error in iPage? Looking forward for any answer. Another quick question... Hi guys.

I'm going through the process of upgrading to osc2.2rc2 with a fresh install but obviously I want to copy/use my old SQL database information (order history/customers etc),.

From what I've seen the only real difference is an additional table "administrators".

1, how do I create/copy my "administrators" into the old database (will this cause any problems) or.

2, how do I combine the contents of my old and new database?.

I've tried playing round with import in phpmyadmin but it errors because it finds the existing file structure..

Thanks.

This post has been edited by.

Osmium.

: 23 July 2008, 04:14..

Comments (6)

I would like to know the answer too. Anyone here know what is the answer. I'll do some research and get back to you if I find an decent answer. You should email the people at iPage as they probably could give you help..

Comment #1

The upgrade.html file does not give instructions for this specific problem, you should re-read the original post..

I too am attempting to do this. I want to install a fresh rc2 setup and then bring in my data from the old old old version I have running..

What I would do is get more familiar with the phpMyAdmin interface, specifically with the 'Export' tab near the top left of the screen. This is assuming you have no mods done to the database - mods will require more custom headaches. Here is what I would do (and forgive me for simplifying but this is in case someone else with less experience finds this):.

1. Log into phpMyAdmin.

2. Click on the name of your database in the list at the left. This should look something like osCommerce(00) with all the tables listed below..

3. Click on the 'Export' tab near the top left of the screen..

4. Make sure all tables are selected in the list box; Under the section with the 'Structure' checkbox (make sure this is checked) you should leave the defaults checked and additionally check the box labeled 'Add IF NOT EXISTS'; under the section with the 'Data' checkbox (make sure this is checked) you should leave the defaults checked and additionally check the box labeled 'Use ignore inserts' and change the Export Type to 'UPDATE'..

5. Export the SQL in your favorite format..

6. Import the SQL into your new DB and adjust for errors. It may help to duplicate the original database in case you need to make changes so the schemas match or to modify data..

If anyone else has better instructions I am all ears...it is a real pain in the arse to upgrade to rc2 from an older version without starting over!..

Comment #2

Hi.

Thanks Adam, thats where I started but my host's version of phpmyadmin 2.9.0 doesn't have any of the options you described (unless I'm missing something) -below is all the text from the import tab on my version of phpmyadmin.

Thanks.

"Import.

File to import.

Location of the text file (Max: 8,192KiB).

Imported file compression will be automatically detected from: None, gzip, bzip2, zip.

Partial import.

Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions..

Number of records(queries) to skip from start.

Format of imported file.

SQL.

SQL optionsThis format has no options"..

Comment #3

Hi Adam (or anyone else).

How did you get on with the migration? I've downloaded SQLyog which makes things a bit more visual and has a pretty good interface. I have noticed there are a quite a few differences in the fields..

I've exported the schema for the databases into an HTML file.

Does anyone know what the following type of index does?.

Customers_basket_attributes 1 idx_customers_basket_att_customers_id 1 customers_id A (NULL) (NULL) (NULL) BTREE.

Cheers.

P.s., i've searched and googled, but I still havent found instructions for doing this type of database migration for osCommerce - I would have thought that it would have been a very common request?..

Comment #4

Thats because it's not that hard to do. The one that stated I need to reread the document is in fact the one that needs to read the documentation included with the release. He failed to tell you the most important part of it. The first thing you need to do run the update sql on your old database. The options he told you about are on export that is when it puts the sql instructions of what to do..

On export after you have updated to it to be rc2a ready..

Select all tables.

Check the box for drop table.

Check the box for add if not exist.

Export it in sql.

Check save to file..

In your new data base select import put in file location and hit go..

This is all assuming you are upgrading from MS2 If you older than MS2 then there are more changes to the data base then what are included in the file and will take diffrent steps to do...

Comment #5

Now that I think about it it may only be good from the rc1 version..

Comment #6

Hi.

Thanks for your help, I feel a bit dumb for not working it out earlier. I basically reread the instructions included in 2.2rc2a and excuted the SQL commands. (Initially I thought they were a technical list of changes - duh).

For any fellow SQL/PHP novices like me here is the way I upgraded my old database to work with osC2.2rc2a. My store was set up back in 2004 and I was unsure what version I had, so to test the migration would work (without risking downtime for my store) I created a new database and copied my old info into it and then proceeded with the below steps.

The first box in the upgrade instructions are SQL queries that need to be executed on your database using something like phpmyadmin (I couldnt run them all at once for some reason but got there in the end).

After I ran the SQL Queries I copied the "administrators" table across using SQLyog.

Because I had created/copied to a new database I edited catalog/includes/configure.php and catalog/admin/includes/configure.php to get them pointing to the right database (not permissions may need to be changed when replacing these files on the server..

Thanks again for the help guys and hopefully my instructions may help other novices like me.

P.s. if you create a new database and copy your old info across to it I think it's relatively safe to try the upgrade if (like me) you are unsure what version of osc you had)..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.