Question Backing up website before upgrading and there is error while importing database. Need some help.

Hello,

Today I wanted to test the upgrade from Kunena 1.7.1 to 1.7.2 and Joomla 1.7.3 to 2.5. Before this I made a backup of my website and database. This is something I did many times before, so I think there is nothing wrong here.

But while trying to re-import my database I got the error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?phpMyAdmin=bb79a8da7b4bc6ce8bd83992983de09e' www.grafischforum.nl/5-overi ' at line 259

Line 259 in my sql file is:

`id` int(11) NOT NULL AUTO_INCREMENT,

Tried this on my local MAMP server as well as on the same webserver as the current forum is running. Both should be able to run this.

I've never seen this error, so guess this is something quite recent. Can someone tell me what I need to do to solve this issue? If I can get this fixed I can go on testing my forum on the new K and J software.

Can someone please help me and solve this issue?

Did you use Akeeba to backup your website? Perhaps you should roll it back, upgrade Joomla first, then upgrade Kunena once you have check no joomla modules/plugins need upgrading?

No, I just use phpmyadmin to export my database and Cyberduck (FTP) to backup my website. I've done this a dozen of times before the past couple of years.

On my local system I wanted to import everything, so I can perform and test the upgrade offline. This I've also done a dozen of times before the past couple of years.

Just this time it looks like Kunena or Joomla corrupted something that is now preventing normal behavior. I have no clue about databases, so I need someone that is willing to help me and fix this error.

So your live website is running fine?

Anyway, I can't help any further. I had absolutely no issue upgrading Joomla to 2.5 or Kunena from 1.7.1 to 1.7.2.

Perhaps you should check that its not an issue caused by J2.5 and some module that needs updating as well.

Yes, my live website is running fine, but before I do an upgrade I backup everything and test if the backup is working. But it looks like there is something corrupt in my live database that was not there the last time I made my backup. I do not make backup on weekly or even monthly base, so fall back to the last database without issues is no option.

Before I do the upgrade I want my backup/fallback to be 100%.

Then get Akeeba backup - its free and works perfectly.

Ik know Akeeba and know it works perfect. But if Joomla or Kunena put corrupt data in the database, also Akeeba will have issues one way or another. This is not about how I make my backups, because I do it this way for over 8 years now.

It's about the database error that I would like to have fixed. But thanks for your efforts and advise so far. It's appreciated.

Did you try to select all tables and repair tables in phpmyadmin? Maybe that fixes your problem in the table?

Or go to administrator/index.php?option=com_installer&view=database and click on fix.

regards 810

Hi 810. If I go to that url I get the following error:

500 - Er deed zich een fout voor.
View is niet gevonden [name, type, prefix]: database, html, installerView

If I search for the text from the error I get in the database file I notice that this line has another line that is not there in the lines around it. The line phpMyAdmin=JzU1q1OkQk%2CamG8IraxDVxqMH04 seems to be there without reason. I will delete it and see what happens.

Thanks so far.