Support

Site Restoration

#25593 restore to localhost | db error processing line 0

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by on Saturday, 13 August 2016 17:20 CDT

niagarait
 I am trying to restore a .jpa file to localhost running wamp 3.0.0 on win7 64bit
kickstart extracts fine.
When it comes to db restoration I get ErrNo #0

 SQL=CREATE TABLE `jfwiq_ak_profiles` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `description` varchar(255) NOT NULL,   `configuration` longtext,   `filters` longtext,   `quickicon` tinyint(3) NOT NULL DEFAULT '1',   PRIMARY KEY (`id`) ) ENGINE=Aria AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1


I tried replacing the 'ENGINE=Aria' part with "", but it did not work.

importing a sql dump into local phpmyadmin results in the same error.

How can I get the db running on localhost, please?

Best,

Thomas

tampe125
Akeeba Staff
Hello Thomas,

looking at the SQL query, it seems that the table was created with a MariaDB database server and you are trying to import it into a MySQL, which does not support the Aria engine.
Please manually try to change all occurrences of Aria with MyISAM, that should do the trick.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

niagarait
Hi Davide,

thanks for the quick reply.

I replaced Aria with MyISAM and imported directly into phpmyadmin on localhost.

Here is what I get:
SQL query:


CREATE TABLE `jfwiq_ak_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `configuration` longtext,
  `filters` longtext,
  `quickicon` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1
MySQL said: Documentation

#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 'PAGE_CHECKSUM=1' at line 8


must be something else.
what do we try next?

thx

tampe125
Akeeba Staff
Try to remove the PAGE_CHECKSUM part.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

niagarait
I removed the PAGE_CHECKSUM and phpmyadmin now imports the.sql file.
However, this takes forever ( I had to extend the maximum execution time) and the import stops half way through the tables.
File size is only 2305 KB.
So this looks like a problem with local phpmyadmin.

The strange thing is, that I can restore the .jpa file without problem on the live server.

Any thoughts?

niagarait
Update
I managed to import edited (PAGE_CHECKSUM removed from extracted .jba file db) .sql file into local myphpadmin.

edited configuration.php to point to above db name.
Now I get db connection error
Application Instantiation Error: Table 'db.prefix_session' doesn't exist


I have set
public $db = 'beauchamp7'; (the db I imported into in step 1)
public $host = 'localhost';
public $user = 'root';
public $password = '';

How can I get past this?

looking forward to your reply :)

T


niagarait
update

site.sql last line is at table 'm'

no wonder table session does not exist.

Looks like extracted site.sql from .jpa file is incomplete.

Perhaps time to rewrite the site from scratch

tampe125
Akeeba Staff
Just to give you some info:
  • The best thing to do is to edit the *.sql files inside the installation folder, then run ANGIE. So it will take care of the restore
  • Using ANGIE will take care of updating your settings, too, so you won't have to do that manually
  • Please keep in mind that you database is split within several sql files: site.sql site.s01 site.s02 etc etc. Once again, the best thing to do is to edit those files manually to remove the specific commands of MariaDB, and then use ANGIE to restore your backup.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

niagarait
Thanks Davide,

I will try that.

Greetings to Italy from Austalia :)

tampe125
Akeeba Staff
You're welcome!
Let me know how it works

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!