Explore information related to phpmyadmin


mysqldump error 1194 table is marked as crashed - Best Fixes ?


This article covers methods to resolve the mysqldump error 1194 for our customers. Generally database administrators use MySQL tables to store some important files along with their professional data or records. Though users store their important data but they are unaware of the situation that they can also lose their important data some day when the database gets corrupt or damaged. 

When MySQL database gets corrupted then it displays several error messages, one such error is "ERROR 1194 (HY000): Table 'table_name' is marked as crashed and should be repaired". And this error is very annoying so its very important to fix MySQL error 1194 as soon as you can.


Main causes of MySQL Error 1194:

  • Due to sudden system shutdown.
  • Virus/malware infection.
  • File system corruption after the newly installed program like hardware or software.

Read More



PHPMyAdmin import database timeout - Fix it Now ?


This article covers methods to fix PHPMyAdmin import database timeout error. This error happens because of a huge file and the restoration process fails with timeout.


To resolve this error, 

1. Login to the server over SSH.

2. Create the file config.inc.php.

For Plesk Onyx and Plesk Obsidian below 18.0.30:

# cp -p /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.inc.php

For Plesk Obsidian 18.0.30 and above:

# cp -p /usr/local/psa/phpMyAdmin/libraries/config.default.php /usr/local/psa/phpMyAdmin/config.inc.php

3. Increase the value of $cfg['ExecTimeLimit'] in config.inc.php created on step 2:

$cfg['ExecTimeLimit'] = 3600;

4. Increase the settings in /etc/sw-cp-server/config to avoid '504 Gateway Timeout' error:

fastcgi_read_timeout 3600;
fastcgi_send_timeout 3600;

5. Restart sw-cp-server:

$ service sw-cp-server restart

Read More



Create custom php ini in Litespeed Webserver - How to do it


This article covers how to Create custom php.ini in Litespeed Webserver. Basically, compared to the Apache web server, the Litespeed web server configuration may feel a bit complicated. In hosting environment with cPanel servers, it is necessary to edit the PHP variables for each domain or customer and this can be done using by creating a custom php.ini for each user's home directory. So the clients can change the PHP values according to their requirements.  

There should some steps need to be done on Litespeed admin panel on cPanel/WHM to enable custom php.ini and you can follow the below steps to enable it.


To Create Custom Php.Ini In A Litespeed Webserver:

1. Login into WHM.

2. Select Litespeed Web Server

3. Litespeed Configuration > Admin Console > Configuration > Server > External App > lsphp5

4. Under Environment section >> add “PHPRC=$VH_ROOT”

5. Under “suEXEC User ” section >> add the account username for which custom php.ini has to be enabled.

6. Under “suEXEC Group ” section >> add the group name of the same account.

7. Click save and return to Main >> Litespeed Web server

8. Under Quick Configuration of PHP suEXEC settings,>> Set Enable PHP suExec to yes.

9. After that put custom php.ini in the user’s home directory and check it using a phpinfo page.

Read More



Phpmyadmin keeps asking for password


This article will guide you on tips to resolve phpMyAdmin error when it keeps asking for a password to login.

This #phpMyAdmin problem can arise due to many different reasons that include browser cache issues, using an incorrect password, drive being full, and so on. 

To fix this problem, you need to reset the cPanel password as follows:

1. Login to WHM at https://<your vps ip>:20871) as user root, using the server's root password.

2. Go to 'Home >> Account Information >> List Accounts'.

3. Click on the + sign near the domain for which you want to change the cPanel password. 4. You can see an option there to change the password.

5. Select the option "Sync #Mysql password with account password" and change password.

Read More



PhpMyAdmin installation on Debian


This article will take you through the steps you need to take to install, Configure and Secure phpMyAdmin on your Debian 10 Server.

Read More



How to fix No matching DirectoryIndex Apache Error


Steps to fix  "No matching DirectoryIndex"  Apache web server error.

Read More



Solve 403 Forbidden permission error in Xampp server


We have dealt with server permission related server bugs for numerous customers as part of our Server Support Services.

Read More



Solve phpMyAdmin Timeout error 1440 session


We have dealt with numerous cases of MySQL and phpMyAdmin Errors and support request from our customers regarding Databases related errors as part of our Linux Support Services.

Read More



Fix SQL Error 1046


Here at IbmiMedia, We continue to see rising cases of clients seeking support on how to solve SQL related errors as part of our Linux Support Services. This error happens when a database is not selected correctly.

Read More



Fix MySQL error code 1054


MySQL error code 1054 occurs when you forget to add single quotes while inserting a varchar value or due to any missing column.

Errors in the database of a website can be very frustrating especially if you have got a high traffic website and it leads to loss of customers and money as your they will turn away from your site since this type of errors affects the whole website in general.

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com






Focus on your business, not your servers.

Click Here to Learn More