Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Problems


jbrown9493

Recommended Posts

Posted

Thanks for allowing me here. I really screwed up. Tired to modify something and well you know. I had a busy store and customers are raving. I had to reinstall my store. I have the osc commerce 2.2 Rc2a using the sts flowers remplate. My server is with earthlink.

The database and store ran fine before I did the bad thing. I've done my homework inside the configure.php files. I've exported and tried to import. I just don't know how to get all my customers and data back into my store. I saved all my images. I am stumped. Wasted a whole day in front of my computer. Got cramps in my hands. Help. What am I missing?

The datbase is there. The info is there.

Posted

Johnny,

 

If the new store has exactly the same set up as the old store, use myphpadmin and drop the existing tables ......then, import the old database into the new store.

 

If the new store has different tables, you will need to import the database and edit the table structure. You may also have to import sections of the database separately to complete the change.

 

 

Chris

Posted

Johnny,

 

If the new store has exactly the same set up as the old store, use myphpadmin and drop the existing tables ......then, import the old database into the new store.

 

If the new store has different tables, you will need to import the database and edit the table structure. You may also have to import sections of the database separately to complete the change.

 

 

Chris

Thanks Chris,

I just had to reinstall the same store. I tried using the same database when I set it up but the information wouldn't show up in the store. I created a new database and put the data into it. If I add a new product or name it stores it. But it won't put all the old information back. When you say import into the new store; what process are you referring to? Just to be on the same page. I have so many option to choose from on the phpmyadmin.

It would be nice to be able to get that data back on my store. Lots of work went into it.

Posted

Johnny,

 

Using myphpadmin, you will select ALL the current tables......and DROP them. You will see that the number of tables next to the database name will be ZERO.

 

Click import....and choose the SQL file you saved from the previous store. Click GO. This will import all the tables and data into the current database, restoring your information.

 

 

 

Chris

Posted

Johnny,

 

Using myphpadmin, you will select ALL the current tables......and DROP them. You will see that the number of tables next to the database name will be ZERO.

 

Click import....and choose the SQL file you saved from the previous store. Click GO. This will import all the tables and data into the current database, restoring your information.

 

 

 

Chris

Ok Chris,

Somethings working. But when I go to my store, I get a blank screen. Maybe I need to reinstall the store?

Posted

Ok Chris,

Somethings working. But when I go to my store, I get a blank screen. Maybe I need to reinstall the store?

I did the drop. Imported the sql. ???Blank screen. What do you think? Delete and reinstall store. During install name the new database to it?

Posted

I did the drop. Imported the sql. ???Blank screen. What do you think? Delete and reinstall store. During install name the new database to it?

Dear Chris,

I reinstalled the store. Set permissions. Drop everything in the database. Imported the saved database.

Set up the new store pointing at the database. How do I get the products, customers back into the store?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...