lost half of my Database

[norfond]

Hello,

I thing I've lost half of my database in stoli's server moving.

After the letter J, I've nothing. First, I've got an error with my jos_session, but after a little investigation, some of my table are lost.

I've try to use the backup in cpanel, but my login is not working.

Now I'm trying to find another way to recover the database.. but I need some help.

My web site is base on joomla. I have joomlapack installed. But since some month, I haven't been able to do a completed backup because of time out. The backups never completed I've after 2 suspension because backup used to much of resources, I've stop to try to do a completed backup with joomlapack.

Thanks in advance.


Account : norfond
account id MMP1024247
contact email norfond@yahoo.ca



Edit : I've repaired, or tried to repaire talbe jos_session with this script :

DROP table IF EXISTS jos_session;
CREATE TABLE `jos_session` (
`username` varchar(150) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
`client_id` tinyint(3) unsigned NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) TYPE=MyISAM CHARACTER SET `utf8`;

found on this tread :

http://forum.joomla.org/viewtopic.php?f=429&t=357126&start=0

 

[vishal]

Which is the cpanel link you used to login. Login to account panel http://x10hosting.com/control/login.php.
Here you can view your account status, also try changing your cpanel password. If you still cannot login post back here

 

[norfond]

Hello,

I can access my cpanel account without problem.

I've update my password to be sure it's set correctly in all services as you suggested.

The service I'm not able to access is the "R1Soft Restore Backups" which is located in the " Files" section in my cpanel.

I've retry to login, but still not able to access it.

On this page, it said "host not found" from the first time I'm redirect from the link in cpanel.

Settings : host description : Free Hosting Template
user : norfond
password : My admin password

May it helped?

 

[norfond]

Hello,

I think if an admin can get a copy of my old mysql database in backup, I'll be fine to get my website back.

Where do I open an official tikets?

thank,

Norfond.

 

[Zubair]

Hello,

I think if an admin can get a copy of my old mysql database in backup, I'll be fine to get my website back.

Where do I open an official tikets?

thank,

Norfond.

This is the official support ticket.