Mysql Database

[super11]

Hi there,

 

I tried to fix my website's invisible database (http://super11.heliohost.org) following the instructions to backup the database, delete it and restore. But i did something wrong i think.

Can you help me?

[wolstech]

You're on Stevie. Many if not all people on Stevie can't use their databases right now because MySQL is completely broken.

 

Instead, you'll see a "can't connect" or "access denied" message. There is no fix but to wait until we hear from Krydos about this.

[super11]

ok. i tried to change the password of the database user. This seems to work. But i need the sql database back. I have a backup, but it doesn't work to put the backup back. Can you help me with that?

[wolstech]

You don't mention a specific error, but I'll assume it's InnoDB related since most issues for backups failing to restore are.

 

Make a copy of the backup, then open the copy in a text editor and do a find and replace in your backup, replace all ENGINE=InnoDB with ENGINE=MyISAM After that, save, and try to restore the edited version. Stevie currently does not support the InnoDB engine.

[super11]

I'm sorry, i didn't mention the specific error.

This is what i tried to do:

-Go to back up

- restore a mysql database

- select the file

- press upload

- a new window opens, which says:

Database herstellen

Determined database name from sql

 

Restoring database “super11_data”

 

Nothing happens (i waited more than an hour)

 

Is this the right procedure?

 

I also checked the backup. There is no ENGINE=InnoDB in it. Only ENGINE=MyISAM

[wolstech]

cPanel's restore tool can do that sometimes. I'm assuming you have a .sql file.

 

Try this: Create an empty database in cPanel. After creation, open PHPMyAdmin, and navigate to that new database. Use the Import tab to restore the backup into the new database (might take some time after you select the file). Verify the contents of the database are correct.