How to restore the database if I don't have the files?

[Charybdis]

Hi,

I attempted an upgrade, but it went wrong. I have the backed up database, but I lost all the old files. I backed up the database in the admin page in Kayako (with default settings). It created a file called username_kayakosuite02Oct2008.sql.gz.

How could I restore the original state?

Or if I install the newest version, how could I restore the content of the old database into the new version?

I downloaded the version I used before the upgrade. Then I simply uploaded the files, and properly configured config.php. Then I restored the database using Cpanel (backup > restore database), with the exact same name and username/pw. But it does not work:

Invalid SQL: SELECT `vkey`, `data` FROM `swregistry` WHERE `vkey` IN('languagecache','usergroupsettingcache','staffa ssigncache','groupassigncache','staffcache','tgrou passigncache','settingscache','tgroupcache'); (Table 'username_kayakosuite.swregistry' doesn't exist)
eSupport is not installed, Please run setup/index.php to run eSupport

After install, which files will be modified and how? Because it seems that Kayako modifies some files after installation?

[Casey Rousseau]

Undoubtedly some of what you're looking for happens when you run the upgrade script, which you may have deleted after the upgrade.

[Charybdis]

Originally Posted by Casey Rousseau

Undoubtedly some of what you're looking for happens when you run the upgrade script, which you may have deleted after the upgrade.

As I wrote, I have the old database, but I lost all the old files.

I used version 3.11.01 (Zend). I want to restore the original state. How to do it?

[Jamie Edwards]

Hi Chary,

Simple restore your database, upload the 3.30.02 (latest) files, edit and upload config.php (to point to your restored database) and run the upgrade script again. It is not normal an upgrade fails, how did it "fail"?

[Charybdis]

Originally Posted by Jamie Edwards

Hi Chary,

Simple restore your database, upload the 3.30.02 (latest) files, edit and upload config.php (to point to your restored database) and run the upgrade script again. It is not normal an upgrade fails, how did it "fail"?

Hi Jamie,

please help! How to restore the database with PHPMyAdmin?

I created the database backup from Kayako, using the default settings (Add “CREATE TABLE” SQL statements and Compress SQL Dump). I got an xxx.sql.gz compressed file.

I created a blank database, then tried to import my old Kayako database. I used these setting before importing in phpmyadmin:
Character set of the file: utf-8

Partial import
[checked] Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions.
Number of records(queries) to skip from start: 0
SQL compatibility mode: NONE

I got this error during importing:

Error

SQL query:

CREATE TABLE `swkbarticledata` (
`kbarticledataid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`kbarticleid` int( 10 ) unsigned DEFAULT '0' NOT NULL ,
`contents` mediumtext,
PRIMARY KEY ( `kbarticledataid` ) ,
KEY `kbarticledata1` ( `kbarticleid` ) ,
KEY `contents` ( `contents` )
);

MySQL said: Documentation
#1170 - BLOB/TEXT column 'contents' used in key specification without a key length

I use now MySQL 5.0.45-community. However, I installed this old Kayako version on MySQL 4. It seems that there is an error in the database (this is version 3.11.01).

[Charybdis]

Ok, I successfully restored the original database. Then uploaded the files of the latest Kayako version. Then I upgraded the site. The upgrade was successful (no errors).

Then I load the home page of Kayako, and it says:
eSupport is not installed. Run setup/index.php to install eSupport

Why?

[Casey Rousseau]

Are you certain you did this step? You didn't explicitly mention it.

Originally Posted by Jamie Edwards

edit and upload config.php (to point to your restored database)

[supportskins]

Have you contacted Kayako Support from - https://members.kayako.net?