1.3.7 backup restore

AndrewB · Post by **AndrewB** » Mon Oct 13, 2003 1:49 pm

I have a backup with my 1.3.7 system

My Categories became messed up

The restore failed to insert many records

I read here that 1.3.7 "Restore ist buggy!"

My Question:

1. Should I manually add all the records that failed to restore in my 1.3.7 system?

OR

2. Should I upgrade to 1.3.8.beta and then try a restore?

AndrewB · Post by **AndrewB** » Mon Oct 13, 2003 2:15 pm

I have taken a look at the exported data. Is the problem with the single quotes in the data?

Do I have an option 3. Edit the phpmyfaq-data.2003-10-12.sql file and replace the single quotes in the insert statements with 2 single quotes?

I might give this a try...

AndrewB · Post by **AndrewB** » Mon Oct 13, 2003 2:35 pm

well. replacing the \' with \'' did not seem to help unless I messed up some way. Less where restored

AndrewB · Post by **AndrewB** » Mon Oct 13, 2003 3:34 pm

OK.

Option 4.
- Go into phpMyAdmin and delete all the data from the tables
- Cut and paste the Insert rows from the backup file into phpMyAdmin and execute the SQL
- this seems to insert the data correctly

Double checking to see if all OK!

AndrewB · Post by **AndrewB** » Tue Oct 14, 2003 1:15 am

I have now got all 198 FAQs restored..

I have also since upgraded to 1.3.8-dev

And taken a backup using 1.3.8-dev. So, can I trust this backup to restore if I need it? Is there anyway to test this without dropping all my tables in a real restore?

I guess I can either trust the restore or build myself a Test FAQ system in my database... Sounds like fun

Post by **Thorsten** » Tue Oct 14, 2003 3:26 pm

Hi,

you can trust the backup file since 1.3.8-dev. The import is bugless since the upcoming 1.3.8 beta2.

bye
Thorsten

AndrewB · Post by **AndrewB** » Tue Oct 14, 2003 5:05 pm

I know

I trust you Thorsten

Post by **Thorsten** » Tue Oct 14, 2003 5:07 pm

AndrewB wrote:I know I trust you Thorsten

Sometimes, this is a bug fault... 8)

bye
Thorsten