Soulfly Posted April 15, 2004 Posted April 15, 2004 Hi. im trying to export my costumers (and other things) from a osc database to another osc db. ive exported costumers to a database and when i try to import it it says that already exists "costumers". how can i do to update it? thanks
Guest Posted April 15, 2004 Posted April 15, 2004 you need to go to mysql.com and search on the commands to extract the information. phpmyadmin is just an engine interface to the database. you will also need to know the proper fields and tables you want information from. or you can use odbc to extract the information to excel or access (contribution available on this) then send back to another database.
241 Posted April 15, 2004 Posted April 15, 2004 Is the other database a blank database for customers, if so you can export the table from the database with the data that you want with phpmyadmin to include the drop create commands then run the sql query on the database that you wish the information to be placed on this will drop table if exists and create table then insert the information No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
Soulfly Posted April 15, 2004 Author Posted April 15, 2004 thank you both im using mysqlfront very nice and easy!!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.