Backing up database - Failed - Rev 5952

[Wayne Workman]

@GFm Go to Sourceforge and find the commit number you want. Look at the commit messages to figure this out. Then follow the bottom of this, where it says “Update to revision”.
https://wiki.fogproject.org/wiki/index.php?title=Upgrade_to_Revision

[GFm]

@Wayne-Workman Great, thank you!

[GFm]

@Wayne-Workman @Tom-Elliott
I tried going backwards (rc-8 and 5934 as well), but now I get the attached pic.

I checked out that config.class.php and it shows the correct settings to my DB, and I also restarted the mysql service, but no luck.

I can open a new post if you want since this is kind of separate, just let me know.

Thanks!

[Wayne Workman]

@GFm So you attempted updating… a day ago, and it failed? You should find a db backup inside of /home with a date and time in it’s name. Just import that, and then try to move to RC-9.

The way you import them (without mysql pass) is:
mysql < file

with a password:
mysql -u root -p < file

This is covered in more detail here:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Manually_export_.2F_import_Fog_database

[GFm]

@Wayne-Workman When I look at this, all the backups from recent show 0. The last backup with data is April, but I know I updated in July and see no backups.

I went into my fog database in mysql… Inside it had data, so it is there. Any other ideas to try and get this working since I can’t restore one of those mysql backups?

Thanks a lot!

[Wayne Workman]

@GFm well… I guess this makes sense. Your installation fails at “backing up db” and the backups are 0 size.

@Tom-Elliott do you have thoughts on what is best to do?

I guess you could move to working-RC-10. This requires some special commands, message me for details.

[GFm]

@Wayne-Workman Tried updating to RC-10 and it gave me the same error as before about invalid database. Here is my config.class.php fil that it said to check out… Are my settings OK?

[Tom Elliott]

@GFm from terminal what happens if you run mysql -u root

[Wayne Workman]

@GFm inside of /opt/fog/.fogsettings change snmysqlhost= to localhost and try again. If that fails, change it to 127.0.0.1 and try again.

[GFm]

@Tom-Elliott

[Tom Elliott]

@GFm and same command but with -h 127.0.0.1

[GFm]

@Wayne-Workman same as before… tried both and restarted mysql service each time

[Wayne Workman]

@GFm you need to re-try installing after each change, you did that?

[GFm]

@Wayne-Workman no… sorry I will and let you know shortly…

[GFm]

@Wayne-Workman @Tom-Elliott 127.0.0.1 worked! I did not test localhost with a reinstall since that worked.

My load just went up a lot, but I’ll see if it drops after a few minutes.

Thanks for the help!!!