Backing up database - Failed - Rev 5952

[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!!!