Category Data Backup / Restore

[peeryr]

I have reinstalled my OSCommerce due to experimental errors, and I wanted to restore my product categories. Is there a easy way to do this without messing up the entire cart?? All I want to do is copy all of my product categories over so that I don't have to enter all of my items again. Please any help will help here!!

 

I appreciate it..

 

Robert

[spax]

The products, categories etc are stored in the database so you just need a backup from store 1, copy it to store 2 then restore the backup from store 2 admin. Unless, of course, the experimental errors are in the database.

[peeryr]

I have reinstalled my OSCommerce due to experimental errors, and I wanted to restore my product categories. Is there a easy way to do this without messing up the entire cart?? All I want to do is copy all of my product categories over so that I don't have to enter all of my items again. Please any help will help here!!

 

I appreciate it..

 

Robert

 

Can you backup and restore the databases within PHPAdmin?? I mean is there a way to just take the databases that are needed and copy and paste them into the new database within PHPAdmin?? I did try this but don't want to risk really screwing things up!! I also would like to know if the backup tool within the OScommerce Admin backs up individual databases. And one more thing, How can i upgrade the PHPAdmin to 2.11.2?? or whatever the latest version is?? I didn't see an update / install method.. Any help would be nice..

 

Robert

[spax]

You can dump the tables from phpMyAdmin but you need to know which ones. The database is relational so one table could relate to another five.

 

Is there a reason you can't use an admin backup?

[peeryr]

You can dump the tables from phpMyAdmin but you need to know which ones. The database is relational so one table could relate to another five.

 

Is there a reason you can't use an admin backup?

 

Well to put it frankly, I don't need all of the tables backed up. Really I just would like to get my categories, products, and product information backed up and restored to the new fresh installation database. Kinda like a fresh start of my database but with the same catagories and products. Do you know what I mean?? In my phpadmin, I can see where I can export and import the databases and tables if i wanted to, but it seems to not work as easy as a copy and paste deal. I am getting SQL errors when just trying to just export and import the table into the new database such as:

 

Error

SQL query:

 

-- phpMyAdmin SQL Dump

-- version 2.10.2

-- http://www.phpmyadmin.net

--

-- Host: localhost:3306

-- Generation Time: Nov 09, 2007 at 12:53 AM

-- Server version: 4.0.16

-- PHP Version: 4.4.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

 

 

 

MySQL said:

 

#1193 - Unknown system variable 'SQL_MODE'

 

I am not totally sure what this is saying that I would need to do, but, I have even thought to manually create the table, but I am afraid that something won't be right. The table that got hosed was the WHOS_ONLINE table. It was saying IN USE, and for some reason I couldn't stop it so that it would allow my main page to run. So by dropping the table, i needed to re-import it, and that is where I am stuck!!! Any help here would be a good thing!!!

[pjeigh]

MySQL said:

 

#1193 - Unknown system variable 'SQL_MODE'

 

I am getting the same error. I found a semi-solution for another app (http://forums.linkbidscript.com/showthread.php?p=34089) but I don't have any control over database imports. That's up to my ISP, who is not being super cooperative about finding a fix. :(