11
detroit
Re: Admin cannot login
  • 2006/3/27 3:40

  • detroit

  • Just popping in

  • Posts: 16

  • Since: 2006/3/26


i got access to cpanel

12
mclindy
Re: Admin cannot login
  • 2006/3/27 3:51

  • mclindy

  • Just popping in

  • Posts: 38

  • Since: 2005/1/23


I am looking at a demo for cPanel, though I don't use it. It might or might not work for you.

It looks like after you log into cPanel there is a screen that reminds me of the Control Panel in Windows (icons for Mail, Webmail, Change Password, etc.). Down in that list I see an icon called MySQL Databases. Click on that.

Next you come to a screen called MySQL Account Mainenance. If you scroll to the bottom you'll see a link to phpmyadmin. Click that.

That should take you to a phpmyadmin screen.

There, on the left, you should see a list or a dropdown list of databases. Hopefully you know the name of you XOOPS database, but let's pretend it's myXoops. You should see something like myXoops(89) which shows that the database called myXoops has 89 tables.

You should see tabs across the top of the phpmyadmin screen. Click the Export tab. Here you have several options and I'm not sure which is the best. Do some homework here and consider making mulitiple copies with different options settings.

After you have your mySQLbackup, do a Google search about restoring databases. I'm not sure how you do that through an ISP since I have my server here at home.

I hope this will help you.

13
mclindy
Re: Admin cannot login
  • 2006/3/27 3:53

  • mclindy

  • Just popping in

  • Posts: 38

  • Since: 2005/1/23


WAIT! HOLD ON A SECOND...

14
mclindy
Re: Admin cannot login
  • 2006/3/27 3:56

  • mclindy

  • Just popping in

  • Posts: 38

  • Since: 2005/1/23


It looks like there's an icon called Backup on the cPanel page. If you click that it looks like you can download a mySQLdatabase backup. That's the best thing to do, I think.

Again take all of this with caution because I've never used cPanel.

But at any rate you're going to need a backup of your data if you're to have any hope.

15
mclindy
Re: Admin cannot login
  • 2006/3/27 3:58

  • mclindy

  • Just popping in

  • Posts: 38

  • Since: 2005/1/23


You might want to have a full backup (it's an option), but you should have the MySQL backup as a separate file as well. I think that you'll want to have it not packaged with everything else in a compressed file.

16
detroit
Re: Admin cannot login
  • 2006/3/27 4:14

  • detroit

  • Just popping in

  • Posts: 16

  • Since: 2006/3/26


i checked phpadmin and found this error
SQL query:

SHOW KEYS FROM `xoops_session`
MySQL said:

#1016 - Can't open file: 'xoops_session.MYI'. (errno: 145)
what should i do now

17
tripmon
Re: Admin cannot login
  • 2006/3/27 4:22

  • tripmon

  • Module Developer

  • Posts: 462

  • Since: 2004/2/28


repair the session table choose sessions table in the left column of my admin, click options up top, click repair.

see if that helps.

18
detroit
Re: Admin cannot login
  • 2006/3/27 4:35

  • detroit

  • Just popping in

  • Posts: 16

  • Since: 2006/3/26


done it mate.thanks for u r all of your support.

19
mclindy
Re: Admin cannot login
  • 2006/3/27 4:38

  • mclindy

  • Just popping in

  • Posts: 38

  • Since: 2005/1/23


It's working? Cool.

Now for the love of God man, back it up! Use the backup feature of cPanel and read up on the backpack module. You should get a backup at least monthly if not weekly or daily.

I'm glad everything worked out well.

Login

Who's Online

137 user(s) are online (77 user(s) are browsing Support Forums)


Members: 0


Guests: 137


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits