[EventCalendar] Import calendar entries from other blog
tkane at prodigy.net
Sat Jul 25 20:58:52 UTC 2009
MMMM, not really.
When I look at my exported data, I see:
DROP TABLE IF EXISTS `wp_ec3_schedule`;
CREATE TABLE IF NOT EXISTS `wp_ec3_schedule` (
`sched_id` bigint(20) NOT NULL auto_increment,
`post_id` bigint(20) default NULL,
`start` datetime default NULL,
`end` datetime default NULL,
`allday` tinyint(1) default NULL,
`rpt` varchar(64) default NULL,
PRIMARY KEY (`sched_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=119 ;
I don't see anything related to the database name except in the comment
--- Database: `irishmus_wp01`
This will replace the table, so if you have data in the table in the other copy of the website you want you'll need to back it up first.
Update is something I'm not familliar with.
--- On Sat, 7/25/09, Alf Haakon Lund <alf at galleritexas.no> wrote:
From: Alf Haakon Lund <alf at galleritexas.no>
Subject: Re: [EventCalendar] Import calendar entries from other blog
To: eventcalendar at firetree.net
Date: Saturday, July 25, 2009, 10:26 AM
Thank you for answering!
I just wonder, when I look at the sql command in the beginnig of the file export it says DROP TABLE IF EXISTS `olddatabase_ec3_schedule`;
CREATE TABLE `olddatabase_ec3_schedule`
1. I need to import these data to newdatabase_ec3_schedule
2. I want to keep the data already there
It seems to me the drop table will leave me without the current data?
I tried to remove the structure from the export and choose the export type UPDATE, then in the sql file renaming all occurrences of olddatabase_ec3_schedule with newdatabase_ec3_schedule.
After this myphpadmin said 198 rows was successfully imported, however I'm not able to find them anywhere in any table.
Hope you still have ideas where to go,
Best wishes, Alf Haakon Lund
Fra Tom Kane <tkane at prodigy.net> lør 25-07-2009 16:24:16 CEST:
> I think what you're missing is the "Add DROP TABLE" on your EXPORT.
> That creates the SQL that will drop the table so that you can re-add it to the export file that you run to import the data into the other site/database.
> I remember reading about that as an option in moving your wordpress site when I first started looking at wordpress about 6 months ago.
> And, I have a test site, and hadn't remembered that the wp_ec3_schedule table wasn't moved over by the normal wordpress export. So, I just looked and it had only 88 rows, I just imported an export with Add DROPPED TABLE and it went to the full 118 rows.
> Give it a try.
> --- On Fri, 7/24/09, Alf Haakon Lund <alf at galleritexas.no> wrote:
> From: Alf Haakon Lund <alf at galleritexas.no>
> Subject: [EventCalendar] Import calendar entries from other blog
> To: "Support for EventCalendar plugin" <eventcalendar at firetree.net>
> Date: Friday, July 24, 2009, 5:25 PM
> Hello everybody,
> I've been struggling with the import of calendar entries from one blog to another.
> I have one site which is going to be closed down and want to migrate the content to a new site for archiving purposes. The new site is also set up with ec3.
> However I could not find a way to merge or join or import the table through MyPhpAdmin, which looked like the best way - I get an error message stating that it will not insert the data because a table already exists (of course I want to keep the existing table).
> Getting the actual posts is a "piece of cake" via the export/import options in wp, but it seems I have to manually re-enter all calendar entries.
> I spent quite a few hours searching for an answer, but it seems I'm not able to ask the right question. So, I'm very thankful if someone has any ideas how to solve this.
> Best wishes, Alf
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
EventCalendar at firetree.net mailing list
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the EventCalendar