Joel R Posted September 27, 2015 Share Posted September 27, 2015 Hi, this is a fairly simple question: how do I move a record from one database to another database? For example, I have records A1, A2, A3 in database AA. I would like to move those records to database BB. It seems like I can only move records to another category, but not to another database. Link to comment Share on other sites More sharing options...
Meddysong Posted September 28, 2015 Share Posted September 28, 2015 I'm fairly sure I read several months ago an explanation to somebody else's similar request that moving records between databases wasn't possible and shouldn't be anyway because a record from AA contains field information that won't work in BB. I'm in a situation quite similar to yours, by the way, and intend to manually change things via phpMyAdmin if I ever resolve this little problem: Link to comment Share on other sites More sharing options...
Joel R Posted September 29, 2015 Author Share Posted September 29, 2015 8 hours ago, Meddysong said: I'm fairly sure I read several months ago an explanation to somebody else's similar request that moving records between databases wasn't possible and shouldn't be anyway because a record from AA contains field information that won't work in BB. I'm in a situation quite similar to yours, by the way, and intend to manually change things via phpMyAdmin if I ever resolve this little problem: That makes a lot of sense. While at work today, I brainstormed that I might be able to copy / reproduce the database in full (maybe?) and then delete away the records that I don't want. I'll have to try it tonight. Link to comment Share on other sites More sharing options...
Meddysong Posted September 29, 2015 Share Posted September 29, 2015 5 hours ago, Joel R said: While at work today, I brainstormed that I might be able to copy / reproduce the database in full (maybe?) and then delete away the records that I don't want. I'll have to try it tonight. That seems sensible. The only drawback (if you're aiming to do it via the ACP rather than going into the MySQL tables) might be that exporting a database and then importing it again as a new one doesn't bring the records with it. But if you don't have too many of them you could always import the database structure and then add new records one by one. Link to comment Share on other sites More sharing options...
opentype Posted September 29, 2015 Share Posted September 29, 2015 Since the database records are really only stored in their respective single database you can indeed do imports and exports in phpMyAdmin. You would need to take care of the field names however, since they need to be unique. Link to comment Share on other sites More sharing options...
emilhem Posted September 30, 2015 Share Posted September 30, 2015 As they pushed all our articles into a single database, this will cause major problem for us. We need to break out hundreds of records to different databases to be able to control how each category is displayed, because a database can only be linked in a single Page. The new structure, without the ability to copy a current database is insane, or even bulk edit (delete) records. So even this solution, of dumping the database, edit the unique fields and importing it, will be a ton of work. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.