restoring data to database

Start
Prev
1
Next
End

1

Steve Klund
Topic Author
Offline
Gold Boarder
Technology is our friend

More

2 years 10 months ago #26739 by Steve Klund

restoring data to database was created by Steve Klund

Hello All!

The documentation for moving a site is really great! It worked flawlessly.

My question is this:
I inadvertently forgot to put the new site in "Maint mode" while testing functions. Found out people logged in and created appointments.

I'd like to confirm the process of moving the tables again to capture any changes.....

Just redo the steps for migration?

1: export all *.backup tables

2. import into new (existing now) database on new site)

3. restart mysql

4. check that last entries match

Sound right?

Thanks

Please Log in to join the conversation.

Rob
Offline
Administrator

More

2 years 10 months ago #26740 by Rob

Replied by Rob on topic restoring data to database

A couple of things to clarify..

ABPro backup/export/import/restore will move data from one instance of ABPro to different one.
It will not merge appointments from one instance to another. The process will replace all data in the destination with date from the source.

"restart mysql" ??
MySQL is never stopped.
It is used to export the _backup tables, and to import them again in the destination.

You do not export/import 'tables'.
You export data from source ABPro tables to a text file, then import it from the text file back into the destination database tables.

Please Log in to join the conversation.

Steve Klund
Topic Author
Offline
Gold Boarder
Technology is our friend

More

2 years 10 months ago #26741 by Steve Klund

Replied by Steve Klund on topic restoring data to database

Yes, sorry for my poorly crafted post.

So, I just follow the procedure of exporting the backup tables data, importing into new server, then run the "restore" function within ABpro

Again, sorry for the badly written post

Please Log in to join the conversation.

Rob
Offline
Administrator

More

2 years 10 months ago #26742 by Rob

Replied by Rob on topic restoring data to database

Yes, that will bring your old data to the new ABPro.

Please Log in to join the conversation.

Start
Prev
1
Next
End

1

Time to create page: 0.235 seconds

Powered by Kunena Forum

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013

Just thought I'd pass along some positive feedback from my client:
"All of us are excited about our new online booking!! Shanyn & Chelsea said it’s “fun”; even I’m getting the hang of it! There are still a few glitches so we’re having another meeting on Tuesday - but all of us are thrilled! Thank you! Thank you!"

The "glitches" they mentioned are all minor and I've tweaked a few settings and answered a few questions to address them. Overall they're very happy. "
Chris C

"Hi, im back
After using appbooking pro for 3 years successfully i have tried another booking system for a new site that was more expensive, promised a lot but full of errors and the developers wanted to suck the $$ for every little request.

Anyways, great to be back here "
roll82

"thanks for all the help you have given me over the past few months. We have managed to get the system to work so that multiple businesses around the country can log into our website and manage appointments for their own businesses through the ABPro System."

owen_molloy October 2013