Support

UNiTE, Remote CLI, eXtract Wizard

#3640 error when installing backups

Posted in ‘UNiTE and Remote CLI’
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
Tool
UNiTE
Tool version
n/a

Latest post by nicholas on Thursday, 03 June 2010 21:41 CDT

user11435
Hi
Im getting this error when i try installing my backups

Error at the line 202: CREATE TABLE `akb_hwdvidslogs_votes` ( `id` int(50) NOT NULL auto_increment, `videoid` int(50) NOT NULL default '0', `userid` int(50) NOT NULL default '0', `vote` int(50) NOT NULL default '0', ... MySQL: MySQL query failed with error 1 (Can't create/write to file './kapugad_jo151/jos_hwdvidslogs_votes.MYD' (Errcode: 13)). The query was:CREATE TABLE `jos_hwdvidslogs_votes` ( `id` int(50) NOT NULL auto_increment, `videoid` int(50) NOT NULL default '0', `userid` int(50) NOT NULL default '0', `vote` int(50) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=32156 DEFAULT CHARSET=utf8

any suggestion on how to repair will be highly appreciated

mico

dlb
Is this a local MySQL server or a commercial host? It appears that the MySQL server can't write to it's file. That is very unusual.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

user11435
Hi Sir Dale

The server is on a commercial host. i just sign up for an VPS account with them and im trying to put up my site with the use of kickstart, but no luck. will this cause by a missing or corrupted MySQL files? any suggestion on how to go around this?

Mico

dlb
No, this looks to me like a problem with the MySQL server itself, not the data we're trying to restore to it. I need to have Nicholas look at this to be sure.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

nicholas
Akeeba Staff
Manager
Yes, this is a problem with the MySQL server, not the restoration. The first step to self-help is to try to repair the database tables using phpMyAdmin. If this doesn't work, you'll have to definitely contact your host so that they can resolve this issue on their end.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

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!