Backup and Restore

[Dean Spencer]

Hi,

We run the website http://www.socialhuddersfield.co.uk which has Events Calendar Pro installed.

We are building a new website and wondered if there was a way to backup all the events (and images) on the old site, and restore them on the new site (also running Events Calendar Pro).

If you could please let me know.

Thank you.

[Hunter]

Hey dellydooley 🙂

There are many ways to achieve backing up and restoring your events from one site to another.

One simple way would be to visit Tools > Export and Import in your WP admin dashboard. There are also plenty of backups available in the WP Plugins repository. I personally have had great success with UpdraftPlus Backup and Restoration.

I’d also try researching Google for this kind of information; all we can do is give you general direction on these types of questions. Thanks for reaching out through our support forums and I hope this information helps! Have a good week.

[Dean Spencer]

The Import / Export didn’t work because the file size is too large.

I plan on using phpMyAdmin – what tables do I need to backup please?

Thank you

[Hunter]

Welcome back,

To answer your question, the post types are tribe_events, tribe_venue, and tribe_organizer. You might also want to contact your hosting company to see if they can increase your limits. Before trying an SQL query, take a look at these plugins. You should be able to export events from your old site and import them into the new site:

• WP Ultimate CSV Importer
• Custom CSV Export Plugin
• WP CSV
• Really Simple CSV Importer

Best of luck with the data transfer and have a good weekend!

[Dean Spencer]

Hi I have tried each one of the tools you have suggested and none of them have worked. Some time-out on Export and some time-out and Import.

We have modified php.ini but to no avail. My knowledge is limited in this area.

I have been doing this for 12 hours now and getting very frustrated.

I have looked at phpMyAdmin and cannot find the tables you have mentioned? Presumably I need to run an SQL Query but not sure on syntax?

There are thousands of events with associated images. I need to do a complete migration.

Any further help would be greatly appreciated.

Thank you.

[Hunter]

Thanks for the response,

I have a few more potential solutions, but I do want to remind you that this type of support unfortunately extends beyond the scope of support we are able to provide through our forums.

The first thing you could do is by simply backing up your entire database via phpMyAdmin and extract the data you need on a test environment.

This thread on Stack Overflow discusses how to export WP posts and meta info in CSV format using an SQL query.

This KB article provides Events Calendar PRO post meta data information.

One last idea I can think of would be to do it in stages if you have phpMyAdmin access. For example:

SELECT   wp_postmeta.*
FROM     wp_postmeta
JOIN     wp_posts ON wp_posts.ID = wp_postmeta.post_id
WHERE    wp_posts.post_type = 'tribe_events'
ORDER BY post_id ASC
LIMIT 0, 100;

Would get you the first 100 event post meta records. Then you would run it again with LIMIT 100, 100; then again with LIMIT 200, 100; etc. Vary as needed for different post types / for the post records themselves.

Take care and good luck with everything 🙂

[Dean Spencer]

Hi, I appreciate this is outside your normal area of support. Thank you again for offering your assistance!

Can I please ask, do I need to backup and restore tribe_events, tribe_venue, and tribe_organizer together in order to keep the data intact?

I did find a plugin which seemed to work, however when I checked the data, the events did not contain venues or organizers. This was despite the fact that the venues or organizers had been restored. I suspect this is because one table was backed up and restored at a time?

Please let me know.

Thank you,

Dean

[Dean Spencer]

Hi, I have purchased ‘WP All Export’ and ‘WP All Import’.

The tool has allowed me to export all events, images, venues and organizers.

The issue is none of the data has been linked, i.e. the Events don’t have an Image, Venue or Organizer.

Are you able to offer any advice please?

Thank you,

Dean

[Hunter]

Hello and welcome back!

When importing events, venues, and organizers, you need to import in this order:

1. Venues
2. Organizers
3. Events

As for the images, I don’t really have an answer for you on that as there are a plethora of reasons why they’re not appearing and it would be nearly impossible for me to figure it out without logging into you site, which we’re unfortunately unable to do for any reason.

Glad to hear you’ve got it going for the most part. Keep at it and I’m sure you’ll get it shortly. You may want to try contacting the import plugin authors and see if they have any insight.

Thanks so much for choosing PRO and have a great day!

[Dean Spencer]

I have spent over 30 hours on this and cannot get this to work. I have paid for plug-ins for export and import and getting fed up with the lack of support offered by anyone.

I have imported in the order suggested but nothing links together.

I would pay for a solution from you guys to do this, I’m surprised one isn’t available.

Please are you able to help?

[Hunter]

Welcome back,

I’m sorry to hear you’re still having troubles. As previously stated, this type of support extends beyond the reach we are able to provide. You may want to try a freelancer site for a data transfer expert.

My method is by exporting via phpMyAdmin – I start with tribe venues, organizers, then events. Next, I export my postmeta. Lastly, I import the venues, organizers, events, then the postmeta into the new site and everything should be transferred.

Again, I wish I could provide more support or options. Good luck with the transfer.

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts