huulie

It seems to work, thanks a lot for your help and support! THANKS!

We always recommended Myisam because it's more stable and less prone to crashing and less prone to corruption, but you can use whatever you want. If you need some features that are specific to InnoDB that aren't available on Myisam then you don't have a choice. If your tables are already using InnoDB from the backup it's not that big of a deal to leave then that way for simplicity. Is it as simple as just changing the option in the Operations tab of the table?

Did you delete the database first and recreate it? Whoops, forgot to first recreate the database Should I change the database engine (to something else than InnoDB)?

Didn't think about that backup, I supposed it should have been outdated but didn't think of the users of my site only viewing (and not editing) the database-content since then. I've found the .sql file in my back up, and tried to upload it using "Import". However, I got this error message: "SQL-query: -- -- Table structure for table `concerten` -- DROP TABLE IF EXISTS `concerten`; MySQL meldt: #1046 - No database selected " Am I doing something wrong?

Sorry: I don't know for sure, as I used the default option. The only table I can open and view the engine is "whc": that table is using MyISAM The other tables, including 'huulie_MUSICONLINEdevriendschap.gastenboek, used the default settings (at the time I created them) I don't know if this is also MyISAM (or InnoDB, or another option), and I can't open the Operations page of this tables to check which engine they use. EDIT: if I expand the table using the +-sign, I am able to view the columns of the table. If I select one of these columns and check the Operations tab, it says "MyISAM"

Previous problem in topic: http://www.helionet.org/index/topic/22526-inaccessible-database-on-stevie/ Username: huulie_systeem Database: huulie_MUSICONLINEdevriendschap First of all: thank you for your fast response! I've changed my user password and deleted/recreated the user (huulie_systeem) that needed access to the database.. and hooray: phpMyAdmin is logging in using both my user and the huulie_systeem account. However, neither of the two accounts is able to view any database-content. Every attempt to open a table (e.g. "gastenboek") returns: "#1146 - Table 'huulie_MUSICONLINEdevriendschap.gastenboek' doesn't exist" I don't know yet to what extend I'm able to access the database using a PHP-script, as my website displays some errors (probably a result of not fetching the right results from the database-query) Thanks to you (moderator and admin) for your help so far, and I hope this error concerning "non-existing tables" can be solved as well

First of all: thank you for your fast response! I've changed my user password and deleted/recreated the user (huulie_systeem) that needed access to the database.. and hooray: phpMyAdmin is logging in using both my user and the huulie_systeem account. However, neither of the two accounts is able to view any database-content. Every attempt to open a table returns: "#1146 - Table 'huulie_MUSICONLINEdevriendschap.gastenboek' doesn't exist" I don't know yet to what extend I'm able to access the database using a PHP-script, as my website displays some errors (probably a result from trying to open it in too many windows or something, I'll have a look at it) Thanks to you (moderator and admin) for your help so far, and I hope this error concerning "non-existing tables" can be solved as well

Unfortunately, the mySQL Database on my domain have stopped working, logging in using an own PHP-script or phpMyAdmin only returns an error (acces denied or server error 500). I tried to change the password using Cpanel, but this also failed because "Although the system’s database map includes a MySQL user named “huulie_systeem”, the MySQL server reported that no user with this name exists. Contact your system administrator." Sadly, I do not have a back-up of the database (because I was still working on it and planned to make a back-up when finished) Referring to http://www.helionet.org/index/topic/21518-stevie-mysql/, maybe an Admin is willing to take a look at this problem? Username: huulie_systeem Database: huulie_MUSICONLINEdevriendschap Thanks in advance, and greetings from the Netherlands, Huub

HelioHost username: huulie the server your account is on: Johnny Your HelioHost main domain: musiconline.heliohost.org --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Yesterday, I tried to upload a new file to my account on your server. Unfortunately, FileZilla was unable to connect to the FTP-server. When I tried to connect to my site, using Google Chrome and the link musiconline.heliohost.org/devriendschap, I discovered that my site had disappeared. Other links, like musiconline.heliohost.org didn't work. I also tried to login in on heliohost.org using my account "huulie", but I got the reply that my account could not be found. I thought this was because I didn't log in into Cpanel using the right URL, but I haven't got a e-mail with the message that my account has been qeueued up for deletion. I would like to know what happend to my account and if it is possible to restore it. Thanks in advance! Yours sincerely, Huub Username: huulie Site: musiconline.heliohost.org Server: Johnny