Installed osc. Overwrote mysql database.

[tcpinhead]

I have installed OSC on all the machines I can get my hands on. That way I can always dig deeper and learn something. It is working on all of them.

 

My Problem: On one of the installs I used the mysql db as the OSC db. oops. OSC was connecting to my db just fine but I couldn't use any admin tools to get to it. I added a new mysql superuser and now have access again. Is there anything I need to worry about? Should I reinstall mysql? Should there be a note not to use mysql as the catalog DB? Is that note already there?

 

Thanks for any advice.

I am a newbie but quickly finding my way.

 

Terral

[tcpinhead]

The new users are in the osc db as users not customers. I hadn't been worried about this but if I use the work I've done on this machine and load the db onto a server, would the users info mess anything up? I guess the thing to do would be backup the db and remove the user info before uploading. Should I split that info back out and make a new user db? I am just not sure which parts of the mysql db are for OSC and which were for mysql.

 

Any help would be great.

 

Thanks

Terral

[badjuju]

Hmm....Let me see if I have this right.

You had an initial database called 'mysql' which you used as your OSC database. Then you created a new db called 'OSC' which you would like to use for as your osc database.

 

Now, you want to move users from 'mysql' to 'osc'.

 

* The first thing you should find out - what's the table name in 'mysql' and which fields are defined there?

 

* If the table names are the same, then create an export file from 'mysql' and import them in 'osc'.

 

* Assuming the table names are different and the users you have in 'mysql' have permissions to connect to the database then it means that even if you move those users to the 'osc' customers table, you will have a lot of missing information like address, phone, email, etc.

 

* In 'mysql' database, what are the contents of the 'customers' table. This is what you really need to import in 'osc'. Follow the second bullet point above, then when you're done, delete those users from the database access group in 'mysql'.

 

Does this make sense? No? Good :)

Let me know if you need more help

[tcpinhead]

Right now I just have a database called 'mysql' which has both the mysql and osc information in it. The table name which has mysql user info in it is called 'users'.

 

I am using it to build a test shop to replace our online one. I'm not sure if we will replace it yet or not. I suppose most of what I have been doing is mostly based in the php files other than the product database. I have easypopulate working so I could export my product info and import that into a new osc db.

 

Thanks for your help

[tcpinhead]

Using phpmyadmin I exported the 'mysql' database that contained both osc and mysql info.

 

Then I created a new database and imported my just exported database into it by opening the file in bbedit (I'm on Mac OS X), copy the entire content, paste in run mysql query, hit go. wait and watch. (wouldn't work in IE, had to do this in Netscape)

 

I made another new file and imported empty OSC db from current snapshot and compared the two files. I can see the difference between the files and delete files accordingly and relink OSC with the new db with the updated info minus the mysql info.

 

whew.

this is all new to me but now you know.