steve*** Posted November 25, 2003 Posted November 25, 2003 Don't ask me why, but i've managed to destroy my database, and was stoopid enough not to keep an upto date back up of it. I dropped the contents of some tables and now the site won't work. Basically what I want is a way of getting all the new account info from the old one and move it into the new store
wizardsandwars Posted November 25, 2003 Posted November 25, 2003 Do you mean 'customer' information? And if your database is 'killed', are you sure the customer information still exists? ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
steve*** Posted November 25, 2003 Author Posted November 25, 2003 I'm not sure it exists, but i think it still does. All I hav done is drop info from one of the tables. Other than that the data is still in there. All I need to do is to get the names, addresses, e-mail addresses from the old site to insert it into the new site.
wizardsandwars Posted November 25, 2003 Posted November 25, 2003 Well, first you should use 'phpmyadmin' to dump the data from the customers table, and then use the same tool connected to your new database to 'import' the dump. If you are using a webhost, and are on cpanel, it should come with phpmyadmin installed already. IF not, that's another *must have* piece of saftware you'll need to administer your oscommerce cart. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
steve*** Posted November 25, 2003 Author Posted November 25, 2003 Excellent, thanks for the help. I've also dumped and then re inserted the customers_info tables The only problem I have now is when I try to edit (so I can see the address details) i get this error Warning: reset(): Passed variable is not an array or object in /home/steve/public_html/jigsawshop/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/steve/public_html/jigsawshop/admin/includes/classes/object_info.php on line 18
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.