comcipher Posted June 12, 2004 Share Posted June 12, 2004 I've been working on a site for a guy for awhile now, and I set it up on a random directory in my current site so he could start moving in his inventory along with pictures. Now we've got his perminant host set up and I need a good way to move everything over. I can't just backup the database because it was set up on the same database as several other programs are using and it's still tied to my site. Perhaps there is some way to point it at that database when intstalling oscommerce? Any help is appreciated.... I could certanly use it. Link to comment Share on other sites More sharing options...
Acheron Posted June 12, 2004 Share Posted June 12, 2004 Well if you can't backup the DB in full, then you need to do it per table. phpMyAdmin allows you to hold CTRL and select only the tables you want to dump the data/structure for. It won't get any easier than that if you have other tables intermingled within the same DB. Link to comment Share on other sites More sharing options...
comcipher Posted June 12, 2004 Author Share Posted June 12, 2004 Could you please be a litte more specific? I'm fooling around in phpmyadmin and i'm not having much luck just yet on how to take out only certin tables. Link to comment Share on other sites More sharing options...
Guest Posted June 12, 2004 Share Posted June 12, 2004 To dump the table, use SELECT * INTO OUTFILE 'file_name' FROM tbl_name. To reload the table, use and restore with LOAD DATA INFILE 'file_name' REPLACE ... To avoid duplicate records, the table must have a PRIMARY KEY or a UNIQUE index. The REPLACE keyword causes old records to be replaced with new ones when a new record duplicates an old record on a unique key value. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.